flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Hot Contracts on Osmosis 1
mattkstew
Hot Contracts on Osmosis 1
Updated 2022-07-10
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with
tab1
as
(
select
distinct
pool_ids
[
0
]
,
min
(
date_trunc
(
'day'
,
block_timestamp
)
)
as
date1
from
osmosis
.
core
.
fact_swaps
where
block_timestamp
>
'2022-05-01'
group
by
1
)
select
date1
,
count
(
*
)
from
tab1
group
by
1
Results
Run a query to Download Data