with raw as (select block_timestamp, from_address, from_asset, to_asset, concat(from_asset, ' to ', to_asset) as swap_pair, from_amount_usd
from thorchain.swaps
where pool_name = 'DOGE.DOGE' and block_timestamp <= '2022-01-18 01:25:21.951')
select sum(from_amount_usd) as swap_volume, count(distinct from_address) as address_count
from raw