horquillas
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-09, from us-premarket-and-after-hours-spain-time.
| tramo | aapl_pb | ko_pb |
|---|---|---|
| Premarket (10:00 a 15:30) | 6.88 | 22.38 |
| Sesión regular (15:30 a 22:00) | 0.91 | 1.13 |
| After hours (22:00 a 02:00) | 5.34 | 21.59 |
- Rows × columns
- 3 × 3
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
tramo |
text | 3 distinct values | |
aapl_pb |
number | 0.91 to 6.88 | |
ko_pb |
number | 1.13 to 22.38 |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
WITH cotizaciones AS
(
SELECT
ticker,
toUInt64(sequence_number) AS peso,
toHour(toTimeZone(sip_timestamp, 'America/New_York')) * 60
+ toMinute(toTimeZone(sip_timestamp, 'America/New_York')) AS minuto_et,
10000 * (toFloat64(ask_price) - toFloat64(bid_price))
/ ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) AS horquilla_pb
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('AAPL', 'KO')
AND sip_timestamp >= '2026-09-14 08:00:00'
AND sip_timestamp < '2026-09-18 00:00:00'
AND toHour(toTimeZone(sip_timestamp, 'America/New_York')) BETWEEN 4 AND 19
AND toMinute(toTimeZone(sip_timestamp, 'America/New_York')) < 5
AND bid_price > 0
AND ask_price > bid_price
AND sequence_number > 0
)
SELECT
multiIf(minuto_et < 570, 'Premarket (10:00 a 15:30)',
minuto_et < 960, 'Sesión regular (15:30 a 22:00)',
'After hours (22:00 a 02:00)') AS tramo,
round(quantileDeterministicIf(0.5)(horquilla_pb, peso, ticker = 'AAPL'), 2) AS aapl_pb,
round(quantileDeterministicIf(0.5)(horquilla_pb, peso, ticker = 'KO'), 2) AS ko_pb
FROM cotizaciones
GROUP BY tramo
HAVING countIf(ticker = 'AAPL') > 20
AND countIf(ticker = 'KO') > 20
ORDER BY min(minuto_et)
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.