select
date_trunc('day',block_timestamp) as block_day,
count(distinct(swapper)) as Investors,
sum(swap_from_amount) as Lost_Algo
from algorand.swaps
where swap_to_asset_id = '604643747'
AND
swap_from_asset_id = 0
group by block_day
order by block_day