flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Untitled Query
superfly
Untitled Query
Updated 2022-07-13
Copy Reference
Fork
9
1
2
3
4
›
⌄
with
ALL_COUNT
as
(
select
DISTINCT
pool_ids
[
0
]
,
min
(
date_trunc
(
'DAY'
,
block_timestamp
)
)
AS
date
from
osmosis
.
core
.
fact_swaps
where
block_timestamp
between
'2022-05-01'
and
'2022-7-13'
group
by
1
)
SELECT
count
(
2
)
FROM
ALL_COUNT
Results
Run a query to Download Data