flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Average Daily Amount of swap transactions of Optimism users
kingharald-eth
Average Daily Amount of swap transactions of Optimism users
Updated 2022-07-23
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
date_trunc
(
'day'
,
a
.
block_timestamp
)
as
date
,
avg
(
eth_value
)
as
average
from
optimism
.
core
.
fact_transactions
a
join
optimism
.
core
.
fact_event_logs
b
on
a
.
tx_hash
=
b
.
tx_hash
where
event_name
=
'Swap'
and
tx_status
=
'SUCCESS'
group
by
date
Results
Run a query to Download Data