nitsTotal transactions NFTs based on days
Updated 2022-02-22
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
›
⌄
with addr as (SELECT address,project_name
from crosschain.address_labels
where blockchAIN = 'solana' and label_type = 'nft')
SELECT project_name,date(block_timestamp)as day, avg(amt)/pow(10,9) as avg_price,
sum(amt)/pow(10,9) as total_sales,
sum(total_sales) over(partition by project_name order by day) as cum_vol ,
count(*) as total_txs ,
sum(total_txs) over(partition by project_name order by day) as cum_txs
from
(SELECT * from
(SELECT *,
inner_instruction:instructions[0]:parsed:info:lamports+
inner_instruction:instructions[1]:parsed:info:lamports+
inner_instruction:instructions[2]:parsed:info:lamports+
inner_instruction:instructions[3]:parsed:info:lamports as amt
from solana.nfts
where array_size(inner_instruction:instructions) > 4
-- and instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
)
inner join
addr
on mint = address )
where amt is not NULL
GROUP by 1,2
order by 2,5 desc
Run a query to Download Data