flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Number of swaps From algo by DEX
mohammadh
Number of swaps From algo by DEX
Updated 2022-04-27
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
block_timestamp
::
date
as
date
,
swap_program
,
count
(
*
)
from
algorand
.
swaps
where
block_timestamp
::
date
BETWEEN
'2022-03-01'
AND
'2022-03-31'
and
swap_from_asset_id
=
0
and
swap_from_amount
>
0
group
by
date
,
swap_program
Results
Run a query to Download Data