SELECT date_trunc('month', block_timestamp) as month, SUM(max_value) AS MONTHLY_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 MONTH
ORDER by MONTH ASC