lagandispenserETH_bridged
Updated 2022-06-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with base as (select tx_hash
from ethereum_core.fact_event_logs
where contract_address = lower('0xC36442b4a4522E871399CD717aBDD847Ab11FE88')
--and event_name = 'TransferSentToL2'
and block_timestamp::date >= '2022-01-01')
select
date_trunc('day', block_timestamp) as day,
sum(event_inputs:value)/1e18 op_bridged,
sum(op_bridged) over (order by day) as cumulative_op_bridged
from ethereum_core.fact_event_logs
where contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
and event_name = 'Transfer'
and tx_hash in (select tx_hash from base)
group by 1
Run a query to Download Data