DigitalDanENS Testing
Updated 2021-12-20Copy Reference Fork
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
›
⌄
with ens_in as (
select *
-- select block_timestamp,
-- tx_id,
-- origin_address,
-- to_address,
-- event_name,
-- event_type,
-- event_id,
-- contract_address,
-- symbol,
-- amount,
-- amount_usd
from ethereum.udm_events
where contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
--and to_address = origin_address
)
select distinct * from ens_in
-- where (event_name = 'DelegateChanged' or event_name = 'DelegateVotesChanged') and Origin_function_signature != '0x76122903'
--where origin_function_signature = '0x76122903'
limit 100
Run a query to Download Data