PREVIEW / etf_30min / 2026-07-08

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-08.parquet
  size:    1.1 MB
  rows:    49,453

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-08 04:00:00	SPY	ETF	746.67	747.86	742.12	742.12	169556.0
2026-07-08 04:30:00	SPY	ETF	742.0	742.23	740.31	740.51	92103.0
2026-07-08 05:00:00	SPY	ETF	740.6	740.75	739.35	739.93	110881.0
2026-07-08 05:30:00	SPY	ETF	739.94	740.84	739.84	739.86	71056.0
2026-07-08 06:00:00	SPY	ETF	740.02	740.595	739.42	740.58	101607.0
2026-07-08 06:30:00	SPY	ETF	740.55	741.45	740.26	741.09	74734.0
2026-07-08 07:00:00	SPY	ETF	741.09	741.36	740.4929	740.78	208884.0
2026-07-08 07:30:00	SPY	ETF	740.7222	743.15	740.65	742.31	385702.0
2026-07-08 08:00:00	SPY	ETF	742.27	743.7	741.821	743.64	193431.0
2026-07-08 08:30:00	SPY	ETF	743.88	744.3	742.96	742.96	225053.0
2026-07-08 09:00:00	SPY	ETF	743.0	743.99	742.8	743.15	334678.0
2026-07-08 09:30:00	SPY	ETF	743.16	744.925	742.64	744.04	3865380.0
2026-07-08 10:00:00	SPY	ETF	744.01	744.7	742.68	743.11	3004455.0
2026-07-08 10:30:00	SPY	ETF	743.09	743.69	740.93	741.84	2871411.0
2026-07-08 11:00:00	SPY	ETF	741.83	742.03	739.55	739.94	2331415.0
2026-07-08 11:30:00	SPY	ETF	739.96	741.27	739.51	740.64	1983241.0
2026-07-08 12:00:00	SPY	ETF	740.68	743.47	740.61	743.1	1911384.0
2026-07-08 12:30:00	SPY	ETF	743.09	744.75	742.45	744.68	1900221.0
2026-07-08 13:00:00	SPY	ETF	744.66	745.78	743.985	745.72	1655337.0
2026-07-08 13:30:00	SPY	ETF	745.73	746.09	743.95	744.39	1578283.0
2026-07-08 14:00:00	SPY	ETF	744.38	745.51	744.0	744.67	1516886.0
2026-07-08 14:30:00	SPY	ETF	744.67	745.5	744.26	745.33	1295190.0
2026-07-08 15:00:00	SPY	ETF	745.34	745.725	744.68	745.19	1212732.0
2026-07-08 15:30:00	SPY	ETF	745.2	746.15	744.41	745.34	4805206.0
2026-07-08 16:00:00	SPY	ETF	745.29	745.57	744.21	744.36	1835581.0
2026-07-08 16:30:00	SPY	ETF	744.34	744.46	743.45	743.91	384928.0
2026-07-08 17:00:00	SPY	ETF	744.08	744.25	743.95	744.04	18862.0
2026-07-08 17:30:00	SPY	ETF	744.08	744.45	744.0	744.38	46729.0
2026-07-08 18:00:00	SPY	ETF	744.33	744.84	744.31	744.4	60178.0
2026-07-08 18:30:00	SPY	ETF	744.59	744.83	744.25	744.42	7200.0
2026-07-08 19:00:00	SPY	ETF	744.5	744.85	744.25	744.62	26835.0
2026-07-08 19:30:00	SPY	ETF	744.45	745.3433	744.39	745.3433	36273.0
2026-07-08 04:00:00	QQQ	ETF	709.3	711.39	701.74	701.98	329377.0
2026-07-08 04:30:00	QQQ	ETF	701.8	702.43	699.15	700.22	299983.0
2026-07-08 05:00:00	QQQ	ETF	700.19	700.81	697.86	699.09	132274.0
2026-07-08 05:30:00	QQQ	ETF	699.04	700.22	698.77	698.95	81254.0
2026-07-08 06:00:00	QQQ	ETF	699.18	700.56	698.2	700.56	118971.0
2026-07-08 06:30:00	QQQ	ETF	700.49	701.79	699.95	700.56	119215.0
2026-07-08 07:00:00	QQQ	ETF	700.51	700.66	699.46	699.64	176376.0
2026-07-08 07:30:00	QQQ	ETF	699.75	702.97	699.46	702.18	288832.0
2026-07-08 08:00:00	QQQ	ETF	702.14	708.898	701.45	704.3087	161221.0
2026-07-08 08:30:00	QQQ	ETF	704.35	705.8	703.64	703.73	243922.0
2026-07-08 09:00:00	QQQ	ETF	703.83	705.59	703.64	705.03	373640.0
2026-07-08 09:30:00	QQQ	ETF	704.95	709.8	704.94	708.95	5010747.0
2026-07-08 10:00:00	QQQ	ETF	708.97	709.47	705.74	707.2	2268192.0
2026-07-08 10:30:00	QQQ	ETF	707.16	708.19	703.75	705.21	2403103.0
2026-07-08 11:00:00	QQQ	ETF	705.26	705.52	700.91	701.45	2315271.0
2026-07-08 11:30:00	QQQ	ETF	701.48	703.77	700.95	702.405	1650328.0
2026-07-08 12:00:00	QQQ	ETF	702.51	707.34	702.34	706.75	1636595.0
2026-07-08 12:30:00	QQQ	ETF	706.75	709.17	706.03	709.07	1919873.0

> showing 50 of 49,453 rows — these rows as CSV

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