strawbettyAlgofi goBTC
    Updated 2022-05-25
    -- Algofi:
    select
    block_timestamp::date as date,
    case when TRY_BASE64_DECODE_STRING(tx_message:txn:note::string) = 'Market: mt' then 'mt'
    when TRY_BASE64_DECODE_STRING(tx_message:txn:note::string) = 'Market: rcu' then 'rcu' end as action,
    count(distinct sender) as users,
    count(distinct tx_group_id) as transactions
    from flipside_prod_db.algorand.transactions
    where
    tx_message:txn:apas[0] IN ('386192725', '465818554') -- goBTC
    and (
    try_base64_decode_string(tx_message:txn:note::string) = 'Market: mt'
    or
    try_base64_decode_string(tx_message:txn:note::string) = 'Market: rcu'
    )
    group by 1,2
    Run a query to Download Data