0xaimanVolume of Pool by TVL
    Updated 2021-11-01


    with addvalue as (select pool_name, sum(rune_amount) as r1,sum(rune_amount_usd) as rusd1, sum(asset_amount) as a1, sum(asset_amount_usd) as ausd1
    from thorchain.liquidity_actions
    where lp_action='add_liquidity'
    group by pool_name
    ),


    removevalue as (select pool_name, sum(rune_amount) as r2,sum(rune_amount_usd) as rusd2, sum(asset_amount) as a2, sum(asset_amount_usd) as ausd2
    from thorchain.liquidity_actions
    where lp_action='remove_liquidity'
    group by pool_name
    )

    select addvalue.pool_name, r1-r2 as Rune_amount,rusd1-rusd2 as rune_amount_usd,a1-a2 as asset_amount ,ausd1-ausd2 as asset_amount_usd
    from addvalue
    inner join removevalue on addvalue.pool_name=removevalue.pool_name
    Run a query to Download Data