PREVIEW / etf_30min / 2025-09-04

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-04.parquet
  size:    1.0 MB
  rows:    41,401

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-04 04:00:00	SPY	ETF	644.46	644.71	644.28	644.71	6566.0
2025-09-04 04:30:00	SPY	ETF	644.65	644.65	644.46	644.49	3815.0
2025-09-04 05:00:00	SPY	ETF	644.52	644.66	644.5	644.59	2030.0
2025-09-04 05:30:00	SPY	ETF	644.63	644.78	644.63	644.75	2112.0
2025-09-04 06:00:00	SPY	ETF	644.9	645.24	644.58	644.58	13283.0
2025-09-04 06:30:00	SPY	ETF	644.73	644.89	644.68	644.85	12839.0
2025-09-04 07:00:00	SPY	ETF	644.7	645.05	644.5	644.6	29599.0
2025-09-04 07:30:00	SPY	ETF	644.58	644.72	644.17	644.42	27999.0
2025-09-04 08:00:00	SPY	ETF	644.95	645.05	643.8	644.38	151728.0
2025-09-04 08:30:00	SPY	ETF	644.43	644.62	644.01	644.4082	86025.0
2025-09-04 09:00:00	SPY	ETF	644.3	644.5	643.97	644.47	233042.0
2025-09-04 09:30:00	SPY	ETF	644.43	645.3	644.19	644.85	5124278.0
2025-09-04 10:00:00	SPY	ETF	644.8	645.11	643.51	644.88	4675203.0
2025-09-04 10:30:00	SPY	ETF	644.87	645.78	644.84	645.645	3391844.0
2025-09-04 11:00:00	SPY	ETF	645.64	646.435	645.31	646.2108	2925917.0
2025-09-04 11:30:00	SPY	ETF	646.22	646.59	645.82	646.175	2061818.0
2025-09-04 12:00:00	SPY	ETF	646.175	646.56	645.83	645.95	1642872.0
2025-09-04 12:30:00	SPY	ETF	645.94	646.5	645.81	645.943	1573652.0
2025-09-04 13:00:00	SPY	ETF	645.95	646.97	645.92	646.8593	1825238.0
2025-09-04 13:30:00	SPY	ETF	646.84	647.462	646.59	647.14	2150468.0
2025-09-04 14:00:00	SPY	ETF	647.14	647.61	647.13	647.23	1900281.0
2025-09-04 14:30:00	SPY	ETF	647.23	647.68	647.08	647.63	1888751.0
2025-09-04 15:00:00	SPY	ETF	647.63	648.25	647.595	647.915	3065379.0
2025-09-04 15:30:00	SPY	ETF	647.91	649.15	647.81	648.99	9189837.0
2025-09-04 16:00:00	SPY	ETF	648.99	649.53	648.73	649.2801	3434955.0
2025-09-04 16:30:00	SPY	ETF	649.29	649.44	649.12	649.12	206548.0
2025-09-04 17:00:00	SPY	ETF	649.1249	649.5	649.05	649.5	65287.0
2025-09-04 17:30:00	SPY	ETF	649.53	649.79	649.35	649.5	111850.0
2025-09-04 18:00:00	SPY	ETF	649.34	649.6	649.13	649.33	69111.0
2025-09-04 18:30:00	SPY	ETF	649.3396	649.54	649.2402	649.5	24872.0
2025-09-04 19:00:00	SPY	ETF	649.5	649.6	649.4701	649.6	6533.0
2025-09-04 19:30:00	SPY	ETF	649.5412	649.55	649.39	649.46	27116.0
2025-09-04 04:00:00	QQQ	ETF	570.82	571.34	570.7	571.3	24222.0
2025-09-04 04:30:00	QQQ	ETF	571.37	571.4	571.06	571.13	11038.0
2025-09-04 05:00:00	QQQ	ETF	571.25	571.36	571.02	571.23	24750.0
2025-09-04 05:30:00	QQQ	ETF	571.23	571.65	571.22	571.62	18271.0
2025-09-04 06:00:00	QQQ	ETF	571.62	572.03	571.26	571.29	23752.0
2025-09-04 06:30:00	QQQ	ETF	571.29	571.66	571.29	571.44	36518.0
2025-09-04 07:00:00	QQQ	ETF	571.43	571.71	571.04	571.15	16998.0
2025-09-04 07:30:00	QQQ	ETF	571.15	571.43	570.75	571.09	45263.0
2025-09-04 08:00:00	QQQ	ETF	571.5	571.7904	570.17	570.97	179243.0
2025-09-04 08:30:00	QQQ	ETF	571.15	571.35	570.48	570.84	159620.0
2025-09-04 09:00:00	QQQ	ETF	570.8	570.86	570.26	570.77	160653.0
2025-09-04 09:30:00	QQQ	ETF	570.74	572.35	570.18	570.61	5011587.0
2025-09-04 10:00:00	QQQ	ETF	570.83	571.0518	569.025	570.77	3760973.0
2025-09-04 10:30:00	QQQ	ETF	570.74	571.92	570.72	571.738	2581608.0
2025-09-04 11:00:00	QQQ	ETF	571.73	572.53	571.01	572.3	2662173.0
2025-09-04 11:30:00	QQQ	ETF	572.32	572.52	571.62	572.12	1626060.0
2025-09-04 12:00:00	QQQ	ETF	572.125	572.49	571.52	571.6928	1282954.0
2025-09-04 12:30:00	QQQ	ETF	571.68	572.775	571.595	572.13	1476177.0

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

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