theericstoneCheck Airdrop
    Updated 2023-04-21
    select
    block_timestamp,
    ftt.tx_hash,
    ftt.to_address,
    ftt.raw_amount/pow(10,18) as amount_dropped
    FROM
    optimism.core.fact_token_transfers ftt
    where block_timestamp > '2023-02-08'
    and from_address = lower('0x2501c477D0A35545a387Aa4A3EEe4292A9a8B3F0')
    and contract_address = lower('0x4200000000000000000000000000000000000042')
    and to_address = lower('{{address}}');

    Run a query to Download Data