PS0G1Daily volume of Matic unstaked
    Updated 2022-09-23
    --inspired by masi
    select trunc(block_timestamp,'day') as day,
    count(DISTINCT tx_hash) as count_tx,
    count(DISTINCT origin_from_address) as users,
    sum(amount_usd) as usd_volume,
    sum(amount) as amounts,
    avg(amount) as average_amount,
    sum(count_tx) over (order by day asc) as cumulaitve_tx,
    sum(amounts) over (order by day asc) as cumulative_amounts,
    sum(usd_volume) over (order by day asc) as cumulative_volume
    from ethereum.core.ez_token_transfers
    where from_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'
    and CONTRACT_ADDRESS = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
    group by 1
    Run a query to Download Data