PREVIEW / etf_30min / 2025-08-27

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-27.parquet
  size:    1011 KB
  rows:    41,024

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-27 04:00:00	SPY	ETF	645.5	645.5	645.15	645.24	8909.0
2025-08-27 04:30:00	SPY	ETF	645.28	645.39	644.99	645.39	3880.0
2025-08-27 05:00:00	SPY	ETF	645.42	645.65	645.42	645.62	2282.0
2025-08-27 05:30:00	SPY	ETF	645.69	645.77	645.63	645.63	2600.0
2025-08-27 06:00:00	SPY	ETF	645.61	645.76	645.57	645.76	1627.0
2025-08-27 06:30:00	SPY	ETF	645.78	645.78	645.6	645.64	6547.0
2025-08-27 07:00:00	SPY	ETF	645.72	645.85	645.53	645.76	16800.0
2025-08-27 07:30:00	SPY	ETF	645.76	645.9	645.75	645.79	22991.0
2025-08-27 08:00:00	SPY	ETF	645.62	646.0	645.08	645.58	62135.0
2025-08-27 08:30:00	SPY	ETF	645.58	645.66	644.95	645.26	89705.0
2025-08-27 09:00:00	SPY	ETF	645.23	645.26	644.41	644.57	159625.0
2025-08-27 09:30:00	SPY	ETF	644.57	645.53	644.42	645.35	4146832.0
2025-08-27 10:00:00	SPY	ETF	645.35	646.34	645.2603	646.1172	2983367.0
2025-08-27 10:30:00	SPY	ETF	646.11	646.41	645.75	646.18	2044887.0
2025-08-27 11:00:00	SPY	ETF	646.19	646.54	646.18	646.3	1557173.0
2025-08-27 11:30:00	SPY	ETF	646.3	646.69	645.91	646.5418	1681710.0
2025-08-27 12:00:00	SPY	ETF	646.55	646.6	645.48	645.96	1672438.0
2025-08-27 12:30:00	SPY	ETF	645.96	646.5299	645.38	646.2993	1910515.0
2025-08-27 13:00:00	SPY	ETF	646.29	646.55	646.04	646.445	1515476.0
2025-08-27 13:30:00	SPY	ETF	646.45	646.82	646.44	646.76	1172570.0
2025-08-27 14:00:00	SPY	ETF	646.755	647.355	646.58	647.26	2133866.0
2025-08-27 14:30:00	SPY	ETF	647.25	647.31	647.0099	647.04	1510705.0
2025-08-27 15:00:00	SPY	ETF	647.035	647.0579	645.82	646.655	3259892.0
2025-08-27 15:30:00	SPY	ETF	646.65	647.37	646.6	646.62	5009612.0
2025-08-27 16:00:00	SPY	ETF	646.61	647.64	643.15	645.87	2809025.0
2025-08-27 16:30:00	SPY	ETF	645.86	645.96	644.62	645.68	1078359.0
2025-08-27 17:00:00	SPY	ETF	645.46	646.2	645.46	646.03	124151.0
2025-08-27 17:30:00	SPY	ETF	646.06	646.19	645.74	645.75	45994.0
2025-08-27 18:00:00	SPY	ETF	645.7	645.7	644.65	644.81	102461.0
2025-08-27 18:30:00	SPY	ETF	644.87	645.29	644.87	644.98	19903.0
2025-08-27 19:00:00	SPY	ETF	644.97	645.11	644.75	644.89	22503.0
2025-08-27 19:30:00	SPY	ETF	644.91	644.92	644.66	644.8199	20796.0
2025-08-27 04:00:00	QQQ	ETF	573.1	573.1	572.47	572.62	65733.0
2025-08-27 04:30:00	QQQ	ETF	572.64	572.75	572.27	572.7	19922.0
2025-08-27 05:00:00	QQQ	ETF	572.69	572.99	572.69	572.93	11189.0
2025-08-27 05:30:00	QQQ	ETF	572.99	573.07	572.9	572.98	7204.0
2025-08-27 06:00:00	QQQ	ETF	572.93	573.1	572.87	573.1	6199.0
2025-08-27 06:30:00	QQQ	ETF	573.12	573.17	572.95	573.09	11281.0
2025-08-27 07:00:00	QQQ	ETF	573.07	573.31	573.0	573.26	15323.0
2025-08-27 07:30:00	QQQ	ETF	573.25	573.39	573.21	573.21	15779.0
2025-08-27 08:00:00	QQQ	ETF	573.26	573.55	572.181	572.93	94864.0
2025-08-27 08:30:00	QQQ	ETF	572.9	572.98	572.17	572.6	140285.0
2025-08-27 09:00:00	QQQ	ETF	572.6	572.68	571.5	571.571	217479.0
2025-08-27 09:30:00	QQQ	ETF	571.59	572.21	570.37	571.47	4430522.0
2025-08-27 10:00:00	QQQ	ETF	571.47	573.18	571.28	572.9701	2159305.0
2025-08-27 10:30:00	QQQ	ETF	572.99	573.4	572.65	573.042	1667324.0
2025-08-27 11:00:00	QQQ	ETF	573.05	573.25	572.745	572.8099	1085788.0
2025-08-27 11:30:00	QQQ	ETF	572.8	573.77	572.4	573.595	1431222.0
2025-08-27 12:00:00	QQQ	ETF	573.59	573.6195	571.74	572.25	1520316.0
2025-08-27 12:30:00	QQQ	ETF	572.23	573.315	571.65	573.06	1356838.0

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

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