binhachonSymmetric vs Asymmetric LPs - #2
    Updated 2022-05-27
    with liquidity_actions as (
    select
    block_timestamp,
    case when position('-', pool_name, 1) = 0 then pool_name else substr(pool_name, 1, position('-', pool_name, 1) - 1) end as pool_name1,
    pool_name,
    case
    when rune_amount = 0 then 'Asset only'
    when asset_amount = 0 then 'Rune only'
    else 'Symmetric' end
    as category,
    lp_action
    from flipside_prod_db.thorchain.liquidity_actions
    )
    select
    date_trunc('month', block_timestamp) as time,
    category,
    pool_name1,
    count(*) as number_of_transactions
    from liquidity_actions
    where block_timestamp >= getdate() - interval'6 months'
    group by 1, 2, 3
    qualify row_number() over (partition by time order by number_of_transactions desc) < 10
    Run a query to Download Data