shadilUntitled Query
    Updated 2022-03-16
    select lb.*, TO_ADDRESS FROM ethereum.udm_events udm
    join ethereum.labels lb on lb.address = udm.to_address
    WHERE
    from_address='0x2db60257e3c7cefd0ff66ebbedefd7cd6c65f037' --wallet seedclub
    and CONTRACT_ADDRESS='0xf76d80200226ac250665139b9e435617e4ba55f9' --token seed club
    and ORIGIN_FUNCTION_NAME='execTransaction'
    and EVENT_TYPE='erc20_transfer'
    -- limit 5

    -- select lb.*, BLOCK_TIMESTAMP, from_address, (select DISTINCT TO_ADDRESS) as receiver, symbol, amount
    -- from ethereum.udm_events udm
    -- join ethereum.labels lb on lb.address = udm.to_address

    -- where
    -- CONTRACT_ADDRESS = '0xf76d80200226ac250665139b9e435617e4ba55f9'
    -- and EVENT_NAME = 'transfer'
    -- and ORIGIN_FUNCTION_NAME = 'claim'
    -- -- and amount = 2500
    -- order by amount DESC

    -- select lb.* ,to_address FROM ethereum.udm_events udm
    -- join ethereum.labels lb on lb.address = udm.to_address
    -- WHERE
    -- from_address='0x110b344e8052e89b2548e13aceb364ad44fa148c' --wallet seedclub
    -- and CONTRACT_ADDRESS='0xf76d80200226ac250665139b9e435617e4ba55f9' --token seed club
    -- -- and ORIGIN_FUNCTION_NAME='execTransaction'
    -- and EVENT_TYPE='erc20_transfer'
    -- and ORIGIN_FUNCTION_NAME = 'claim'

    -- select *
    -- FROM ethereum.udm_events
    -- WHERE
    -- from_address='0x56FCBC9D08f9500eF87e5d025b8974A5d19B21Af'

    -- select *
    -- FROM ethereum.labels
    Run a query to Download Data