LTirrellxNFT_all_summary_with_old
Updated 2023-03-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
all_data as (
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 in (
'xnft5aaToUM4UFETUQfj7NUDUBdvYHTVhNFThEYTm55',
'BaHSGaf883GA3u8qSC5wNigcXyaScJLSBJZbALWvPcjs'
)
and block_timestamp::date > current_date - 90
order by
block_timestamp desc
)
-- select
-- count(distinct tx_id) as count,
-- programId
-- from all_data
-- where instruction_type = 'createInstall'
-- group by programId
select
block_timestamp::date as date,
Run a query to Download Data