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

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

else 'New' end as wallet_age

from lasts)

select wallet_age, count(from_address) as count

from finalss

group by 1