PREVIEW / etf_30min / 2026-07-22

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-22.parquet
  size:    1.0 MB
  rows:    45,913

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-07-22 04:00:00	SPY	ETF	746.94	747.75	745.11	746.13	55153.0
2026-07-22 04:30:00	SPY	ETF	746.4	746.45	746.0	746.36	11089.0
2026-07-22 05:00:00	SPY	ETF	746.33	747.01	746.33	746.61	11871.0
2026-07-22 05:30:00	SPY	ETF	746.53	746.56	745.91	746.36	11893.0
2026-07-22 06:00:00	SPY	ETF	746.58	747.13	746.37	747.0	18452.0
2026-07-22 06:30:00	SPY	ETF	746.96	746.98	746.53	746.81	32608.0
2026-07-22 07:00:00	SPY	ETF	746.879	746.88	746.11	746.13	92778.0
2026-07-22 07:30:00	SPY	ETF	746.15	746.5	745.05	745.61	123179.0
2026-07-22 08:00:00	SPY	ETF	745.61	745.87	745.1	745.51	88484.0
2026-07-22 08:30:00	SPY	ETF	745.53	746.12	744.3	745.32	227400.0
2026-07-22 09:00:00	SPY	ETF	745.36	746.73	745.35	746.66	176076.0
2026-07-22 09:30:00	SPY	ETF	746.62	748.785	746.37	748.78	2697762.0
2026-07-22 10:00:00	SPY	ETF	748.77	749.38	747.09	747.3	1852112.0
2026-07-22 10:30:00	SPY	ETF	747.29	747.977	746.68	747.935	1691360.0
2026-07-22 11:00:00	SPY	ETF	747.93	749.68	747.89	749.41	1583357.0
2026-07-22 11:30:00	SPY	ETF	749.42	749.79	748.7506	749.76	880075.0
2026-07-22 12:00:00	SPY	ETF	749.76	750.02	749.49	749.85	1020932.0
2026-07-22 12:30:00	SPY	ETF	749.86	750.0048	749.48	749.83	804754.0
2026-07-22 13:00:00	SPY	ETF	749.835	749.96	748.95	749.0445	945292.0
2026-07-22 13:30:00	SPY	ETF	749.05	749.41	748.39	748.52	1021327.0
2026-07-22 14:00:00	SPY	ETF	748.515	748.71	748.01	748.49	1293213.0
2026-07-22 14:30:00	SPY	ETF	748.49	748.6	748.05	748.41	1134199.0
2026-07-22 15:00:00	SPY	ETF	748.44	748.46	747.65	748.0	1281389.0
2026-07-22 15:30:00	SPY	ETF	748.0	748.3	747.295	747.39	4713248.0
2026-07-22 16:00:00	SPY	ETF	747.34	749.06	746.89	748.55	1816039.0
2026-07-22 16:30:00	SPY	ETF	748.5	748.58	747.8	747.8	330890.0
2026-07-22 17:00:00	SPY	ETF	747.81	748.26	747.0	747.25	285949.0
2026-07-22 17:30:00	SPY	ETF	747.2	747.25	746.33	746.84	124341.0
2026-07-22 18:00:00	SPY	ETF	747.0	747.21	745.86	745.93	87074.0
2026-07-22 18:30:00	SPY	ETF	745.92	746.14	745.34	745.96	42976.0
2026-07-22 19:00:00	SPY	ETF	745.9	746.01	745.44	745.69	15195.0
2026-07-22 19:30:00	SPY	ETF	745.74	746.68	745.73	746.68	30778.0
2026-07-22 04:00:00	QQQ	ETF	703.85	707.15	702.22	703.88	304978.0
2026-07-22 04:30:00	QQQ	ETF	703.89	704.22	703.38	704.07	28442.0
2026-07-22 05:00:00	QQQ	ETF	704.1	705.01	704.03	704.47	38219.0
2026-07-22 05:30:00	QQQ	ETF	704.43	704.5	703.57	704.46	37857.0
2026-07-22 06:00:00	QQQ	ETF	704.52	705.46	704.19	705.35	61376.0
2026-07-22 06:30:00	QQQ	ETF	705.2475	705.59	704.6901	705.16	55232.0
2026-07-22 07:00:00	QQQ	ETF	705.19	705.44	703.86	703.9464	155298.0
2026-07-22 07:30:00	QQQ	ETF	703.922	704.18	701.87	702.7	229958.0
2026-07-22 08:00:00	QQQ	ETF	702.88	708.439	701.33	702.06	173663.0
2026-07-22 08:30:00	QQQ	ETF	702.1	703.07	700.5	701.88	436543.0
2026-07-22 09:00:00	QQQ	ETF	701.9	703.78	701.88	703.54	221559.0
2026-07-22 09:30:00	QQQ	ETF	703.56	708.1	703.56	708.1	3245070.0
2026-07-22 10:00:00	QQQ	ETF	708.09	708.24	706.16	706.6701	1773304.0
2026-07-22 10:30:00	QQQ	ETF	706.69	707.66	705.58	707.19	1328954.0
2026-07-22 11:00:00	QQQ	ETF	707.2	709.65	707.2	709.23	1541163.0
2026-07-22 11:30:00	QQQ	ETF	709.24	709.47	708.0136	709.37	987740.0
2026-07-22 12:00:00	QQQ	ETF	709.35	709.4876	708.65	708.9	639965.0
2026-07-22 12:30:00	QQQ	ETF	708.9	709.32	708.07	708.87	590417.0

> showing 50 of 45,913 rows — these rows as CSV

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