SELECT
date_trunc('day', block_timestamp) as day,
sum(to_amount/power(10, To_DECIMAL)),
COUNT(*)
FROM osmosis.core.fact_swaps
WHERE BLOCK_TIMESTAMP > '2022-10-26'
AND TO_CURRENCY like 'uosmo'
AND trader LIKE 'osmo1y6tldk0vyu0h5m7574uhj37qrvvelc4ey0ewuq'
GROUP BY 1