crypto_edgarFloor Price Tracker
Updated 2023-05-30
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
›
⌄
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