2844Raydium TOTAL SWAPS
Updated 2022-07-11Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with Total as(
select
block_timestamp::date as "DATE", count(TX_ID) as "Raydium TOTAL SWAPS"
from
solana.fact_swaps
where block_timestamp::date >= '2022-01-01'
AND swap_program in ('raydium v4')
AND swap_from_amount > 0
GROUP BY 1
ORDER BY 1 DESC),
FALSE AS (
select
block_timestamp::date as "DATE1",count(TX_ID) as "Raydium FAILED SWAPS"
from solana.core.fact_swaps
where block_timestamp::date >= '2022-01-01'
AND succeeded = FALSE
AND swap_program in ('raydium v4')
GROUP BY 1
ORDER BY 1 DESC
)
SELECT "DATE","Raydium TOTAL SWAPS","Raydium FAILED SWAPS","Raydium FAILED SWAPS"/"Raydium TOTAL SWAPS" AS "RATE OF FAILED SWAPS"
FROM Total,FALSE
WHERE "DATE"="DATE1"
GROUP BY 1,2,3
ORDER BY 1
Run a query to Download Data