PREVIEW / etf_30min / 2025-03-13

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-13.parquet
  size:    965 KB
  rows:    39,164

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-03-13 04:00:00	SPY	ETF	556.63	556.63	554.81	556.18	37310.0
2025-03-13 04:30:00	SPY	ETF	556.11	556.66	555.64	556.66	4622.0
2025-03-13 05:00:00	SPY	ETF	556.61	558.05	555.98	557.75	31718.0
2025-03-13 05:30:00	SPY	ETF	557.9	559.2	557.8	559.18	27865.0
2025-03-13 06:00:00	SPY	ETF	559.19	559.63	558.87	559.38	33445.0
2025-03-13 06:30:00	SPY	ETF	559.44	559.67	558.27	558.67	46782.0
2025-03-13 07:00:00	SPY	ETF	558.64	558.95	557.46	557.85	77507.0
2025-03-13 07:30:00	SPY	ETF	557.85	558.33	556.74	557.85	201054.0
2025-03-13 08:00:00	SPY	ETF	557.71	558.926	555.2	557.04	354314.0
2025-03-13 08:30:00	SPY	ETF	558.0	559.0	557.26	558.1	313257.0
2025-03-13 09:00:00	SPY	ETF	558.3	558.94	558.05	558.48	163367.0
2025-03-13 09:30:00	SPY	ETF	558.49	558.718	554.47	555.03	3350278.0
2025-03-13 10:00:00	SPY	ETF	555.02	559.105	554.45	557.115	3078294.0
2025-03-13 10:30:00	SPY	ETF	557.13	558.37	555.56	555.98	2091383.0
2025-03-13 11:00:00	SPY	ETF	556.0	556.97	554.14	554.2837	1974740.0
2025-03-13 11:30:00	SPY	ETF	554.25	555.16	552.37	552.4898	3352807.0
2025-03-13 12:00:00	SPY	ETF	552.47	554.07	552.27	552.57	2030490.0
2025-03-13 12:30:00	SPY	ETF	552.59	554.5762	551.36	552.595	3134941.0
2025-03-13 13:00:00	SPY	ETF	552.58	553.34	550.36	551.16	2519639.0
2025-03-13 13:30:00	SPY	ETF	551.11	551.24	549.68	550.09	2788139.0
2025-03-13 14:00:00	SPY	ETF	550.07	553.25	549.975	553.06	2856368.0
2025-03-13 14:30:00	SPY	ETF	553.07	554.32	552.5342	553.94	2777340.0
2025-03-13 15:00:00	SPY	ETF	553.8041	554.62	550.9	551.47	2878652.0
2025-03-13 15:30:00	SPY	ETF	551.48	552.06	550.16	551.51	7281035.0
2025-03-13 16:00:00	SPY	ETF	551.52	559.1292	551.3828	552.8799	8955512.0
2025-03-13 16:30:00	SPY	ETF	552.87	552.98	552.45	552.5016	132390.0
2025-03-13 17:00:00	SPY	ETF	552.43	552.5	551.75	551.78	361856.0
2025-03-13 17:30:00	SPY	ETF	551.95	552.5	551.9412	552.5	40586.0
2025-03-13 18:00:00	SPY	ETF	552.5	553.83	552.5	553.35	160103.0
2025-03-13 18:30:00	SPY	ETF	553.4	554.349	553.4	553.88	68135.0
2025-03-13 19:00:00	SPY	ETF	553.9	554.4799	553.8	554.16	37039.0
2025-03-13 19:30:00	SPY	ETF	554.13	554.26	553.74	553.89	58785.0
2025-03-13 04:00:00	QQQ	ETF	474.28	474.55	472.31	473.52	67691.0
2025-03-13 04:30:00	QQQ	ETF	473.56	474.31	473.1	474.23	47906.0
2025-03-13 05:00:00	QQQ	ETF	474.24	475.8	473.54	475.48	56598.0
2025-03-13 05:30:00	QQQ	ETF	475.44	477.05	475.44	477.02	57750.0
2025-03-13 06:00:00	QQQ	ETF	477.03	477.57	476.7	477.3	65325.0
2025-03-13 06:30:00	QQQ	ETF	477.32	477.33	475.95	476.27	68477.0
2025-03-13 07:00:00	QQQ	ETF	476.25	476.66	474.99	475.51	101445.0
2025-03-13 07:30:00	QQQ	ETF	475.42	475.81	474.31	475.2	119070.0
2025-03-13 08:00:00	QQQ	ETF	475.19	477.258	472.11	474.55	300201.0
2025-03-13 08:30:00	QQQ	ETF	474.73	476.73	474.73	475.77	305928.0
2025-03-13 09:00:00	QQQ	ETF	475.85	476.6	475.49	476.23	167750.0
2025-03-13 09:30:00	QQQ	ETF	476.24	476.2801	470.56	471.22	3464681.0
2025-03-13 10:00:00	QQQ	ETF	471.13	476.15	470.17	473.86	3037027.0
2025-03-13 10:30:00	QQQ	ETF	473.87	475.2	472.0801	472.6	1887350.0
2025-03-13 11:00:00	QQQ	ETF	472.65	473.87	470.67	470.945	1619042.0
2025-03-13 11:30:00	QQQ	ETF	470.93	471.81	469.0602	469.5	2433569.0
2025-03-13 12:00:00	QQQ	ETF	469.52	470.93	469.2801	469.69	1356476.0
2025-03-13 12:30:00	QQQ	ETF	469.65	471.81	468.17	469.273	2158802.0

> showing 50 of 39,164 rows — these rows as CSV

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