with liquidity_remover as(
select
distinct from_address as address
from
thorchain.liquidity_actions
where
block_timestamp > '2021-11-17T00:00:00Z'
and block_timestamp < '2021-11-25T00:00:00Z'
and lp_action = 'remove_liquidity' -- and from_address not like '%thor%'
),
address_table as(
select
block_timestamp,
address,
row_number() over (
partition by address
order by
block_timestamp
) as row_number
from
(
select
block_timestamp,
to_address as address
from
thorchain.transfers
union
select
block_timestamp,
from_address as address
from
thorchain.swaps
union
select
block_timestamp,
to_address as address