namanasync2024-05-03 09:45 AM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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