Saleh$MATIC Staking-date
    Updated 2022-09-20
    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