trunc(BLOCK_TIMESTAMP, 'Day') as "Day",

sum(RUNE_AMOUNT_USD) as "Volume(USD)",

avg(RUNE_AMOUNT_USD) as "Avg Volume(USD)",

from thorchain.core.fact_transfers

group by trunc(BLOCK_TIMESTAMP, 'Day')