PREVIEW / etf_30min / 2026-08-19

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-08-19.parquet
  size:    1.1 MB
  rows:    47,352

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-08-19 04:00:00	SPY	ETF	767.89	768.24	765.86	768.18	67339.0
2026-08-19 04:30:00	SPY	ETF	768.16	768.16	767.85	767.89	4633.0
2026-08-19 05:00:00	SPY	ETF	767.89	767.93	767.48	767.48	5610.0
2026-08-19 05:30:00	SPY	ETF	767.53	767.64	767.24	767.36	18204.0
2026-08-19 06:00:00	SPY	ETF	767.32	767.39	767.055	767.15	11870.0
2026-08-19 06:30:00	SPY	ETF	767.3701	767.69	767.26	767.47	4495.0
2026-08-19 07:00:00	SPY	ETF	767.42	768.0	767.39	767.79	33473.0
2026-08-19 07:30:00	SPY	ETF	767.79	767.85	767.47	767.85	18272.0
2026-08-19 08:00:00	SPY	ETF	767.79	768.1	766.99	767.73	80366.0
2026-08-19 08:30:00	SPY	ETF	767.79	771.82	767.56	770.86	987321.0
2026-08-19 09:00:00	SPY	ETF	770.73	771.09	770.09	770.34	307646.0
2026-08-19 09:30:00	SPY	ETF	770.36	770.63	768.1	769.99	3593654.0
2026-08-19 10:00:00	SPY	ETF	770.02	770.26	768.73	770.03	1919006.0
2026-08-19 10:30:00	SPY	ETF	769.98	772.24	769.8102	772.2	2075660.0
2026-08-19 11:00:00	SPY	ETF	772.195	772.47	770.88	771.1087	1358932.0
2026-08-19 11:30:00	SPY	ETF	771.13	771.18	770.07	770.6209	1421133.0
2026-08-19 12:00:00	SPY	ETF	770.64	771.99	770.4	770.67	1092843.0
2026-08-19 12:30:00	SPY	ETF	770.68	770.755	769.5	769.68	1402365.0
2026-08-19 13:00:00	SPY	ETF	769.69	770.229	769.02	769.57	1254739.0
2026-08-19 13:30:00	SPY	ETF	769.58	769.89	769.16	769.5076	1025316.0
2026-08-19 14:00:00	SPY	ETF	769.53	770.55	768.96	769.58	1342852.0
2026-08-19 14:30:00	SPY	ETF	769.58	770.09	769.48	769.515	1136697.0
2026-08-19 15:00:00	SPY	ETF	769.53	770.02	769.43	769.63	1500226.0
2026-08-19 15:30:00	SPY	ETF	769.65	770.38	768.2	769.06	5642596.0
2026-08-19 16:00:00	SPY	ETF	769.09	769.23	766.875	768.92	3013073.0
2026-08-19 16:30:00	SPY	ETF	768.94	769.12	768.77	769.05	121819.0
2026-08-19 17:00:00	SPY	ETF	769.0	769.1	768.96	769.05	32307.0
2026-08-19 17:30:00	SPY	ETF	769.06	769.17	769.0	769.17	8040.0
2026-08-19 18:00:00	SPY	ETF	769.24	770.29	769.15	769.85	38796.0
2026-08-19 18:30:00	SPY	ETF	769.8364	770.25	769.8	770.23	21485.0
2026-08-19 19:00:00	SPY	ETF	770.26	770.59	770.06	770.149	13490.0
2026-08-19 19:30:00	SPY	ETF	770.17	770.34	770.01	770.01	17377.0
2026-08-19 04:00:00	QQQ	ETF	717.3	719.02	714.01	718.6	184412.0
2026-08-19 04:30:00	QQQ	ETF	718.61	718.86	718.08	718.295	27717.0
2026-08-19 05:00:00	QQQ	ETF	718.34	718.77	717.29	717.31	45801.0
2026-08-19 05:30:00	QQQ	ETF	717.5	717.76	716.58	716.94	24243.0
2026-08-19 06:00:00	QQQ	ETF	716.97	716.97	715.97	716.58	48259.0
2026-08-19 06:30:00	QQQ	ETF	716.64	717.05	716.14	716.19	35361.0
2026-08-19 07:00:00	QQQ	ETF	716.18	717.57	715.95	716.66	76425.0
2026-08-19 07:30:00	QQQ	ETF	716.67	716.67	715.85	716.54	58839.0
2026-08-19 08:00:00	QQQ	ETF	716.5	717.7	716.0095	717.39	180540.0
2026-08-19 08:30:00	QQQ	ETF	717.54	721.87	716.89	721.54	800417.0
2026-08-19 09:00:00	QQQ	ETF	721.4	721.66	720.06	720.44	386825.0
2026-08-19 09:30:00	QQQ	ETF	720.39	721.4999	713.37	715.5	5654153.0
2026-08-19 10:00:00	QQQ	ETF	715.52	715.93	712.61	715.17	3529003.0
2026-08-19 10:30:00	QQQ	ETF	715.14	718.6	714.82	718.59	2473982.0
2026-08-19 11:00:00	QQQ	ETF	718.57	718.737	717.58	718.33	990037.0
2026-08-19 11:30:00	QQQ	ETF	718.32	718.4	716.8	718.17	1121732.0
2026-08-19 12:00:00	QQQ	ETF	718.18	719.7	717.71	718.25	1109060.0
2026-08-19 12:30:00	QQQ	ETF	718.26	718.52	716.86	717.04	810029.0

> showing 50 of 47,352 rows — these rows as CSV

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