PREVIEW / etf_30min / 2025-09-29

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-29.parquet
  size:    1.0 MB
  rows:    44,405

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-09-29 04:00:00	SPY	ETF	664.57	665.03	664.12	664.91	30365.0
2025-09-29 04:30:00	SPY	ETF	664.91	665.26	664.84	665.23	19969.0
2025-09-29 05:00:00	SPY	ETF	665.22	665.33	665.09	665.26	10255.0
2025-09-29 05:30:00	SPY	ETF	665.18	665.5	665.03	665.04	29434.0
2025-09-29 06:00:00	SPY	ETF	665.06	665.72	664.98	665.7	9299.0
2025-09-29 06:30:00	SPY	ETF	665.7	665.8	665.3	665.35	132417.0
2025-09-29 07:00:00	SPY	ETF	665.4	665.47	664.6	664.65	97711.0
2025-09-29 07:30:00	SPY	ETF	664.64	664.98	664.49	664.96	44181.0
2025-09-29 08:00:00	SPY	ETF	665.38	665.7	663.71	665.03	120181.0
2025-09-29 08:30:00	SPY	ETF	665.01	665.6	664.97	665.43	105475.0
2025-09-29 09:00:00	SPY	ETF	665.45	665.67	664.25	664.4	296880.0
2025-09-29 09:30:00	SPY	ETF	664.36	664.76	663.725	664.525	6487358.0
2025-09-29 10:00:00	SPY	ETF	664.53	665.28	663.99	664.76	4253974.0
2025-09-29 10:30:00	SPY	ETF	664.76	665.17	664.29	664.46	2763170.0
2025-09-29 11:00:00	SPY	ETF	664.45	664.6573	663.21	663.53	3837249.0
2025-09-29 11:30:00	SPY	ETF	663.54	663.655	662.84	663.31	3155855.0
2025-09-29 12:00:00	SPY	ETF	663.31	663.8	662.935	663.47	2269038.0
2025-09-29 12:30:00	SPY	ETF	663.48	663.7	662.85	663.04	1481436.0
2025-09-29 13:00:00	SPY	ETF	663.05	663.0856	662.4	662.56	2390463.0
2025-09-29 13:30:00	SPY	ETF	662.57	663.09	662.19	662.94	2663272.0
2025-09-29 14:00:00	SPY	ETF	662.94	663.595	662.9	663.46	2514698.0
2025-09-29 14:30:00	SPY	ETF	663.47	663.58	663.06	663.35	2470899.0
2025-09-29 15:00:00	SPY	ETF	663.345	663.345	661.86	662.645	5400711.0
2025-09-29 15:30:00	SPY	ETF	662.64	663.76	662.61	663.61	9594953.0
2025-09-29 16:00:00	SPY	ETF	663.61	663.76	663.34	663.51	2373532.0
2025-09-29 16:30:00	SPY	ETF	663.46	663.46	662.88	663.05	197394.0
2025-09-29 17:00:00	SPY	ETF	663.04	663.08	662.97	663.0309	20612.0
2025-09-29 17:30:00	SPY	ETF	663.1099	663.1099	662.88	663.02	27791.0
2025-09-29 18:00:00	SPY	ETF	663.02	663.24	662.94	662.94	22906.0
2025-09-29 18:30:00	SPY	ETF	663.03	663.5492	663.03	663.5	24143.0
2025-09-29 19:00:00	SPY	ETF	663.5	663.53	663.36	663.5299	10006.0
2025-09-29 19:30:00	SPY	ETF	663.57	663.66	663.27	663.34	30823.0
2025-09-29 20:00:00	SPY	ETF	663.32	663.32	663.32	663.32	200.0
2025-09-29 04:00:00	QQQ	ETF	599.2	599.77	599.0	599.69	48203.0
2025-09-29 04:30:00	QQQ	ETF	599.75	600.2	599.68	600.15	33124.0
2025-09-29 05:00:00	QQQ	ETF	600.19	600.2	599.97	600.13	20509.0
2025-09-29 05:30:00	QQQ	ETF	600.1	600.29	599.67	599.67	30886.0
2025-09-29 06:00:00	QQQ	ETF	599.68	600.34	599.54	600.25	27107.0
2025-09-29 06:30:00	QQQ	ETF	600.25	600.35	599.93	600.06	27939.0
2025-09-29 07:00:00	QQQ	ETF	600.06	600.12	599.31	599.32	91997.0
2025-09-29 07:30:00	QQQ	ETF	599.3	599.75	599.21	599.71	34213.0
2025-09-29 08:00:00	QQQ	ETF	600.1	600.23	595.524	599.91	138171.0
2025-09-29 08:30:00	QQQ	ETF	599.94	600.49	599.87	600.2743	146603.0
2025-09-29 09:00:00	QQQ	ETF	600.29	600.48	599.04	599.15	210182.0
2025-09-29 09:30:00	QQQ	ETF	599.11	601.57	599.045	601.26	5682482.0
2025-09-29 10:00:00	QQQ	ETF	601.26	602.05	600.68	601.605	3364481.0
2025-09-29 10:30:00	QQQ	ETF	601.605	601.72	600.805	600.945	2115174.0
2025-09-29 11:00:00	QQQ	ETF	600.94	601.278	599.37	599.48	2637810.0
2025-09-29 11:30:00	QQQ	ETF	599.48	599.64	598.64	599.07	2260784.0
2025-09-29 12:00:00	QQQ	ETF	599.06	599.53	598.51	599.05	2127469.0

> showing 50 of 44,405 rows — these rows as CSV

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