flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
optimism data6
bachi
optimism data6
Updated 2023-04-13
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select
project_name
,
count
(
DISTINCT
tx_hash
)
as
total_txs
from
(
SELECT
*
from
optimism
.
core
.
dim_labels
inner
join
optimism
.
core
.
fact_event_logs
on
contract_address
=
address
)
where
label_type
=
'nft'
GROUP
by
1
order
by
2
desc
limit
10
Results
Run a query to Download Data