lagandispenserETH_bridged
    Updated 2022-06-18
    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