PREVIEW / etf_30min / 2025-08-26

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-26.parquet
  size:    1009 KB
  rows:    40,794

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-26 04:00:00	SPY	ETF	641.37	641.95	641.33	641.76	11343.0
2025-08-26 04:30:00	SPY	ETF	641.6	641.91	641.5	641.8	16947.0
2025-08-26 05:00:00	SPY	ETF	641.79	642.11	641.6	642.03	4378.0
2025-08-26 05:30:00	SPY	ETF	642.16	642.25	641.89	642.07	2900.0
2025-08-26 06:00:00	SPY	ETF	642.07	642.42	642.07	642.27	12036.0
2025-08-26 06:30:00	SPY	ETF	642.28	642.44	642.21	642.29	9438.0
2025-08-26 07:00:00	SPY	ETF	642.31	642.32	641.92	641.94	22874.0
2025-08-26 07:30:00	SPY	ETF	641.95	642.11	641.53	642.06	24512.0
2025-08-26 08:00:00	SPY	ETF	642.23	642.5	640.73	641.94	63605.0
2025-08-26 08:30:00	SPY	ETF	641.87	642.27	641.85	642.18	59456.0
2025-08-26 09:00:00	SPY	ETF	642.19	642.39	642.09	642.18	96017.0
2025-08-26 09:30:00	SPY	ETF	642.2	642.8499	641.57	642.555	4366130.0
2025-08-26 10:00:00	SPY	ETF	642.492	643.27	642.38	643.08	2958422.0
2025-08-26 10:30:00	SPY	ETF	643.065	643.18	642.49	642.6919	1916423.0
2025-08-26 11:00:00	SPY	ETF	642.7	642.88	642.295	642.44	1642288.0
2025-08-26 11:30:00	SPY	ETF	642.41	642.91	642.2914	642.75	1037942.0
2025-08-26 12:00:00	SPY	ETF	642.76	643.55	642.76	643.33	1646106.0
2025-08-26 12:30:00	SPY	ETF	643.33	643.5	643.1	643.32	1037080.0
2025-08-26 13:00:00	SPY	ETF	643.3	643.59	642.89	643.51	1139368.0
2025-08-26 13:30:00	SPY	ETF	643.5	643.581	642.435	642.86	1485769.0
2025-08-26 14:00:00	SPY	ETF	642.86	643.53	642.79	643.51	1497940.0
2025-08-26 14:30:00	SPY	ETF	643.52	644.09	643.51	643.895	1843732.0
2025-08-26 15:00:00	SPY	ETF	643.89	644.7101	643.615	644.56	2660925.0
2025-08-26 15:30:00	SPY	ETF	644.55	645.51	643.92	645.13	8034208.0
2025-08-26 16:00:00	SPY	ETF	645.13	645.71	644.96	645.64	2550334.0
2025-08-26 16:30:00	SPY	ETF	645.65	645.79	645.57	645.78	115745.0
2025-08-26 17:00:00	SPY	ETF	645.78	645.78	645.61	645.65	34578.0
2025-08-26 17:30:00	SPY	ETF	645.65	645.72	645.65	645.72	8847.0
2025-08-26 18:00:00	SPY	ETF	645.73	645.9	645.6	645.75	33748.0
2025-08-26 18:30:00	SPY	ETF	645.6901	645.81	645.6901	645.7491	5975.0
2025-08-26 19:00:00	SPY	ETF	645.7499	645.78	645.68	645.7	4266.0
2025-08-26 19:30:00	SPY	ETF	645.74	645.84	645.7	645.71	24805.0
2025-08-26 04:00:00	QQQ	ETF	569.17	569.86	569.08	569.53	21384.0
2025-08-26 04:30:00	QQQ	ETF	569.51	569.72	569.38	569.51	9160.0
2025-08-26 05:00:00	QQQ	ETF	569.58	570.04	569.44	569.95	21641.0
2025-08-26 05:30:00	QQQ	ETF	569.96	570.08	569.69	569.94	12459.0
2025-08-26 06:00:00	QQQ	ETF	569.94	570.4	569.94	570.4	23636.0
2025-08-26 06:30:00	QQQ	ETF	570.4	570.63	570.28	570.4	20317.0
2025-08-26 07:00:00	QQQ	ETF	570.32	570.39	569.801	569.81	20889.0
2025-08-26 07:30:00	QQQ	ETF	569.74	569.84	569.2	569.81	22481.0
2025-08-26 08:00:00	QQQ	ETF	570.17	570.61	568.56	569.66	115438.0
2025-08-26 08:30:00	QQQ	ETF	569.66	570.01	569.1	569.71	60620.0
2025-08-26 09:00:00	QQQ	ETF	569.7205	569.95	569.67	569.83	78553.0
2025-08-26 09:30:00	QQQ	ETF	569.83	570.98	568.8	570.4726	4076744.0
2025-08-26 10:00:00	QQQ	ETF	570.42	571.705	570.17	571.59	2227238.0
2025-08-26 10:30:00	QQQ	ETF	571.58	571.81	570.9	571.08	1271771.0
2025-08-26 11:00:00	QQQ	ETF	571.09	571.42	570.68	570.7403	1203869.0
2025-08-26 11:30:00	QQQ	ETF	570.74	571.0904	570.37	570.972	1055584.0
2025-08-26 12:00:00	QQQ	ETF	570.97	571.885	570.97	571.57	1054536.0
2025-08-26 12:30:00	QQQ	ETF	571.57	571.73	571.14	571.49	735175.0

> showing 50 of 40,794 rows — these rows as CSV

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