PREVIEW / etf_30min / 2025-09-05

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-05.parquet
  size:    1.0 MB
  rows:    42,104

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-05 04:00:00	SPY	ETF	650.36	650.55	649.88	650.52	16070.0
2025-09-05 04:30:00	SPY	ETF	650.56	650.81	650.47	650.58	15698.0
2025-09-05 05:00:00	SPY	ETF	650.76	650.76	650.53	650.53	5308.0
2025-09-05 05:30:00	SPY	ETF	650.55	650.6	650.43	650.44	21437.0
2025-09-05 06:00:00	SPY	ETF	650.42	650.62	650.28	650.52	13820.0
2025-09-05 06:30:00	SPY	ETF	650.5	650.62	650.41	650.41	26594.0
2025-09-05 07:00:00	SPY	ETF	650.4	650.71	650.4	650.57	52281.0
2025-09-05 07:30:00	SPY	ETF	650.58	650.58	649.86	649.86	85318.0
2025-09-05 08:00:00	SPY	ETF	650.55	651.1	649.4896	649.65	328168.0
2025-09-05 08:30:00	SPY	ETF	649.585	651.66	648.44	651.63	1160177.0
2025-09-05 09:00:00	SPY	ETF	651.63	652.15	651.4	651.43	402828.0
2025-09-05 09:30:00	SPY	ETF	651.46	652.21	650.54	651.065	7698356.0
2025-09-05 10:00:00	SPY	ETF	651.06	651.095	646.05	646.56	7805299.0
2025-09-05 10:30:00	SPY	ETF	646.52	646.66	644.0896	644.14	7108329.0
2025-09-05 11:00:00	SPY	ETF	644.15	646.28	643.33	646.205	4887270.0
2025-09-05 11:30:00	SPY	ETF	646.21	646.9	645.34	645.67	3643092.0
2025-09-05 12:00:00	SPY	ETF	645.68	646.75	645.29	645.725	2669970.0
2025-09-05 12:30:00	SPY	ETF	645.74	646.47	645.23	646.47	2321333.0
2025-09-05 13:00:00	SPY	ETF	646.47	646.55	645.37	645.85	2334262.0
2025-09-05 13:30:00	SPY	ETF	645.87	646.06	644.61	645.12	2522024.0
2025-09-05 14:00:00	SPY	ETF	645.15	645.99	644.9	645.7099	2640813.0
2025-09-05 14:30:00	SPY	ETF	645.69	646.31	645.69	646.31	2311821.0
2025-09-05 15:00:00	SPY	ETF	646.29	647.41	645.9	647.11	3677043.0
2025-09-05 15:30:00	SPY	ETF	647.12	647.27	646.15	647.21	7714368.0
2025-09-05 16:00:00	SPY	ETF	647.19	647.26	646.63	646.83	1929253.0
2025-09-05 16:30:00	SPY	ETF	646.78	647.02	646.74	646.98	278025.0
2025-09-05 17:00:00	SPY	ETF	646.93	647.048	646.86	646.94	98919.0
2025-09-05 17:30:00	SPY	ETF	646.94	646.94	646.1997	646.23	122305.0
2025-09-05 18:00:00	SPY	ETF	646.17	646.27	645.8894	646.1197	80162.0
2025-09-05 18:30:00	SPY	ETF	646.12	646.12	646.0118	646.07	60962.0
2025-09-05 19:00:00	SPY	ETF	646.06	646.09	645.88	645.95	66563.0
2025-09-05 19:30:00	SPY	ETF	645.96	646.04	645.93	645.96	29839.0
2025-09-05 04:00:00	QQQ	ETF	577.21	578.2	577.21	578.16	31788.0
2025-09-05 04:30:00	QQQ	ETF	578.2	578.43	578.0	578.43	21925.0
2025-09-05 05:00:00	QQQ	ETF	578.5	578.5	578.19	578.28	12598.0
2025-09-05 05:30:00	QQQ	ETF	578.31	578.45	578.26	578.28	18153.0
2025-09-05 06:00:00	QQQ	ETF	578.31	578.4	578.06	578.33	25733.0
2025-09-05 06:30:00	QQQ	ETF	578.34	578.43	578.22	578.23	38139.0
2025-09-05 07:00:00	QQQ	ETF	578.11	578.7	578.06	578.58	28521.0
2025-09-05 07:30:00	QQQ	ETF	578.599	578.599	577.98	577.98	26558.0
2025-09-05 08:00:00	QQQ	ETF	578.36	578.7	574.799	578.16	249647.0
2025-09-05 08:30:00	QQQ	ETF	578.4	580.46	576.92	580.45	1174681.0
2025-09-05 09:00:00	QQQ	ETF	580.45	581.01	580.37	580.48	636897.0
2025-09-05 09:30:00	QQQ	ETF	580.48	581.12	579.21	579.95	8971651.0
2025-09-05 10:00:00	QQQ	ETF	579.92	579.94	574.52	575.129	7088769.0
2025-09-05 10:30:00	QQQ	ETF	575.1	575.41	572.5	572.5542	6040457.0
2025-09-05 11:00:00	QQQ	ETF	572.56	574.73	571.53	574.63	4674867.0
2025-09-05 11:30:00	QQQ	ETF	574.62	575.5	573.92	574.27	3119415.0
2025-09-05 12:00:00	QQQ	ETF	574.26	575.24	573.71	574.32	2542188.0
2025-09-05 12:30:00	QQQ	ETF	574.38	575.15	573.75	575.15	1984809.0

> showing 50 of 42,104 rows — these rows as CSV

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