-- SELECT
-- TRUNC(BLOCK_TIMESTAMP,'day') Daily,
-- SUM(RUNE_AMOUNT_USD) as "Volume(USD)",
-- AVG(RUNE_AMOUNT_USD) as "Avg Volume(USD)",
-- FROM thorchain.core.fact_transfers
-- WHERE Daily::date >= current_date - 30
-- GROUP BY TRUNC(BLOCK_TIMESTAMP,'day')
-- LIMIT 100
SELECT
trunc(block_timestamp,'day') daily,
SUM(FROM_AMOUNT_USD) as "Volume(USD)",
AVG(FROM_AMOUNT_USD) as "Avg Volume(USD)",
FROM thorchain.defi.fact_swaps
GROUP BY TRUNC(BLOCK_TIMESTAMP,'day')