0xaimandweferfQFWER
Updated 2022-11-27
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
›
⌄
with a as (select *, inner_instructions[1]:instructions[3]:accounts[12] from solana.core.fact_transactions
where inner_instructions[1]:instructions[3]:accounts[12]= 'yootn8Kf22CQczC732psp7qEqxwPGSDQCFZHkzoXp25'),
b as ( select mint from solana.core.fact_nft_mints m
inner join a on a.tx_id=m.tx_id)
, d as ( select c.* from solana.core.fact_nft_sales c
inner join b on b.mint=c.mint),
sales as (select date(block_timestamp) as dt, min(SALES_AMOUNT) as floor_price, max(SALES_AMOUNT) as ceiling_price, median(SALES_AMOUNT) as median, avg(SALES_AMOUNT) as avg_sales_price --date(block_timestamp) as dt, count(distinct PURCHASER) as n_unique_buyer, count(distinct tx_id) as n_nft_sold
from d
group by 1),
pr as (select date(RECORDED_HOUR) as dtp, avg(close) as avp from solana.core.fact_token_prices_hourly
where symbol = 'SOL'
group by 1)
select dt, floor_price, ceiling_price, median, avg_sales_price,
floor_price*avp as floor_price_usd, ceiling_price*avp as ceiling_price_usd, median*avp as median_usd, avg_sales_price*avp as avg_sales_price_usd
from sales inner join pr on sales.dt=pr.dtp
limit 2000
Run a query to Download Data