0xaimanUst outflow : solana stables
    Updated 2022-05-16


    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