PREVIEW / etf_30min / 2024-11-22

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-22.parquet
  size:    925 KB
  rows:    36,121

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-11-22 04:00:00	SPY	ETF	593.74	593.74	591.67	591.91	11456.0
2024-11-22 04:30:00	SPY	ETF	591.5	592.69	591.1	592.52	21800.0
2024-11-22 05:00:00	SPY	ETF	592.43	592.48	591.06	591.85	9548.0
2024-11-22 05:30:00	SPY	ETF	591.78	592.48	591.73	592.15	63371.0
2024-11-22 06:00:00	SPY	ETF	591.95	592.5	591.68	592.24	6492.0
2024-11-22 06:30:00	SPY	ETF	592.18	592.77	591.72	592.73	7920.0
2024-11-22 07:00:00	SPY	ETF	592.86	593.29	592.81	593.29	23008.0
2024-11-22 07:30:00	SPY	ETF	593.34	593.62	593.0	593.55	110254.0
2024-11-22 08:00:00	SPY	ETF	593.05	594.15	592.72	593.619	135592.0
2024-11-22 08:30:00	SPY	ETF	593.68	593.68	593.19	593.38	108758.0
2024-11-22 09:00:00	SPY	ETF	593.38	593.72	593.17	593.64	148651.0
2024-11-22 09:30:00	SPY	ETF	593.66	596.131	593.57	595.97	4091756.0
2024-11-22 10:00:00	SPY	ETF	595.94	596.01	593.1526	593.67	2020643.0
2024-11-22 10:30:00	SPY	ETF	593.78	595.82	593.5901	595.76	1173482.0
2024-11-22 11:00:00	SPY	ETF	595.79	595.8965	593.71	594.59	1244658.0
2024-11-22 11:30:00	SPY	ETF	594.57	595.1699	593.92	595.04	815745.0
2024-11-22 12:00:00	SPY	ETF	595.05	595.88	594.71	595.61	1039974.0
2024-11-22 12:30:00	SPY	ETF	595.61	595.85	594.66	595.7299	746823.0
2024-11-22 13:00:00	SPY	ETF	595.69	596.15	595.41	595.52	925697.0
2024-11-22 13:30:00	SPY	ETF	595.52	595.97	594.9001	595.43	790482.0
2024-11-22 14:00:00	SPY	ETF	595.44	595.44	594.15	594.99	1102522.0
2024-11-22 14:30:00	SPY	ETF	594.99	595.63	594.89	595.3999	890217.0
2024-11-22 15:00:00	SPY	ETF	595.39	595.39	594.17	594.77	1767984.0
2024-11-22 15:30:00	SPY	ETF	594.7583	596.1	594.67	595.48	4067469.0
2024-11-22 16:00:00	SPY	ETF	595.48	595.93	593.67	595.65	2878494.0
2024-11-22 16:30:00	SPY	ETF	595.58	595.92	595.51	595.86	158181.0
2024-11-22 17:00:00	SPY	ETF	595.89	596.04	595.86	596.01	63658.0
2024-11-22 17:30:00	SPY	ETF	596.02	596.32	596.0	596.25	28276.0
2024-11-22 18:00:00	SPY	ETF	596.25	596.48	596.25	596.48	41799.0
2024-11-22 18:30:00	SPY	ETF	596.5	596.75	596.0	596.45	81853.0
2024-11-22 19:00:00	SPY	ETF	596.39	596.49	596.35	596.35	10868.0
2024-11-22 19:30:00	SPY	ETF	596.36	596.49	596.35	596.45	16751.0
2024-11-22 04:00:00	QQQ	ETF	504.46	504.84	502.4	502.91	19414.0
2024-11-22 04:30:00	QQQ	ETF	502.6	503.82	502.1	503.6	46536.0
2024-11-22 05:00:00	QQQ	ETF	503.48	503.48	502.11	502.76	49180.0
2024-11-22 05:30:00	QQQ	ETF	503.03	503.52	503.03	503.4	17732.0
2024-11-22 06:00:00	QQQ	ETF	503.09	503.73	502.77	503.37	14494.0
2024-11-22 06:30:00	QQQ	ETF	503.4	504.0	502.9	504.0	22764.0
2024-11-22 07:00:00	QQQ	ETF	503.9	504.4	503.89	504.39	40485.0
2024-11-22 07:30:00	QQQ	ETF	504.35	504.67	504.06	504.58	29233.0
2024-11-22 08:00:00	QQQ	ETF	504.12	505.18	502.1796	504.69	139723.0
2024-11-22 08:30:00	QQQ	ETF	504.68	504.75	504.09	504.22	97951.0
2024-11-22 09:00:00	QQQ	ETF	504.24	504.88	503.93	504.41	109503.0
2024-11-22 09:30:00	QQQ	ETF	504.4	506.36	504.05	505.95	2053399.0
2024-11-22 10:00:00	QQQ	ETF	505.96	505.96	502.78	503.24	1617771.0
2024-11-22 10:30:00	QQQ	ETF	503.26	505.88	503.11	505.66	1146989.0
2024-11-22 11:00:00	QQQ	ETF	505.67	505.77	503.28	504.11	1123698.0
2024-11-22 11:30:00	QQQ	ETF	504.16	505.25	503.42	504.94	1087364.0
2024-11-22 12:00:00	QQQ	ETF	504.96	505.75	504.55	505.5101	696741.0
2024-11-22 12:30:00	QQQ	ETF	505.52	506.15	504.61	505.94	1116506.0

> showing 50 of 36,121 rows — these rows as CSV

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