LTirrellxNFT_all
Updated 2023-06-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
block_timestamp,
block_id,
tx_id,
instructions[0]:accounts[0] as xnft, -- only the xNFT account for certain instructions
instructions[0]:data as program_data, -- can be used to find instruction name
case
when program_data = '7tyNegi96Ez' then 'createInstall'
else program_data
end as instruction_type,
instructions[0]:programId as programId,
signers[0] as fee_payer,
succeeded,
instructions[0]:accounts as all_accounts -- unparsed account info
from
solana.core.fact_transactions
where
programId = 'xnft5aaToUM4UFETUQfj7NUDUBdvYHTVhNFThEYTm55'
and block_timestamp::date > '2022-12-01'
order by
block_timestamp desc
Run a query to Download Data