flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
comparing Rayidum, Jupiter, and Orca
kiacrypto
comparing Rayidum, Jupiter, and Orca
Updated 2022-04-09
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
date_trunc
(
'day'
,
block_timestamp
)
as
date
,
swap_program
,
count
(
*
)
as
quantity_of_swaps
,
count
(
distinct
swapper
)
as
number_of_unique_wallets
from
solana
.
fact_swaps
where
date
>=
'2022-01-01'
and
succeeded
=
TRUE
group
by
1
,
2
Results
Run a query to Download Data