AndyCoolDelegation trends for ENS
    Updated 2021-12-07
    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