there is no way to truly know realistically how much real spend/value moves daily because:
a. the destination addresses of a 2 output tx might be A spend B change return.. or A change return B spend. so without knowing which is which you cant determine whats actually moving as real value spent vs whats just coming back to the person
b. some users do address hopping or also known as tumbling where they send funds to a new address every block down a succession of addresses in one day to try to mystify whom is involved in a transaction
c. these tumbles may be users trying to do tumbles or may be exchanges moving funds from hot to cold to hot in quick succession to then send to someone else.
so point b and c might appear as X btc moved in block A, X btc moved in block B X btc moved in block C. but instead of it being x*3 as a total value moved it might actually be just X returning to the sender in A and no funds/value actually changes hands even if show as moved in B and C
the same goes for CEX trades on the market
someone might have 0.1btc and sell it. but they can the use the USD to buy an altcoin, sell the altcoin for btc and redo the cycle again all while only using one allotment of 0.1btc repeatedly to cause the trade volume to show as alot more then 0.1btc has been traded.. alot of CEX's got in trouble years ago by using their own insider balance databases to fake trades to make it seem like their market was busier than it really was
we see it today on the blockchain where idiot memetoken freaks try to move the same allotment of coin in every block to try to promote their stupid fake meme data junk is being traded often when reality is its the same person that is both "buyer" and "seller"
..
there is already stats like
https://www.blockchain.com/explorer/charts/output-volumewhich shows how much btc is moved each day on the blockchain, but as explained, it is meaningless of context
if you truly want to work out a underlying value of a blockchain at any time the easiest way is to work out the cost of securing the blockchain at any time by looking at the mechanism of securing it (PoW/PoS) by calculating how many devices are actually involved and their cost of hardware/electric to secure the blockchain
the market rate is speculatively above this value, and you can then figure out how much bubble inflated the market rate is in comparison to the value