SELECT date_trunc('day', block_timestamp) as day, SUM(max_value) AS DAILY_USD
FROM (SELECT BLOCK_TIMESTAMP, TX_ID,
MAX(FROM_AMOUNT_USD) AS max_value
FROM thorchain.core.fact_swaps
WHERE AFFILIATE_ADDRESS='te'
GROUP BY TX_ID, BLOCK_TIMESTAMP)
GROUP BY day
ORDER by day ASC