RE: The Future of Steemit
I would very much like to be helpful, but unfortunately I will not be able to do what you need. I just researched this topic. Here: https://github.com/fooblic/steem-flow there is even a ready-made solution, but I'm too stupid to use it. I understand I need to start my own web server and then configure to run the script regularly. This is what the result would look like: https://steemit.com/stats/@fooblic/steem-flow-monthly-report-9.
To do it manually, I need to know the Steemit accounts that correspond to the exchanges. For example, there is a poloniex account, but I did not find binance.
In short, I still have a lot to learn to be Mr. Statistics.
But if you go back to the article https://steemit.com/steem/@remlaps-lite/steem-total-value-powered-up-usd83-million-november-14-2021, you can refer to it. In particular:
Value of powered-up STEEM in terms of USD
Continuing a generalized uptrend that began in June, but down by about 5% since last week.
Here I agree with you. No positive dynamics is visible. But I still do not understand why.

I'll see if I can use some of that. It's hard to know but thank you for looking into it. I'm aware of this post that's been written too with some more data but it's not got the month before to compare it against. I'm sure I'll cobble something together 👍
Maybe this will help in some way: https://steemit.com/hive-130095/@steem.history/steem-effective-steem-power-list-11-23 ?
It is possible to compare with the same list, say, for May. Yes, it's only the 150 strongest accounts including upvu, tipu and other bots. But if we throw out of this list known bots, as well as SC and booming, we can assume that this is a representative sample.
Ah, I've just posted my post - I think I've got my message across with what I've got so thanks for your help 👍