Introduction:
This a Bounty by Flipsidecrypto, asking us to define who is an active user and how many of them are on a daily, monthly and annual time base. in other words, we want to see if users became more active overtime or not?
Methodology:
Flipside database provides different tables that each can be a useful source to determine wallet activity; NFT_Metadata, Swaps, msgs and Staking for example. But combining these would be an arduous job not fitting for this medium. instead I decided to use transactions table which fairlu consists of most forms of on-chain interaction with Block Chain. I chose 1 transaction For daily basis, 7 for Weekly, 30 for Monthly and overall number of 100 transaction in one year as the criteria for being an active wallet.