NavidChallenge 2 - A
Updated 2022-05-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
date_trunc('day', block_timestamp) as date,
SUM(swap_from_amount) AS volume
FROM solana.swaps a
WHERE swap_from_mint = 'So11111111111111111111111111111111111111112'
AND swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
AND succeeded = 'TRUE'
AND swap_program = 'orca'
AND block_timestamp between '2022-02-01' and '2022-02-28'
GROUP BY date
ORDER BY date ASC