PREVIEW / etf_30min / 2025-08-15

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-15.parquet
  size:    985 KB
  rows:    40,446

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-15 04:00:00	SPY	ETF	646.81	647.02	646.67	646.77	42723.0
2025-08-15 04:30:00	SPY	ETF	646.56	646.56	645.73	645.79	16612.0
2025-08-15 05:00:00	SPY	ETF	645.75	645.99	645.67	645.84	4380.0
2025-08-15 05:30:00	SPY	ETF	645.73	645.83	645.52	645.52	2210.0
2025-08-15 06:00:00	SPY	ETF	645.55	645.8	645.34	645.73	3951.0
2025-08-15 06:30:00	SPY	ETF	645.87	646.47	645.87	646.3	26795.0
2025-08-15 07:00:00	SPY	ETF	646.21	646.5	646.19	646.42	26866.0
2025-08-15 07:30:00	SPY	ETF	646.38	646.48	646.21	646.28	23547.0
2025-08-15 08:00:00	SPY	ETF	646.28	647.04	645.6	645.97	119480.0
2025-08-15 08:30:00	SPY	ETF	645.85	646.28	645.55	646.13	116157.0
2025-08-15 09:00:00	SPY	ETF	646.1	646.33	645.52	645.99	308928.0
2025-08-15 09:30:00	SPY	ETF	645.99	646.09	643.72	644.1	5125696.0
2025-08-15 10:00:00	SPY	ETF	643.78	644.65	643.21	644.21	3378535.0
2025-08-15 10:30:00	SPY	ETF	644.2	644.33	643.37	643.575	2229965.0
2025-08-15 11:00:00	SPY	ETF	643.58	644.28	643.26	643.478	2143389.0
2025-08-15 11:30:00	SPY	ETF	643.47	644.14	642.5153	643.415	3043453.0
2025-08-15 12:00:00	SPY	ETF	643.4	643.94	643.08	643.29	2148212.0
2025-08-15 12:30:00	SPY	ETF	643.295	644.28	643.295	644.0808	1812418.0
2025-08-15 13:00:00	SPY	ETF	644.08	644.2957	643.74	644.1654	1851424.0
2025-08-15 13:30:00	SPY	ETF	644.16	644.81	644.12	644.7708	1996129.0
2025-08-15 14:00:00	SPY	ETF	644.77	644.88	643.98	644.53	2699622.0
2025-08-15 14:30:00	SPY	ETF	644.52	644.64	643.81	644.26	2129682.0
2025-08-15 15:00:00	SPY	ETF	644.25	644.28	643.32	643.8	3179778.0
2025-08-15 15:30:00	SPY	ETF	643.8	644.13	643.13	643.44	6401568.0
2025-08-15 16:00:00	SPY	ETF	643.45	643.52	642.73	642.89	2191994.0
2025-08-15 16:30:00	SPY	ETF	642.86	643.09	642.81	643.09	107603.0
2025-08-15 17:00:00	SPY	ETF	643.08	643.09	642.85	642.95	127257.0
2025-08-15 17:30:00	SPY	ETF	643.0	643.1999	642.93	643.1999	12841.0
2025-08-15 18:00:00	SPY	ETF	643.24	643.4392	643.15	643.31	8416.0
2025-08-15 18:30:00	SPY	ETF	643.31	643.5699	643.31	643.5695	25784.0
2025-08-15 19:00:00	SPY	ETF	643.51	643.8	643.5	643.76	45222.0
2025-08-15 19:30:00	SPY	ETF	643.76	643.78	643.2294	643.2294	36987.0
2025-08-15 04:00:00	QQQ	ETF	580.45	580.84	580.42	580.47	8392.0
2025-08-15 04:30:00	QQQ	ETF	580.31	580.31	579.06	579.2	16012.0
2025-08-15 05:00:00	QQQ	ETF	579.22	579.5	579.11	579.34	6199.0
2025-08-15 05:30:00	QQQ	ETF	579.36	579.41	579.15	579.17	8042.0
2025-08-15 06:00:00	QQQ	ETF	579.05	579.39	578.91	579.35	6591.0
2025-08-15 06:30:00	QQQ	ETF	579.45	580.01	579.45	579.87	8598.0
2025-08-15 07:00:00	QQQ	ETF	579.78	580.18	579.72	580.09	26647.0
2025-08-15 07:30:00	QQQ	ETF	579.96	580.22	579.94	580.07	12867.0
2025-08-15 08:00:00	QQQ	ETF	579.78	581.02	579.02	579.53	97212.0
2025-08-15 08:30:00	QQQ	ETF	579.51	579.91	579.3	579.72	63205.0
2025-08-15 09:00:00	QQQ	ETF	579.6	580.2	579.32	579.87	319562.0
2025-08-15 09:30:00	QQQ	ETF	579.8	579.84	576.44	577.29	4287165.0
2025-08-15 10:00:00	QQQ	ETF	577.2	579.09	576.4	578.49	2891588.0
2025-08-15 10:30:00	QQQ	ETF	578.49	578.64	576.84	577.145	1953142.0
2025-08-15 11:00:00	QQQ	ETF	577.13	577.97	576.84	577.21	1538225.0
2025-08-15 11:30:00	QQQ	ETF	577.2	577.6	575.5743	576.84	2277103.0
2025-08-15 12:00:00	QQQ	ETF	576.83	577.385	576.25	576.34	1718690.0
2025-08-15 12:30:00	QQQ	ETF	576.35	577.7494	576.24	577.57	1604515.0

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

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