SELECT
count(distinct(tx_id)) as dex_agg_tx,
block_timestamp::date as date
FROM thorchain.swap_events
WHERE SPLIT(memo, ':')[6] IS NOT NULL
and date between '2022-08-23' and current_date - 1
group by 2 order by 2 desc
-- We are not sure if 'Swap In' transactions are counted in this query. Swap In = Dex Aggretator -> Thorchain , Swap Out = Thorchain -> Dex Aggregator