shadilUntitled Query
    Updated 2022-04-18
    SELECT
    ac.*
    -- TRY_BASE64_DECODE_STRING(ac.tx_message:txn:apaa[0]::STRING) as pos,
    -- COUNT(*)
    from algorand.transactions ac

    where ac.BLOCK_TIMESTAMP::date >= '2022-04-11'
    and ac.tx_group_id = 'zNQKdnCbtFJwrIrWPGQxCH4rtBAtEqA5m2vm/Mi119Y='
    -- and TRY_BASE64_DECODE_STRING(ac.tx_message:txn:apaa[0]::STRING) = 'Auction'
    -- and ac.tx_message:txn:apid::string = '684650147'
    -- GROUP by pos
    and TRY_BASE64_DECODE_STRING(ac.tx_message:txn:apaa[0]::STRING) = 'NewPosition'

    -- limit 10
    Run a query to Download Data