shadilUntitled Query
Updated 2022-03-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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