flipside

    PIKA airdrop - Total Claim
    freemartianPIKA airdrop - Total Claim
    Updated 2023-09-20
    -- select * from optimism.core.ez_token_transfers
    -- where tx_hash = '0x4cfb9e104bc1287ee3601147c702993987b6e34f9d30ab8fe9f22486ddeb41e9'

    select
    sum(amount) as Total_PIKA_Claimed,
    count(distinct to_address) as Claimers_Count
    from optimism.core.ez_token_transfers
    where from_address = '0x67a9e34a763395266612ffc8c9305eb2fca4d4be'
    and contract_address = '0x1508fbb7928aedc86bee68c91bc4afcf493b0e78'
    and origin_function_signature = '0x3d13f874'
    Run a query to Download Data