PREVIEW / etf_30min / 2025-01-06

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-06.parquet
  size:    975 KB
  rows:    39,942

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-01-06 04:00:00	SPY	ETF	593.73	594.34	593.73	594.14	21506.0
2025-01-06 04:30:00	SPY	ETF	594.22	594.79	594.16	594.78	7734.0
2025-01-06 05:00:00	SPY	ETF	594.77	595.21	594.53	594.94	8732.0
2025-01-06 05:30:00	SPY	ETF	594.85	594.85	594.44	594.52	5617.0
2025-01-06 06:00:00	SPY	ETF	594.37	595.9	593.87	595.9	38632.0
2025-01-06 06:30:00	SPY	ETF	595.9	596.27	595.7	596.19	46513.0
2025-01-06 07:00:00	SPY	ETF	596.24	596.35	595.86	596.27	94878.0
2025-01-06 07:30:00	SPY	ETF	596.23	596.95	596.05	596.5	73944.0
2025-01-06 08:00:00	SPY	ETF	596.23	596.88	591.89	596.58	115831.0
2025-01-06 08:30:00	SPY	ETF	596.58	597.0	596.15	597.0	97043.0
2025-01-06 09:00:00	SPY	ETF	597.03	597.08	594.57	596.25	1137418.0
2025-01-06 09:30:00	SPY	ETF	596.27	598.27	595.9	597.88	4270184.0
2025-01-06 10:00:00	SPY	ETF	597.9	599.0	597.68	598.89	2136696.0
2025-01-06 10:30:00	SPY	ETF	598.91	599.22	598.07	598.87	1731505.0
2025-01-06 11:00:00	SPY	ETF	598.88	599.51	598.48	599.509	1273341.0
2025-01-06 11:30:00	SPY	ETF	599.492	599.7	599.17	599.46	1138752.0
2025-01-06 12:00:00	SPY	ETF	599.46	599.465	598.37	598.57	923415.0
2025-01-06 12:30:00	SPY	ETF	598.53	598.74	597.4	597.75	1562012.0
2025-01-06 13:00:00	SPY	ETF	597.75	597.79	596.58	597.39	1475689.0
2025-01-06 13:30:00	SPY	ETF	597.37	597.4298	595.59	595.67	1449057.0
2025-01-06 14:00:00	SPY	ETF	595.63	595.85	594.88	595.35	1998110.0
2025-01-06 14:30:00	SPY	ETF	595.37	595.58	594.2603	594.35	1564385.0
2025-01-06 15:00:00	SPY	ETF	594.32	595.26	594.04	595.055	2370419.0
2025-01-06 15:30:00	SPY	ETF	595.055	595.5	593.6	595.4	5238556.0
2025-01-06 16:00:00	SPY	ETF	595.38	595.95	595.2364	595.7	2191386.0
2025-01-06 16:30:00	SPY	ETF	595.7	595.96	595.66	595.9	106807.0
2025-01-06 17:00:00	SPY	ETF	595.84	595.9	595.78	595.7808	31185.0
2025-01-06 17:30:00	SPY	ETF	595.82	596.0	595.82	596.0	40429.0
2025-01-06 18:00:00	SPY	ETF	595.93	596.21	595.81	595.85	60481.0
2025-01-06 18:30:00	SPY	ETF	595.81	595.99	595.7	595.71	12355.0
2025-01-06 19:00:00	SPY	ETF	595.79	595.82	595.55	595.6	28963.0
2025-01-06 19:30:00	SPY	ETF	595.75	595.86	595.35	595.55	42483.0
2025-01-06 04:00:00	QQQ	ETF	520.27	522.1	520.27	521.89	95797.0
2025-01-06 04:30:00	QQQ	ETF	521.9	522.51	521.66	522.48	32713.0
2025-01-06 05:00:00	QQQ	ETF	522.49	523.02	522.13	522.74	25557.0
2025-01-06 05:30:00	QQQ	ETF	522.48	522.82	522.3	522.51	19388.0
2025-01-06 06:00:00	QQQ	ETF	522.48	523.81	521.84	523.7	139138.0
2025-01-06 06:30:00	QQQ	ETF	523.78	524.24	523.44	523.94	41586.0
2025-01-06 07:00:00	QQQ	ETF	523.89	524.06	523.48	523.9	114304.0
2025-01-06 07:30:00	QQQ	ETF	523.86	524.56	523.61	524.0	75976.0
2025-01-06 08:00:00	QQQ	ETF	523.93	524.62	518.192	524.17	211889.0
2025-01-06 08:30:00	QQQ	ETF	524.29	524.44	523.43	524.41	143049.0
2025-01-06 09:00:00	QQQ	ETF	524.41	524.52	521.83	524.0	581343.0
2025-01-06 09:30:00	QQQ	ETF	524.02	526.76	523.76	526.045	3507539.0
2025-01-06 10:00:00	QQQ	ETF	526.08	527.68	525.16	527.46	1989809.0
2025-01-06 10:30:00	QQQ	ETF	527.445	527.8	526.67	527.2912	1580077.0
2025-01-06 11:00:00	QQQ	ETF	527.31	527.92	526.9403	527.72	1047383.0
2025-01-06 11:30:00	QQQ	ETF	527.71	527.76	526.66	526.96	980449.0
2025-01-06 12:00:00	QQQ	ETF	526.9	527.26	525.97	526.25	679320.0
2025-01-06 12:30:00	QQQ	ETF	526.25	526.4999	524.895	525.52	1156976.0

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

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