SandeshUntitled Query
Updated 2022-10-26Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab as
(
select ft.*
, dc.*
from optimism.core.fact_transactions ft
left join optimism.core.dim_labels dc
on ft.to_address=dc.address
where block_timestamp > CURRENT_DATE - interval '3 months'
-- and ft.to_address=lower('0xbE811A0D44E2553d25d11CB8DC0d3F0D0E6430E6')
and nonce < 3
)
select project_name, count(distinct from_address) as cnt
from tab
group by project_name
order by cnt desc
Run a query to Download Data