AndyCoolPost airdrop behavior of ENS
    Updated 2021-12-08
    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