block_timestamp,

tx_id,

iff(charindex('-', pool_name) = 0, pool_name, LEFT(pool_name, CHARINDEX('-', pool_name) - 1)) as pool,

rune_amount,

asset_amount

from flipside_prod_db.thorchain.liquidity_actions),

n_asset_only as (select pool, count(*) as total_transactions, 'asset_only' as label from data where rune_amount = 0 group by pool),

n_rune_only as (select pool, count(*) as total_transactions, 'rune_only' as label from data where asset_amount = 0 group by pool) ,

n_symmetric as (select pool, count(*) as total_transactions, 'symmetric' as label from data where asset_amount != 0 and rune_amount != 0 group by pool),

temp as (select * from n_asset_only

union

select * from n_rune_only

union

select * from n_symmetric

select * from temp