flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
daily swaps on flow
msafadoost
daily swaps on flow
Updated 2022-06-17
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
DATE
(
BLOCK_TIMESTAMP
)
as
dates
,
COUNT
(
DISTINCT
(
TX_ID
)
)
as
swap_counts
,
sum
(
swap_counts
)
over
(
ORDER
by
dates
)
FROM
flow
.
core
.
fact_swaps
--WHERE TX_SUCCEEDED = 'TRUE'
GROUP
by
1
ORDER
by
1
Results
Run a query to Download Data