flipside

    #4 total liquidity volume by pool and over time
    german#4 total liquidity volume by pool and over time
    Updated 2021-10-28
    select
    date_trunc('day', block_timestamp) as day,
    sum(asset_amount_usd),
    lp_action,
    pool_name

    FROM thorchain.liquidity_actions
    WHERE asset_amount_usd > 5000
    GROUP BY 4,1,3
    ORDER BY 1
    Run a query to Download Data