PREVIEW / etf_30min / 2025-09-08

all etf 30-min files

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

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-08 04:00:00	SPY	ETF	648.25	648.63	647.9	648.49	12970.0
2025-09-08 04:30:00	SPY	ETF	648.5	648.66	648.4	648.49	5368.0
2025-09-08 05:00:00	SPY	ETF	648.47	648.51	648.3	648.51	4945.0
2025-09-08 05:30:00	SPY	ETF	648.43	648.77	648.38	648.77	2701.0
2025-09-08 06:00:00	SPY	ETF	648.71	648.9	648.71	648.79	13091.0
2025-09-08 06:30:00	SPY	ETF	648.75	648.96	648.7	648.7	5470.0
2025-09-08 07:00:00	SPY	ETF	648.67	648.81	648.53	648.71	34000.0
2025-09-08 07:30:00	SPY	ETF	648.72	648.83	648.25	648.25	49117.0
2025-09-08 08:00:00	SPY	ETF	648.72	648.84	647.61	648.13	72427.0
2025-09-08 08:30:00	SPY	ETF	648.29	648.73	648.29	648.63	89942.0
2025-09-08 09:00:00	SPY	ETF	648.65	649.01	648.49	648.61	178892.0
2025-09-08 09:30:00	SPY	ETF	648.62	649.06	648.0542	648.37	5946023.0
2025-09-08 10:00:00	SPY	ETF	648.375	648.9	647.75	648.77	3442494.0
2025-09-08 10:30:00	SPY	ETF	648.755	649.765	648.66	649.38	2821429.0
2025-09-08 11:00:00	SPY	ETF	649.37	649.81	649.14	649.8	2319392.0
2025-09-08 11:30:00	SPY	ETF	649.79	649.84	648.5	649.38	2337113.0
2025-09-08 12:00:00	SPY	ETF	649.38	649.4	648.38	648.63	1869606.0
2025-09-08 12:30:00	SPY	ETF	648.63	648.805	647.78	648.56	1999676.0
2025-09-08 13:00:00	SPY	ETF	648.56	648.76	647.99	648.48	1511155.0
2025-09-08 13:30:00	SPY	ETF	648.49	648.68	647.23	647.59	1495745.0
2025-09-08 14:00:00	SPY	ETF	647.5999	648.51	647.36	648.395	2269581.0
2025-09-08 14:30:00	SPY	ETF	648.39	648.58	647.91	648.235	1917902.0
2025-09-08 15:00:00	SPY	ETF	648.22	648.2368	647.335	647.58	3222516.0
2025-09-08 15:30:00	SPY	ETF	647.58	648.88	647.47	648.8	9745726.0
2025-09-08 16:00:00	SPY	ETF	648.8	648.99	648.5055	648.93	2876112.0
2025-09-08 16:30:00	SPY	ETF	648.93	648.94	648.75	648.82	203722.0
2025-09-08 17:00:00	SPY	ETF	648.77	648.9	648.73	648.9	58228.0
2025-09-08 17:30:00	SPY	ETF	648.91	649.04	648.9	649.0	45067.0
2025-09-08 18:00:00	SPY	ETF	648.94	649.3299	648.88	649.3	34855.0
2025-09-08 18:30:00	SPY	ETF	649.2	649.47	649.19	649.45	22476.0
2025-09-08 19:00:00	SPY	ETF	649.45	649.55	649.29	649.33	13898.0
2025-09-08 19:30:00	SPY	ETF	649.36	649.36	649.109	649.15	15628.0
2025-09-08 04:00:00	QQQ	ETF	577.6	577.9	577.38	577.76	16866.0
2025-09-08 04:30:00	QQQ	ETF	577.71	578.0	577.69	577.91	8948.0
2025-09-08 05:00:00	QQQ	ETF	577.9	578.02	577.67	577.92	12941.0
2025-09-08 05:30:00	QQQ	ETF	577.9	578.38	577.83	578.26	18065.0
2025-09-08 06:00:00	QQQ	ETF	578.32	578.43	578.17	578.33	22421.0
2025-09-08 06:30:00	QQQ	ETF	578.32	578.53	578.03	578.13	20288.0
2025-09-08 07:00:00	QQQ	ETF	578.07	578.3	577.951	578.19	31008.0
2025-09-08 07:30:00	QQQ	ETF	578.25	578.3	577.86	577.87	11512.0
2025-09-08 08:00:00	QQQ	ETF	578.06	578.39	575.628	577.61	105363.0
2025-09-08 08:30:00	QQQ	ETF	577.6499	578.24	577.6499	578.16	69081.0
2025-09-08 09:00:00	QQQ	ETF	578.25	578.63	578.04	578.32	118656.0
2025-09-08 09:30:00	QQQ	ETF	578.37	580.56	578.07	579.84	6172530.0
2025-09-08 10:00:00	QQQ	ETF	579.84	580.4	578.87	580.25	3677076.0
2025-09-08 10:30:00	QQQ	ETF	580.24	580.84	579.99	580.16	2352899.0
2025-09-08 11:00:00	QQQ	ETF	580.15	580.67	579.79	580.565	2043225.0
2025-09-08 11:30:00	QQQ	ETF	580.56	580.74	579.46	580.49	1854002.0
2025-09-08 12:00:00	QQQ	ETF	580.49	580.5	579.25	579.5	1501901.0
2025-09-08 12:30:00	QQQ	ETF	579.49	579.65	578.5	579.0199	2000344.0

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

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