SELECT

DATE_TRUNC('day',BLOCK_TIMESTAMP) AS DATE,

TX_HASH,

POOL_ADDRESS,

POOL_NAME,

RECIPIENT,

TOKEN0_SYMBOL

AMOUNT0_USD,

TOKEN1_SYMBOL,

AMOUNT1_USD,

(ABS(AMOUNT0_USD) + ABS(AMOUNT1_USD))/2 AS VOL_USD

FROM

ethereum.uniswapv3.ez_swaps

WHERE (AMOUNT0_USD > 0 OR AMOUNT1_USD > 0)

AND BLOCKCHAIN = 'ethereum'

AND DATE >= CURRENT_DATE - INTERVAL '12months'

ORDER BY 1 ASC),

AGG_TABLE AS (

DATE,

POOL_ADDRESS,

POOL_NAME,

SUM(VOL_USD) AS AMOUNT_USD

SWAP_DAILY

GROUP BY 1,2,3

ORDER BY 1)

A.DATE,

A.POOL_ADDRESS,