YellowSOL Swaps on Jupiter
Updated 2022-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
SUM(swap_from_amount) AS SwappedAway_SOL,
DATE_TRUNC('day', block_timestamp) AS DATE,
AVG(swap_from_amount) AS average,
COUNT (swap_from_amount) AS User_count
FROM solana.swaps
WHERE
swap_program LIKE '%jupiter%'
AND
succeeded = 'TRUE'
AND
swap_from_mint = 'So11111111111111111111111111111111111111112'
AND
DATE(block_timestamp) >= '2022-01-01'
GROUP BY DATE
ORDER BY DATE
Run a query to Download Data