flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Q77-1
mehrancrypto-dxoepq
Q77-1
Updated 2022-11-08
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with
tab1
as
(
SELECT
pool_id
as
number
,
min
(
BLOCK_TIMESTAMP
::
date
)
as
creation
from
near
.
core
.
ez_dex_swaps
GROUP
BY
1
)
SELECT
creation
,
COUNT
(
number
)
FROM
tab1
GROUP
BY
1
Results
Run a query to Download Data