0xaimanSolana Blue Chip Weekly Floor Price since June '22
    Updated 2022-06-15

    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