zakkisyedCopy of RUNE: SWAP volume over time grouped by pool name
    Updated 2021-12-07
    SELECT
    COUNT(DISTINCT tx_id) AS no_of_swaps,
    avg(volume) AS avg_swap_volume,
    pool_name,
    date_trunc('day',block_timestamp) AS day
    FROM (
    SELECT
    tx_id,
    block_timestamp,
    pool_name,
    CASE WHEN to_asset = 'THOR.RUNE' THEN to_e8 ELSE from_e8 END AS volume
    FROM thorchain.swap_events
    WHERE block_timestamp > CURRENT_DATE - 90
    )
    GROUP BY 3,4
    ORDER BY 4 ASC, 2 DESC
    Run a query to Download Data