from thorchain.liquidity_actions

where lp_action = 'add_liquidity' and tx_id is not null),

remlp as (select tx_id, from_address, block_timestamp, pool_name, rune_amount, asset_amount

from thorchain.liquidity_actions

where lp_action = 'remove_liquidity' and tx_id is not null)

select a.from_address, a.pool_name, a.rune_amount as add_rune, a.asset_amount as add_asset, date(a.block_timestamp) as date_add, date(b.block_timestamp) as date_rem,

datediff(day, date_add, date_rem) as duration,

b.rune_amount as remove_rune, b.asset_amount as remove_asset

from addlp a

left join remlp b on a.from_address = b.from_address and a.pool_name = b.pool_name and b.block_timestamp > a.block_timestamp

limit 1000