PREVIEW / etf_30min / 2026-07-01

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-01.parquet
  size:    1.1 MB
  rows:    46,196

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-01 04:00:00	SPY	ETF	744.53	745.2	743.0	744.12	174976.0
2026-07-01 04:30:00	SPY	ETF	744.21	744.67	744.07	744.67	8396.0
2026-07-01 05:00:00	SPY	ETF	744.69	744.69	744.07	744.24	20485.0
2026-07-01 05:30:00	SPY	ETF	744.34	744.89	744.27	744.89	5379.0
2026-07-01 06:00:00	SPY	ETF	744.97	745.3	744.45	745.26	6848.0
2026-07-01 06:30:00	SPY	ETF	745.28	745.52	744.88	745.48	21252.0
2026-07-01 07:00:00	SPY	ETF	745.379	745.72	745.3	745.3	67588.0
2026-07-01 07:30:00	SPY	ETF	745.31	745.36	744.78	744.8693	66362.0
2026-07-01 08:00:00	SPY	ETF	745.01	745.54	744.4	745.3	48971.0
2026-07-01 08:30:00	SPY	ETF	745.29	745.58	744.26	744.66	153801.0
2026-07-01 09:00:00	SPY	ETF	744.77	745.72	744.17	744.93	120250.0
2026-07-01 09:30:00	SPY	ETF	744.96	745.34	742.375	745.34	5304058.0
2026-07-01 10:00:00	SPY	ETF	745.34	747.02	745.0	746.82	2429884.0
2026-07-01 10:30:00	SPY	ETF	746.82	747.11	745.69	746.96	2128769.0
2026-07-01 11:00:00	SPY	ETF	746.99	749.32	746.9	749.29	2647235.0
2026-07-01 11:30:00	SPY	ETF	749.28	749.365	748.34	748.79	1297925.0
2026-07-01 12:00:00	SPY	ETF	748.811	749.435	748.67	748.9701	1028690.0
2026-07-01 12:30:00	SPY	ETF	748.98	749.21	747.3225	747.52	1416664.0
2026-07-01 13:00:00	SPY	ETF	747.51	748.42	747.04	747.93	1476802.0
2026-07-01 13:30:00	SPY	ETF	747.94	748.18	747.16	747.195	1019047.0
2026-07-01 14:00:00	SPY	ETF	747.2	747.69	746.71	747.13	1235588.0
2026-07-01 14:30:00	SPY	ETF	747.13	747.38	746.45	746.85	1563789.0
2026-07-01 15:00:00	SPY	ETF	746.86	747.69	746.78	746.94	1907905.0
2026-07-01 15:30:00	SPY	ETF	746.94	747.31	745.16	745.69	6538879.0
2026-07-01 16:00:00	SPY	ETF	745.67	745.76	744.48	744.8	2748576.0
2026-07-01 16:30:00	SPY	ETF	744.8	744.95	744.2	744.9	270190.0
2026-07-01 17:00:00	SPY	ETF	744.8999	745.11	744.75	745.04	67980.0
2026-07-01 17:30:00	SPY	ETF	744.87	745.24	744.87	745.11	19424.0
2026-07-01 18:00:00	SPY	ETF	745.16	745.76	744.76	745.4	185795.0
2026-07-01 18:30:00	SPY	ETF	745.33	745.64	745.2	745.6201	12844.0
2026-07-01 19:00:00	SPY	ETF	745.4896	745.53	745.17	745.27	17432.0
2026-07-01 19:30:00	SPY	ETF	745.27	745.38	744.5	744.91	24416.0
2026-07-01 04:00:00	QQQ	ETF	732.43	734.88	730.8	731.39	226440.0
2026-07-01 04:30:00	QQQ	ETF	731.44	732.59	731.17	732.55	33519.0
2026-07-01 05:00:00	QQQ	ETF	732.28	732.35	731.63	732.01	31990.0
2026-07-01 05:30:00	QQQ	ETF	731.86	732.75	731.86	732.74	35513.0
2026-07-01 06:00:00	QQQ	ETF	732.82	733.03	731.99	733.0299	36636.0
2026-07-01 06:30:00	QQQ	ETF	733.02	733.42	732.12	733.25	37210.0
2026-07-01 07:00:00	QQQ	ETF	733.3	733.94	733.0478	733.21	142384.0
2026-07-01 07:30:00	QQQ	ETF	733.12	733.17	732.07	732.21	88362.0
2026-07-01 08:00:00	QQQ	ETF	732.25	736.952	731.5	732.48	159289.0
2026-07-01 08:30:00	QQQ	ETF	732.36	732.96	729.14	730.08	542553.0
2026-07-01 09:00:00	QQQ	ETF	729.9	731.03	728.69	729.22	416586.0
2026-07-01 09:30:00	QQQ	ETF	729.18	730.24	725.52	730.17	5747123.0
2026-07-01 10:00:00	QQQ	ETF	730.24	731.29	729.305	730.185	1973071.0
2026-07-01 10:30:00	QQQ	ETF	730.2	730.35	726.6786	728.03	2070491.0
2026-07-01 11:00:00	QQQ	ETF	728.05	731.75	727.89	731.6216	1666951.0
2026-07-01 11:30:00	QQQ	ETF	731.61	731.92	728.8	729.54	1847377.0
2026-07-01 12:00:00	QQQ	ETF	729.46	730.17	728.59	729.23	1239230.0
2026-07-01 12:30:00	QQQ	ETF	729.225	729.66	727.53	727.9	1083746.0

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

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