from thorchain.liquidity_actions

where pool_name = 'DOGE.DOGE'),

addy as (select DISTINCT from_address as fromm

from raw),

firsts as (select from_address, date(block_timestamp) as dt, ROW_NUMBER() OVER(PARTITION BY from_address ORDER BY dt ASC) as rank

from thorchain.transfers

where from_address in (select fromm from addy)),

lasts as (select from_address, dt

from firsts

where rank = 1),

finalss as (select from_address, dt, case --dt is first tx ever

when dt <= '2022-01-15' then 'Old'

else 'New' end as wallet_age

from lasts),

oldwallet as (select from_address

from finalss

where wallet_age = 'Old'),

wallets as (select from_address from oldwallet),

removlp as (select *

from thorchain.liquidity_actions

where lp_action = 'remove_liquidity'

and from_address in (select from_address from wallets)

and block_timestamp between '2022-01-08' and '2022-01-15')

select from_address, pool_name, sum(rune_amount_usd+asset_amount_usd) as volume

from removlp

group by 1,2