shreexDaily Swappers
    Updated 2022-12-23
    (select
    date_trunc('day',block_timestamp) as date,
    'USDC'as stablecoin,
    sum(swap_from_amount) as volume,
    count(distinct swapper) as unique_swapper
    from solana.core.fact_swaps where block_timestamp >= CURRENT_DATE - interval '2 months' and swap_from_mint= 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    group by date
    order by date )
    UNION

    (
    select
    date_trunc('day',block_timestamp) as date,
    'USDT' as stablecoin,
    sum(swap_from_amount) as volume,
    count(distinct swapper) as unique_swapper
    from solana.core.fact_swaps where block_timestamp >= CURRENT_DATE - interval '2 months' and swap_from_mint= 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
    group by date
    order by date)
    UNION (
    (
    select
    date_trunc('day',block_timestamp) as date,
    'PAI' as stablecoin,
    sum(swap_from_amount) as volume,
    count(distinct swapper) as unique_swapper
    from solana.core.fact_swaps where block_timestamp >= CURRENT_DATE - interval '2 months' and swap_from_mint= 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS'
    group by date
    order by date)
    UNION (
    (
    select
    date_trunc('day',block_timestamp) as date,
    'UXD' as stablecoin,
    sum(swap_from_amount) as volume,
    count(distinct swapper) as unique_swapper
    Run a query to Download Data