0x137d9174D3bd00F2153DcC0Fe7AF712d3876a71EUntitled Query
Updated 2022-12-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
*
FROM (SELECT
transaction_result:events[1]:value:fields[1] as minter,
transaction_result:events[1]:value:fields[0] as id, tx_id, block_timestamp
FROM flow.core.fact_transactions
WHERE proposer = '0xe3ad6030cbaff1c2'
AND transaction_result:events[0]:type = 'A.e3ad6030cbaff1c2.DimensionX.Mint'
AND transaction_result:events[1]:type = 'A.e3ad6030cbaff1c2.DimensionX.Deposit'
AND transaction_result:events[0]:value:fields[1] = '2' -- mint type 2
AND block_timestamp > '12/07/2022'
) as res
ORDER BY block_timestamp DESC
Run a query to Download Data