PREVIEW / etf_30min / 2026-07-20

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-20.parquet
  size:    1.0 MB
  rows:    46,388

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-20 04:00:00	SPY	ETF	744.07	745.69	742.81	745.38	47303.0
2026-07-20 04:30:00	SPY	ETF	745.0887	745.2	744.84	744.9607	16840.0
2026-07-20 05:00:00	SPY	ETF	744.97	745.35	744.65	745.15	85685.0
2026-07-20 05:30:00	SPY	ETF	745.15	746.24	745.15	745.7	19757.0
2026-07-20 06:00:00	SPY	ETF	745.74	745.79	745.2	745.47	17857.0
2026-07-20 06:30:00	SPY	ETF	745.57	745.95	745.28	745.71	14956.0
2026-07-20 07:00:00	SPY	ETF	745.701	746.46	745.58	745.88	53363.0
2026-07-20 07:30:00	SPY	ETF	745.9	748.01	745.9	747.088	187027.0
2026-07-20 08:00:00	SPY	ETF	747.055	747.055	745.66	746.5182	164782.0
2026-07-20 08:30:00	SPY	ETF	746.62	746.67	745.86	746.25	105766.0
2026-07-20 09:00:00	SPY	ETF	746.28	747.17	746.16	747.03	133634.0
2026-07-20 09:30:00	SPY	ETF	747.06	748.73	745.52	745.69	3916830.0
2026-07-20 10:00:00	SPY	ETF	745.68	746.36	744.26	745.68	2329697.0
2026-07-20 10:30:00	SPY	ETF	745.69	745.96	743.69	744.11	1664817.0
2026-07-20 11:00:00	SPY	ETF	744.14	745.97	743.805	745.87	1537381.0
2026-07-20 11:30:00	SPY	ETF	745.89	746.44	745.1	745.99	1292157.0
2026-07-20 12:00:00	SPY	ETF	746.0	747.005	745.58	746.5	1580202.0
2026-07-20 12:30:00	SPY	ETF	746.49	746.78	744.47	745.0	2019117.0
2026-07-20 13:00:00	SPY	ETF	745.01	745.21	743.56	744.12	1591842.0
2026-07-20 13:30:00	SPY	ETF	744.13	744.92	743.59	744.55	1305552.0
2026-07-20 14:00:00	SPY	ETF	744.55	745.38	744.13	744.47	1623866.0
2026-07-20 14:30:00	SPY	ETF	744.48	744.49	742.43	742.72	2077069.0
2026-07-20 15:00:00	SPY	ETF	742.76	743.19	741.5103	742.73	2910912.0
2026-07-20 15:30:00	SPY	ETF	742.74	743.34	741.61	742.1	5820179.0
2026-07-20 16:00:00	SPY	ETF	742.15	742.87	741.32	741.56	2311780.0
2026-07-20 16:30:00	SPY	ETF	741.57	742.02	741.5	742.0	113433.0
2026-07-20 17:00:00	SPY	ETF	741.95	742.05	741.45	741.98	72667.0
2026-07-20 17:30:00	SPY	ETF	741.9538	742.05	741.87	742.05	19317.0
2026-07-20 18:00:00	SPY	ETF	742.07	742.1	741.02	741.18	42145.0
2026-07-20 18:30:00	SPY	ETF	741.25	741.3	740.96	741.1602	9499.0
2026-07-20 19:00:00	SPY	ETF	741.15	742.56	741.15	742.56	25741.0
2026-07-20 19:30:00	SPY	ETF	742.59	742.69	741.73	742.1377	14710.0
2026-07-20 04:00:00	QQQ	ETF	697.12	699.7	695.55	698.88	149661.0
2026-07-20 04:30:00	QQQ	ETF	698.86	698.86	697.75	698.26	30831.0
2026-07-20 05:00:00	QQQ	ETF	698.38	699.06	697.65	698.88	25475.0
2026-07-20 05:30:00	QQQ	ETF	698.73	701.09	698.72	700.01	72549.0
2026-07-20 06:00:00	QQQ	ETF	700.07	700.19	699.24	700.13	57607.0
2026-07-20 06:30:00	QQQ	ETF	700.15	700.56	699.9	700.38	61500.0
2026-07-20 07:00:00	QQQ	ETF	700.37	701.75	700.3	701.07	144840.0
2026-07-20 07:30:00	QQQ	ETF	701.11	703.75	701.11	702.83	295055.0
2026-07-20 08:00:00	QQQ	ETF	702.8	702.8	700.74	701.95	165512.0
2026-07-20 08:30:00	QQQ	ETF	702.0	702.22	701.2064	701.75	100411.0
2026-07-20 09:00:00	QQQ	ETF	701.8	702.57	701.52	702.14	297277.0
2026-07-20 09:30:00	QQQ	ETF	702.16	705.8	700.66	701.09	3861931.0
2026-07-20 10:00:00	QQQ	ETF	701.07	702.36	698.91	701.89	2249543.0
2026-07-20 10:30:00	QQQ	ETF	701.88	702.37	698.11	698.54	1485184.0
2026-07-20 11:00:00	QQQ	ETF	698.51	701.75	698.08	701.53	1171413.0
2026-07-20 11:30:00	QQQ	ETF	701.5406	702.72	700.54	702.38	941444.0
2026-07-20 12:00:00	QQQ	ETF	702.4099	704.02	701.8354	703.1874	1063253.0
2026-07-20 12:30:00	QQQ	ETF	703.26	703.54	700.135	700.82	1303029.0

> showing 50 of 46,388 rows — these rows as CSV

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