strawbettyPact.fi (Add & Remove liquidity goBTC)
    Updated 2022-05-25
    -- Pact.fi (Add & Remove liquidity)
    select
    block_timestamp::date as date,
    case when TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'ADDLIQ' then 'Add liquidity'
    when TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'REMLIQ' then 'Remove liquidity' 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[1] = '386192725' -- goBTC
    and
    (
    TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'ADDLIQ'
    or
    TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'REMLIQ'
    )
    group by 1,2
    Run a query to Download Data