flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Monthly Near Transactions and Users on Dexs
vegard
Monthly Near Transactions and Users on Dexs
Updated 2022-11-08
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
date_trunc
(
'month'
,
block_timestamp
)
as
month
,
count
(
distinct
(
tx_hash
)
)
as
tx_num
,
count
(
distinct
(
trader
)
)
as
traders_num
from
near
.
core
.
ez_dex_swaps
group
by
1
order
by
1
asc
,
2
desc
Results
Run a query to Download Data