banbannardcsMATIC Stake
    Updated 2022-09-19
    select date_trunc('day', block_timestamp) as day,
    count(distinct(matic_from_address)) as count_staker,
    sum(amount) as matic_staked,
    sum(matic_staked) over (order by day) as cum_matic_staked,
    count(distinct(tx_hash)) as tx_count
    from polygon.core.ez_matic_transfers
    where --tx_hash ='0xa61984fe44ca36804e00f88672ebf413e0f35d7525fb0682caf7ec121049d7db'
    matic_to_address = '0x376b467dff007dd8d3f24404caddff7f72257fe4'
    and origin_to_address = '0x376b467dff007dd8d3f24404caddff7f72257fe4'
    and origin_function_signature = '0xd0e30db0'
    group by 1
    Run a query to Download Data