flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Number of New Pools
Eman-Raz
Number of New Pools
Updated 2023-04-13
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with
tab1
as
(
select
pool_id
,
min
(
block_timestamp
::
date
)
as
first_tx
from
terra
.
core
.
ez_swaps
where
tx_succeeded
=
'TRUE'
group
by
1
)
select
count
(
distinct
pool_id
)
as
"Total Number of New Pools"
from
tab1
where
first_tx
>=
'2023-01-01'
Results
Run a query to Download Data