PREVIEW / etf_30min / 2026-07-13

all etf 30-min files

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

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-13 04:00:00	SPY	ETF	752.01	752.79	749.85	752.51	92637.0
2026-07-13 04:30:00	SPY	ETF	752.54	752.86	752.29	752.7	12461.0
2026-07-13 05:00:00	SPY	ETF	752.77	753.21	752.4	753.21	27274.0
2026-07-13 05:30:00	SPY	ETF	753.17	753.27	752.92	753.0316	11130.0
2026-07-13 06:00:00	SPY	ETF	753.06	753.07	752.64	752.65	17367.0
2026-07-13 06:30:00	SPY	ETF	752.71	752.9	752.58	752.63	19684.0
2026-07-13 07:00:00	SPY	ETF	752.7	753.29	752.44	752.95	158063.0
2026-07-13 07:30:00	SPY	ETF	752.91	753.13	752.12	752.33	99762.0
2026-07-13 08:00:00	SPY	ETF	752.3603	752.71	751.66	751.91	155057.0
2026-07-13 08:30:00	SPY	ETF	751.85	752.66	751.55	752.59	120249.0
2026-07-13 09:00:00	SPY	ETF	752.66	752.86	752.21	752.51	134513.0
2026-07-13 09:30:00	SPY	ETF	752.47	753.91	751.92	753.62	2993725.0
2026-07-13 10:00:00	SPY	ETF	753.63	753.9105	750.3	753.09	3522738.0
2026-07-13 10:30:00	SPY	ETF	753.09	753.3	751.0	752.7401	1859939.0
2026-07-13 11:00:00	SPY	ETF	752.74	753.055	751.8812	752.38	947898.0
2026-07-13 11:30:00	SPY	ETF	752.39	752.525	751.0945	751.235	1168285.0
2026-07-13 12:00:00	SPY	ETF	751.23	751.81	749.93	750.29	1538952.0
2026-07-13 12:30:00	SPY	ETF	750.27	750.66	748.93	749.87	2380676.0
2026-07-13 13:00:00	SPY	ETF	749.9	750.64	749.53	749.81	1372047.0
2026-07-13 13:30:00	SPY	ETF	749.81	750.26	749.21	749.235	1249474.0
2026-07-13 14:00:00	SPY	ETF	749.26	750.21	749.04	749.24	1677569.0
2026-07-13 14:30:00	SPY	ETF	749.24	750.07	748.9702	749.56	1797938.0
2026-07-13 15:00:00	SPY	ETF	749.58	749.97	748.17	748.38	2598262.0
2026-07-13 15:30:00	SPY	ETF	748.39	749.61	748.0	749.1	6834194.0
2026-07-13 16:00:00	SPY	ETF	749.12	749.17	747.59	748.45	1920919.0
2026-07-13 16:30:00	SPY	ETF	748.44	748.44	748.05	748.32	83032.0
2026-07-13 17:00:00	SPY	ETF	748.43	748.5	748.15	748.26	32003.0
2026-07-13 17:30:00	SPY	ETF	748.25	748.36	748.21	748.36	13163.0
2026-07-13 18:00:00	SPY	ETF	748.41	749.07	748.2802	748.33	102756.0
2026-07-13 18:30:00	SPY	ETF	748.37	748.65	747.94	748.02	31752.0
2026-07-13 19:00:00	SPY	ETF	748.0	748.0	747.5	747.6	23701.0
2026-07-13 19:30:00	SPY	ETF	747.54	748.25	747.08	748.13	52622.0
2026-07-13 04:00:00	QQQ	ETF	716.85	718.47	713.96	718.14	410642.0
2026-07-13 04:30:00	QQQ	ETF	718.11	718.79	717.62	718.49	66935.0
2026-07-13 05:00:00	QQQ	ETF	718.6	719.0764	717.95	718.97	49098.0
2026-07-13 05:30:00	QQQ	ETF	718.95	719.35	718.79	719.24	35668.0
2026-07-13 06:00:00	QQQ	ETF	719.23	719.36	718.38	718.48	32220.0
2026-07-13 06:30:00	QQQ	ETF	718.54	719.02	718.35	718.77	27272.0
2026-07-13 07:00:00	QQQ	ETF	718.89	719.91	718.53	719.4	164793.0
2026-07-13 07:30:00	QQQ	ETF	719.41	719.79	718.19	718.51	98935.0
2026-07-13 08:00:00	QQQ	ETF	718.51	726.054	717.0848	717.16	246711.0
2026-07-13 08:30:00	QQQ	ETF	717.127	719.06	716.4801	717.8917	188214.0
2026-07-13 09:00:00	QQQ	ETF	717.9401	718.66	717.17	717.84	188280.0
2026-07-13 09:30:00	QQQ	ETF	717.72	718.43	713.15	715.77	5040818.0
2026-07-13 10:00:00	QQQ	ETF	715.85	717.6	712.56	717.5	2806143.0
2026-07-13 10:30:00	QQQ	ETF	717.59	718.1	715.1401	717.91	1664177.0
2026-07-13 11:00:00	QQQ	ETF	717.93	718.74	716.55	717.66	994981.0
2026-07-13 11:30:00	QQQ	ETF	717.65	718.03	715.0	715.36	996187.0
2026-07-13 12:00:00	QQQ	ETF	715.3301	715.975	713.52	714.09	1017504.0
2026-07-13 12:30:00	QQQ	ETF	713.99	713.99	711.7	713.26	1952626.0

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

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