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('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')

OR

TOKEN_OUT = LOWER('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

Date DESC;