crypto_edgarFloor Price Tracker
    Updated 2023-05-30
    with
    okay_bears AS (
    SELECT
    ADDRESS AS MINT
    FROM
    solana.core.dim_labels
    WHERE
    label = 'okay bears'
    ),
    sol_prices as (
    select
    DATE_TRUNC('Day', recorded_hour) as day,
    avg(close) as price_sol
    from
    solana.core.fact_token_prices_hourly
    where
    symbol = 'SOL'
    and day >= TIMESTAMP '2023-04-17'
    group by
    day
    ),
    floor_prices as (
    select
    date_trunc('day', block_timestamp) as day,
    percentile_cont(0.1) within group (
    order by
    sales_amount
    ) as floor
    from
    solana.core.fact_nft_sales sales
    inner join okay_bears using (mint)
    left join solana.core.fact_token_prices_hourly prices on date_trunc('hour', block_timestamp) = prices.recorded_hour
    and prices.symbol = 'SOL'
    where
    succeeded
    and block_timestamp >= TIMESTAMP '2022-04-26'
    Run a query to Download Data