flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
pactfi swaps
amiroza
pactfi swaps
Updated 2022-07-06
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with
DEX_swaps
as
(
select
date_trunc
(
'day'
,
block_timestamp
)
date
,
count
(
*
)
pactfi_count
from
Algorand
.
Swaps
where
date
>=
'2022-01-01 00:00:00.000'
and
lower
(
swap_program
)
=
'pactfi'
and
swap_from_amount
>
0
group
by
1
)
select
*
from
DEX_swaps
t1
Results
Run a query to Download Data