0xaimandweferfQFWER
    Updated 2022-11-27
    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