shadilUntitled Query
Updated 2022-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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