0xaimanFlloor Price of June NFTs on Solana
    Updated 2022-06-15

    select date_trunc('week',block_timestamp) as week, address_name, 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 project, nft_holding_pattern, n_address_minter
    from (select address_name as project,NFT_holding_pattern,count(purchaser) as n_address_minter
    from (select address_name, purchaser, case
    when xd=0 then 'Held'
    when xd>=1 and xd<7 then 'Flipped after 7 day'
    when xd>=7 and xd<14 then 'Flipped after 14 days'
    when xd>14 then 'Held more than 2 weeks before flip'

    end as NFT_holding_pattern
    from (with held as (select mint, purchaser, datediff(day,t1,t2) as days_hold_bfore_sold
    from
    (with a as (select mint, purchaser, block_timestamp as t1,mint_price, count(tx_id) as n_nft_minted from solana.core.fact_nft_mints
    where block_timestamp>='2022-06-01'

    group by 1,2,3,4 order by 1),

    b as (
    Run a query to Download Data