STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Tesla's Bitcoin 10-K: Feb 8, 2021 on the Tape
Was February 8 a big day for TSLA? Its own prior five months as the yardstickscalar · 2026-07-26 · 1×4109 February 8, 2021 across the bitcoin-adjacent names: close-to-close change, ET regular hoursranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. The 2022 exit: the July 20 disclosure 8-K on file, and TSLA's next sessionscalar · 2026-07-26 · 1×51 TSLA by half-hour: February 8, 2021 regular sessionseries · 2026-07-26 · 13×4Preview: a 13-point series, ending lower. TSLA options on February 8, 2021 vs the prior 20 sessions: contracts and put/call mixscalar · 2026-07-26 · 1×70.85 TSLA's next 20 sessions: every close indexed to the February 8, 2021 closeseries · 2026-07-26 · 21×3Preview: a 16-point series, ending lower. Tesla's SEC filings dated February 8, 2021: plus the year-end cash the purchase came out ofscalar · 2026-07-26 · 1×51 TSLA on February 8, 2021: the disclosure session, receiptedscalar · 2026-07-26 · 1×11852.61
Was February 8 a big day for TSLA? Its own prior five months as the yardstick

Was February 8 a big day for TSLA? Its own prior five months as the yardstick

most recentas of scalar 1×4read in context →
baseline sessions
109
median abs move pct
2.5
sessions moving more
80
feb8 change pct
1.3
the exact SQL behind every number 
WITH daily AS (
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
        argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS close_usd
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'TSLA'
      AND window_start >= toDateTime('2020-08-31 00:00:00') AND window_start < toDateTime('2021-02-09 01:00:00')
    GROUP BY et_date
),
chg AS (
    SELECT
        et_date,
        close_usd,
        lagInFrame(close_usd) OVER (ORDER BY et_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_close
    FROM daily
)
SELECT
    countIf(et_date >= toDate('2020-09-01') AND et_date < toDate('2021-02-08') AND prev_close > 0) AS baseline_sessions,
    round(quantileDeterministicIf(0.5)(abs(close_usd / prev_close - 1) * 100, toUInt32(et_date), et_date >= toDate('2020-09-01') AND et_date < toDate('2021-02-08') AND prev_close > 0), 1) AS median_abs_move_pct,
    countIf(et_date >= toDate('2020-09-01') AND et_date < toDate('2021-02-08') AND prev_close > 0 AND abs(close_usd / prev_close - 1) > abs((SELECT close_usd / prev_close - 1 FROM chg WHERE et_date = toDate('2021-02-08')))) AS sessions_moving_more,
    round(anyIf((close_usd / prev_close - 1) * 100, et_date = toDate('2021-02-08')), 1) AS feb8_change_pct
FROM chg
HAVING countIf(et_date >= toDate('2020-09-01') AND et_date < toDate('2021-02-08') AND prev_close > 0) > 0
More from this analysisTesla's Bitcoin 10-K: Feb 8, 2021 on the Tape
The 2022 exit: the July 20 disclosure 8-K on file, and TSLA's next session scalar 1×5 → TSLA options on February 8, 2021 vs the prior 20 sessions: contracts and put/call mix scalar 1×7 → Tesla's SEC filings dated February 8, 2021: plus the year-end cash the purchase came out of scalar 1×5 → TSLA on February 8, 2021: the disclosure session, receipted scalar 1×11 → See all 2,170 queries →
$