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