flipside

    lst 3
    abhishek281196lst 3
    SELECT
    count(*) as swaps,
    count(DISTINCT swapper) as users,
    sum(swap_from_amount * price1) as volume_usd
    FROM solana.defi.fact_swaps
    LEFT outer JOIN (
    SELECT
    date(recorded_hour) as day1,
    token_address as ta1,
    token_name as tn1,
    median(close) as price1
    FROM solana.price.ez_token_prices_hourly
    --WHERE recorded_hour > current_date - 60
    GROUP BY 1,2,3
    ) as a on day1 = date(block_timestamp)
    and ta1 = SWAP_FROM_MINT
    --LIMIT 100
    --WHERE block_timestamp > current_date - 60
    AND (
    SWAP_FROM_MINT in ('bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1', 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So', '7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj', 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn')
    OR SWAP_TO_MINT in ('bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1', 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So', '7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj', 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn')
    )
    --GROUP BY 1,2,3


    Run a query to Download Data