PREVIEW / etf_30min / 2025-11-04

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-11-04.parquet
  size:    1.1 MB
  rows:    47,064

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-11-04 04:00:00	SPY	ETF	676.52	678.63	675.63	675.71	119981.0
2025-11-04 04:30:00	SPY	ETF	675.73	676.34	674.3	674.47	97776.0
2025-11-04 05:00:00	SPY	ETF	674.44	675.37	673.77	675.32	241232.0
2025-11-04 05:30:00	SPY	ETF	675.29	676.6	675.29	676.47	58283.0
2025-11-04 06:00:00	SPY	ETF	676.59	676.65	676.23	676.57	184167.0
2025-11-04 06:30:00	SPY	ETF	676.62	677.0	676.28	676.47	60288.0
2025-11-04 07:00:00	SPY	ETF	676.39	677.02	675.61	676.98	262188.0
2025-11-04 07:30:00	SPY	ETF	676.99	677.18	676.29	676.57	152913.0
2025-11-04 08:00:00	SPY	ETF	676.5	680.03	674.2	675.79	324385.0
2025-11-04 08:30:00	SPY	ETF	675.76	676.34	675.34	676.01	276763.0
2025-11-04 09:00:00	SPY	ETF	675.99	676.5	675.24	676.15	293196.0
2025-11-04 09:30:00	SPY	ETF	676.11	678.815	674.67	678.6817	9429645.0
2025-11-04 10:00:00	SPY	ETF	678.71	679.645	678.31	679.32	4095883.0
2025-11-04 10:30:00	SPY	ETF	679.32	679.96	677.63	678.18	3318448.0
2025-11-04 11:00:00	SPY	ETF	678.18	678.82	677.56	678.2	3030954.0
2025-11-04 11:30:00	SPY	ETF	678.21	678.63	677.44	678.19	2768451.0
2025-11-04 12:00:00	SPY	ETF	678.19	678.205	675.68	676.93	3533263.0
2025-11-04 12:30:00	SPY	ETF	676.93	677.25	675.725	676.01	2733927.0
2025-11-04 13:00:00	SPY	ETF	675.98	676.1256	674.98	675.25	2419785.0
2025-11-04 13:30:00	SPY	ETF	675.25	676.42	674.71	676.15	3347327.0
2025-11-04 14:00:00	SPY	ETF	676.11	676.68	675.66	676.295	3698911.0
2025-11-04 14:30:00	SPY	ETF	676.29	676.375	674.58	675.17	3388332.0
2025-11-04 15:00:00	SPY	ETF	675.19	676.23	675.02	675.96	3625664.0
2025-11-04 15:30:00	SPY	ETF	675.97	676.535	674.615	675.35	9735954.0
2025-11-04 16:00:00	SPY	ETF	675.35	675.68	674.55	674.92	3796730.0
2025-11-04 16:30:00	SPY	ETF	674.98	675.82	674.7	675.61	154312.0
2025-11-04 17:00:00	SPY	ETF	675.64	675.77	675.31	675.68	81115.0
2025-11-04 17:30:00	SPY	ETF	675.66	675.69	675.12	675.12	57884.0
2025-11-04 18:00:00	SPY	ETF	675.22	675.62	674.42	674.6	122712.0
2025-11-04 18:30:00	SPY	ETF	674.6699	674.9	674.35	674.41	52069.0
2025-11-04 19:00:00	SPY	ETF	674.31	674.31	673.24	673.34	40093.0
2025-11-04 19:30:00	SPY	ETF	673.32	673.32	672.34	672.34	145924.0
2025-11-04 20:00:00	SPY	ETF	672.33	672.33	672.33	672.33	863.0
2025-11-04 04:00:00	QQQ	ETF	625.0	625.0	622.83	622.98	181397.0
2025-11-04 04:30:00	QQQ	ETF	623.02	623.56	621.55	621.68	250179.0
2025-11-04 05:00:00	QQQ	ETF	621.66	622.68	620.97	622.66	200092.0
2025-11-04 05:30:00	QQQ	ETF	622.62	624.0	622.6	623.71	159145.0
2025-11-04 06:00:00	QQQ	ETF	623.68	623.97	623.4	623.92	86569.0
2025-11-04 06:30:00	QQQ	ETF	623.92	624.49	623.78	623.82	157319.0
2025-11-04 07:00:00	QQQ	ETF	623.9	624.37	622.92	624.29	307591.0
2025-11-04 07:30:00	QQQ	ETF	624.28	624.51	623.39	623.61	173403.0
2025-11-04 08:00:00	QQQ	ETF	624.58	631.606	621.09	622.58	707941.0
2025-11-04 08:30:00	QQQ	ETF	622.6	623.11	621.95	622.66	530463.0
2025-11-04 09:00:00	QQQ	ETF	622.63	623.47	621.9	623.24	588958.0
2025-11-04 09:30:00	QQQ	ETF	623.28	626.67	621.3687	626.515	7991815.0
2025-11-04 10:00:00	QQQ	ETF	626.5	626.95	625.34	626.23	3966534.0
2025-11-04 10:30:00	QQQ	ETF	626.22	626.85	623.81	624.41	2993980.0
2025-11-04 11:00:00	QQQ	ETF	624.41	625.21	623.19	623.978	2385531.0
2025-11-04 11:30:00	QQQ	ETF	623.99	624.58	622.83	623.6001	2161531.0
2025-11-04 12:00:00	QQQ	ETF	623.6	623.635	620.8899	622.53	3152855.0

> showing 50 of 47,064 rows — these rows as CSV

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