defi__joshBuy and Sell volume of $TITCOIN
    Updated 2025-04-02
    WITH daily_volumes AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) as date,
    -- Buy volume (when token is received)
    SUM(CASE
    WHEN swap_to_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
    THEN swap_to_amount_usd
    ELSE 0
    END) as buy_volume_usd,
    -- Sell volume (when token is sent)
    SUM(CASE
    WHEN swap_from_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
    THEN swap_from_amount_usd
    ELSE 0
    END) as sell_volume_usd
    FROM
    solana.defi.ez_dex_swaps
    WHERE
    block_timestamp >= DATEADD('day', -30, CURRENT_DATE)
    AND (
    swap_from_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
    OR swap_to_mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
    )
    GROUP BY
    date
    ORDER BY
    date
    )

    SELECT
    date,
    ROUND(buy_volume_usd, 2) as buy_volume_usd,
    ROUND(sell_volume_usd, 2) as sell_volume_usd,
    ROUND(buy_volume_usd - sell_volume_usd, 2) as net_volume_usd
    FROM
    daily_volumes
    QueryRunArchived: QueryRun has been archived