PREVIEW / etf_30min / 2026-08-18

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-08-18.parquet
  size:    1.1 MB
  rows:    47,256

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2026-08-18 04:00:00	SPY	ETF	769.21	770.42	767.8	768.6634	125466.0
2026-08-18 04:30:00	SPY	ETF	768.53	769.18	768.53	768.95	9598.0
2026-08-18 05:00:00	SPY	ETF	768.8	769.14	768.39	768.7	14854.0
2026-08-18 05:30:00	SPY	ETF	768.64	769.02	768.285	768.99	14440.0
2026-08-18 06:00:00	SPY	ETF	768.96	769.16	768.85	769.11	25646.0
2026-08-18 06:30:00	SPY	ETF	769.21	769.4088	768.2499	769.15	109564.0
2026-08-18 07:00:00	SPY	ETF	769.18	769.66	769.14	769.5899	76998.0
2026-08-18 07:30:00	SPY	ETF	769.53	769.85	769.22	769.51	135588.0
2026-08-18 08:00:00	SPY	ETF	769.49	769.88	769.27	769.31	75633.0
2026-08-18 08:30:00	SPY	ETF	769.3	769.6	768.9	769.55	178411.0
2026-08-18 09:00:00	SPY	ETF	769.6	769.65	768.45	768.68	197917.0
2026-08-18 09:30:00	SPY	ETF	768.7	769.5	767.9	768.47	4108918.0
2026-08-18 10:00:00	SPY	ETF	768.49	769.27	767.63	768.66	2757289.0
2026-08-18 10:30:00	SPY	ETF	768.64	769.25	767.71	767.92	2025823.0
2026-08-18 11:00:00	SPY	ETF	767.93	768.38	767.33	767.84	1752200.0
2026-08-18 11:30:00	SPY	ETF	767.855	768.63	767.6	768.35	1333356.0
2026-08-18 12:00:00	SPY	ETF	768.35	768.87	768.14	768.21	823650.0
2026-08-18 12:30:00	SPY	ETF	768.19	768.87	768.07	768.63	722691.0
2026-08-18 13:00:00	SPY	ETF	768.62	768.82	768.08	768.3	876354.0
2026-08-18 13:30:00	SPY	ETF	768.29	768.3925	767.61	767.62	678403.0
2026-08-18 14:00:00	SPY	ETF	767.62	768.565	767.45	768.36	1515343.0
2026-08-18 14:30:00	SPY	ETF	768.355	768.43	767.68	767.7	1272086.0
2026-08-18 15:00:00	SPY	ETF	767.69	768.18	767.56	768.02	1413470.0
2026-08-18 15:30:00	SPY	ETF	768.015	768.22	766.92	767.41	6827283.0
2026-08-18 16:00:00	SPY	ETF	767.41	767.53	767.17	767.4	1866904.0
2026-08-18 16:30:00	SPY	ETF	767.3985	767.56	767.11	767.27	167524.0
2026-08-18 17:00:00	SPY	ETF	767.28	767.3481	767.1	767.26	27074.0
2026-08-18 17:30:00	SPY	ETF	767.25	767.36	767.11	767.36	21269.0
2026-08-18 18:00:00	SPY	ETF	767.36	767.72	767.15	767.15	38132.0
2026-08-18 18:30:00	SPY	ETF	767.14	767.1993	766.75	766.75	13509.0
2026-08-18 19:00:00	SPY	ETF	766.75	767.35	766.7	767.1	18897.0
2026-08-18 19:30:00	SPY	ETF	767.14	767.26	767.03	767.04	20844.0
2026-08-18 04:00:00	QQQ	ETF	723.6	725.94	721.38	721.74	381719.0
2026-08-18 04:30:00	QQQ	ETF	721.8951	722.6	721.52	721.99	31821.0
2026-08-18 05:00:00	QQQ	ETF	722.1	722.32	721.085	721.36	48896.0
2026-08-18 05:30:00	QQQ	ETF	721.29	721.46	720.19	721.3	98998.0
2026-08-18 06:00:00	QQQ	ETF	721.28	721.46	720.58	721.08	100063.0
2026-08-18 06:30:00	QQQ	ETF	721.12	721.71	721.0	721.4	40413.0
2026-08-18 07:00:00	QQQ	ETF	721.41	722.29	721.22	721.98	149676.0
2026-08-18 07:30:00	QQQ	ETF	721.85	722.31	721.1501	721.65	95819.0
2026-08-18 08:00:00	QQQ	ETF	721.62	729.323	720.81	720.87	156215.0
2026-08-18 08:30:00	QQQ	ETF	720.86	721.0	720.06	720.805	174038.0
2026-08-18 09:00:00	QQQ	ETF	720.79	721.13	719.7	720.23	214138.0
2026-08-18 09:30:00	QQQ	ETF	720.22	722.13	718.11	719.125	5148332.0
2026-08-18 10:00:00	QQQ	ETF	719.14	720.56	717.24	719.7317	3250471.0
2026-08-18 10:30:00	QQQ	ETF	719.63	720.2	716.46	716.72	2857926.0
2026-08-18 11:00:00	QQQ	ETF	716.73	717.975	715.92	717.7626	2916916.0
2026-08-18 11:30:00	QQQ	ETF	717.7	718.97	717.15	718.87	2439563.0
2026-08-18 12:00:00	QQQ	ETF	718.88	719.49	718.19	718.2	2151224.0
2026-08-18 12:30:00	QQQ	ETF	718.2	719.67	718.0501	719.18	1817950.0

> showing 50 of 47,256 rows — these rows as CSV

> unlock the full archive -- $79 one-time