kellenTHORChain Swap Volume by Chain
    Updated 2022-12-09

    SELECT SPLIT(SPLIT(t.pool_name, '.')[0], '/')[0] AS chain
    , ROUND(SUM(swap_volume_rune_usd)) AS swap_volume_usd
    FROM thorchain.core.fact_daily_pool_stats t
    WHERE day >= DATEADD('month', -18, CURRENT_DATE)
    GROUP BY 1
    ORDER BY 2 DESC

    Run a query to Download Data