alirsAlgoDex Volume
    Updated 2022-07-01
    with algodex_txns as (
    select
    TRY_BASE64_DECODE_STRING(tx_message:txn:note) as note,
    replace(REGEXP_SUBSTR(note,'("escrowOrderType":)("\\w+")'),'\"','') as order_type,
    *
    from algorand.transactions
    where
    block_timestamp::date >= '2022-02-09'and block_timestamp::date <= '2022-07-02'
    and order_type is not null
    )
    select
    date_trunc('day',block_timestamp) as date,
    sum(tx_message:txn:amt/1e6) as algo_amount,
    sum(algo_amount) over (order by date asc rows between unbounded preceding and current row) as cumulative_algo_amount
    from algorand.transactions
    where tx_group_id in (select tx_group_id from algodex_txns)
    and asset_id = 0 -- ALGO
    and block_timestamp::date >= '2022-02-09'and block_timestamp::date <= '2022-07-02'
    group by date
    Run a query to Download Data