BLOCK_TIMESTAMP,

TX_ID,

FROM_ADDRESS,

COALESCE(FROM_AMOUNT_USD, TO_AMOUNT_USD) AS VOLUME,

FROM thorchain.defi.fact_swaps

WHERE AFFILIATE_ADDRESS = 'll'

AND BLOCK_TIMESTAMP::DATE >= '2024-10-21'

COUNT(DISTINCT TX_ID) AS TOTAL_SWAPS,

COUNT(DISTINCT FROM_ADDRESS) AS TOTAL_USERS,

SUM(VOLUME) AS TOTAL_SWAP_VOL,

AVG(VOLUME) AS AVG_VOL_PER_DAY,

TOTAL_SWAPS / TOTAL_USERS AS AVG_SWAPS_PER_USER,

TOTAL_SWAP_VOL/ TOTAL_USERS AS AVG_SWAPVOL_PER_USER

FROM STATS