PREVIEW / etf_30min / 2025-01-23

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-23.parquet
  size:    950 KB
  rows:    38,397

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-23 04:00:00	SPY	ETF	604.85	605.09	604.67	604.81	6286.0
2025-01-23 04:30:00	SPY	ETF	604.76	605.39	604.76	605.29	4837.0
2025-01-23 05:00:00	SPY	ETF	605.29	605.66	605.15	605.45	14484.0
2025-01-23 05:30:00	SPY	ETF	605.44	605.49	605.07	605.07	1249.0
2025-01-23 06:00:00	SPY	ETF	605.22	605.49	605.22	605.37	7832.0
2025-01-23 06:30:00	SPY	ETF	605.58	605.73	605.46	605.67	14522.0
2025-01-23 07:00:00	SPY	ETF	605.65	605.73	605.19	605.61	44508.0
2025-01-23 07:30:00	SPY	ETF	605.69	605.88	605.58	605.88	33551.0
2025-01-23 08:00:00	SPY	ETF	605.55	606.38	604.9104	605.6901	75335.0
2025-01-23 08:30:00	SPY	ETF	605.79	606.0999	605.48	605.909	70887.0
2025-01-23 09:00:00	SPY	ETF	605.93	606.0	605.63	605.83	121457.0
2025-01-23 09:30:00	SPY	ETF	605.8	606.3	605.52	606.2259	1949528.0
2025-01-23 10:00:00	SPY	ETF	606.24	606.25	605.62	605.73	1447114.0
2025-01-23 10:30:00	SPY	ETF	605.72	606.91	605.65	606.89	1235564.0
2025-01-23 11:00:00	SPY	ETF	606.9	607.55	606.38	607.51	2025984.0
2025-01-23 11:30:00	SPY	ETF	607.5	607.87	607.08	607.25	2339096.0
2025-01-23 12:00:00	SPY	ETF	607.25	607.42	606.94	607.17	1574746.0
2025-01-23 12:30:00	SPY	ETF	607.17	607.69	606.9	607.68	1074446.0
2025-01-23 13:00:00	SPY	ETF	607.68	608.3	607.5999	607.985	1325497.0
2025-01-23 13:30:00	SPY	ETF	608.0	608.25	607.67	607.75	741309.0
2025-01-23 14:00:00	SPY	ETF	607.73	607.82	607.31	607.66	991563.0
2025-01-23 14:30:00	SPY	ETF	607.67	608.01	607.67	607.825	701582.0
2025-01-23 15:00:00	SPY	ETF	607.79	608.27	607.6	608.095	1169673.0
2025-01-23 15:30:00	SPY	ETF	608.09	609.74	607.69	609.71	5372011.0
2025-01-23 16:00:00	SPY	ETF	609.71	609.75	609.06	609.2	4235120.0
2025-01-23 16:30:00	SPY	ETF	609.17	609.72	609.05	609.26	449957.0
2025-01-23 17:00:00	SPY	ETF	609.28	609.75	609.23	609.31	54332.0
2025-01-23 17:30:00	SPY	ETF	609.28	609.33	609.25	609.25	8978.0
2025-01-23 18:00:00	SPY	ETF	609.25	609.25	608.95	609.05	107583.0
2025-01-23 18:30:00	SPY	ETF	609.06	609.15	609.03	609.15	11998.0
2025-01-23 19:00:00	SPY	ETF	609.15	609.18	609.11	609.13	1919.0
2025-01-23 19:30:00	SPY	ETF	609.1	609.1399	608.91	609.02	23783.0
2025-01-23 04:00:00	QQQ	ETF	529.39	529.39	528.15	528.54	57981.0
2025-01-23 04:30:00	QQQ	ETF	528.59	529.17	528.46	529.07	18584.0
2025-01-23 05:00:00	QQQ	ETF	529.11	529.36	528.85	529.23	23280.0
2025-01-23 05:30:00	QQQ	ETF	529.07	529.15	528.67	528.67	14200.0
2025-01-23 06:00:00	QQQ	ETF	528.81	529.1	528.63	528.71	51791.0
2025-01-23 06:30:00	QQQ	ETF	528.78	529.34	528.74	529.17	61430.0
2025-01-23 07:00:00	QQQ	ETF	529.22	529.35	528.67	529.2	91941.0
2025-01-23 07:30:00	QQQ	ETF	529.13	529.33	528.99	529.19	26573.0
2025-01-23 08:00:00	QQQ	ETF	529.35	531.908	528.61	529.21	209919.0
2025-01-23 08:30:00	QQQ	ETF	529.29	529.63	528.75	529.19	122326.0
2025-01-23 09:00:00	QQQ	ETF	529.21	529.34	528.76	529.05	167398.0
2025-01-23 09:30:00	QQQ	ETF	529.03	529.7	528.45	529.22	1837819.0
2025-01-23 10:00:00	QQQ	ETF	529.23	529.49	528.53	529.3041	786809.0
2025-01-23 10:30:00	QQQ	ETF	529.31	530.28	529.08	530.0323	840933.0
2025-01-23 11:00:00	QQQ	ETF	530.06	530.45	529.22	530.44	1086342.0
2025-01-23 11:30:00	QQQ	ETF	530.4	531.0	530.07	530.38	786925.0
2025-01-23 12:00:00	QQQ	ETF	530.38	530.38	529.76	529.925	432219.0
2025-01-23 12:30:00	QQQ	ETF	529.89	530.2297	529.3	530.17	640110.0

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

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