PREVIEW / etf_30min / 2025-08-04

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-04.parquet
  size:    1021 KB
  rows:    42,361

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
2025-08-04 04:00:00	SPY	ETF	624.1	625.66	624.1	625.44	43370.0
2025-08-04 04:30:00	SPY	ETF	625.49	626.0	625.38	626.0	56460.0
2025-08-04 05:00:00	SPY	ETF	625.96	626.3	625.91	625.91	12593.0
2025-08-04 05:30:00	SPY	ETF	626.09	626.33	625.75	625.78	13945.0
2025-08-04 06:00:00	SPY	ETF	625.75	626.03	625.73	625.87	16186.0
2025-08-04 06:30:00	SPY	ETF	625.88	626.01	625.37	625.5	84059.0
2025-08-04 07:00:00	SPY	ETF	625.5	625.5	624.82	625.34	61656.0
2025-08-04 07:30:00	SPY	ETF	625.42	625.68	624.93	625.0	107549.0
2025-08-04 08:00:00	SPY	ETF	625.04	626.1304	623.7	625.67	178684.0
2025-08-04 08:30:00	SPY	ETF	625.65	625.86	625.23	625.38	147618.0
2025-08-04 09:00:00	SPY	ETF	625.4	625.75	625.24	625.7	197415.0
2025-08-04 09:30:00	SPY	ETF	625.67	629.205	625.58	629.01	8133670.0
2025-08-04 10:00:00	SPY	ETF	629.01	629.53	628.27	629.4	4165641.0
2025-08-04 10:30:00	SPY	ETF	629.41	629.7	628.46	629.18	4449781.0
2025-08-04 11:00:00	SPY	ETF	629.19	629.56	628.65	629.0	3058873.0
2025-08-04 11:30:00	SPY	ETF	628.99	630.05	628.59	629.87	3096204.0
2025-08-04 12:00:00	SPY	ETF	629.86	630.17	629.62	629.72	2401782.0
2025-08-04 12:30:00	SPY	ETF	629.71	630.45	629.68	630.135	1988785.0
2025-08-04 13:00:00	SPY	ETF	630.13	630.52	630.06	630.29	1962446.0
2025-08-04 13:30:00	SPY	ETF	630.3	630.49	629.39	629.81	2365508.0
2025-08-04 14:00:00	SPY	ETF	629.82	630.315	629.73	629.99	2840275.0
2025-08-04 14:30:00	SPY	ETF	629.99	630.4	629.775	629.8802	2131351.0
2025-08-04 15:00:00	SPY	ETF	629.8968	630.75	629.74	630.265	4019691.0
2025-08-04 15:30:00	SPY	ETF	630.265	631.215	629.9209	631.09	8552001.0
2025-08-04 16:00:00	SPY	ETF	631.07	631.9699	621.72	631.88	3522752.0
2025-08-04 16:30:00	SPY	ETF	631.87	632.32	631.87	632.3	251143.0
2025-08-04 17:00:00	SPY	ETF	632.26	632.32	632.14	632.28	33611.0
2025-08-04 17:30:00	SPY	ETF	632.31	632.4	632.2	632.33	28446.0
2025-08-04 18:00:00	SPY	ETF	632.35	632.47	631.84	631.87	38807.0
2025-08-04 18:30:00	SPY	ETF	631.84	631.91	631.7	631.9	32128.0
2025-08-04 19:00:00	SPY	ETF	631.9	632.3	631.8	631.87	26039.0
2025-08-04 19:30:00	SPY	ETF	631.83	631.95	631.64	631.79	25753.0
2025-08-04 04:00:00	QQQ	ETF	557.06	558.02	557.0	557.74	44272.0
2025-08-04 04:30:00	QQQ	ETF	557.72	558.37	557.61	558.37	38066.0
2025-08-04 05:00:00	QQQ	ETF	558.32	558.62	558.23	558.24	21382.0
2025-08-04 05:30:00	QQQ	ETF	558.27	558.7	558.17	558.17	25121.0
2025-08-04 06:00:00	QQQ	ETF	558.2	558.54	558.12	558.49	84948.0
2025-08-04 06:30:00	QQQ	ETF	558.49	558.7	558.22	558.33	51157.0
2025-08-04 07:00:00	QQQ	ETF	558.34	558.34	557.65	558.23	63249.0
2025-08-04 07:30:00	QQQ	ETF	558.3	558.64	557.8	557.92	57094.0
2025-08-04 08:00:00	QQQ	ETF	557.95	558.6304	555.7	558.52	184656.0
2025-08-04 08:30:00	QQQ	ETF	558.55	558.76	558.26	558.6002	151724.0
2025-08-04 09:00:00	QQQ	ETF	558.64	559.13	558.5199	559.06	196078.0
2025-08-04 09:30:00	QQQ	ETF	559.05	563.01	558.95	562.755	6785748.0
2025-08-04 10:00:00	QQQ	ETF	562.77	563.13	561.98	562.83	2953070.0
2025-08-04 10:30:00	QQQ	ETF	562.85	562.95	561.51	562.02	2510631.0
2025-08-04 11:00:00	QQQ	ETF	562.01	562.22	561.35	561.93	1891164.0
2025-08-04 11:30:00	QQQ	ETF	561.91	563.2	561.62	562.97	1779240.0
2025-08-04 12:00:00	QQQ	ETF	562.97	563.51	562.84	563.22	1571165.0
2025-08-04 12:30:00	QQQ	ETF	563.215	563.58	562.955	563.37	1464654.0

> showing 50 of 42,361 rows — these rows as CSV

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