freemartianDaily & Accumulative ETH Frozen
    Updated 2023-04-13
    select
    count(distinct tx_hash) as Deposit_count,
    sum(event_inputs:value)/pow(10,18) as Deposit_volume,
    date_trunc('day', block_timestamp::date) as TIME,
    sum(Deposit_volume) over (order by TIME) as accumulative_deposit,
    sum(Deposit_count) over (order by TIME) as accumulative_deposit_count
    from ethereum.core.fact_event_logs
    where origin_to_address = '0xa4b41efc1b6f73355c90119aeefddb1ffcf907b0'
    and contract_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    and event_name = 'Transfer'
    group by TIME
    Run a query to Download Data