(SELECT

AVG(PRICE) AS Price

, HOUR::DATE AS Date

FROM

crosschain.price.ez_prices_hourly

WHERE

TOKEN_ADDRESS = 'ibc/785AFEC6B3741100D15E7AF01374E3C4C36F24888E96479B1C33F5C71F364EF9'

GROUP BY 2)

SELECT

DATE_TRUNC('WEEK',BLOCK_TIMESTAMP) AS Date

, SUM((AMOUNT / 1E6) * PRICE) AS Volume

, SUM(Volume) OVER (ORDER BY DATE_TRUNC('WEEK',BLOCK_TIMESTAMP)) AS "Total volume"

terra.core.ez_transfers A LEFT JOIN Price B ON A.BLOCK_TIMESTAMP::DATE=B.DATE

WHERE

CURRENCY = 'uluna'

GROUP BY 1

ORDER BY 1 DESC