PREVIEW / etf_30min / 2025-09-16

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-16.parquet
  size:    1.0 MB
  rows:    42,747

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-16 04:00:00	SPY	ETF	661.76	662.45	661.12	662.35	25608.0
2025-09-16 04:30:00	SPY	ETF	662.26	662.65	662.26	662.42	6171.0
2025-09-16 05:00:00	SPY	ETF	662.52	662.6	662.29	662.4	5751.0
2025-09-16 05:30:00	SPY	ETF	662.36	662.36	662.05	662.15	3560.0
2025-09-16 06:00:00	SPY	ETF	662.17	662.19	662.04	662.12	4991.0
2025-09-16 06:30:00	SPY	ETF	662.14	662.2	662.05	662.09	9287.0
2025-09-16 07:00:00	SPY	ETF	662.1	662.12	661.73	662.06	10736.0
2025-09-16 07:30:00	SPY	ETF	662.0	662.05	661.75	661.93	25956.0
2025-09-16 08:00:00	SPY	ETF	661.96	662.44	661.33	661.63	70803.0
2025-09-16 08:30:00	SPY	ETF	661.57	661.92	660.6742	661.4	154470.0
2025-09-16 09:00:00	SPY	ETF	661.42	661.65	661.27	661.44	104193.0
2025-09-16 09:30:00	SPY	ETF	661.46	661.78	660.03	660.28	6809000.0
2025-09-16 10:00:00	SPY	ETF	660.27	660.518	659.63	659.945	4877315.0
2025-09-16 10:30:00	SPY	ETF	659.94	660.3	659.71	659.85	2480528.0
2025-09-16 11:00:00	SPY	ETF	659.86	660.115	659.39	659.63	2647317.0
2025-09-16 11:30:00	SPY	ETF	659.62	659.945	659.21	659.665	2417509.0
2025-09-16 12:00:00	SPY	ETF	659.665	659.96	659.53	659.905	1440487.0
2025-09-16 12:30:00	SPY	ETF	659.9	660.08	659.48	659.955	1691274.0
2025-09-16 13:00:00	SPY	ETF	659.96	660.44	659.905	660.26	1535378.0
2025-09-16 13:30:00	SPY	ETF	660.27	660.36	659.9267	660.2	1582062.0
2025-09-16 14:00:00	SPY	ETF	660.18	660.405	660.03	660.19	1564644.0
2025-09-16 14:30:00	SPY	ETF	660.2	660.74	660.095	660.6	2052496.0
2025-09-16 15:00:00	SPY	ETF	660.6	660.73	660.03	660.145	2765533.0
2025-09-16 15:30:00	SPY	ETF	660.14	660.66	659.68	659.93	9042928.0
2025-09-16 16:00:00	SPY	ETF	659.94	660.4259	659.8173	660.33	3131711.0
2025-09-16 16:30:00	SPY	ETF	660.33	660.42	660.03	660.03	144379.0
2025-09-16 17:00:00	SPY	ETF	660.05	660.1998	660.0	660.03	18808.0
2025-09-16 17:30:00	SPY	ETF	660.03	660.03	659.79	659.94	64113.0
2025-09-16 18:00:00	SPY	ETF	659.94	660.22	659.84	660.2	89094.0
2025-09-16 18:30:00	SPY	ETF	660.31	660.46	660.3	660.43	6706.0
2025-09-16 19:00:00	SPY	ETF	660.39	660.43	660.21	660.21	4004.0
2025-09-16 19:30:00	SPY	ETF	660.19	660.3	660.1899	660.3	7227.0
2025-09-16 04:00:00	QQQ	ETF	593.0	594.0	592.82	593.64	58599.0
2025-09-16 04:30:00	QQQ	ETF	593.6	593.96	593.55	593.75	17717.0
2025-09-16 05:00:00	QQQ	ETF	593.87	593.96	593.59	593.68	8408.0
2025-09-16 05:30:00	QQQ	ETF	593.62	593.64	593.27	593.48	14238.0
2025-09-16 06:00:00	QQQ	ETF	593.45	593.56	593.3	593.47	11479.0
2025-09-16 06:30:00	QQQ	ETF	593.48	593.57	593.32	593.44	16888.0
2025-09-16 07:00:00	QQQ	ETF	593.43	593.46	592.88	593.13	38638.0
2025-09-16 07:30:00	QQQ	ETF	593.09	593.16	592.7	592.97	46943.0
2025-09-16 08:00:00	QQQ	ETF	593.2	593.9496	591.237	592.59	108496.0
2025-09-16 08:30:00	QQQ	ETF	592.58	593.02	592.51	592.82	114510.0
2025-09-16 09:00:00	QQQ	ETF	592.79	593.1	592.55	592.59	178098.0
2025-09-16 09:30:00	QQQ	ETF	592.61	592.86	591.01	591.37	4981642.0
2025-09-16 10:00:00	QQQ	ETF	591.36	591.91	590.99	591.405	2546958.0
2025-09-16 10:30:00	QQQ	ETF	591.41	591.84	591.128	591.392	1730240.0
2025-09-16 11:00:00	QQQ	ETF	591.39	591.49	590.74	590.92	1745071.0
2025-09-16 11:30:00	QQQ	ETF	590.91	591.1	590.5611	590.73	1213800.0
2025-09-16 12:00:00	QQQ	ETF	590.71	591.18	590.49	591.15	1292498.0
2025-09-16 12:30:00	QQQ	ETF	591.14	591.3	590.71	591.0985	1007342.0

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

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