AndyCoolDelegation trends for ENS
Updated 2021-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with base as (
select
BLOCK_TIMESTAMP,EVENT_INPUTS:delegator::string as delegator, EVENT_INPUTS:fromDelegate::string as fromDelegate, EVENT_INPUTS:toDelegate::string as toDelegate, EVENT_NAME
from ethereum.events_emitted evt
where true --tx_id ='0x1351baf9546c41cdb79f79849c11d50d49927721d236d3f191fa66ebf13ef8e0'
and evt.contract_address ='0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
and evt.event_name <> 'Claim'
and evt.event_name <> 'Approval'
and evt.event_name <> 'Transfer'
and event_inputs:fromDelegate::string <> lower('0x0000000000000000000000000000000000000000'))
select date_trunc('day',block_timestamp) as dayz, count(DISTINCT(delegator)), count(DISTINCT(fromDelegate)), count(DISTINCT(toDelegate)) from base
group by dayz
order by dayz desc
Run a query to Download Data