flipside

    1. ens A
    boomer771. ens A
    Updated 2021-12-08
    with register as (select count(distinct event_inputs:name::string) as total_domain_registered, count(distinct event_inputs:owner::string) as address_count, 'A' as xx
    from ethereum.events_emitted
    where block_timestamp < '2021-11-01' and event_name = 'NameRegistered' and contract_address = '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5'),

    claim as (select count(distinct tx_from_address) as address_claimed, avg(event_inputs:value/1e18) as average_claims, 'A' as xx
    from ethereum.events_emitted
    where contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72' and event_name = 'Claim')

    select a.total_domain_registered, a.address_count, b.address_claimed, b.average_claims
    from register a
    left join claim b on a.xx = b.xx
    Run a query to Download Data