shreexDaily ENS Registrations
Updated 2022-10-02
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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