PREVIEW / etf_30min / 2025-09-22

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-22.parquet
  size:    1.1 MB
  rows:    44,426

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-22 04:00:00	SPY	ETF	661.87	662.71	661.75	662.47	20985.0
2025-09-22 04:30:00	SPY	ETF	662.49	662.62	662.01	662.05	8788.0
2025-09-22 05:00:00	SPY	ETF	662.04	662.18	661.54	661.85	58153.0
2025-09-22 05:30:00	SPY	ETF	661.9	661.9	661.73	661.86	6957.0
2025-09-22 06:00:00	SPY	ETF	661.9	662.35	661.81	662.23	11840.0
2025-09-22 06:30:00	SPY	ETF	662.32	662.38	661.67	661.75	16464.0
2025-09-22 07:00:00	SPY	ETF	661.75	661.94	661.52	661.71	134306.0
2025-09-22 07:30:00	SPY	ETF	661.67	661.95	661.48	661.95	96856.0
2025-09-22 08:00:00	SPY	ETF	661.7484	663.44	661.11	661.46	100303.0
2025-09-22 08:30:00	SPY	ETF	661.44	662.0	661.43	661.86	92533.0
2025-09-22 09:00:00	SPY	ETF	661.83	662.25	661.57	662.19	96315.0
2025-09-22 09:30:00	SPY	ETF	662.2	663.565	662.17	663.41	6391992.0
2025-09-22 10:00:00	SPY	ETF	663.41	664.14	663.175	664.08	3987208.0
2025-09-22 10:30:00	SPY	ETF	664.07	665.075	663.895	665.02	3649106.0
2025-09-22 11:00:00	SPY	ETF	665.01	665.32	664.695	664.94	3025032.0
2025-09-22 11:30:00	SPY	ETF	664.94	665.035	664.48	664.59	2250465.0
2025-09-22 12:00:00	SPY	ETF	664.5813	665.93	664.56	665.845	4412122.0
2025-09-22 12:30:00	SPY	ETF	665.845	666.5	665.79	666.41	3457087.0
2025-09-22 13:00:00	SPY	ETF	666.41	666.53	666.11	666.51	2035723.0
2025-09-22 13:30:00	SPY	ETF	666.505	666.78	666.27	666.355	2245420.0
2025-09-22 14:00:00	SPY	ETF	666.35	666.62	666.03	666.565	3206908.0
2025-09-22 14:30:00	SPY	ETF	666.57	666.82	666.46	666.78	2073202.0
2025-09-22 15:00:00	SPY	ETF	666.78	667.24	666.765	667.142	2653963.0
2025-09-22 15:30:00	SPY	ETF	667.14	667.29	666.71	666.76	8003178.0
2025-09-22 16:00:00	SPY	ETF	666.76	666.84	666.09	666.22	4054987.0
2025-09-22 16:30:00	SPY	ETF	666.25	666.84	666.19	666.58	300771.0
2025-09-22 17:00:00	SPY	ETF	666.3592	666.73	666.3592	666.66	15003.0
2025-09-22 17:30:00	SPY	ETF	666.6104	666.6977	666.6	666.6977	6314.0
2025-09-22 18:00:00	SPY	ETF	666.6	666.7	666.26	666.31	120004.0
2025-09-22 18:30:00	SPY	ETF	666.33	666.4	666.19	666.4	8409.0
2025-09-22 19:00:00	SPY	ETF	666.49	666.52	666.42	666.5	5827.0
2025-09-22 19:30:00	SPY	ETF	666.47	666.7564	666.47	666.71	20473.0
2025-09-22 04:00:00	QQQ	ETF	597.01	597.94	596.9	597.61	39873.0
2025-09-22 04:30:00	QQQ	ETF	597.56	597.73	596.9	596.91	25210.0
2025-09-22 05:00:00	QQQ	ETF	596.98	597.09	596.42	597.02	39774.0
2025-09-22 05:30:00	QQQ	ETF	597.01	597.05	596.72	596.9	18467.0
2025-09-22 06:00:00	QQQ	ETF	596.87	597.52	596.84	597.39	24063.0
2025-09-22 06:30:00	QQQ	ETF	597.45	597.49	596.69	596.69	31170.0
2025-09-22 07:00:00	QQQ	ETF	596.77	597.08	596.58	596.89	62486.0
2025-09-22 07:30:00	QQQ	ETF	596.83	597.1	596.63	597.08	39874.0
2025-09-22 08:00:00	QQQ	ETF	596.7489	599.191	596.22	596.65	143757.0
2025-09-22 08:30:00	QQQ	ETF	596.6	597.49	596.55	597.26	48463.0
2025-09-22 09:00:00	QQQ	ETF	597.26	597.89	596.97	597.76	131417.0
2025-09-22 09:30:00	QQQ	ETF	597.74	599.38	597.72	599.17	4569374.0
2025-09-22 10:00:00	QQQ	ETF	599.165	599.98	598.75	599.9301	2666249.0
2025-09-22 10:30:00	QQQ	ETF	599.92	600.579	599.6115	600.47	2547322.0
2025-09-22 11:00:00	QQQ	ETF	600.46	600.72	599.93	600.32	2124060.0
2025-09-22 11:30:00	QQQ	ETF	600.33	600.44	599.77	600.13	1841931.0
2025-09-22 12:00:00	QQQ	ETF	600.11	601.63	600.0907	601.565	3696634.0
2025-09-22 12:30:00	QQQ	ETF	601.578	602.07	601.49	601.89	2393036.0

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

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