flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
superfly
Untitled Query
Updated 2022-09-28
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
BLOCK_TIMESTAMP
::
date
as
day
,
count
(
distinct
trader
)
as
users
,
count
(
distinct
tx_id
)
as
transaxtions
from
osmosis
.
core
.
fact_swaps
where
POOL_IDS
[
0
]
=
812
and
TX_STATUS
=
'SUCCEEDED'
group
by
1
order
by
1
Results
Run a query to Download Data