mariaadaily new contract
Updated 2024-10-24
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with base as ( select min(block_timestamp) as day,
contract_address
from base.core.ez_decoded_event_logs
group by 2)
select date(day) as date,
count(contract_address) as new_contracts,
sum(new_contracts) over (order by date asc) as cumulative_new_contracts
from base
where day >= current_date - 90
group by 1
QueryRunArchived: QueryRun has been archived