PREVIEW / etf_30min / 2025-01-29

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-29.parquet
  size:    929 KB
  rows:    37,566

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-29 04:00:00	SPY	ETF	605.96	605.96	604.57	604.89	14045.0
2025-01-29 04:30:00	SPY	ETF	604.85	605.28	604.68	605.06	6125.0
2025-01-29 05:00:00	SPY	ETF	605.13	605.17	604.8	604.82	2992.0
2025-01-29 05:30:00	SPY	ETF	604.86	605.39	604.86	605.19	8461.0
2025-01-29 06:00:00	SPY	ETF	605.14	605.2	605.0	605.04	9167.0
2025-01-29 06:30:00	SPY	ETF	605.09	605.58	605.0	605.4	10837.0
2025-01-29 07:00:00	SPY	ETF	605.39	605.39	604.75	604.8	11243.0
2025-01-29 07:30:00	SPY	ETF	604.77	604.77	604.45	604.64	13960.0
2025-01-29 08:00:00	SPY	ETF	605.2	605.81	603.16	603.2	114696.0
2025-01-29 08:30:00	SPY	ETF	603.33	603.54	602.89	603.54	178541.0
2025-01-29 09:00:00	SPY	ETF	603.51	603.99	603.3	603.69	181390.0
2025-01-29 09:30:00	SPY	ETF	603.71	603.99	602.4452	603.27	1883423.0
2025-01-29 10:00:00	SPY	ETF	603.31	604.13	602.75	602.98	1286366.0
2025-01-29 10:30:00	SPY	ETF	603.01	603.5	602.48	602.78	815133.0
2025-01-29 11:00:00	SPY	ETF	602.82	603.176	602.21	602.46	960338.0
2025-01-29 11:30:00	SPY	ETF	602.44	602.97	601.93	602.29	735481.0
2025-01-29 12:00:00	SPY	ETF	602.2947	603.46	602.21	603.055	642787.0
2025-01-29 12:30:00	SPY	ETF	603.06	603.32	601.95	602.08	690879.0
2025-01-29 13:00:00	SPY	ETF	602.1	602.36	599.66	602.31	1762176.0
2025-01-29 13:30:00	SPY	ETF	602.33	602.63	601.35	601.49	839420.0
2025-01-29 14:00:00	SPY	ETF	601.49	601.49	599.22	599.4	2731530.0
2025-01-29 14:30:00	SPY	ETF	599.39	603.28	599.25	602.32	3225806.0
2025-01-29 15:00:00	SPY	ETF	602.29	603.6801	600.55	603.35	2073425.0
2025-01-29 15:30:00	SPY	ETF	603.36	603.66	600.74	601.8	3489621.0
2025-01-29 16:00:00	SPY	ETF	601.81	602.9	599.24	602.53	3348898.0
2025-01-29 16:30:00	SPY	ETF	602.53	604.7041	601.12	602.62	293033.0
2025-01-29 17:00:00	SPY	ETF	602.35	603.18	602.35	603.07	131072.0
2025-01-29 17:30:00	SPY	ETF	603.2	603.36	602.0	602.09	81071.0
2025-01-29 18:00:00	SPY	ETF	602.08	602.5	601.14	601.22	103084.0
2025-01-29 18:30:00	SPY	ETF	601.44	602.16	601.191	601.95	32386.0
2025-01-29 19:00:00	SPY	ETF	601.71	602.79	601.71	602.79	18871.0
2025-01-29 19:30:00	SPY	ETF	602.81	603.06	602.74	603.06	26745.0
2025-01-29 04:00:00	QQQ	ETF	523.22	524.27	523.0	523.77	67809.0
2025-01-29 04:30:00	QQQ	ETF	523.61	524.35	523.42	524.07	26368.0
2025-01-29 05:00:00	QQQ	ETF	524.11	524.11	523.65	523.65	14502.0
2025-01-29 05:30:00	QQQ	ETF	523.54	524.24	523.54	524.22	15100.0
2025-01-29 06:00:00	QQQ	ETF	523.91	524.01	523.64	523.93	15941.0
2025-01-29 06:30:00	QQQ	ETF	523.92	524.62	523.71	524.5	38963.0
2025-01-29 07:00:00	QQQ	ETF	524.41	524.46	523.9	524.21	75562.0
2025-01-29 07:30:00	QQQ	ETF	524.15	524.17	523.5	523.63	33451.0
2025-01-29 08:00:00	QQQ	ETF	524.02	524.7	521.75	522.16	221561.0
2025-01-29 08:30:00	QQQ	ETF	522.13	522.54	521.5896	522.518	111153.0
2025-01-29 09:00:00	QQQ	ETF	522.55	523.1	522.39	522.44	184399.0
2025-01-29 09:30:00	QQQ	ETF	522.46	522.59	519.94	520.5403	2312862.0
2025-01-29 10:00:00	QQQ	ETF	520.55	521.63	519.63	520.175	1093317.0
2025-01-29 10:30:00	QQQ	ETF	520.14	520.77	519.02	520.191	756593.0
2025-01-29 11:00:00	QQQ	ETF	520.23	520.65	519.535	519.8499	626983.0
2025-01-29 11:30:00	QQQ	ETF	519.75	520.4087	519.29	519.67	641382.0
2025-01-29 12:00:00	QQQ	ETF	519.71	521.18	519.655	520.77	446520.0
2025-01-29 12:30:00	QQQ	ETF	520.8	521.0	519.58	519.75	561827.0

> showing 50 of 37,566 rows — these rows as CSV

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