HosseinUntitled Query
    Updated 2023-01-14
    select
    date_trunc('week', block_timestamp) as week,
    count(distinct tx_hash) as txn_count,
    sum(raw_amount/1e18) as total_volume,
    sum(txn_count) over (order by week) as cumulative_txn_count,
    sum(total_volume) over (order by week) as cumulative_total_volume
    from ethereum.core.ez_token_transfers
    where contract_address = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' --aETHc
    and from_address = '0x0000000000000000000000000000000000000000'
    group by week
    order by week asc
    Run a query to Download Data