shahdadi-9ptm8YUntitled Query
    Updated 2022-07-14
    select * from flipside_prod_db.algorand.transactions where tx_group_id='5Nt6lqW2DJ14KlvN/l68gTR6jtW+3reoN54745h0q1Y='

    select
    block_timestamp::date as date,
    CASE WHEN TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'd' THEN 'Deposit'
    WHEN TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'r' THEN 'Redeem'
    end AS action,
    count(distinct tx_group_id) as tx_count,
    count(distinct sender) as users_count
    from flipside_prod_db.algorand.APPLICATION_CALL_TRANSACTION
    where TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) IN ('d','r') and app_id in( 686498781,686500029)
    and date <= '2022-05-20' and TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'l'
    group by 1,2
    order by 1,2
    Run a query to Download Data