0xaimanUst outflow : solana stables
Updated 2022-05-16
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
28
29
30
31
›
⌄
select date, stablecoin, ust_volume_dumped
from(
select date(t) as date, stablecoin, sum(ust) as ust_volume_dumped
from (select block_timestamp as t, SWAP_FROM_AMOUNT as ust, swap_to_mint,
case when swap_to_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
when swap_to_mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
when swap_to_mint='USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'
when swap_to_mint='7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'
when swap_to_mint='Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'
end as stablecoin
from solana.fact_swaps
where block_timestamp>'2022-04-01' and swap_from_mint='CXLBjMMcwkc17GfJtBos6rQCo1ypeH6eDbB82Kby4MRm' or swap_from_mint='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i'
or swap_from_mint='A96PoNcxa9LMxcF9HhKAfA1p3M1dGbubPMWf19gHAkgJ' or swap_from_mint='UST8SCn7jrqsq51odVLqcmvnC658HkqrKrPL3w2hHQ7' or
swap_from_mint='UST98bfV6EASdTFQrRwCBczpehdMFwYCUdLT5tEbhpW')
where t>'2022-04-01' and
swap_to_mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or
swap_to_mint='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or
swap_to_mint='USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' or swap_to_mint='7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' or
swap_to_mint='Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'
group by 1,2 order by 1)
where date>'2022-03-31'
Run a query to Download Data