flipside

    $OP Airdrop 2
    Hadiseh$OP Airdrop 2
    Updated 2022-09-29
    select
    count(DISTINCT tx_hash) as total_transaction,
    sum(raw_amount/pow(10,18)) as total_amounts,
    count(DISTINCT origin_from_address) as total_users
    from optimism.core.fact_token_transfers
    where tx_hash in ( select tx_hash
    from optimism.core.fact_event_logs
    where event_name = 'Claimed'
    and contract_address = lower('0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'))
    Run a query to Download Data