PREVIEW / etf_1hour / 2025-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-06.parquet
  size:    637 KB
  rows:    24,552

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.79	593.73	594.78	29240.0
2025-01-06 05:00:00	SPY	ETF	594.77	595.21	594.44	594.52	14349.0
2025-01-06 06:00:00	SPY	ETF	594.37	596.27	593.87	596.19	85145.0
2025-01-06 07:00:00	SPY	ETF	596.24	596.95	595.86	596.5	168822.0
2025-01-06 08:00:00	SPY	ETF	596.23	597.0	591.89	597.0	212874.0
2025-01-06 09:00:00	SPY	ETF	597.03	598.27	594.57	597.88	5407602.0
2025-01-06 10:00:00	SPY	ETF	597.9	599.22	597.68	598.87	3868201.0
2025-01-06 11:00:00	SPY	ETF	598.88	599.7	598.48	599.46	2412093.0
2025-01-06 12:00:00	SPY	ETF	599.46	599.465	597.4	597.75	2485427.0
2025-01-06 13:00:00	SPY	ETF	597.75	597.79	595.59	595.67	2924746.0
2025-01-06 14:00:00	SPY	ETF	595.63	595.85	594.2603	594.35	3562495.0
2025-01-06 15:00:00	SPY	ETF	594.32	595.5	593.6	595.4	7608975.0
2025-01-06 16:00:00	SPY	ETF	595.38	595.96	595.2364	595.9	2298193.0
2025-01-06 17:00:00	SPY	ETF	595.84	596.0	595.78	596.0	71614.0
2025-01-06 18:00:00	SPY	ETF	595.93	596.21	595.7	595.71	72836.0
2025-01-06 19:00:00	SPY	ETF	595.79	595.86	595.35	595.55	71446.0
2025-01-06 04:00:00	QQQ	ETF	520.27	522.51	520.27	522.48	128510.0
2025-01-06 05:00:00	QQQ	ETF	522.49	523.02	522.13	522.51	44945.0
2025-01-06 06:00:00	QQQ	ETF	522.48	524.24	521.84	523.94	180724.0
2025-01-06 07:00:00	QQQ	ETF	523.89	524.56	523.48	524.0	190280.0
2025-01-06 08:00:00	QQQ	ETF	523.93	524.62	518.192	524.41	354938.0
2025-01-06 09:00:00	QQQ	ETF	524.41	526.76	521.83	526.045	4088882.0
2025-01-06 10:00:00	QQQ	ETF	526.08	527.8	525.16	527.2912	3569886.0
2025-01-06 11:00:00	QQQ	ETF	527.31	527.92	526.66	526.96	2027832.0
2025-01-06 12:00:00	QQQ	ETF	526.9	527.26	524.895	525.52	1836296.0
2025-01-06 13:00:00	QQQ	ETF	525.4813	525.51	523.29	523.38	3095553.0
2025-01-06 14:00:00	QQQ	ETF	523.45	523.82	522.256	522.34	2900960.0
2025-01-06 15:00:00	QQQ	ETF	522.27	524.66	522.03	524.52	5345425.0
2025-01-06 16:00:00	QQQ	ETF	524.49	525.31	524.49	525.14	1263565.0
2025-01-06 17:00:00	QQQ	ETF	525.15	525.4	524.96	525.31	32199.0
2025-01-06 18:00:00	QQQ	ETF	525.23	525.5958	524.99	525.02	62542.0
2025-01-06 19:00:00	QQQ	ETF	525.02	525.26	524.6	524.83	32916.0
2025-01-06 04:00:00	IWM	ETF	224.98	225.1	224.65	224.95	36483.0
2025-01-06 05:00:00	IWM	ETF	224.84	224.97	224.77	224.78	9721.0
2025-01-06 06:00:00	IWM	ETF	224.76	226.72	224.52	226.7	88019.0
2025-01-06 07:00:00	IWM	ETF	226.82	227.49	226.57	227.05	160654.0
2025-01-06 08:00:00	IWM	ETF	226.7801	227.4484	224.08	227.14	171876.0
2025-01-06 09:00:00	IWM	ETF	227.14	227.25	225.02	226.59	3056263.0
2025-01-06 10:00:00	IWM	ETF	226.6	226.69	225.73	226.0399	2155593.0
2025-01-06 11:00:00	IWM	ETF	226.05	227.17	225.825	227.1	1953267.0
2025-01-06 12:00:00	IWM	ETF	227.12	227.12	226.13	226.51	1418771.0
2025-01-06 13:00:00	IWM	ETF	226.5	226.53	225.7	225.71	1508737.0
2025-01-06 14:00:00	IWM	ETF	225.72	225.89	224.84	224.84	1876769.0
2025-01-06 15:00:00	IWM	ETF	224.83	224.93	224.14	224.53	3872417.0
2025-01-06 16:00:00	IWM	ETF	224.52	224.84	224.52	224.83	738899.0
2025-01-06 17:00:00	IWM	ETF	224.78	224.8405	224.57	224.7001	9433.0
2025-01-06 18:00:00	IWM	ETF	224.84	224.88	224.5713	224.5713	11347.0
2025-01-06 19:00:00	IWM	ETF	224.57	224.66	224.44	224.52	10133.0
2025-01-06 04:00:00	DIA	ETF	427.92	428.05	427.63	428.05	8135.0
2025-01-06 05:00:00	DIA	ETF	427.88	427.95	427.23	427.23	5067.0

> showing 50 of 24,552 rows — these rows as CSV

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