PREVIEW / etf_30min / 2026-07-10

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-10.parquet
  size:    1.0 MB
  rows:    45,304

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-10 04:00:00	SPY	ETF	750.06	751.27	749.83	750.42	35228.0
2026-07-10 04:30:00	SPY	ETF	750.4099	750.5	750.19	750.37	4936.0
2026-07-10 05:00:00	SPY	ETF	750.34	751.07	749.65	750.99	14185.0
2026-07-10 05:30:00	SPY	ETF	750.97	751.13	750.835	751.0	3452.0
2026-07-10 06:00:00	SPY	ETF	751.01	751.49	751.01	751.49	26425.0
2026-07-10 06:30:00	SPY	ETF	751.6	751.89	751.59	751.89	36891.0
2026-07-10 07:00:00	SPY	ETF	751.8414	752.05	751.5512	751.62	33944.0
2026-07-10 07:30:00	SPY	ETF	751.44	751.45	750.94	751.15	114477.0
2026-07-10 08:00:00	SPY	ETF	751.2	752.3	750.56	751.6	161928.0
2026-07-10 08:30:00	SPY	ETF	751.6	752.06	751.3	751.6478	51694.0
2026-07-10 09:00:00	SPY	ETF	751.66	752.22	751.54	752.04	90746.0
2026-07-10 09:30:00	SPY	ETF	752.05	753.235	751.8	752.915	2665933.0
2026-07-10 10:00:00	SPY	ETF	752.92	753.35	752.11	752.5859	1676353.0
2026-07-10 10:30:00	SPY	ETF	752.61	753.25	748.1	751.2199	4172262.0
2026-07-10 11:00:00	SPY	ETF	751.18	753.42	750.652	753.25	1299362.0
2026-07-10 11:30:00	SPY	ETF	753.25	753.39	751.38	752.8175	1243840.0
2026-07-10 12:00:00	SPY	ETF	752.81	753.69	752.81	753.21	1297538.0
2026-07-10 12:30:00	SPY	ETF	753.21	754.14	753.03	754.01	1530128.0
2026-07-10 13:00:00	SPY	ETF	754.01	754.06	753.48	754.01	807313.0
2026-07-10 13:30:00	SPY	ETF	754.02	754.41	753.875	753.99	1161425.0
2026-07-10 14:00:00	SPY	ETF	754.0	754.72	753.93	754.43	1679881.0
2026-07-10 14:30:00	SPY	ETF	754.42	754.66	754.31	754.495	1254431.0
2026-07-10 15:00:00	SPY	ETF	754.495	755.18	754.455	754.96	2585585.0
2026-07-10 15:30:00	SPY	ETF	754.96	755.42	754.57	754.9	5370637.0
2026-07-10 16:00:00	SPY	ETF	754.87	755.5	754.56	755.31	2813354.0
2026-07-10 16:30:00	SPY	ETF	755.27	755.65	755.25	755.45	249831.0
2026-07-10 17:00:00	SPY	ETF	755.42	755.6	754.97	755.1	75264.0
2026-07-10 17:30:00	SPY	ETF	755.05	755.4	754.99	754.99	45715.0
2026-07-10 18:00:00	SPY	ETF	755.02	755.09	754.72	754.99	39687.0
2026-07-10 18:30:00	SPY	ETF	754.99	755.04	754.8631	755.04	13634.0
2026-07-10 19:00:00	SPY	ETF	755.04	755.14	754.85	755.1272	11777.0
2026-07-10 19:30:00	SPY	ETF	754.9794	755.29	754.81	754.81	37462.0
2026-07-10 04:00:00	QQQ	ETF	719.44	723.41	718.58	719.19	183342.0
2026-07-10 04:30:00	QQQ	ETF	719.12	719.78	718.84	719.3	44238.0
2026-07-10 05:00:00	QQQ	ETF	719.25	720.3	717.925	720.21	60774.0
2026-07-10 05:30:00	QQQ	ETF	720.12	720.58	719.96	720.39	23787.0
2026-07-10 06:00:00	QQQ	ETF	720.45	720.86	720.09	720.8094	59169.0
2026-07-10 06:30:00	QQQ	ETF	720.87	721.41	720.8	721.13	43522.0
2026-07-10 07:00:00	QQQ	ETF	721.11	722.0	721.11	721.2	93751.0
2026-07-10 07:30:00	QQQ	ETF	721.1	721.1	720.11	720.25	112775.0
2026-07-10 08:00:00	QQQ	ETF	720.3	721.83	719.2591	721.17	217957.0
2026-07-10 08:30:00	QQQ	ETF	721.06	721.38	719.94	719.94	105138.0
2026-07-10 09:00:00	QQQ	ETF	719.94	721.11	719.68	720.8	200959.0
2026-07-10 09:30:00	QQQ	ETF	720.7	724.09	719.83	722.81	2758626.0
2026-07-10 10:00:00	QQQ	ETF	722.8	723.8994	721.0	722.4541	1635865.0
2026-07-10 10:30:00	QQQ	ETF	722.42	723.66	717.0	720.3499	2825427.0
2026-07-10 11:00:00	QQQ	ETF	720.31	724.29	719.35	724.0509	1473617.0
2026-07-10 11:30:00	QQQ	ETF	724.09	724.34	720.58	723.24	1631202.0
2026-07-10 12:00:00	QQQ	ETF	723.29	725.27	723.29	724.91	1478358.0
2026-07-10 12:30:00	QQQ	ETF	724.92	725.58	724.73	725.2018	822686.0

> showing 50 of 45,304 rows — these rows as CSV

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