--darvishi
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