Saleh$MATIC Staking-date
Updated 2022-09-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
block_timestamp::date as date
,count(tx_hash) as stakes
,count(distinct ORIGIN_FROM_ADDRESS) as stakers
,sum(amount) as matic_stake_amount
,sum(amount_usd) as usd_stake_amount
,avg(amount) as avg_matic_stake
,avg(amount_usd) as avg_usd_stake
,sum(stakers) over(order by date) as growth_stakers
,sum(stakes) over(order by date) as growth_stakes
,sum(matic_stake_amount) over(order by date) as growth_matic_stake
,sum(usd_stake_amount) over(order by date) as growth_usd_stake
from polygon.core.ez_matic_transfers t
join polygon.core.dim_labels l on l.address = t.matic_to_address
where block_timestamp::date >= '2022-07-01'
and label_subtype = 'pool'
and address_name like '%staking%'
group by 1
order by 1
Run a query to Download Data