block_timestamp::date as date,

COUNT(*) AS total_swaps,

count(distinct FROM_ADDRESS) AS sender,

count(distinct NATIVE_TO_ADDRESS) AS receiver,

SUM(case when from_asset='THOR.RUNE' then FROM_AMOUNT ELSE to_amount end) AS total_rune_swapped

FROM thorchain.core.fact_swaps

WHERE (from_ASSET = 'THOR.RUNE' or to_asset = 'THOR.RUNE')

and block_timestamp>=current_date-INTERVAL '1 YEAR'

GROUP BY 1

ORDER BY 1