PREVIEW / etf_30min / 2026-07-16

all etf 30-min files

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

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-16 04:00:00	SPY	ETF	753.31	756.22	752.51	753.18	53658.0
2026-07-16 04:30:00	SPY	ETF	753.3	754.12	753.25	754.12	9253.0
2026-07-16 05:00:00	SPY	ETF	754.119	754.65	754.119	754.26	13651.0
2026-07-16 05:30:00	SPY	ETF	754.29	754.39	753.62	753.65	10048.0
2026-07-16 06:00:00	SPY	ETF	753.64	753.866	753.25	753.45	47184.0
2026-07-16 06:30:00	SPY	ETF	753.55	753.74	753.24	753.46	20623.0
2026-07-16 07:00:00	SPY	ETF	753.4298	753.7	752.57	753.0598	162859.0
2026-07-16 07:30:00	SPY	ETF	753.0	753.01	751.25	752.84	132173.0
2026-07-16 08:00:00	SPY	ETF	752.84	752.97	751.53	751.95	79379.0
2026-07-16 08:30:00	SPY	ETF	751.95	752.09	751.25	751.8352	185675.0
2026-07-16 09:00:00	SPY	ETF	751.81	752.88	751.69	752.8	161126.0
2026-07-16 09:30:00	SPY	ETF	752.74	753.52	750.67	751.905	3520569.0
2026-07-16 10:00:00	SPY	ETF	751.9	754.388	751.64	754.35	2647974.0
2026-07-16 10:30:00	SPY	ETF	754.34	754.57	753.34	754.17	1712923.0
2026-07-16 11:00:00	SPY	ETF	754.2	754.44	752.98	753.8001	1276326.0
2026-07-16 11:30:00	SPY	ETF	753.82	754.405	753.03	753.57	942406.0
2026-07-16 12:00:00	SPY	ETF	753.6	753.6	751.45	751.93	1706040.0
2026-07-16 12:30:00	SPY	ETF	751.94	752.97	751.59	752.86	1344292.0
2026-07-16 13:00:00	SPY	ETF	752.88	752.91	752.03	752.705	983630.0
2026-07-16 13:30:00	SPY	ETF	752.71	752.81	751.08	751.31	1235875.0
2026-07-16 14:00:00	SPY	ETF	751.33	751.71	750.46	750.91	2034858.0
2026-07-16 14:30:00	SPY	ETF	750.92	750.93	749.92	750.23	1662572.0
2026-07-16 15:00:00	SPY	ETF	750.22	750.7	748.86	749.1	2678564.0
2026-07-16 15:30:00	SPY	ETF	749.08	751.04	747.88	750.76	8491473.0
2026-07-16 16:00:00	SPY	ETF	750.83	750.87	749.76	750.0	1883719.0
2026-07-16 16:30:00	SPY	ETF	749.96	750.16	749.72	750.11	180103.0
2026-07-16 17:00:00	SPY	ETF	750.16	750.23	749.83	750.0	28693.0
2026-07-16 17:30:00	SPY	ETF	750.03	750.35	749.98	750.3	11038.0
2026-07-16 18:00:00	SPY	ETF	750.4	750.5	749.78	749.8	82634.0
2026-07-16 18:30:00	SPY	ETF	749.79	749.9	749.5	749.59	18874.0
2026-07-16 19:00:00	SPY	ETF	749.52	749.79	749.0	749.16	15994.0
2026-07-16 19:30:00	SPY	ETF	749.061	749.48	748.78	749.09	21546.0
2026-07-16 04:00:00	QQQ	ETF	715.23	719.84	712.41	713.55	172493.0
2026-07-16 04:30:00	QQQ	ETF	713.77	715.15	713.72	715.14	42938.0
2026-07-16 05:00:00	QQQ	ETF	715.4	716.25	715.38	715.59	43083.0
2026-07-16 05:30:00	QQQ	ETF	715.7	716.05	713.57	713.62	31841.0
2026-07-16 06:00:00	QQQ	ETF	713.6	714.34	713.23	713.83	33059.0
2026-07-16 06:30:00	QQQ	ETF	713.77	714.26	713.0	713.55	63627.0
2026-07-16 07:00:00	QQQ	ETF	713.66	713.669	711.69	712.19	131399.0
2026-07-16 07:30:00	QQQ	ETF	712.23	712.23	709.64	711.7	233232.0
2026-07-16 08:00:00	QQQ	ETF	711.68	718.278	710.0	710.45	200555.0
2026-07-16 08:30:00	QQQ	ETF	710.77	710.98	709.65	710.35	140408.0
2026-07-16 09:00:00	QQQ	ETF	710.29	712.57	710.23	712.07	293418.0
2026-07-16 09:30:00	QQQ	ETF	712.01	713.599	707.0	709.175	3673866.0
2026-07-16 10:00:00	QQQ	ETF	709.09	712.9	708.54	712.48	2041627.0
2026-07-16 10:30:00	QQQ	ETF	712.475	713.07	709.58	711.35	1277440.0
2026-07-16 11:00:00	QQQ	ETF	711.41	711.91	708.92	710.61	1510430.0
2026-07-16 11:30:00	QQQ	ETF	710.585	712.02	709.35	710.22	1087509.0
2026-07-16 12:00:00	QQQ	ETF	710.25	710.3	707.11	707.96	2090997.0
2026-07-16 12:30:00	QQQ	ETF	707.96	709.22	707.27	708.8672	1209494.0

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

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