princefarzamWHAT PERCENTAGE OF ALL JUPITER SWAPS ARE STABLECOIN SWAPS
Updated 2022-03-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH JUPITER AS (SELECT
COUNT(DISTINCT TX_ID) AS All_JUPITER_SWAPS
FROM solana.swaps
WHERE block_timestamp::DATE >='2021-12-01'
AND SUCCEEDED = TRUE
AND SWAP_PROGRAM::string='jupiter aggregator v2'),
STABLE AS(
SELECT
COUNT(DISTINCT TX_ID) AS STABLE_SWAPS
FROM solana.swaps
WHERE block_timestamp::DATE >='2021-12-01'
AND SUCCEEDED = TRUE
AND (SWAP_FROM_MINT::string IN ('9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
OR SWAP_TO_MINT::string IN ('9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'))
AND SWAP_PROGRAM::string='jupiter aggregator v2')
SELECT
J.All_JUPITER_SWAPS,
S.STABLE_SWAPS,
S.STABLE_SWAPS/J.All_JUPITER_SWAPS*100 AS PERCENTAGE
FROM JUPITER J,STABLE S
Run a query to Download Data