KaskoazulSmall LP actions
    Updated 2022-04-13
    with LARGE_RUNE as (
    select pool_name,
    'RUNE' as ASSET,
    count(rune_amount_usd) as LARGE_RUNE
    from thorchain.liquidity_actions
    where rune_amount_usd >= 1000
    group by 1, 2
    order by 1, 2
    ),

    SMALL_RUNE as (
    select pool_name,
    'RUNE' as ASSET,
    count(rune_amount_usd) as SMALL_RUNE
    from thorchain.liquidity_actions
    where rune_amount_usd < 1000
    group by 1, 2
    order by 1, 2
    ),

    LARGE_ASSET as (
    select pool_name,
    'ASSET' as ASSET,
    count(asset_amount_usd) as LARGE_ASSET
    from thorchain.liquidity_actions
    where asset_amount_usd >= 1000
    group by 1, 2
    order by 1, 2
    ),

    SMALL_ASSET as (
    select pool_name,
    'ASSET' as ASSET,
    count(asset_amount_usd) as SMALL_ASSET
    from thorchain.liquidity_actions
    where asset_amount_usd < 1000
    Run a query to Download Data