flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Solana Protocol Feature 2
mattkstew
Solana Protocol Feature 2
Updated 2023-04-13
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc
(
'day'
,
block_timestamp
)
,
count_if
(
succeeded
=
'TRUE'
)
as
Succesful_Swaps
,
count_if
(
succeeded
=
'FALSE'
)
as
Failed_Swaps
from
solana
.
core
.
fact_swaps
where
swap_program
like
'raydium v4'
group
by
1
Results
Run a query to Download Data