ACTION,

AMOUNT0_USD + AMOUNT1_USD AS AMOUNT_USD,

BLOCK_TIMESTAMP,

TX_HASH,

LIQUIDITY_PROVIDER AS USER

FROM ethereum.uniswapv3.ez_lp_actions

WHERE AMOUNT_USD < POW(10, 6)

TRUNC(BLOCK_TIMESTAMP, 'MONTH') AS DATE,

COUNT(DISTINCT TX_HASH) AS TRANSACTIONS,

SUM(AMOUNT_USD) AS VOLUME,

AVG(AMOUNT_USD) AS AVG_VOLUME,

MEDIAN(AMOUNT_USD) AS MEDIAN_VOLUME,

COUNT(DISTINCT USER) AS USERS,

SUM(TRANSACTIONS) OVER (ORDER BY DATE) AS CUMULATIVE_TRANSACTIONS,

SUM(VOLUME) OVER (ORDER BY DATE) AS CUMULATIVE_VOLUME

FROM MAIN

WHERE ACTION = 'INCREASE_LIQUIDITY'

GROUP BY 1

ORDER BY 1