SELECT
COUNT(DISTINCT tx_id) AS no_of_swaps,
avg(volume) AS avg_swap_volume,
pool_name,
date_trunc('day',block_timestamp) AS day
FROM (
SELECT
tx_id,
block_timestamp,
pool_name,
CASE WHEN to_asset = 'THOR.RUNE' THEN to_e8 ELSE from_e8 END AS volume
FROM thorchain.swap_events
WHERE block_timestamp > CURRENT_DATE - 90
)
GROUP BY 3,4
ORDER BY 4 ASC, 2 DESC