PREVIEW / etf_30min / 2025-07-09

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-09.parquet
  size:    992 KB
  rows:    40,456

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-07-09 04:00:00	SPY	ETF	620.47	620.68	620.35	620.59	15103.0
2025-07-09 04:30:00	SPY	ETF	620.62	620.71	620.45	620.53	1810.0
2025-07-09 05:00:00	SPY	ETF	620.54	621.56	620.54	621.56	35358.0
2025-07-09 05:30:00	SPY	ETF	621.5	621.6	621.28	621.31	7567.0
2025-07-09 06:00:00	SPY	ETF	621.29	621.46	621.15	621.36	2763.0
2025-07-09 06:30:00	SPY	ETF	621.28	621.67	621.21	621.25	25203.0
2025-07-09 07:00:00	SPY	ETF	621.39	621.8	621.25	621.64	22215.0
2025-07-09 07:30:00	SPY	ETF	621.7	622.0	621.58	621.73	65969.0
2025-07-09 08:00:00	SPY	ETF	621.53	622.08	619.49	621.9699	107953.0
2025-07-09 08:30:00	SPY	ETF	622.0	622.29	621.74	621.9	101023.0
2025-07-09 09:00:00	SPY	ETF	621.96	622.81	621.81	622.76	145267.0
2025-07-09 09:30:00	SPY	ETF	622.77	624.72	622.65	624.245	5447547.0
2025-07-09 10:00:00	SPY	ETF	624.23	624.54	623.15	623.37	3300263.0
2025-07-09 10:30:00	SPY	ETF	623.38	623.38	621.07	621.44	6151078.0
2025-07-09 11:00:00	SPY	ETF	621.44	622.32	620.9105	622.105	3791290.0
2025-07-09 11:30:00	SPY	ETF	622.1	622.54	621.31	621.93	2925516.0
2025-07-09 12:00:00	SPY	ETF	621.93	622.41	621.55	621.79	2130769.0
2025-07-09 12:30:00	SPY	ETF	621.8	622.3677	621.73	622.02	1532130.0
2025-07-09 13:00:00	SPY	ETF	622.01	622.675	621.62	622.322	2185066.0
2025-07-09 13:30:00	SPY	ETF	622.32	622.79	622.06	622.465	2391135.0
2025-07-09 14:00:00	SPY	ETF	622.45	623.309	622.3932	622.85	3005289.0
2025-07-09 14:30:00	SPY	ETF	622.86	623.57	622.82	623.4	2352034.0
2025-07-09 15:00:00	SPY	ETF	623.405	623.77	623.1	623.6	3723654.0
2025-07-09 15:30:00	SPY	ETF	623.59	624.21	623.41	624.03	7463580.0
2025-07-09 16:00:00	SPY	ETF	624.01	624.4	623.56	623.7591	2216192.0
2025-07-09 16:30:00	SPY	ETF	623.69	625.8642	623.67	623.91	280682.0
2025-07-09 17:00:00	SPY	ETF	623.9	624.01	623.83	624.0	77326.0
2025-07-09 17:30:00	SPY	ETF	623.96	624.02	623.91	623.99	19813.0
2025-07-09 18:00:00	SPY	ETF	623.96	624.46	623.6875	624.3	54423.0
2025-07-09 18:30:00	SPY	ETF	624.24	624.38	624.181	624.25	26459.0
2025-07-09 19:00:00	SPY	ETF	624.26	624.26	623.91	623.94	10235.0
2025-07-09 19:30:00	SPY	ETF	623.9112	623.9112	623.58	623.6788	64684.0
2025-07-09 04:00:00	QQQ	ETF	552.43	552.61	552.16	552.38	20093.0
2025-07-09 04:30:00	QQQ	ETF	552.42	552.6	552.33	552.39	4294.0
2025-07-09 05:00:00	QQQ	ETF	552.4	553.38	552.4	553.37	15334.0
2025-07-09 05:30:00	QQQ	ETF	553.31	553.55	553.13	553.14	12093.0
2025-07-09 06:00:00	QQQ	ETF	553.11	553.26	552.86	553.06	5915.0
2025-07-09 06:30:00	QQQ	ETF	553.13	553.41	553.01	553.14	14868.0
2025-07-09 07:00:00	QQQ	ETF	553.14	553.55	553.1	553.45	11693.0
2025-07-09 07:30:00	QQQ	ETF	553.549	553.84	553.41	553.53	23535.0
2025-07-09 08:00:00	QQQ	ETF	553.23	553.78	551.43	553.59	89660.0
2025-07-09 08:30:00	QQQ	ETF	553.5714	553.91	553.24	553.43	86111.0
2025-07-09 09:00:00	QQQ	ETF	553.45	554.5	553.36	554.45	111783.0
2025-07-09 09:30:00	QQQ	ETF	554.46	557.2953	554.46	557.04	4026864.0
2025-07-09 10:00:00	QQQ	ETF	557.03	557.63	555.84	556.135	2904398.0
2025-07-09 10:30:00	QQQ	ETF	556.14	556.14	553.2899	553.74	3937124.0
2025-07-09 11:00:00	QQQ	ETF	553.74	554.74	553.1	554.5251	2553435.0
2025-07-09 11:30:00	QQQ	ETF	554.53	554.74	553.57	553.785	1903570.0
2025-07-09 12:00:00	QQQ	ETF	553.78	554.4712	553.54	554.365	1257324.0
2025-07-09 12:30:00	QQQ	ETF	554.37	555.205	554.363	554.605	1612928.0

> showing 50 of 40,456 rows — these rows as CSV

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