flipside

    standard swap volume 2
    sarathstandard swap volume 2
    Updated 2022-05-17
    with data1 as (SELECT DATE_TRUNC('month', block_timestamp) as month1, to_asset, sum(to_amount_usd) as swap_to_volume
    FROM flipside_prod_db.thorchain.swaps
    GROUP BY month1, to_Asset),
    data2 as(
    SELECT DATE_TRUNC('month', block_timestamp) as month, from_asset, sum(from_amount_usd) as swap_from_volume
    FROM flipside_prod_db.thorchain.swaps
    GROUP BY month, from_Asset)

    SELECT month,from_asset,swap_from_volume,to_Asset,swap_to_volume from data1 join data2 on data1.month1=data2.month
    Run a query to Download Data