0xaimanSolana Blue Chip Weekly Floor Price since June '22
Updated 2022-06-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
›
⌄
select date_trunc('week',block_timestamp) as dt, address_name as project, min(floor_price) as floor_price_
from(with ax as (with sales as (select block_timestamp, mint, min(sales_amount) as floor_price from solana.core.fact_nft_sales
where block_timestamp>='2022-06-01'
group by 1 ,2 order by 1),
label as (select address, address_name from solana.core.dim_labels)
select block_timestamp, mint, address_name,floor_price
from sales inner join label on sales.mint=label.address),
bx as ( select address_name, min(sales_amount) as floor
from (with l as (select address, address_name from solana.core.dim_labels),
s as (
select block_timestamp,mint, tx_id, sales_amount from solana.core.fact_nft_sales
)
select block_timestamp,address_name, tx_id, sales_amount
from l inner join s on l.address=s.mint
where block_timestamp>='2022-06-01')
group by 1 order by 2 desc
limit 10)
select block_timestamp, mint, ax.address_name,floor_price
from ax inner join bx on ax.address_name=bx.address_Name)
Run a query to Download Data