PREVIEW / etf_30min / 2025-08-25

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-25.parquet
  size:    1020 KB
  rows:    42,244

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-08-25 04:00:00	SPY	ETF	644.41	644.52	644.23	644.51	13531.0
2025-08-25 04:30:00	SPY	ETF	644.51	644.55	644.13	644.13	7757.0
2025-08-25 05:00:00	SPY	ETF	644.1	644.13	643.89	643.89	21645.0
2025-08-25 05:30:00	SPY	ETF	643.85	644.04	643.79	644.04	9291.0
2025-08-25 06:00:00	SPY	ETF	644.04	644.04	643.45	643.46	19133.0
2025-08-25 06:30:00	SPY	ETF	643.5	643.63	643.37	643.43	48564.0
2025-08-25 07:00:00	SPY	ETF	643.44	643.94	643.38	643.92	82560.0
2025-08-25 07:30:00	SPY	ETF	643.88	643.94	643.78	643.83	15462.0
2025-08-25 08:00:00	SPY	ETF	643.55	645.14	643.24	643.33	135600.0
2025-08-25 08:30:00	SPY	ETF	643.29	643.6097	643.14	643.48	141561.0
2025-08-25 09:00:00	SPY	ETF	643.5	644.05	643.45	644.03	149867.0
2025-08-25 09:30:00	SPY	ETF	644.03	644.369	643.41	644.34	5451729.0
2025-08-25 10:00:00	SPY	ETF	644.33	644.67	643.76	644.15	3407657.0
2025-08-25 10:30:00	SPY	ETF	644.15	644.46	643.74	644.42	2113773.0
2025-08-25 11:00:00	SPY	ETF	644.41	645.05	644.23	644.91	2021732.0
2025-08-25 11:30:00	SPY	ETF	644.91	645.065	644.505	644.97	1686638.0
2025-08-25 12:00:00	SPY	ETF	644.96	645.145	644.79	644.94	1446244.0
2025-08-25 12:30:00	SPY	ETF	644.94	645.29	644.82	644.995	1302216.0
2025-08-25 13:00:00	SPY	ETF	644.9813	645.015	644.41	644.67	1475742.0
2025-08-25 13:30:00	SPY	ETF	644.66	644.82	644.025	644.505	1693144.0
2025-08-25 14:00:00	SPY	ETF	644.5011	644.565	643.94	644.17	1830511.0
2025-08-25 14:30:00	SPY	ETF	644.165	644.28	643.895	643.94	1567021.0
2025-08-25 15:00:00	SPY	ETF	643.97	644.15	643.62	643.69	2424966.0
2025-08-25 15:30:00	SPY	ETF	643.69	643.84	642.35	642.47	6691320.0
2025-08-25 16:00:00	SPY	ETF	642.48	643.09	642.34	643.07	2312682.0
2025-08-25 16:30:00	SPY	ETF	643.0899	643.1499	642.89	642.93	103702.0
2025-08-25 17:00:00	SPY	ETF	642.92	642.97	642.8	642.84	123158.0
2025-08-25 17:30:00	SPY	ETF	642.84	642.98	642.8	642.98	10274.0
2025-08-25 18:00:00	SPY	ETF	642.98	643.38	642.97	643.27	33026.0
2025-08-25 18:30:00	SPY	ETF	643.2	643.32	643.17	643.17	7571.0
2025-08-25 19:00:00	SPY	ETF	643.27	643.33	642.94	643.08	14633.0
2025-08-25 19:30:00	SPY	ETF	643.08	643.19	642.8319	643.01	29485.0
2025-08-25 04:00:00	QQQ	ETF	571.2	571.38	570.76	571.12	35949.0
2025-08-25 04:30:00	QQQ	ETF	571.17	571.33	570.68	570.68	8139.0
2025-08-25 05:00:00	QQQ	ETF	570.66	570.79	570.2	570.23	27988.0
2025-08-25 05:30:00	QQQ	ETF	570.24	570.58	570.17	570.54	50304.0
2025-08-25 06:00:00	QQQ	ETF	570.55	570.59	569.84	569.96	33560.0
2025-08-25 06:30:00	QQQ	ETF	569.89	570.32	569.62	569.99	64616.0
2025-08-25 07:00:00	QQQ	ETF	570.03	570.42	569.8	570.36	29071.0
2025-08-25 07:30:00	QQQ	ETF	570.33	570.48	570.22	570.41	22032.0
2025-08-25 08:00:00	QQQ	ETF	570.08	572.08	569.63	569.77	174478.0
2025-08-25 08:30:00	QQQ	ETF	569.75	570.1	569.6	569.99	74646.0
2025-08-25 09:00:00	QQQ	ETF	570.01	570.44	569.92	570.44	120666.0
2025-08-25 09:30:00	QQQ	ETF	570.4	570.9399	569.16	570.9399	4581411.0
2025-08-25 10:00:00	QQQ	ETF	570.95	571.94	570.59	571.48	2420687.0
2025-08-25 10:30:00	QQQ	ETF	571.46	572.27	571.26	572.195	1770601.0
2025-08-25 11:00:00	QQQ	ETF	572.18	572.965	572.06	572.8599	1549164.0
2025-08-25 11:30:00	QQQ	ETF	572.87	573.2871	572.41	572.912	1355045.0
2025-08-25 12:00:00	QQQ	ETF	572.9	573.24	572.76	572.86	1024871.0
2025-08-25 12:30:00	QQQ	ETF	572.84	573.19	572.6299	572.8	781267.0

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

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