PREVIEW / etf_30min / 2024-11-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-25.parquet
  size:    947 KB
  rows:    38,198

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-25 04:00:00	SPY	ETF	598.01	598.44	598.01	598.41	25046.0
2024-11-25 04:30:00	SPY	ETF	598.45	598.64	598.31	598.57	4141.0
2024-11-25 05:00:00	SPY	ETF	598.52	598.55	598.48	598.48	5904.0
2024-11-25 05:30:00	SPY	ETF	598.43	598.79	598.43	598.77	6517.0
2024-11-25 06:00:00	SPY	ETF	598.79	598.79	598.45	598.69	98956.0
2024-11-25 06:30:00	SPY	ETF	598.71	598.71	598.6	598.62	15507.0
2024-11-25 07:00:00	SPY	ETF	598.61	598.69	598.03	598.18	226595.0
2024-11-25 07:30:00	SPY	ETF	598.14	598.68	598.1	598.56	102780.0
2024-11-25 08:00:00	SPY	ETF	598.625	598.75	597.88	598.63	102720.0
2024-11-25 08:30:00	SPY	ETF	598.57	600.045	598.48	599.65	430545.0
2024-11-25 09:00:00	SPY	ETF	599.63	600.18	599.45	599.52	296805.0
2024-11-25 09:30:00	SPY	ETF	599.52	600.86	598.67	599.26	5646506.0
2024-11-25 10:00:00	SPY	ETF	599.25	599.295	597.55	599.11	2834340.0
2024-11-25 10:30:00	SPY	ETF	599.09	599.26	597.81	597.98	1693311.0
2024-11-25 11:00:00	SPY	ETF	597.96	598.43	597.6	597.99	1321891.0
2024-11-25 11:30:00	SPY	ETF	597.97	598.38	597.14	597.27	1258025.0
2024-11-25 12:00:00	SPY	ETF	597.255	597.6	595.75	596.04	1774619.0
2024-11-25 12:30:00	SPY	ETF	596.04	596.63	595.2	596.4565	1324605.0
2024-11-25 13:00:00	SPY	ETF	596.4601	597.44	596.421	597.1504	1233940.0
2024-11-25 13:30:00	SPY	ETF	597.18	597.61	596.94	597.32	867184.0
2024-11-25 14:00:00	SPY	ETF	597.31	597.435	596.49	596.99	992710.0
2024-11-25 14:30:00	SPY	ETF	596.98	597.45	596.66	597.09	767352.0
2024-11-25 15:00:00	SPY	ETF	597.085	597.1692	596.67	597.14	1116640.0
2024-11-25 15:30:00	SPY	ETF	597.13	597.745	596.85	597.45	4728793.0
2024-11-25 16:00:00	SPY	ETF	597.45	598.39	597.08	598.3	3292239.0
2024-11-25 16:30:00	SPY	ETF	598.3	598.37	597.53	598.1	233451.0
2024-11-25 17:00:00	SPY	ETF	598.09	598.11	597.95	598.079	37797.0
2024-11-25 17:30:00	SPY	ETF	598.0	598.11	598.0	598.04	9653.0
2024-11-25 18:00:00	SPY	ETF	598.1	598.65	598.0	598.6499	74946.0
2024-11-25 18:30:00	SPY	ETF	598.631	598.65	595.63	596.31	241865.0
2024-11-25 19:00:00	SPY	ETF	596.2	596.24	595.3	595.98	53508.0
2024-11-25 19:30:00	SPY	ETF	595.93	596.0	595.24	595.27	140791.0
2024-11-25 04:00:00	QQQ	ETF	508.57	508.69	508.26	508.54	59602.0
2024-11-25 04:30:00	QQQ	ETF	508.49	508.85	508.44	508.75	38846.0
2024-11-25 05:00:00	QQQ	ETF	508.79	508.85	508.66	508.85	34547.0
2024-11-25 05:30:00	QQQ	ETF	508.8	509.09	508.78	509.09	34321.0
2024-11-25 06:00:00	QQQ	ETF	509.04	509.09	508.7	508.84	7745.0
2024-11-25 06:30:00	QQQ	ETF	508.88	508.93	508.72	508.72	15403.0
2024-11-25 07:00:00	QQQ	ETF	508.69	508.84	508.221	508.43	97293.0
2024-11-25 07:30:00	QQQ	ETF	508.4	508.73	508.25	508.44	49639.0
2024-11-25 08:00:00	QQQ	ETF	508.65	509.11	505.411	508.37	144555.0
2024-11-25 08:30:00	QQQ	ETF	508.42	510.16	508.18	509.53	274721.0
2024-11-25 09:00:00	QQQ	ETF	509.54	510.62	509.29	509.9	226690.0
2024-11-25 09:30:00	QQQ	ETF	509.9	511.4525	507.58	508.22	3824369.0
2024-11-25 10:00:00	QQQ	ETF	508.2201	508.52	506.44	507.95	2171048.0
2024-11-25 10:30:00	QQQ	ETF	507.895	508.205	506.55	507.0713	1413186.0
2024-11-25 11:00:00	QQQ	ETF	507.05	508.36	506.89	508.0	764418.0
2024-11-25 11:30:00	QQQ	ETF	508.01	508.61	506.93	507.3	985016.0
2024-11-25 12:00:00	QQQ	ETF	507.3	507.39	504.95	505.21	1337597.0
2024-11-25 12:30:00	QQQ	ETF	505.18	506.15	504.2625	505.95	1363516.0

> showing 50 of 38,198 rows — these rows as CSV

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