flipside

    $OP Airdrop
    boomer77$OP Airdrop
    Updated 2022-09-26
    select date_trunc('day', block_timestamp) as dt, sum(event_inputs:amount/1e18) as op_claimed, count(distinct origin_from_address) as claimer_count,
    count(distinct tx_hash) as tx_count,
    SUM(op_claimed) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as total_op_claimed
    FROM optimism.core.fact_event_logs
    where contract_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' and event_name = 'Claimed'
    and tx_status = 'SUCCESS'
    group by 1
    Run a query to Download Data