PREVIEW / etf_30min / 2025-01-03

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-03.parquet
  size:    929 KB
  rows:    36,752

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-03 04:00:00	SPY	ETF	586.0	587.25	585.89	587.05	28828.0
2025-01-03 04:30:00	SPY	ETF	586.9	587.18	586.86	587.12	6191.0
2025-01-03 05:00:00	SPY	ETF	586.9	586.9	586.31	586.46	15824.0
2025-01-03 05:30:00	SPY	ETF	586.55	586.55	585.96	586.1	6954.0
2025-01-03 06:00:00	SPY	ETF	586.02	586.19	585.7	586.12	2962.0
2025-01-03 06:30:00	SPY	ETF	585.9	586.11	585.88	585.99	3871.0
2025-01-03 07:00:00	SPY	ETF	586.01	586.05	585.4	586.04	197208.0
2025-01-03 07:30:00	SPY	ETF	586.001	586.35	585.88	586.28	61483.0
2025-01-03 08:00:00	SPY	ETF	586.0	586.805	585.48	586.69	103373.0
2025-01-03 08:30:00	SPY	ETF	586.72	586.92	586.1194	586.1194	86665.0
2025-01-03 09:00:00	SPY	ETF	586.2	587.6	586.2	587.47	215267.0
2025-01-03 09:30:00	SPY	ETF	587.53	589.545	586.79	588.01	4150316.0
2025-01-03 10:00:00	SPY	ETF	588.02	589.46	586.43	588.22	2500219.0
2025-01-03 10:30:00	SPY	ETF	588.24	589.4594	587.55	589.15	1344369.0
2025-01-03 11:00:00	SPY	ETF	589.18	589.85	588.12	589.63	1272742.0
2025-01-03 11:30:00	SPY	ETF	589.6	590.99	589.555	590.3861	1362518.0
2025-01-03 12:00:00	SPY	ETF	590.39	591.01	590.04	590.145	1138997.0
2025-01-03 12:30:00	SPY	ETF	590.15	590.76	589.9	590.69	1060181.0
2025-01-03 13:00:00	SPY	ETF	590.69	591.5	590.2	591.495	1648837.0
2025-01-03 13:30:00	SPY	ETF	591.5	591.8401	591.05	591.29	1284154.0
2025-01-03 14:00:00	SPY	ETF	591.31	592.2	591.11	592.1	1297819.0
2025-01-03 14:30:00	SPY	ETF	592.08	592.6	591.88	592.07	1483634.0
2025-01-03 15:00:00	SPY	ETF	592.04	592.04	591.43	591.93	1537132.0
2025-01-03 15:30:00	SPY	ETF	591.93	592.21	591.05	591.87	5305989.0
2025-01-03 16:00:00	SPY	ETF	591.84	591.95	591.4	591.51	2646598.0
2025-01-03 16:30:00	SPY	ETF	591.5	591.64	591.4	591.49	65365.0
2025-01-03 17:00:00	SPY	ETF	591.54	591.7	591.5	591.58	17787.0
2025-01-03 17:30:00	SPY	ETF	591.62	591.66	591.58	591.62	2494.0
2025-01-03 18:00:00	SPY	ETF	591.72	591.8	591.63	591.72	12950.0
2025-01-03 18:30:00	SPY	ETF	591.72	591.91	591.72	591.84	9212.0
2025-01-03 19:00:00	SPY	ETF	591.9	591.95	591.86	591.93	13706.0
2025-01-03 19:30:00	SPY	ETF	591.96	592.07	591.87	592.0401	10130.0
2025-01-03 04:00:00	QQQ	ETF	511.92	513.21	511.89	513.0	25764.0
2025-01-03 04:30:00	QQQ	ETF	512.91	513.07	512.7	512.9	13488.0
2025-01-03 05:00:00	QQQ	ETF	512.78	512.78	512.19	512.42	8074.0
2025-01-03 05:30:00	QQQ	ETF	512.43	512.47	511.9	512.03	17426.0
2025-01-03 06:00:00	QQQ	ETF	511.98	512.24	511.63	512.24	8871.0
2025-01-03 06:30:00	QQQ	ETF	512.18	512.33	511.97	512.33	11488.0
2025-01-03 07:00:00	QQQ	ETF	512.2	512.2	511.39	512.0	49220.0
2025-01-03 07:30:00	QQQ	ETF	511.89	512.15	511.65	512.15	31526.0
2025-01-03 08:00:00	QQQ	ETF	511.98	512.85	511.36	512.5294	125519.0
2025-01-03 08:30:00	QQQ	ETF	512.54	512.87	511.7699	511.83	97225.0
2025-01-03 09:00:00	QQQ	ETF	511.81	513.55	511.761	513.25	195296.0
2025-01-03 09:30:00	QQQ	ETF	513.35	516.5899	512.96	515.48	3198216.0
2025-01-03 10:00:00	QQQ	ETF	515.4	516.73	512.53	514.28	2330114.0
2025-01-03 10:30:00	QQQ	ETF	514.29	515.8	513.41	515.27	1131424.0
2025-01-03 11:00:00	QQQ	ETF	515.28	516.45	514.35	516.44	921485.0
2025-01-03 11:30:00	QQQ	ETF	516.44	517.97	516.34	517.31	1359772.0
2025-01-03 12:00:00	QQQ	ETF	517.34	517.87	516.82	516.9816	736984.0
2025-01-03 12:30:00	QQQ	ETF	517.02	517.5801	516.81	517.47	501914.0

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

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