shreexDaily ENS Registrations
    Updated 2022-10-02
    select
    date_trunc('day',block_timestamp) as date,
    case when block_timestamp >= '2022-09-15' then 'after merge'
    when block_timestamp < '2022-09-15' then 'before merge' else 'a' end as merge,
    count(*) as ens_registrations,
    count(distinct origin_from_address) as ens_joiners
    from ethereum.core.fact_event_logs
    where contract_address='0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85'
    AND EVENT_NAME='NameRegistered' and block_timestamp >='2022-01-01' and tx_status='SUCCESS'
    GROUP BY date,merge
    ORDER BY date