STRASMORE/EXPLORE 2,549 QUERIES

band_trace

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-09-24, from bulk-deals-vs-block-deals-in-india.

as of series 21×3read in context →
band_trace — 21 rows by 3 columns, computed from US exchange, SIP and OPRA data.
session_datehigh_above_vwap_pctlow_below_vwap_pct
2026-06-011.150.78
2026-06-020.722.13
2026-06-031.740.87
2026-06-040.740.51
2026-06-051.521.07
2026-06-083.172.15
2026-06-092.981.48
2026-06-101.151.4
2026-06-110.981.56
2026-06-121.90.68
2026-06-150.61.48
2026-06-160.651.55
2026-06-171.670.93
2026-06-180.840.83
2026-06-221.250.65
2026-06-231.60.92
2026-06-241.640.65
2026-06-254.091.35
2026-06-261.282.96
2026-06-292.230.79
2026-06-300.642.63
Rows × columns
21 × 3
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for band_trace, derived from the stored result.
ColumnTypeRangeNotes
session_date date 2026-06-01 to 2026-06-30
high_above_vwap_pct number 0.6 to 4.09 percent
low_below_vwap_pct number 0.51 to 2.96 percent

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.

SELECT
    toString(date)                                          AS session_date,
    round(100 * (toFloat64(high) / toFloat64(vwap) - 1), 2) AS high_above_vwap_pct,
    round(100 * (toFloat64(vwap) / toFloat64(low) - 1), 2)  AS low_below_vwap_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'AAPL'
  AND date >= '2026-06-01'
  AND date <= '2026-06-30'
  AND vwap > 0
  AND low > 0
ORDER BY date
⌘/Ctrl + Enter

ఈ డేటాతో మీ AI అసిస్టెంట్‌లో పని చేయండి

ఈ పేజీ డేటాతో, క్వెరీకి సిద్ధంగా తెరుచుకుంటుంది. ఉచితం, ఖాతా అవసరం లేదు.

Claude ChatGPT Gemini Muse మీ సొంత ఏజెంట్