barbodswap volume to stablecoins
Updated 2022-05-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
date_trunc('day', block_timestamp) as day,
CASE
WHEN SWAP_FROM_MINT = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
WHEN SWAP_FROM_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'
WHEN SWAP_FROM_MINT = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' THEN 'UST'
WHEN SWAP_FROM_MINT = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' THEN 'USDH'
WHEN SWAP_FROM_MINT = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' THEN 'UXD'
WHEN SWAP_FROM_MINT = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' THEN 'PAI'
ELSE NULL
END as stable,
sum(swap_from_amount) as volume,
sum(volume) over (partition by stable ORDER BY DAY) as cum_volume
FROM flipside_prod_db.solana.fact_swaps
WHERE block_timestamp >= '2022-04-01'
AND succeeded = 'TRUE'
AND swap_from_amount > 0
AND stable is not NULL
GROUP BY 1,2
Run a query to Download Data