ZookThorchain - Count Daily Dex Aggregator Transactions
    Updated 2023-03-26
    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
    Run a query to Download Data