freemartianDaily & Accumulative ETH Frozen
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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