PREVIEW / etf_30min / 2025-04-30

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-30.parquet
  size:    958 KB
  rows:    39,905

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-04-30 04:00:00	SPY	ETF	553.29	554.08	552.87	553.3	14381.0
2025-04-30 04:30:00	SPY	ETF	553.18	553.58	552.79	553.0	5470.0
2025-04-30 05:00:00	SPY	ETF	553.11	553.75	553.11	553.75	4580.0
2025-04-30 05:30:00	SPY	ETF	553.9	553.9	553.44	553.48	3660.0
2025-04-30 06:00:00	SPY	ETF	553.4	553.51	553.1	553.1	21374.0
2025-04-30 06:30:00	SPY	ETF	553.05	553.15	552.34	553.15	43426.0
2025-04-30 07:00:00	SPY	ETF	553.1	553.86	552.55	552.55	187867.0
2025-04-30 07:30:00	SPY	ETF	552.61	552.81	552.14	552.3	80020.0
2025-04-30 08:00:00	SPY	ETF	553.6	553.8	549.99	550.74	397571.0
2025-04-30 08:30:00	SPY	ETF	551.06	552.1	546.17	547.19	1267751.0
2025-04-30 09:00:00	SPY	ETF	547.11	547.67	545.77	547.63	576494.0
2025-04-30 09:30:00	SPY	ETF	547.59	547.59	541.52	541.94	7438543.0
2025-04-30 10:00:00	SPY	ETF	541.925	546.49	541.63	546.31	4678810.0
2025-04-30 10:30:00	SPY	ETF	546.31	547.4597	545.31	546.97	3426991.0
2025-04-30 11:00:00	SPY	ETF	546.98	549.745	546.89	549.01	2956085.0
2025-04-30 11:30:00	SPY	ETF	549.005	549.84	548.61	549.4869	2053801.0
2025-04-30 12:00:00	SPY	ETF	549.43	550.24	547.78	548.09	2110661.0
2025-04-30 12:30:00	SPY	ETF	548.09	549.7699	547.41	549.5558	1531858.0
2025-04-30 13:00:00	SPY	ETF	549.555	550.15	547.14	550.03	1632944.0
2025-04-30 13:30:00	SPY	ETF	550.0	551.12	549.7743	550.47	1712918.0
2025-04-30 14:00:00	SPY	ETF	550.48	553.1	549.75	550.48	4491815.0
2025-04-30 14:30:00	SPY	ETF	550.45	551.11	549.11	549.6	2464379.0
2025-04-30 15:00:00	SPY	ETF	549.59	551.03	549.59	549.79	3093627.0
2025-04-30 15:30:00	SPY	ETF	549.82	556.52	549.38	554.35	15839738.0
2025-04-30 16:00:00	SPY	ETF	554.36	558.1	552.81	557.99	6080516.0
2025-04-30 16:30:00	SPY	ETF	557.98	558.44	555.1913	557.8	517724.0
2025-04-30 17:00:00	SPY	ETF	557.75	558.25	557.5	558.0	111944.0
2025-04-30 17:30:00	SPY	ETF	558.01	558.26	557.5	557.64	166200.0
2025-04-30 18:00:00	SPY	ETF	557.72	559.74	557.45	558.25	266088.0
2025-04-30 18:30:00	SPY	ETF	558.54	559.22	558.18	558.71	110258.0
2025-04-30 19:00:00	SPY	ETF	558.85	559.24	558.32	559.2	132869.0
2025-04-30 19:30:00	SPY	ETF	559.2	559.46	558.95	559.2785	55789.0
2025-04-30 04:00:00	QQQ	ETF	473.52	474.95	473.37	473.97	39195.0
2025-04-30 04:30:00	QQQ	ETF	473.8	474.28	473.58	473.81	13612.0
2025-04-30 05:00:00	QQQ	ETF	473.87	474.55	473.87	474.51	8315.0
2025-04-30 05:30:00	QQQ	ETF	474.64	474.68	474.09	474.11	22322.0
2025-04-30 06:00:00	QQQ	ETF	474.1	474.2	473.71	473.71	23439.0
2025-04-30 06:30:00	QQQ	ETF	473.71	473.71	473.03	473.67	20125.0
2025-04-30 07:00:00	QQQ	ETF	473.7	474.33	473.08	473.1	64896.0
2025-04-30 07:30:00	QQQ	ETF	473.15	473.15	472.3	472.65	43694.0
2025-04-30 08:00:00	QQQ	ETF	473.93	475.174	469.91	470.75	325801.0
2025-04-30 08:30:00	QQQ	ETF	470.5	471.64	466.15	466.82	769177.0
2025-04-30 09:00:00	QQQ	ETF	466.77	467.26	465.53	467.26	466939.0
2025-04-30 09:30:00	QQQ	ETF	467.13	467.22	462.47	462.8	4317909.0
2025-04-30 10:00:00	QQQ	ETF	462.67	467.505	462.43	467.38	3333367.0
2025-04-30 10:30:00	QQQ	ETF	467.38	468.5	466.57	467.9398	2055472.0
2025-04-30 11:00:00	QQQ	ETF	467.9	470.52	467.84	469.88	1911558.0
2025-04-30 11:30:00	QQQ	ETF	469.86	470.87	469.4	470.57	1570038.0
2025-04-30 12:00:00	QQQ	ETF	470.5	471.31	468.8409	469.225	1697926.0
2025-04-30 12:30:00	QQQ	ETF	469.19	470.59	468.54	470.45	1084885.0

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

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