SELECT DATE(BLOCK_TIMESTAMP) day_, COUNT(*) AS swaps_number,
sum(CASE WHEN t2.ADDRESS = t1.FROM_CURRENCY THEN FROM_AMOUNT ELSE TO_AMOUNT END) as amount
FROM osmosis.core.fact_swaps t1
JOIN osmosis.core.dim_labels t2 ON t2.ADDRESS = t1.FROM_CURRENCY OR t2.ADDRESS = t1.To_CURRENCY
WHERE t1.BLOCK_TIMESTAMP >= DATEADD(DAY, -90, CURRENT_DATE)
AND t1.TX_STATUS = 'SUCCEEDED'
AND t2.address = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A' --upper(t1.PROJECT_NAME) = 'SCRT'
GROUP BY DATE(BLOCK_TIMESTAMP)
ORDER BY 1 ASC