Flipside Algorand Wallet Behavior

-- The Flipside algorand bounty payout wallet is TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE and -- any sent payment transaction under 10,000 ALGOs can be assumed to be a bounty payout. -- Chart the creation date of the wallets that have been paid out by the Flipside Algorand Wallet -- using the created_at block and block_timestamp in the algorand.account table. Do we see people creating wallets to answer flipside algorand bounty questions? -- 2a. Using algorand.account show the distribution of current balances using the balance field for wallets that have been paid out by Flipside. -- 2b. We want to see what percent of each wallet’s ALGO holdings are from bounty payouts. -- Show the distribution of what percent of each wallets current ALGO holdings come from bounty payouts. -- 2c. What is the total amount Flipside has paid out to wallets and what is the total amount of ALGOs these wallets -- are currently holding(use balance in the algroand.account table for balance). -- Using algorand.account_asset table, let’s look at what other ASAs wallets(that have been paid by flipside crypto) are holding. -- Create a chart of the top 10 assets the wallets are holding(make sure the amount field, balance, is greater than 0). -- Display a count of the number of wallets that are holding this asset and display the percent of flipside bounty wallets that hold this asset. -- 4a. What percent of wallets(that have been paid by flipside crypto) have interacted with an application on algorand?( sent an algorand.application_call_transaction) -- 4b. Show the distribution of number of applications users have interacted with(plot the number of app_ids each wallet has interacted with).