PREVIEW / etf_30min / 2025-02-03

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-03.parquet
  size:    1012 KB
  rows:    42,496

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-02-03 04:00:00	SPY	ETF	593.91	594.6	590.36	592.9	212283.0
2025-02-03 04:30:00	SPY	ETF	593.0	593.38	592.11	592.11	16111.0
2025-02-03 05:00:00	SPY	ETF	592.3	592.88	591.8	592.71	42663.0
2025-02-03 05:30:00	SPY	ETF	592.97	593.77	592.97	593.36	105638.0
2025-02-03 06:00:00	SPY	ETF	593.61	594.3	593.55	593.59	85985.0
2025-02-03 06:30:00	SPY	ETF	593.66	593.76	592.78	593.21	167443.0
2025-02-03 07:00:00	SPY	ETF	593.15	593.45	592.355	592.85	184748.0
2025-02-03 07:30:00	SPY	ETF	592.74	592.88	591.55	591.83	137804.0
2025-02-03 08:00:00	SPY	ETF	592.9	594.15	589.5	592.87	518932.0
2025-02-03 08:30:00	SPY	ETF	592.98	593.32	592.1	592.54	328456.0
2025-02-03 09:00:00	SPY	ETF	592.4	592.92	591.67	592.6	335075.0
2025-02-03 09:30:00	SPY	ETF	592.67	594.37	591.6	592.036	6486791.0
2025-02-03 10:00:00	SPY	ETF	591.97	596.6	590.49	596.38	6815701.0
2025-02-03 10:30:00	SPY	ETF	596.36	598.65	592.44	597.88	4372283.0
2025-02-03 11:00:00	SPY	ETF	597.86	599.25	595.76	597.87	2967076.0
2025-02-03 11:30:00	SPY	ETF	597.87	599.01	596.91	597.3399	2546758.0
2025-02-03 12:00:00	SPY	ETF	597.32	598.7	596.69	597.4	1718785.0
2025-02-03 12:30:00	SPY	ETF	597.39	598.08	595.97	597.38	2754521.0
2025-02-03 13:00:00	SPY	ETF	597.3435	598.26	596.08	597.795	1835682.0
2025-02-03 13:30:00	SPY	ETF	597.87	599.0	597.4201	598.835	1297108.0
2025-02-03 14:00:00	SPY	ETF	598.81	600.0	598.5	599.48	1655692.0
2025-02-03 14:30:00	SPY	ETF	599.485	600.29	599.245	599.68	1258521.0
2025-02-03 15:00:00	SPY	ETF	599.7	600.0258	598.4	598.55	1761844.0
2025-02-03 15:30:00	SPY	ETF	598.56	599.05	597.39	597.65	6073047.0
2025-02-03 16:00:00	SPY	ETF	597.65	599.89	597.41	599.61	3484174.0
2025-02-03 16:30:00	SPY	ETF	599.57	601.44	599.15	600.84	1533686.0
2025-02-03 17:00:00	SPY	ETF	600.82	601.0	600.66	600.8601	71954.0
2025-02-03 17:30:00	SPY	ETF	600.8995	601.75	600.86	601.75	109907.0
2025-02-03 18:00:00	SPY	ETF	601.9	602.05	601.0222	601.0222	96082.0
2025-02-03 18:30:00	SPY	ETF	601.069	601.18	600.74	601.08	21926.0
2025-02-03 19:00:00	SPY	ETF	600.97	600.97	600.23	600.4597	64231.0
2025-02-03 19:30:00	SPY	ETF	600.5	600.74	600.358	600.44	41094.0
2025-02-03 04:00:00	QQQ	ETF	513.3	513.8	512.42	513.17	122581.0
2025-02-03 04:30:00	QQQ	ETF	513.26	513.84	512.54	512.71	60783.0
2025-02-03 05:00:00	QQQ	ETF	512.65	513.47	512.22	513.21	93126.0
2025-02-03 05:30:00	QQQ	ETF	513.48	514.27	513.45	513.91	47315.0
2025-02-03 06:00:00	QQQ	ETF	514.13	514.94	513.9	514.05	58119.0
2025-02-03 06:30:00	QQQ	ETF	514.12	514.29	513.16	513.73	50256.0
2025-02-03 07:00:00	QQQ	ETF	513.73	513.86	512.67	513.48	205457.0
2025-02-03 07:30:00	QQQ	ETF	513.45	513.51	512.09	512.62	290889.0
2025-02-03 08:00:00	QQQ	ETF	512.61	521.899	507.5	513.67	729454.0
2025-02-03 08:30:00	QQQ	ETF	513.69	513.93	512.551	513.15	188885.0
2025-02-03 09:00:00	QQQ	ETF	513.2	513.84	512.67	513.49	466746.0
2025-02-03 09:30:00	QQQ	ETF	513.47	515.84	512.5	513.52	4122654.0
2025-02-03 10:00:00	QQQ	ETF	513.5	517.03	511.05	516.85	3961431.0
2025-02-03 10:30:00	QQQ	ETF	516.8	519.25	516.08	518.47	3282883.0
2025-02-03 11:00:00	QQQ	ETF	518.4401	519.63	516.54	518.11	1996464.0
2025-02-03 11:30:00	QQQ	ETF	518.12	519.43	517.22	517.6	1334355.0
2025-02-03 12:00:00	QQQ	ETF	517.64	519.29	517.118	517.795	1134135.0
2025-02-03 12:30:00	QQQ	ETF	517.78	518.64	516.51	518.0	1849450.0

> showing 50 of 42,496 rows — these rows as CSV

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