PREVIEW / etf_30min / 2025-08-01

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-01.parquet
  size:    1.0 MB
  rows:    43,810

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-01 04:00:00	SPY	ETF	629.5	629.5	626.06	626.15	165874.0
2025-08-01 04:30:00	SPY	ETF	626.25	626.87	625.69	626.7	68056.0
2025-08-01 05:00:00	SPY	ETF	626.67	627.1	626.28	626.32	44236.0
2025-08-01 05:30:00	SPY	ETF	626.13	626.84	626.12	626.68	11598.0
2025-08-01 06:00:00	SPY	ETF	626.67	626.67	626.0	626.5	21614.0
2025-08-01 06:30:00	SPY	ETF	626.35	626.42	624.83	625.17	278460.0
2025-08-01 07:00:00	SPY	ETF	625.36	626.52	625.2	626.37	139154.0
2025-08-01 07:30:00	SPY	ETF	626.28	627.0	626.26	626.87	97650.0
2025-08-01 08:00:00	SPY	ETF	625.38	631.64	624.8696	626.95	462635.0
2025-08-01 08:30:00	SPY	ETF	626.53	628.2	625.4	625.84	1297259.0
2025-08-01 09:00:00	SPY	ETF	625.95	626.64	625.3	626.31	533158.0
2025-08-01 09:30:00	SPY	ETF	626.3	626.34	621.1	621.4815	11829461.0
2025-08-01 10:00:00	SPY	ETF	621.53	623.52	619.65	623.37	9704416.0
2025-08-01 10:30:00	SPY	ETF	623.37	624.07	621.78	621.96	7754046.0
2025-08-01 11:00:00	SPY	ETF	621.96	622.9793	621.39	621.51	5665188.0
2025-08-01 11:30:00	SPY	ETF	621.51	624.035	621.38	624.0	5244635.0
2025-08-01 12:00:00	SPY	ETF	624.0	624.965	623.88	624.21	5117824.0
2025-08-01 12:30:00	SPY	ETF	624.21	624.46	621.2	621.35	6929649.0
2025-08-01 13:00:00	SPY	ETF	621.34	621.79	620.335	620.57	6801142.0
2025-08-01 13:30:00	SPY	ETF	620.57	621.41	620.21	620.6299	5190611.0
2025-08-01 14:00:00	SPY	ETF	620.61	621.81	619.29	621.6248	5676757.0
2025-08-01 14:30:00	SPY	ETF	621.63	623.11	620.95	621.4	6782162.0
2025-08-01 15:00:00	SPY	ETF	621.41	622.3	620.97	621.79	7461759.0
2025-08-01 15:30:00	SPY	ETF	621.78	623.3	620.84	621.71	14758898.0
2025-08-01 16:00:00	SPY	ETF	621.71	623.7583	621.5	622.1193	2955227.0
2025-08-01 16:30:00	SPY	ETF	622.08	622.13	621.68	621.68	259085.0
2025-08-01 17:00:00	SPY	ETF	621.71	621.9995	621.5	621.88	105449.0
2025-08-01 17:30:00	SPY	ETF	621.98	622.11	621.91	622.11	22228.0
2025-08-01 18:00:00	SPY	ETF	622.1499	622.17	621.91	621.97	25316.0
2025-08-01 18:30:00	SPY	ETF	621.98	622.01	621.6	621.62	43972.0
2025-08-01 19:00:00	SPY	ETF	621.6007	621.6007	621.14	621.24	39375.0
2025-08-01 19:30:00	SPY	ETF	621.11	621.24	621.03	621.23	29907.0
2025-08-01 04:00:00	QQQ	ETF	562.78	562.78	558.42	558.42	148897.0
2025-08-01 04:30:00	QQQ	ETF	558.8	559.72	558.23	559.41	105997.0
2025-08-01 05:00:00	QQQ	ETF	559.3	560.0	558.93	558.93	82976.0
2025-08-01 05:30:00	QQQ	ETF	558.9	559.88	558.76	559.78	63263.0
2025-08-01 06:00:00	QQQ	ETF	559.7	559.7	558.7	559.14	46328.0
2025-08-01 06:30:00	QQQ	ETF	559.08	559.25	557.45	558.01	149143.0
2025-08-01 07:00:00	QQQ	ETF	558.08	559.4	557.98	559.23	183490.0
2025-08-01 07:30:00	QQQ	ETF	559.2	559.83	559.13	559.8	82668.0
2025-08-01 08:00:00	QQQ	ETF	558.31	564.587	557.867	559.56	442733.0
2025-08-01 08:30:00	QQQ	ETF	559.55	560.76	558.21	558.3501	650920.0
2025-08-01 09:00:00	QQQ	ETF	558.41	559.17	557.87	558.85	345080.0
2025-08-01 09:30:00	QQQ	ETF	558.85	559.02	553.32	553.8002	9235613.0
2025-08-01 10:00:00	QQQ	ETF	553.73	556.38	551.88	556.38	6338500.0
2025-08-01 10:30:00	QQQ	ETF	556.38	557.26	554.78	555.035	3732294.0
2025-08-01 11:00:00	QQQ	ETF	555.03	555.74	554.32	554.3782	2154674.0
2025-08-01 11:30:00	QQQ	ETF	554.37	557.16	554.23	556.915	2315473.0
2025-08-01 12:00:00	QQQ	ETF	556.92	557.841	556.77	556.96	2015043.0
2025-08-01 12:30:00	QQQ	ETF	556.96	557.22	553.68	553.84	2106118.0

> showing 50 of 43,810 rows — these rows as CSV

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