@WazzCrypto another issue that youll probably have is that you need a db that partitions the data by time. for example im using "PARTITION BY DAY" which means that my db is really a lot of smaller dbs when it comes to searching. I can have billions of rows that search as fast as 1000s.
@WazzCrypto specific database and it works well.
Time series is the preferred choice for anyone dealing with tx data (HFT bots use it).
The reason i use a data broker is that you have a processing penalty if the data arrives out of time order so that broker adds the timestamp
@WazzCrypto if you are adding raw transaction data specifically from a chain like Solana then youre going to need to do some serious parsing before you add to the database - this could be your issue.
I'm currently at over 2.5bn rows of data and I'm not doing 1gb per day even at 1000tx/sec
@LeonidasNFT@MetaMask i doubt its pointing to the wrong token from the cashtag. the cashtag is made up of the contract address so its more likely that the page has the wrong contract added to start with
@art_xbt strats tend to work better for certain regimes. try cutting up your backtest into Broad rally, Narrow rally, Rotation, Chop, Narrow sell-off and Broad sell-off. treating the entire backtest as 1 regime will give inaccuracies :)