PREVIEW / etf_30min / 2026-07-07

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-07.parquet
  size:    1.1 MB
  rows:    48,406

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-07 04:00:00	SPY	ETF	749.39	750.34	748.5	750.23	69877.0
2026-07-07 04:30:00	SPY	ETF	750.28	750.45	749.97	750.01	60944.0
2026-07-07 05:00:00	SPY	ETF	750.01	750.41	749.8	750.18	7986.0
2026-07-07 05:30:00	SPY	ETF	750.16	750.39	749.95	750.3	10333.0
2026-07-07 06:00:00	SPY	ETF	750.42	750.56	750.0	750.31	26585.0
2026-07-07 06:30:00	SPY	ETF	750.32	750.32	749.52	749.91	20563.0
2026-07-07 07:00:00	SPY	ETF	749.93	750.0	749.44	749.8	56019.0
2026-07-07 07:30:00	SPY	ETF	749.78	750.12	749.46	750.03	58376.0
2026-07-07 08:00:00	SPY	ETF	750.1	750.7	750.059	750.54	71612.0
2026-07-07 08:30:00	SPY	ETF	750.5	750.89	750.12	750.26	62069.0
2026-07-07 09:00:00	SPY	ETF	750.28	750.8	749.79	750.23	99512.0
2026-07-07 09:30:00	SPY	ETF	750.27	750.96	748.25	748.85	3880093.0
2026-07-07 10:00:00	SPY	ETF	748.8504	749.2	746.09	746.7	3202660.0
2026-07-07 10:30:00	SPY	ETF	746.68	747.01	745.21	746.445	2925061.0
2026-07-07 11:00:00	SPY	ETF	746.46	746.68	745.76	746.369	1707563.0
2026-07-07 11:30:00	SPY	ETF	746.36	747.45	745.43	747.36	1619109.0
2026-07-07 12:00:00	SPY	ETF	747.38	748.99	747.25	748.77	1964791.0
2026-07-07 12:30:00	SPY	ETF	748.765	749.13	748.24	748.96	1469707.0
2026-07-07 13:00:00	SPY	ETF	748.96	749.34	748.42	748.84	1194478.0
2026-07-07 13:30:00	SPY	ETF	748.85	749.27	748.65	749.18	994971.0
2026-07-07 14:00:00	SPY	ETF	749.18	749.3	748.83	748.99	1127058.0
2026-07-07 14:30:00	SPY	ETF	749.0	749.07	747.42	747.51	2278183.0
2026-07-07 15:00:00	SPY	ETF	747.5	747.7	746.0	746.7	3670499.0
2026-07-07 15:30:00	SPY	ETF	746.67	747.97	746.38	747.69	5515701.0
2026-07-07 16:00:00	SPY	ETF	747.66	747.78	747.03	747.3	1771420.0
2026-07-07 16:30:00	SPY	ETF	747.38	747.59	747.35	747.47	96653.0
2026-07-07 17:00:00	SPY	ETF	747.59	747.66	746.0	746.22	200794.0
2026-07-07 17:30:00	SPY	ETF	746.21	746.63	745.95	746.47	101712.0
2026-07-07 18:00:00	SPY	ETF	746.57	746.98	746.11	746.85	66108.0
2026-07-07 18:30:00	SPY	ETF	746.71	747.08	746.71	747.08	22408.0
2026-07-07 19:00:00	SPY	ETF	747.0	747.5	746.72	747.39	16629.0
2026-07-07 19:30:00	SPY	ETF	747.42	747.46	746.11	746.16	65998.0
2026-07-07 04:00:00	QQQ	ETF	715.38	717.73	713.39	716.5	250212.0
2026-07-07 04:30:00	QQQ	ETF	716.42	716.85	715.82	715.82	19776.0
2026-07-07 05:00:00	QQQ	ETF	715.66	716.56	715.37	715.71	17592.0
2026-07-07 05:30:00	QQQ	ETF	715.69	715.9	714.9	715.86	32450.0
2026-07-07 06:00:00	QQQ	ETF	715.84	716.44	715.21	716.12	135907.0
2026-07-07 06:30:00	QQQ	ETF	716.09	716.09	714.9	715.72	61467.0
2026-07-07 07:00:00	QQQ	ETF	715.71	715.7888	714.39	715.1884	202159.0
2026-07-07 07:30:00	QQQ	ETF	715.07	715.41	714.17	715.37	167329.0
2026-07-07 08:00:00	QQQ	ETF	715.31	722.278	715.31	716.47	219344.0
2026-07-07 08:30:00	QQQ	ETF	716.45	716.95	714.9	715.35	166687.0
2026-07-07 09:00:00	QQQ	ETF	715.34	715.71	713.92	714.19	282891.0
2026-07-07 09:30:00	QQQ	ETF	714.17	716.35	709.97	711.1728	4918084.0
2026-07-07 10:00:00	QQQ	ETF	711.12	712.025	706.08	707.21	3659500.0
2026-07-07 10:30:00	QQQ	ETF	707.21	707.76	704.9	707.19	3436873.0
2026-07-07 11:00:00	QQQ	ETF	707.17	708.5	706.42	707.4494	1777851.0
2026-07-07 11:30:00	QQQ	ETF	707.46	709.26	705.84	709.2	1456931.0
2026-07-07 12:00:00	QQQ	ETF	709.21	713.0462	708.99	712.69	2216391.0
2026-07-07 12:30:00	QQQ	ETF	712.69	713.31	711.56	712.87	1500135.0

> showing 50 of 48,406 rows — these rows as CSV

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