AndyCoolPost airdrop behavior of ENS
Updated 2021-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with base as
(
select lower(tx_id) as tx_id from ethereum.udm_events where from_address in
(
select tx_from_address as from_address
from ethereum.events_emitted evt
where true --tx_id ='0x1351baf9546c41cdb79f79849c11d50d49927721d236d3f191fa66ebf13ef8e0'
and evt.contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
and evt.event_name = 'Claim'
)
)
select * from ethereum.dex_swaps where tx_id in (select * from base)
and token_address = lower('0xc18360217d8f7ab5e7c516566761ea12ce7f9d72')
Run a query to Download Data