flipside

    Pool Volume (USD)
    amir007-Q63RX1Pool Volume (USD)
    Updated 2023-03-03
    SELECT block_timestamp::date AS date
    , token_0_symbol || ' - ' || token_1_symbol AS token_pair
    , sum(volume_usd) AS sum_volume_usd
    FROM osmosis.mars.ez_pool_hour
    GROUP BY 1, 2
    HAVING sum(volume_usd) > 0

    Run a query to Download Data