MLDZMNStake over time
    Updated 2022-07-07


    select
    BLOCK_TIMESTAMP::date as day,
    CASE
    when RECEIVER='VEST2A43254FW6XZYIRUL2RZPCR4M3BH35UPMRSMFS3YCBX5SYPQDIBSIU' then 'ALGO/VEST'
    when RECEIVER='COSGLPLILGWRZUP47PU7FSKUPJFEWENFSJKU6RGIOZVWVYF26IVTGTGLFA' then 'ALGO/COCG'
    when RECEIVER='XYS43RS2Y5UNTY7W24MUKLNFZ45VILD5ETUJ7IZFWE75N5VA3JGUJTMEWE' then 'ALGO/USDC'
    when RECEIVER='O74MYOAFM4KJ5G72IBKGRQKXU43M75VIDEUH6TNCUNRLBXI5SXI7GRQHYQ' then 'ALGO/goMINT'
    when RECEIVER='5RQ2B7TRL3XWJEVAFGR7PPC7FDXGXCUHKTUHNESCDUNCE3YD2VBTGLWTUE' then 'ALGO/Planets'
    when RECEIVER='K32GRE7G64NUDCFYPOT2CE2KLPFSPSQITHDBKKISGJ5443X4IFWHUCYGXQ' then 'ALGO/DEFLY'
    when RECEIVER='HBR5GVSSPBN7IJ4JYJ6CKEXC5DYCKH7NFPDOM4JWRPMATB5EYXFHPHS3TM' then 'ALGO/XET'
    when RECEIVER='QRI7HNUXTBOMV5LMTSTS3A2LTEIAKJIWBEKTNVX7CM537UQT2UNXWFGN34' then 'ALGO/WBLN'
    when RECEIVER='ZCG3G65JJJ24GQQP2DWLA34J3TMHEXATMUOOGM2SBGIPMI7HAIOTAPWLIA' then 'ALGO/CHIP'
    when RECEIVER='XYS43RS2Y5UNTY7W24MUKLNFZ45VILD5ETUJ7IZFWE75N5VA3JGUJTMEWE' then 'ALGO/ADAO'
    when RECEIVER='OJGTHEJ2O5NXN7FVXDZZEEJTUEQHHCIYIE5MWY6BEFVVLZ2KANJODBOKGA' then 'ALGO/ALCH'
    when RECEIVER='5T4XRV5KSNYZ57SU7B65UITJZ26PMIDJUMXT4EUBWXO3XE4MS2PFOFB724' then 'ALGO/STKE'
    when RECEIVER='XYS43RS2Y5UNTY7W24MUKLNFZ45VILD5ETUJ7IZFWE75N5VA3JGUJTMEWE' then 'ALGO/GEMS'
    when RECEIVER='FQ5Y2WEOBBGZOXWLRW55D2Q4I635FYJIRKE2G2NTAZP2SIAXS4AZIYJPYY' then 'ALGO/SMILE'
    when RECEIVER='VMD3LZXHPU63DWQOM2ZOHBHT6JCWNBTBITCUUZDS3VE2O2LGVYWPZKFJHI' then 'ALGO/HDL'
    end as pools,
    sum(AMOUNT) as ALGO_amount,
    count(distinct ASSET_SENDER) as distinct_staker,
    count(distinct TX_GROUP_ID) as no_stake,
    avg(AMOUNT) as average_stake,
    sum(ALGO_amount) over (partition by pools order by day) as grow_rate

    from flipside_prod_db.algorand.transfers
    where ASSET_ID=0
    and BLOCK_TIMESTAMP>='2022-06-01'
    group by 1,2 having pools is not null

    Run a query to Download Data