flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
number of gALGO3 swaps from for each DEX
2844
number of gALGO3 swaps from for each DEX
Updated 2022-04-29
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc
(
'day'
,
block_timestamp
)
as
DATE2
,
count
(
swap_from_asset_id
)
as
"pactfi"
from
algorand
.
swaps
where
swap_from_asset_id
=
'694432641'
AND
SWAP_PROGRAM
LIKE
'pact%'
and
block_timestamp
>=
'2022-01-01'
group
by
DATE2
order
by
date2
desc
Results
Run a query to Download Data