crypto_gosttroubled-yellow
    Updated 2024-10-13
    SELECT
    DATE(block_timestamp) AS Swap_Date,
    COUNT(DISTINCT tx_id) AS BNsoln_Swap,
    COUNT(DISTINCT SWAPPER) AS bnsoln_Swapper,
    SUM(SWAP_From_AMOUNT_usd) AS Swap_BNsol_Amount
    FROM
    solana.defi.ez_dex_swaps
    WHERE
    SWAP_from_MINT = 'BNso1VUJnh4zcfpZa6986Ea66P6TCp59hvtNJ8b1X85'
    OR SWAP_to_MINT = 'BNso1VUJnh4zcfpZa6986Ea66P6TCp59hvtNJ8b1X85'
    GROUP BY
    Swap_Date
    ORDER BY
    Swap_BNsol_Amount DESC;
    QueryRunArchived: QueryRun has been archived