MLDZMNStake over time
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
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