DATE_TRUNC('DAY', block_timestamp) AS date,

pool_name,

pool_address,

SUM(OFFER_AMOUNT_USD) AS offer_volume_usd,

SUM(RETURN_AMOUNT_USD) as return_volume_usd

FROM flipside_prod_db.astroport.swaps

WHERE block_timestamp < '2022-05-07' -- beginning of depeg

GROUP BY 1, 2, 3

ORDER BY 1 ASC, 4 DESC;