PREVIEW / etf_30min / 2026-06-18

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-06-18.parquet
  size:    1.1 MB
  rows:    46,162

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-06-18 04:00:00	SPY	ETF	746.05	747.0	744.35	745.95	142626.0
2026-06-18 04:30:00	SPY	ETF	745.84	746.25	745.0	745.11	19524.0
2026-06-18 05:00:00	SPY	ETF	745.0	745.89	744.92	745.63	15883.0
2026-06-18 05:30:00	SPY	ETF	745.51	746.58	745.51	746.43	11823.0
2026-06-18 06:00:00	SPY	ETF	746.51	746.65	746.12	746.29	47564.0
2026-06-18 06:30:00	SPY	ETF	746.39	746.49	745.43	745.47	25700.0
2026-06-18 07:00:00	SPY	ETF	745.5005	746.0	743.78	744.31	144987.0
2026-06-18 07:30:00	SPY	ETF	744.26	744.57	743.35	744.43	92007.0
2026-06-18 08:00:00	SPY	ETF	744.44	745.68	744.24	745.66	144838.0
2026-06-18 08:30:00	SPY	ETF	745.56	746.59	745.17	746.14	178346.0
2026-06-18 09:00:00	SPY	ETF	746.13	748.02	745.0	747.8	313272.0
2026-06-18 09:30:00	SPY	ETF	747.77	748.2	743.86	744.75	5281278.0
2026-06-18 10:00:00	SPY	ETF	744.81	746.9	744.25	745.37	3710356.0
2026-06-18 10:30:00	SPY	ETF	745.33	747.31	744.43	746.84	2280682.0
2026-06-18 11:00:00	SPY	ETF	746.86	747.07	745.15	745.38	2060190.0
2026-06-18 11:30:00	SPY	ETF	745.38	746.53	744.331	746.2501	2197407.0
2026-06-18 12:00:00	SPY	ETF	746.26	746.88	745.75	746.65	1485380.0
2026-06-18 12:30:00	SPY	ETF	746.65	747.25	746.21	746.64	1274292.0
2026-06-18 13:00:00	SPY	ETF	746.66	748.13	746.42	747.55	1986019.0
2026-06-18 13:30:00	SPY	ETF	747.57	747.96	746.98	747.01	1142365.0
2026-06-18 14:00:00	SPY	ETF	747.02	747.08	746.42	746.5	1657800.0
2026-06-18 14:30:00	SPY	ETF	746.51	746.97	746.16	746.385	1365828.0
2026-06-18 15:00:00	SPY	ETF	746.39	746.46	745.2	746.01	2244825.0
2026-06-18 15:30:00	SPY	ETF	746.01	748.23	745.61	746.56	8867199.0
2026-06-18 16:00:00	SPY	ETF	746.56	748.499	746.4	748.01	5263200.0
2026-06-18 16:30:00	SPY	ETF	748.0	748.14	747.35	747.7	179137.0
2026-06-18 17:00:00	SPY	ETF	747.7	748.16	746.74	748.0	298792.0
2026-06-18 17:30:00	SPY	ETF	748.02	748.17	747.87	747.98	42604.0
2026-06-18 18:00:00	SPY	ETF	747.92	748.18	746.8	746.92	81733.0
2026-06-18 18:30:00	SPY	ETF	746.94	746.97	746.34	746.51	46178.0
2026-06-18 19:00:00	SPY	ETF	746.51	746.92	746.43	746.77	11726.0
2026-06-18 19:30:00	SPY	ETF	746.83	747.14	746.68	746.94	16906.0
2026-06-18 04:00:00	QQQ	ETF	733.51	734.91	729.0	733.33	225082.0
2026-06-18 04:30:00	QQQ	ETF	733.34	734.23	732.41	732.59	53174.0
2026-06-18 05:00:00	QQQ	ETF	732.39	733.79	732.39	733.5	39377.0
2026-06-18 05:30:00	QQQ	ETF	733.6	734.88	733.38	734.74	90719.0
2026-06-18 06:00:00	QQQ	ETF	734.73	734.88	734.14	734.41	60609.0
2026-06-18 06:30:00	QQQ	ETF	734.5	734.7	733.11	733.35	94363.0
2026-06-18 07:00:00	QQQ	ETF	733.39	733.94	731.84	732.75	170844.0
2026-06-18 07:30:00	QQQ	ETF	732.65	733.16	731.61	733.16	109859.0
2026-06-18 08:00:00	QQQ	ETF	733.17	734.33	721.969	734.03	248909.0
2026-06-18 08:30:00	QQQ	ETF	734.28	735.76	733.96	735.22	262250.0
2026-06-18 09:00:00	QQQ	ETF	735.2188	737.6	734.13	737.18	624853.0
2026-06-18 09:30:00	QQQ	ETF	737.2	737.65	732.51	734.205	5277196.0
2026-06-18 10:00:00	QQQ	ETF	734.31	738.43	733.87	735.52	3092297.0
2026-06-18 10:30:00	QQQ	ETF	735.5	738.8	734.2	737.88	2033976.0
2026-06-18 11:00:00	QQQ	ETF	737.9	739.14	736.65	736.9799	1643872.0
2026-06-18 11:30:00	QQQ	ETF	736.94	738.55	734.94	738.3	1770139.0
2026-06-18 12:00:00	QQQ	ETF	738.28	739.4699	737.98	739.26	1410132.0
2026-06-18 12:30:00	QQQ	ETF	739.27	739.85	738.54	739.335	1207936.0

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

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