peteerTop 5 DAPP daily chart
Updated 2022-08-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with optimisim_data as (select * from optimism.core.dim_labels inner join optimism.core.fact_event_logs
on contract_address = address
where label_type = 'dex' or label_type = 'dapp' )
select count(distinct tx_hash),block_timestamp::date, project_name from optimisim_data where project_name in (
select top 5 project_name as pn from optimisim_data
where label_type = 'dapp'
group by pn
order by count(distinct tx_hash) desc)
group by block_timestamp::date,project_name
Run a query to Download Data