theericstoneCheck Airdrop Number 3
Updated 2023-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 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