DATE(block_timestamp) AS transaction_date,

COUNT(DISTINCT t.chain) AS daily_chain_count,

COUNT(DISTINCT t.liquidity_pool) AS daily_pool_count,

COUNT(DISTINCT t.transaction_id) AS daily_swap_count,

COUNT(DISTINCT t.user_address) AS daily_unique_users,

SUM(t.transaction_volume) AS daily_total_transaction_volume

FROM

(SELECT

COALESCE(from_amount_usd, to_amount_usd) AS transaction_volume,

blockchain AS chain,

pool_name AS liquidity_pool,

tx_id AS transaction_id,

from_address AS user_address,

block_timestamp

FROM

thorchain.defi.fact_swaps

WHERE

block_timestamp::date >= '2024-01-01'

) AS t

GROUP BY

transaction_date

ORDER BY

transaction_date;