theericstoneCheck Airdrop Number 3
    Updated 2023-09-29
    -- forked from Check Airdrop @ https://flipsidecrypto.xyz/edit/queries/8db63a47-b550-4a91-aee0-d64111a8ba32

    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-09-18'
    and from_address = lower('0x2501c477D0A35545a387Aa4A3EEe4292A9a8B3F0')
    and contract_address = lower('0x4200000000000000000000000000000000000042')
    and to_address = lower('{{address}}');


    Run a query to Download Data