itsxenuxBalloonsville Rug Average Sale Price
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
27
›
⌄
WITH all_sales AS (
SELECT
tx_id,
block_timestamp,
(
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 +
COALESCE(inner_instruction:instructions[4]:parsed:info:lamports, 0)
)/POW(10,9) AS sell_price
FROM solana.nfts SN
JOIN solana.labels SL
ON SN.mint = SL.address
WHERE date(block_timestamp) > '2022-02-04'
AND instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
AND array_size(inner_instruction:instructions) > 4
AND SL.label = 'balloonsville'
)
SELECT
date(block_timestamp) AS date,
avg(sell_price) AS average_sale
from all_sales
GROUP BY date
ORDER BY date
Run a query to Download Data