flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Optimism DEXs 2.5
mattkstew
Optimism DEXs 2.5
Updated 2022-08-07
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
--date_trunc('day', block_timestamp),
project_name
,
count
(
distinct
from_address
)
from
optimism
.
core
.
fact_token_transfers
left
outer
join
optimism
.
core
.
dim_labels
on
contract_address
=
address
where
label_type
like
'dex'
group
by
1
Results
Run a query to Download Data