namanasync2024-05-03 09:45 AM
    select
    ethereum.public.udf_hex_to_int (DATA) / pow(10, 18) AS AMOUNT,
    CONCAT('0x', SUBSTR(TOPICS[1], -40, 40)) AS AIRDROP_WALLET_RECIPIENT,
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    TX_HASH
    FROM
    optimism.core.ez_decoded_event_logs
    WHERE
    ORIGIN_TO_ADDRESS = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
    AND ORIGIN_FUNCTION_SIGNATURE = '0xae373c1b'
    AND BLOCK_NUMBER >= 70506697
    AND TX_STATUS = 'SUCCESS'arbitrum.core.dim_contract_abis
    Run a query to Download Data