Oooh great! This is very clever! I was doing this locally earlier by tracking memos, though it doesn't handle when people are using internal balances to initiate a vote (I do handle refunded balances though). This, while time consuming, should capture everything. Thanks for the analysis!
Posted using Partiko Android
Thanks, @eonwarped! Yes, the internal balances make the result from the memo approach only a lower boundary. Another limitation with memos is that you typically know how much was spent for the votes, but can only estimate the vote value based on typical ROIs. Nevertheless, it scales better to larger time ranges.
Would be interesting to know how many bids are done from internal balances vs. blockchain transfers! :)