PREVIEW / etf_30min / 2026-07-09

all etf 30-min files

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

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-09 04:00:00	SPY	ETF	747.13	748.42	746.18	747.95	45017.0
2026-07-09 04:30:00	SPY	ETF	747.83	747.94	746.87	747.1117	16384.0
2026-07-09 05:00:00	SPY	ETF	746.93	747.17	746.7	746.92	22884.0
2026-07-09 05:30:00	SPY	ETF	746.77	746.96	746.03	746.74	11543.0
2026-07-09 06:00:00	SPY	ETF	746.79	747.07	746.58	746.71	15296.0
2026-07-09 06:30:00	SPY	ETF	746.66	746.81	745.4	746.2	41728.0
2026-07-09 07:00:00	SPY	ETF	746.14	746.59	745.8	746.57	89722.0
2026-07-09 07:30:00	SPY	ETF	746.59	747.2995	746.3	747.0075	96415.0
2026-07-09 08:00:00	SPY	ETF	747.04	747.84	745.98	747.76	166980.0
2026-07-09 08:30:00	SPY	ETF	747.81	748.08	747.05	747.17	102998.0
2026-07-09 09:00:00	SPY	ETF	747.14	747.69	747.09	747.38	129741.0
2026-07-09 09:30:00	SPY	ETF	747.33	749.23	745.68	748.67	3668556.0
2026-07-09 10:00:00	SPY	ETF	748.69	749.02	745.59	747.8799	2978821.0
2026-07-09 10:30:00	SPY	ETF	747.86	748.92	747.1	748.73	1370520.0
2026-07-09 11:00:00	SPY	ETF	748.72	749.98	748.6	749.8	1570290.0
2026-07-09 11:30:00	SPY	ETF	749.78	750.25	749.485	749.87	1043209.0
2026-07-09 12:00:00	SPY	ETF	749.88	750.82	749.87	750.64	1138851.0
2026-07-09 12:30:00	SPY	ETF	750.64	750.8999	750.24	750.44	1094660.0
2026-07-09 13:00:00	SPY	ETF	750.45	751.79	750.4	751.755	1223650.0
2026-07-09 13:30:00	SPY	ETF	751.76	751.97	751.18	751.63	1327687.0
2026-07-09 14:00:00	SPY	ETF	751.625	751.865	751.24	751.4505	1377356.0
2026-07-09 14:30:00	SPY	ETF	751.45	751.5895	750.86	751.05	1674120.0
2026-07-09 15:00:00	SPY	ETF	751.05	751.47	750.6601	751.1	1646768.0
2026-07-09 15:30:00	SPY	ETF	751.09	751.72	750.83	751.64	5274936.0
2026-07-09 16:00:00	SPY	ETF	751.63	751.77	751.16	751.28	2791438.0
2026-07-09 16:30:00	SPY	ETF	751.27	751.69	751.08	751.26	306478.0
2026-07-09 17:00:00	SPY	ETF	751.69	751.69	751.04	751.05	237524.0
2026-07-09 17:30:00	SPY	ETF	751.06	751.32	751.01	751.16	24986.0
2026-07-09 18:00:00	SPY	ETF	751.24	751.44	750.9	751.0	62826.0
2026-07-09 18:30:00	SPY	ETF	751.0626	751.26	751.02	751.18	8303.0
2026-07-09 19:00:00	SPY	ETF	751.25	751.69	751.06	751.69	8978.0
2026-07-09 19:30:00	SPY	ETF	751.641	751.65	751.17	751.4386	8764.0
2026-07-09 04:00:00	QQQ	ETF	716.79	718.01	711.5	717.1891	235129.0
2026-07-09 04:30:00	QQQ	ETF	717.1482	717.31	715.84	716.2	65306.0
2026-07-09 05:00:00	QQQ	ETF	716.385	716.385	715.5	715.99	34560.0
2026-07-09 05:30:00	QQQ	ETF	715.9	716.15	715.09	715.73	26395.0
2026-07-09 06:00:00	QQQ	ETF	715.87	716.41	715.58	716.01	17102.0
2026-07-09 06:30:00	QQQ	ETF	715.94	716.17	713.94	714.76	71586.0
2026-07-09 07:00:00	QQQ	ETF	714.77	715.84	714.355	715.795	140558.0
2026-07-09 07:30:00	QQQ	ETF	715.88	717.69	715.5	717.06	221178.0
2026-07-09 08:00:00	QQQ	ETF	717.17	718.45	711.973	718.35	210510.0
2026-07-09 08:30:00	QQQ	ETF	718.45	719.24	717.56	718.02	232496.0
2026-07-09 09:00:00	QQQ	ETF	718.03	718.64	717.8007	718.32	179244.0
2026-07-09 09:30:00	QQQ	ETF	718.33	722.75	716.5	722.17	4217469.0
2026-07-09 10:00:00	QQQ	ETF	722.21	722.54	715.125	718.74	3307947.0
2026-07-09 10:30:00	QQQ	ETF	718.8	720.14	717.15	719.32	2020170.0
2026-07-09 11:00:00	QQQ	ETF	719.39	721.64	719.13	721.36	1432364.0
2026-07-09 11:30:00	QQQ	ETF	721.38	722.08	720.95	721.6644	1114110.0
2026-07-09 12:00:00	QQQ	ETF	721.66	722.56	721.5225	721.76	958083.0
2026-07-09 12:30:00	QQQ	ETF	721.78	722.38	721.12	721.94	803742.0

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

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