DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,

COUNT(DISTINCT TX_HASH) AS "Total Transactions",

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users",

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD, 0)) AS "Trading Volume USD",

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD, 0)) / COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Avg Volume Per User",

AVG(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD, 0)) AS "Avg Volume"

FROM

avalanche.defi.ez_dex_swaps

WHERE

TOKEN_IN = LOWER('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')

OR

TOKEN_OUT = LOWER('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

Date DESC;