select distinct asset_blockchain, is_small, count(is_small)

    FROM

    (

    select asset_blockchain,

    case when asset_amount_usd <1000 then 'small' else 'large' end as is_small
    from thorchain.liquidity_actions

    where lp_action != 'remove_liquidity'
    and block_timestamp >= CURRENT_DATE - 30
    --and asset_blockchain = 'TERRA'
    --and asset_amount_usd <1000
    and asset_amount_usd !=0

    )

    group by 1,2
    Run a query to Download Data