select
block_timestamp ::date as date ,
sum(TO_AMOUNT) as sum_TO_AMOUNT ,
sum(TO_AMOUNT_USD) as sum_TO_AMOUNT_USD,
count (DISTINCT tx_id) as num_swaps
from flipside_prod_db.thorchain.swaps
where BLOCK_TIMESTAMP::date >='2022-04-27'
and to_asset ='THOR.RUNE'
group by 1