with first_pool as (
SELECT pool_name, min(block_timestamp) as min_date from thorchain.swaps
group by pool_name
)
SELECT sw.pool_name, sum(sw.FROM_AMOUNT_USD) as total_usd
FROM thorchain.swaps sw
join first_pool fp on fp.pool_name = sw.pool_name
-- where sw.tx_id = '13944C1631DA455BC43136D1364187FFEFDC9208A878D6B45F34EF24F3AB1BE8'
where date(sw.block_timestamp) = date(fp.min_date) + 7
group by sw.pool_name