tape kamili Juni 29 2026 ndani

Hii ni maelezo ya ndani ya muhtasari wa soko wa Juni 29, 2026: mwonekano ghafi chini ya baa za dakika — 156.1 milioni ya biashara binafsi na 505.38 milioni ya sasisho za nukuu za NBBO katika kikao cha kawaida cha Jumatatu. Kila nambari ni matokeo ya swala lililohifadhiwa (panua paneli yoyote kwa SQL kamili), na matokeo mawili ya uchunguzi wa siku hiyo yana maelezo kamili: marekebisho ya kiasi ambayo kamusi ya msimbo wa tepi inayotaka, na faili ya mtoa huduma inayoacha kimya kwenye herufi S.

Kanda ya biashara, chapisho kwa chapisho

Ukaguzi wa kikao huja kwanza, haudhaniwi kamwe: kalenda ya likizo ya soko ina safu 0 za Juni 29, 2026, na SPY ilichapisha hasa pau za dakika 390 ndani ya dirisha la kawaida — kikao kamili, 9:30 asubuhi hadi 4:00 jioni kwa saa za New York. Katika siku iliyorefushwa, kanda iliyounganishwa ilirekodi 156.1 milioni ya biashara binafsi.

WITH
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date = '2026-06-29') AS holiday_rows,
    (
        SELECT countIf(window_start >= '2026-06-29 13:30:00' AND window_start < '2026-06-29 20:00:00')
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY' AND window_start >= '2026-06-29 00:00:00' AND window_start < '2026-06-30 00:00:00'
    ) AS spy_bars
SELECT
    holiday_rows AS holiday_rows_jun29,
    spy_bars AS spy_regular_session_bars,
    round(count() / 1e6, 1) AS trades_m,
    round(100.0 * countIf(size < 100) / count(), 2) AS odd_lot_pct_of_trades,
    round(100.0 * toFloat64(sumIf(size, size < 100)) / toFloat64(sum(size)), 2) AS odd_lot_pct_of_shares,
    multiIf(
        countIf(size <= 19) >= 0.5 * count(), 19,
        countIf(size <= 20) >= 0.5 * count(), 20,
        countIf(size <= 21) >= 0.5 * count(), 21,
        countIf(size <= 22) >= 0.5 * count(), 22,
        countIf(size <= 23) >= 0.5 * count(), 23,
        0) AS median_print_shares,
    round(countIf(size = 1) / 1e6, 1) AS one_share_trades_m,
    round(100.0 * countIf(size != round(size)) / count(), 2) AS fractional_pct_of_trades
FROM global_markets.stocks_trades
WHERE sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'

72.61% ya machapisho yote yalikuwa kura zisizo za kawaida — biashara za chini ya hisa 100 — lakini zilihamisha 8.79% tu ya hisa ghafi — jumla isiyorekebishwa ambayo sehemu ya uchunguzi wa kiasi hapa chini inapunguza. Chapisho la wastani lilikuwa hisa 21, likipimwa kwa kifaa cha kuthibitisha chenye mabano — hesabu za jumla kwa hisa 19 hadi 23 — ambacho kinarudisha 0 ikiwa mabano unakosa, na limefungwa ili kukosa kushikilia baada ya hapo. Machapisho 17.9 milioni yalikuwa kwa hisa moja haswa na 4.73% yalikuwa na ukubwa wa sehemu — muundo unaoendana na programu za rejareja zinazogonga kanda kipande kimoja kwa wakati, huku watengenezaji wa soko wakichukua upande mwingine.

Uchunguzi wa kiasi cha biashara: kupata "kiasi kinacholingana" kutoka kwa kamusi

Jumlisha sehemu ya ukubwa kwenye kila chapisho na Juni 29 inaonyesha hisa 24.79 bilioni zilizouzwa. Takwimu hiyo si sahihi, na mkanda wenyewe unasema hivyo. Kila chapisho hubeba misimbo ya hali, na SIP — Mchakataji wa Taarifa za Dhamana anayeunganisha kila soko kuwa mkondo mmoja — huchapisha kamusi inayoeleza, kwa kila msimbo, ikiwa chapisho linasasisha kiasi cha jumla. Baadhi ya ujumbe ni matangazo ya kiutawala ya kiasi ambacho tayari kimehesabiwa mara moja. Badala ya kuweka msimbo wa orodha ya misimbo "inayojulikana", chapisho hili linapata seti ya kutengwa kutoka kwa kamusi yenyewe:

SELECT
    count() AS excluded_codes,
    sum(id) AS excluded_id_checksum,
    arrayStringConcat(arraySort(groupArray(concat(toString(id), ' ', name))), ' · ') AS codes
FROM global_markets.stocks_condition_codes
WHERE asset_class = 'stocks'
  AND type = 'sale_condition'
  AND JSONExtractBool(update_rules, 'consolidated', 'updates_volume') = 0

Masharti 3 ya mauzo yana updates_volume = false kwenye mkondo wa pamoja: 15 Market Center Official Close · 16 Market Center Official Open · 38 Corrected Consolidated Close (per listing market). Hapa kuna somo lililofanyiwa kazi: rasimu ya awali ya muhtasari wa kila siku iliweka misimbo 15 na 16 — ujumbe rasmi wa kufungua/kufunga ambao kila mwongozo wa data unataja — na ikakosa msimbo 38 kabisa. Kamusi, si orodha ya misimbo iliyokaririwa, ndiyo chanzo cha ukweli.

Vitalu viwili ni makusudi: swali la scalar ndani ya kamusi ndani ya uchunguzi wa rekodi 156.1 milioni linavuka kikomo chetu cha sekunde 30. Kwa hivyo kitalu cha juu kinapata seti kama safu moja — iliyodhibitiwa kwa usahihi kwa hesabu ya misimbo na checksum ya kitambulisho (69) — na kitalu cha chini kinatumia viambishi vilivyopatikana. Ikiwa kamusi itabadilika wakati wowote, kikomo cha checksum kitashikilia chapisho hili kwa ukaguzi; viambishi haviwezi kamwe kuwa vya zamani kimyakimya.

SELECT
    round(toFloat64(sum(size)) / 1e9, 2) AS raw_shares_bn,
    round(toFloat64(sumIf(size, NOT hasAny(conditions, [15, 16, 38]))) / 1e9, 2) AS matched_shares_bn,
    round(toFloat64(sumIf(size, hasAny(conditions, [15, 16, 38]))) / 1e9, 2) AS excluded_shares_bn,
    countIf(hasAny(conditions, [15, 16, 38])) AS excluded_prints
FROM global_markets.stocks_trades
WHERE sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'

Hesabu iliyosahihishwa: hisa 24.79 bilioni ghafi, hisa 20.66 bilioni zilizohesabiwa na SIP, hisa 4.13 bilioni zilizotengwa katika machapisho 91175 ya kiutawala. Ufafanuzi mmoja, ulioelezwa kwa usahihi: "kiasi kinacholingana" maana yake ni kiasi ambacho sheria za hali za SIP zenyewe zinahesabu kwa jumla ya pamoja — hakuna zaidi. Hatuamuzi ni biashara zipi zilikuwa na maana kiuchumi; tunatumia hesabu ya mkanda yenyewe.

Machapisho makubwa zaidi, yamefafanuliwa

Machapisho makubwa zaidi ya siku hii ndipo misimbo ya hali inapoacha kuwa maelezo madogo:

SELECT
    ticker,
    formatDateTime(toTimeZone(sip_timestamp, 'America/New_York'), '%H:%i:%S') AS et_time,
    round(toFloat64(size) / 1e6, 2) AS shares_m,
    toFloat64(price) AS price,
    round(toFloat64(size) * toFloat64(price) / 1e6, 1) AS notional_usd_m,
    round(100 * (toFloat64(size) * toFloat64(price)) / max(toFloat64(size) * toFloat64(price)) OVER (), 1) AS pct_of_biggest_dollar_print,
    arrayStringConcat(arrayMap(c -> toString(c), conditions), ', ') AS condition_id
FROM global_markets.stocks_trades
WHERE sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'
  AND size >= 10000000
  AND NOT hasAny(conditions, [15, 16, 38])
ORDER BY size DESC
LIMIT 10

Soma safu za juu kama mfano uliofanyiwa kazi. Chapisho kubwa zaidi la siku — hisa 61.69 milioni CAG (Conagra) kwa $13.98, takriban $862.5 milioni, lililowekwa muhuri 16:04:53 ET chini ya misimbo 8, 41 (8 Closing Prints, 41 Trade Thru Exempt) — ni matokeo ya mnada wa kufunga wa NYSE uliochapishwa baada ya saa 4:00 usiku. Inahesabiwa kwa kiasi cha mauzo mara moja tu. Hisa zilezile 61.69 milioni kisha zinaonekana tena chini ya msimbo 15, Market Center Official Close: ripoti ya kurudia ambayo kamusi haijumuishi, sehemu ya 4.13 bilioni iliyoondolewa hapo juu. Safu hiyo ya msimbo-15 imeondolewa kwenye jedwali hapo juu kwa makusudi, kwa hivyo upokeaji wake unapata paneli yake ya bei nafuu ya safu moja:

SELECT
    round(toFloat64(maxIf(size, has(conditions, 8))) / 1e6, 2) AS auction_print_shares_m,
    round(toFloat64(maxIf(size, has(conditions, 15))) / 1e6, 2) AS official_close_reprint_shares_m,
    round(toFloat64(maxIf(size, has(conditions, 8))) - toFloat64(maxIf(size, has(conditions, 15))), 2) AS share_difference,
    formatDateTime(toTimeZone(argMaxIf(sip_timestamp, size, has(conditions, 15)), 'America/New_York'), '%H:%i:%S') AS reprint_et,
    argMaxIf(exchange, size, has(conditions, 15)) AS reprint_exchange_id,
    countIf(has(conditions, 15)) AS cag_code15_prints
FROM global_markets.stocks_trades
WHERE ticker = 'CAG'
  AND sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'

Kubwa zaidi kati ya jumbe 6 za kufunga rasmi kwenye CAG hubeba hisa 61.69 milioni — mnada 61.69 milioni haswa (tofauti: 0) — iliyowekwa muhuri 16:04:53 ET kutoka kitambulisho cha soko 10, NYSE katika saraka ya hisa: soko la kuorodhesha likirudia mnada wake wenyewe.

Safu zingine CAG ni kiumbe tofauti — chapisho la hisa 15.17 milioni chini ya misimbo 12, 2 (12 Form T / extended hours, 2 Average Price Trade) na mbili zaidi chini ya msimbo 12 ni machapisho ya baada ya mnada yaliyoripotiwa kupitia FINRA ambayo masharti yake yana updates_volume = true. SIP inayahesabu kama machapisho halisi, na vivyo hivyo takwimu yetu iliyolinganishwa.

Kwingineko, msimbo 9 unaashiria misalaba ya kufunga ya Nasdaq — msalaba wa NVDA wa $3389.5 milioni ndio chapisho kubwa zaidi la jedwali kwa dola — na misimbo kwenye chapisho la SNAP (53, 41) inajumuisha 53, Qualified Contingent Trade.

Saa: dakika kumi zinazomiliki siku

Kwa mwonekano wa dakika, mkanda wa biashara hujikita karibu kabisa kwenye kingo za kipindi cha soko:

SELECT
    formatDateTime(toTimeZone(toStartOfMinute(sip_timestamp), 'America/New_York'), '%H:%i') AS et_minute,
    round(count() / 1e6, 2) AS trades_m
FROM global_markets.stocks_trades
WHERE sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'
GROUP BY et_minute
ORDER BY trades_m DESC
LIMIT 10

Dakika ya 15:59 ET ilichapisha 3.98 milioni ya miamala — zaidi ya elfu sitini kwa sekunde. Ikiwa salio la kumi bora linajikita kwenye ufunguzi na kufunga ni kipimo cha safu moja yenyewe:

SELECT
    countIf(NOT (et_minute BETWEEN '09:30' AND '09:39' OR et_minute BETWEEN '15:50' AND '16:00')) AS entries_outside_open_close,
    countIf(et_minute BETWEEN '09:30' AND '09:39' OR et_minute BETWEEN '15:50' AND '16:00') AS entries_in_open_close,
    maxIf(et_minute, NOT (et_minute BETWEEN '09:30' AND '09:39' OR et_minute BETWEEN '15:50' AND '16:00')) AS outside_entry_minute,
    maxIf(trades_m, NOT (et_minute BETWEEN '09:30' AND '09:39' OR et_minute BETWEEN '15:50' AND '16:00')) AS outside_entry_trades_m
FROM (
    SELECT
        formatDateTime(toTimeZone(toStartOfMinute(sip_timestamp), 'America/New_York'), '%H:%i') AS et_minute,
        round(count() / 1e6, 2) AS trades_m
    FROM global_markets.stocks_trades
    WHERE sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'
    GROUP BY et_minute
    ORDER BY trades_m DESC
    LIMIT 10
)

9 kati ya kumi hukaa ndani ya dakika kumi za kwanza za ufunguzi au dakika kumi za mwisho kabla ya kufunga. Isipokuwa moja — 10:15 ET, mlipuko wa 0.88 milioni ya chapa — ni hitilafu halisi ya asubuhi; sababu yake haijulikani kutoka kwa data hii, na hatutabuni moja. Saa hiyo hiyo inarudi chini.

Mkondo wa nukuu: nusu bilioni ya sasisho

National Best Bid and Offer — bei bora ya kununua na kuuza katika kila soko, inayochapishwa tena wakati wowote mojawapo inapobadilika — ilisasishwa mara 505.38 milioni mnamo Juni 29, dhidi ya biashara 156.1 milioni.

WITH
    (
        SELECT (round(countIf(ticker = 'QQQ') / 1e6, 2), round(countIf(ticker = 'NVDA') / 1e6, 2),
                round(countIf(ticker = 'AAPL') / 1e6, 2), round(countIf(ticker = 'TSLA') / 1e6, 2))
        FROM global_markets.cache_stocks_quotes
        WHERE ticker IN ('QQQ', 'NVDA', 'AAPL', 'TSLA')
          AND sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'
    ) AS pinned
SELECT
    round(count() / 1e6, 2) AS updates_m,
    pinned.1 AS qqq_updates_m,
    pinned.2 AS nvda_updates_m,
    round(pinned.1 - pinned.2, 2) AS qqq_minus_nvda_updates_m,
    round(pinned.2 - greatest(pinned.3, pinned.4), 2) AS nvda_minus_next_single_m
FROM global_markets.cache_stocks_quotes
WHERE sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'

Bidhaa za fahirisi ndizo zinazotawala nukuu: QQQ pekee ilirekodi sasisho 5.23 milioni dhidi ya 1.8 milioni kwa NVDA, hisa moja iliyonukuliwa zaidi tuliyoiangalia — sasisho 0.67 milioni zaidi ya jina linalofuata. Sensa kamili ya kila orodha kwa kila ticker haitoshi chini ya kikomo cha sekunde 30, kwa hivyo jedwali la viongozi hapa chini ni seti iliyokaguliwa, si orodha kamili:

SELECT ticker, round(count() / 1e6, 2) AS updates_m
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('QQQ', 'SPY', 'TQQQ', 'IWM', 'SQQQ', 'NVDA', 'AAPL', 'TSLA')
  AND sip_timestamp >= '2026-06-29 00:00:00' AND sip_timestamp < '2026-06-30 00:00:00'
GROUP BY ticker
ORDER BY updates_m DESC

QQQ iliongoza seti iliyokaguliwa kwa sasisho 5.23 milioni; juu ya jedwali ni fedha za fahirisi na ndugu zao za kujiinua (leveraged), si majina ya hisa moja.

SPY chini ya darubini: risiti za nanosekunde, na usambaaji pande mbili

WITH
    (
        SELECT (formatDateTime(toTimeZone(toStartOfSecond(sip_timestamp), 'America/New_York'), '%H:%i:%S'), count())
        FROM global_markets.cache_stocks_quotes
        WHERE ticker = 'SPY' AND sip_timestamp >= '2026-06-29 13:30:00' AND sip_timestamp < '2026-06-29 20:00:00'
        GROUP BY toStartOfSecond(sip_timestamp)
        ORDER BY count() DESC, toStartOfSecond(sip_timestamp) ASC
        LIMIT 1
    ) AS busiest_sec,
    ordered AS (
        SELECT
            toFloat64(ask_price - bid_price) AS spread,
            bid_price,
            ask_price,
            toFloat64(sip_timestamp - lagInFrame(sip_timestamp) OVER (ORDER BY sip_timestamp, sequence_number)) AS gap_s,
            greatest(toFloat64(least(leadInFrame(sip_timestamp, 1, toDateTime64('2026-06-29 20:00:00', 9)) OVER (ORDER BY sip_timestamp, sequence_number ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING), toDateTime64('2026-06-29 20:00:00', 9)) - sip_timestamp), 0) AS dwell_s,
            rowNumberInAllBlocks() AS rn
        FROM global_markets.cache_stocks_quotes
        WHERE ticker = 'SPY' AND sip_timestamp >= '2026-06-29 13:30:00' AND sip_timestamp < '2026-06-29 20:00:00'
    )
SELECT
    round(count() / 1e6, 2) AS spy_updates_m,
    busiest_sec.1 AS busiest_second_et,
    toUInt8(startsWith(busiest_sec.1, '10:15')) AS busiest_second_in_1015,
    busiest_sec.2 AS busiest_second_updates,
    round(minIf(gap_s, rn > 0 AND gap_s > 0) * 1e9) AS min_gap_between_updates_ns,
    round(quantileExactIf(0.5)(gap_s, rn > 0) * 1e6, 1) AS median_gap_us,
    countIf(rn > 0 AND gap_s = 0) AS identical_timestamp_pairs,
    round(sumIf(spread * dwell_s, bid_price > 0 AND ask_price >= bid_price) / sumIf(dwell_s, bid_price > 0 AND ask_price >= bid_price) * 100, 2) AS time_weighted_avg_spread_cents,
    round(avgIf(spread, bid_price > 0 AND ask_price >= bid_price) * 100, 2) AS per_update_avg_spread_cents,
    round((avgIf(spread, bid_price > 0 AND ask_price >= bid_price) - sumIf(spread * dwell_s, bid_price > 0 AND ask_price >= bid_price) / sumIf(dwell_s, bid_price > 0 AND ask_price >= bid_price)) * 100, 2) AS per_update_premium_cents,
    countIf(bid_price > 0 AND ask_price > 0 AND ask_price < bid_price) AS crossed_updates,
    countIf(bid_price <= 0 OR ask_price <= 0) AS zero_bid_or_ask_updates
FROM ordered

Nukuu ya SPY ilibadilika mara 3.98 milioni katika saa za kawaida pekee. Sekunde yake yenye shughuli nyingi zaidi — 10:15:43 ET, ndani ya dakika 10:15 iliyowekwa alama hapo juu — ilibeba masasisho 1461. Pengo dogo zaidi kati ya masasisho mfululizo lilikuwa 1375 nanoseconds, wastani wa kati 245.6 microseconds, na 75138 jozi mfululizo zilibeba mihuri ya nanosecond inayofanana — hata ubora wa nanosecond hauwezi kuagiza kikamilifu mkanda wa kisasa.

Nanosecond hizo huthibitisha thamani yake kwa kupima usambaaji wa bei ya kununua na kuuza. Kwa kuhesabu kila sasisho kwa usawa, wastani wa usambaaji wa SPY ulikuwa senti 2.72; kwa kupima kila nukuu kwa muda iliyosimama, senti 2.34. Takwimu ya kila sasisho inasomeka kuwa pana kwa senti 0.38 kimitambo: masasisho hujikusanya hasa katika nyakati ambazo usambaaji ni mpana na unaobadilika, wakati agizo linalosubiri linaishi kwa saa halisi. Wakati wowote unapoona takwimu ya usambaaji, uliza saa gani iliipima. Sensa inafichuliwa, haijafichwa: 1544 masasisho ya saa za kawaida yalivuka kwa muda (bei ya kuuza chini ya bei ya kununua, mchanganyiko wa nukuu kutoka kwa soko tofauti) na 0 yalibeba bei ya kununua au kuuza sifuri; takwimu za usambaaji hazijumuishi zote mbili na huzitenga.

Mwanya una saa yake

Kuweka mwanya wa bei uliotajwa wa SPY kwa vipindi vya nusu saa kunageuza muundo mdogo kuwa mkunjo ambao kila mfanyabiashara anaweza kutumia:

SELECT
    formatDateTime(toTimeZone(toStartOfInterval(sip_timestamp, INTERVAL 30 MINUTE), 'America/New_York'), '%H:%i') AS et_time,
    round(quantileExactIf(0.5)(toFloat64(ask_price - bid_price), bid_price > 0 AND ask_price >= bid_price) * 100, 1) AS median_spread_cents,
    count() AS quote_updates
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'SPY' AND sip_timestamp >= '2026-06-29 08:00:00' AND sip_timestamp < '2026-06-30 00:00:00'
GROUP BY et_time
ORDER BY et_time

Wastani wa senti 8 katika kipindi cha soko la kabla ya kufungua 04:00 ET, senti 3 katika kipindi cha kufungua 09:30, na senti 2 kufikia 14:00 — kuuza hisa hiyo hiyo wakati wa ufunguzi wa soko la kabla ya kufungua kunagharimu takriban mara nne ya mwanya wa agizo la mapema alasiri. Mwanya si kitu kisichobadilika; ni ratiba.

Kielelezo cha uchunguzi: faili lililosimama kwenye S

Kila faili ya kila siku kutoka kwa mtoa huduma hupitia ukaguzi wa ukamilifu kabla ya kuchapisha nambari kutoka humo: hesabu ticker, angalia mwanda wa alfabeti, linganisha majirani. Faili ya kiasi cha mauzo mafupi nje ya soko la FINRA ya Juni 29 ndiyo kielelezo cha kwa nini:

SELECT
    date,
    uniqExact(ticker) AS tickers,
    min(ticker) AS first_ticker,
    max(ticker) AS last_ticker,
    countIf(ticker = 'TSLA') AS tsla_rows,
    round(100 * sum(short_volume) / sum(total_volume), 2) AS short_pct_of_reported
FROM global_markets.stocks_short_volume
WHERE date BETWEEN '2026-06-26' AND '2026-06-30'
GROUP BY date
ORDER BY date

Faili ya Juni 26 inashughulikia 15052 ticker, A hadi ZYME. Faili ya Juni 29 inashughulikia 5489 ticker, A hadi SSUS — inasimama tu katikati ya majina ya S. Kila ticker kialfabeti baada ya hatua hiyo — TSLA ikiwemo, ikiwa na safu 0 za Juni 29 dhidi ya 1 za Juni 26 — haipo; kufikia Juni 30 faili inarudi kwa 15362 ticker. Ukaguzi wa ukamilifu si chochote cha kisasa zaidi ya risiti hii ya safu moja kwa siku — tofauti kati ya kuchapisha takwimu na kuchapisha kitu cha bandia.

Kwa ufichuzi huo ndani ya mstari — na kwa huo pekee — hapa kuna uwiano: kiasi cha mauzo mafupi kilichowekwa alama kinahesabiwa kuwa 45.85% ya kiasi cha mauzo nje ya soko kilichoripotiwa Juni 29, pamoja na 46.89% Juni 26 na 48.82% Juni 30. Takwimu ya Juni 29 inashughulikia tu sehemu ya A-hadi-S, kwa hiyo itibu kama usomaji wa sehemu. Sehemu ya karibu nusu ya hisa fupi ni kiwango cha kawaida ambacho kila kikao cha jirani kinaonyesha — na kiasi cha mauzo mafupi cha kila siku si riba ya mauzo mafupi.

Vidokezo vya Data

Mbinu

• Nyakati huhifadhiwa kwa UTC na huchujwa kwa mipaka ghafi ya UTC (saa za kawaida za Juni 29 ni 13:30 hadi 20:00 UTC); toTimeZone inaonekana tu kwenye orodha za SELECT.
• Aina ya kipindi huthibitishwa dhidi ya kalenda ya likizo na dirisha la kawaida la pau 390 lililozingatiwa — kamwe haidhaniwi.
• "Kiasi kinachohesabiwa na SIP (kilicholingana)" ni kiasi ambacho sheria za masharti za SIP zenyewe huhesabu kuelekea jumla iliyounganishwa; seti ya kutengwa inatokana na kamusi, iliyowekewa mipaka ya checksum, kamwe haijabandikwa kwa nguvu.
• Takwimu za usambaaji kwa kila sasisho hupima kila sasisho la NBBO kwa usawa; takwimu za uzani wa muda hupima kila nukuu kwa muda ilichodumu. Zote mbili zinafichua vighairi vyake.
• Safu wima za bei/ukubwa wa desimali hujumlishwa kwa asili na kutupwa kwa sehemu za kuelea za biti 64 kabla ya hesabu yoyote ya uwiano au bei mara ukubwa.
• Majedwali ya tiketi huhifadhi historia kamili bila kumalizika kwa muda; matokeo haya yaliyohifadhiwa na yenye matoleo ndio rekodi ya kudumu bila kujali. Hali ya ghala kufikia Julai 3, 2026.

Kila paneli hapo juu ni kitu kimoja kilichohifadhiwa — chati, jedwali, na SQL kwa pamoja. Fungua yoyote kati yao, nakili swala, na uendelee nayo kwenye mfumo wa Strasmore.