PREVIEW / etf_30min / 2024-08-29

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-08-29.parquet
  size:    813 KB
  rows:    32,631

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
2024-08-29 04:00:00	SPY	ETF	557.22	558.8	557.22	558.15	65916.0
2024-08-29 04:30:00	SPY	ETF	558.1	558.83	558.1	558.62	14932.0
2024-08-29 05:00:00	SPY	ETF	558.63	559.4	558.61	559.29	21816.0
2024-08-29 05:30:00	SPY	ETF	559.43	560.06	559.28	559.91	15005.0
2024-08-29 06:00:00	SPY	ETF	559.9	560.2	559.46	559.46	26009.0
2024-08-29 06:30:00	SPY	ETF	559.46	559.68	559.09	559.34	35158.0
2024-08-29 07:00:00	SPY	ETF	559.26	559.56	558.77	559.18	225851.0
2024-08-29 07:30:00	SPY	ETF	559.16	560.21	559.15	559.75	73532.0
2024-08-29 08:00:00	SPY	ETF	559.08	560.19	556.38	559.92	189447.0
2024-08-29 08:30:00	SPY	ETF	560.15	560.82	559.45	559.83	292959.0
2024-08-29 09:00:00	SPY	ETF	559.84	560.51	559.72	560.29	220803.0
2024-08-29 09:30:00	SPY	ETF	560.31	561.28	559.37	561.1	4110788.0
2024-08-29 10:00:00	SPY	ETF	561.1	561.95	560.1	561.71	2164198.0
2024-08-29 10:30:00	SPY	ETF	561.735	562.8	561.63	562.12	1990652.0
2024-08-29 11:00:00	SPY	ETF	562.09	563.19	561.47	562.12	1267679.0
2024-08-29 11:30:00	SPY	ETF	562.13	562.54	561.92	562.48	894983.0
2024-08-29 12:00:00	SPY	ETF	562.48	563.54	562.42	563.28	1277285.0
2024-08-29 12:30:00	SPY	ETF	563.27	563.68	562.67	563.11	1014786.0
2024-08-29 13:00:00	SPY	ETF	563.12	563.12	562.15	562.47	812925.0
2024-08-29 13:30:00	SPY	ETF	562.46	562.89	561.96	562.85	923945.0
2024-08-29 14:00:00	SPY	ETF	562.8	562.84	560.35	560.58	1386749.0
2024-08-29 14:30:00	SPY	ETF	560.56	560.56	557.18	558.493	3653675.0
2024-08-29 15:00:00	SPY	ETF	558.48	559.67	557.53	559.125	1882460.0
2024-08-29 15:30:00	SPY	ETF	559.11	559.95	557.69	558.315	5043519.0
2024-08-29 16:00:00	SPY	ETF	558.32	559.37	558.32	559.3	2083007.0
2024-08-29 16:30:00	SPY	ETF	559.321	559.37	559.0	559.11	84594.0
2024-08-29 17:00:00	SPY	ETF	559.1	559.22	559.02	559.22	18021.0
2024-08-29 17:30:00	SPY	ETF	559.16	559.4	559.16	559.21	28184.0
2024-08-29 18:00:00	SPY	ETF	559.3	559.5	558.6	558.91	28271.0
2024-08-29 18:30:00	SPY	ETF	558.99	558.99	558.86	558.929	1084.0
2024-08-29 19:00:00	SPY	ETF	558.8	559.03	558.79	559.03	5497.0
2024-08-29 19:30:00	SPY	ETF	558.969	559.0	558.75	558.86	12102.0
2024-08-29 04:00:00	QQQ	ETF	469.72	471.42	468.38	470.64	108889.0
2024-08-29 04:30:00	QQQ	ETF	470.61	471.4	470.59	471.17	28366.0
2024-08-29 05:00:00	QQQ	ETF	471.18	472.4	471.09	472.35	46256.0
2024-08-29 05:30:00	QQQ	ETF	472.43	473.36	471.95	472.99	97519.0
2024-08-29 06:00:00	QQQ	ETF	473.09	473.61	472.42	472.46	42245.0
2024-08-29 06:30:00	QQQ	ETF	472.53	472.76	471.76	472.07	49695.0
2024-08-29 07:00:00	QQQ	ETF	472.01	472.2	471.34	471.79	149363.0
2024-08-29 07:30:00	QQQ	ETF	471.77	473.09	471.69	472.5	93048.0
2024-08-29 08:00:00	QQQ	ETF	471.92	473.308	467.9	472.67	260933.0
2024-08-29 08:30:00	QQQ	ETF	473.0	473.56	471.94	472.56	258036.0
2024-08-29 09:00:00	QQQ	ETF	472.61	473.42	472.43	473.28	249811.0
2024-08-29 09:30:00	QQQ	ETF	473.28	476.95	472.78	476.82	5379001.0
2024-08-29 10:00:00	QQQ	ETF	476.82	477.77	474.06	475.6966	2661016.0
2024-08-29 10:30:00	QQQ	ETF	475.71	477.93	475.68	476.72	2241103.0
2024-08-29 11:00:00	QQQ	ETF	476.79	477.81	475.56	476.38	1307215.0
2024-08-29 11:30:00	QQQ	ETF	476.42	477.05	476.15	476.5201	973554.0
2024-08-29 12:00:00	QQQ	ETF	476.52	477.84	476.43	477.32	1068251.0
2024-08-29 12:30:00	QQQ	ETF	477.3	477.88	476.38	476.99	1006143.0

> showing 50 of 32,631 rows — these rows as CSV

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