PREVIEW / etf_30min / 2025-08-14

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-14.parquet
  size:    1014 KB
  rows:    41,738

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-14 04:00:00	SPY	ETF	644.56	644.84	644.54	644.82	6250.0
2025-08-14 04:30:00	SPY	ETF	644.85	644.85	644.51	644.58	5323.0
2025-08-14 05:00:00	SPY	ETF	644.52	644.86	644.49	644.86	3396.0
2025-08-14 05:30:00	SPY	ETF	644.87	644.95	644.73	644.78	5817.0
2025-08-14 06:00:00	SPY	ETF	644.75	644.86	644.52	644.52	5610.0
2025-08-14 06:30:00	SPY	ETF	644.54	644.7	644.46	644.58	2752.0
2025-08-14 07:00:00	SPY	ETF	644.56	644.82	644.48	644.82	10832.0
2025-08-14 07:30:00	SPY	ETF	644.84	645.19	644.7	645.13	45605.0
2025-08-14 08:00:00	SPY	ETF	644.47	645.21	643.9	644.88	87341.0
2025-08-14 08:30:00	SPY	ETF	644.92	644.97	641.4	642.6	2064509.0
2025-08-14 09:00:00	SPY	ETF	642.55	642.86	642.05	642.75	424882.0
2025-08-14 09:30:00	SPY	ETF	642.78	644.25	642.34	644.02	5784422.0
2025-08-14 10:00:00	SPY	ETF	644.02	644.615	643.7	644.24	2696680.0
2025-08-14 10:30:00	SPY	ETF	644.25	645.545	644.21	644.74	2972265.0
2025-08-14 11:00:00	SPY	ETF	644.74	644.79	642.96	643.335	2846397.0
2025-08-14 11:30:00	SPY	ETF	643.34	644.22	642.98	644.07	2532417.0
2025-08-14 12:00:00	SPY	ETF	644.04	644.09	642.665	643.09	2037355.0
2025-08-14 12:30:00	SPY	ETF	643.09	644.26	642.985	644.17	1504990.0
2025-08-14 13:00:00	SPY	ETF	644.16	645.05	644.09	645.0006	1679671.0
2025-08-14 13:30:00	SPY	ETF	645.01	645.06	644.25	644.71	1595121.0
2025-08-14 14:00:00	SPY	ETF	644.72	644.725	643.91	644.085	2391255.0
2025-08-14 14:30:00	SPY	ETF	644.07	644.95	643.95	644.6	2307817.0
2025-08-14 15:00:00	SPY	ETF	644.59	645.49	644.48	645.03	3068844.0
2025-08-14 15:30:00	SPY	ETF	645.03	645.62	644.84	644.94	6364852.0
2025-08-14 16:00:00	SPY	ETF	644.93	645.3974	644.2306	644.49	1963875.0
2025-08-14 16:30:00	SPY	ETF	644.5	645.09	644.45	645.07	474614.0
2025-08-14 17:00:00	SPY	ETF	645.09	645.12	644.8	644.8	66800.0
2025-08-14 17:30:00	SPY	ETF	644.86	644.95	644.83	644.92	12460.0
2025-08-14 18:00:00	SPY	ETF	644.95	645.329	644.77	645.06	29569.0
2025-08-14 18:30:00	SPY	ETF	645.09	645.28	645.0	645.25	4310.0
2025-08-14 19:00:00	SPY	ETF	645.28	645.49	645.28	645.32	9491.0
2025-08-14 19:30:00	SPY	ETF	645.3001	645.527	645.16	645.16	26616.0
2025-08-14 04:00:00	QQQ	ETF	580.15	580.28	580.09	580.28	7515.0
2025-08-14 04:30:00	QQQ	ETF	580.25	580.36	579.9	579.96	5030.0
2025-08-14 05:00:00	QQQ	ETF	579.92	580.22	579.82	580.19	10144.0
2025-08-14 05:30:00	QQQ	ETF	580.22	580.27	579.96	579.96	9740.0
2025-08-14 06:00:00	QQQ	ETF	580.0	580.11	579.86	580.04	3489.0
2025-08-14 06:30:00	QQQ	ETF	580.07	580.26	580.01	580.16	4535.0
2025-08-14 07:00:00	QQQ	ETF	580.2	580.58	580.05	580.53	18149.0
2025-08-14 07:30:00	QQQ	ETF	580.55	580.75	580.37	580.68	73003.0
2025-08-14 08:00:00	QQQ	ETF	580.14	580.88	579.35	580.61	103989.0
2025-08-14 08:30:00	QQQ	ETF	580.7	580.9	576.74	577.98	1209875.0
2025-08-14 09:00:00	QQQ	ETF	577.95	578.36	577.3	578.3	379330.0
2025-08-14 09:30:00	QQQ	ETF	578.28	580.8	577.91	580.19	5420145.0
2025-08-14 10:00:00	QQQ	ETF	580.2	580.6899	579.45	580.58	2388248.0
2025-08-14 10:30:00	QQQ	ETF	580.57	581.88	580.33	580.6822	2296106.0
2025-08-14 11:00:00	QQQ	ETF	580.68	580.79	578.45	579.04	2240868.0
2025-08-14 11:30:00	QQQ	ETF	579.04	580.34	578.66	580.1	2204332.0
2025-08-14 12:00:00	QQQ	ETF	580.09	580.15	578.46	578.94	1951511.0
2025-08-14 12:30:00	QQQ	ETF	578.93	580.55	578.93	580.46	1794104.0

> showing 50 of 41,738 rows — these rows as CSV

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