PREVIEW / etf_1hour / 2025-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-01-07.parquet
  size:    619 KB
  rows:    23,692

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-07 04:00:00	SPY	ETF	595.67	595.96	595.11	595.35	24357.0
2025-01-07 05:00:00	SPY	ETF	595.23	596.05	595.08	596.03	15721.0
2025-01-07 06:00:00	SPY	ETF	596.01	596.15	595.4	595.69	90722.0
2025-01-07 07:00:00	SPY	ETF	595.8	596.4	595.36	595.81	119762.0
2025-01-07 08:00:00	SPY	ETF	595.36	597.0	594.23	596.95	154462.0
2025-01-07 09:00:00	SPY	ETF	596.92	597.75	596.1	596.34	2384242.0
2025-01-07 10:00:00	SPY	ETF	596.34	596.34	590.27	593.44	8368580.0
2025-01-07 11:00:00	SPY	ETF	593.45	593.72	590.51	590.7	3693416.0
2025-01-07 12:00:00	SPY	ETF	590.715	591.73	589.64	590.905	2937612.0
2025-01-07 13:00:00	SPY	ETF	590.91	592.409	590.73	591.0	2062545.0
2025-01-07 14:00:00	SPY	ETF	591.0	591.57	589.83	590.02	2471459.0
2025-01-07 15:00:00	SPY	ETF	590.02	590.13	586.78	588.72	11074001.0
2025-01-07 16:00:00	SPY	ETF	588.73	591.273	588.63	588.72	3879864.0
2025-01-07 17:00:00	SPY	ETF	588.76	588.9	588.71	588.77	57438.0
2025-01-07 18:00:00	SPY	ETF	588.74	589.16	588.18	589.15	134044.0
2025-01-07 19:00:00	SPY	ETF	589.16	589.62	589.01	589.48	78072.0
2025-01-07 04:00:00	QQQ	ETF	524.7	525.17	524.0	524.23	63288.0
2025-01-07 05:00:00	QQQ	ETF	524.03	525.05	523.81	525.05	31317.0
2025-01-07 06:00:00	QQQ	ETF	525.0	525.05	523.91	524.2	71278.0
2025-01-07 07:00:00	QQQ	ETF	524.33	524.88	523.85	524.46	125609.0
2025-01-07 08:00:00	QQQ	ETF	523.96	525.2	522.52	525.2	200766.0
2025-01-07 09:00:00	QQQ	ETF	525.26	525.99	523.3	523.65	2731653.0
2025-01-07 10:00:00	QQQ	ETF	523.61	523.61	516.14	519.76	6115847.0
2025-01-07 11:00:00	QQQ	ETF	519.76	520.3299	516.82	517.03	3633971.0
2025-01-07 12:00:00	QQQ	ETF	517.08	517.98	515.88	517.28	2098576.0
2025-01-07 13:00:00	QQQ	ETF	517.27	519.03	516.88	517.15	1576164.0
2025-01-07 14:00:00	QQQ	ETF	517.1	518.0	516.28	516.5855	2621723.0
2025-01-07 15:00:00	QQQ	ETF	516.66	516.73	513.28	515.15	5408346.0
2025-01-07 16:00:00	QQQ	ETF	515.15	516.0	515.14	515.53	1643005.0
2025-01-07 17:00:00	QQQ	ETF	515.5611	515.61	515.42	515.55	38444.0
2025-01-07 18:00:00	QQQ	ETF	515.55	516.01	514.84	515.99	91229.0
2025-01-07 19:00:00	QQQ	ETF	516.0	516.45	515.89	516.29	67856.0
2025-01-07 04:00:00	IWM	ETF	224.47	224.88	224.47	224.65	8972.0
2025-01-07 05:00:00	IWM	ETF	224.57	224.96	224.57	224.87	5846.0
2025-01-07 06:00:00	IWM	ETF	224.86	225.01	224.76	224.83	8238.0
2025-01-07 07:00:00	IWM	ETF	224.81	225.08	224.65	224.65	62943.0
2025-01-07 08:00:00	IWM	ETF	224.69	225.5303	224.0	225.5303	164262.0
2025-01-07 09:00:00	IWM	ETF	225.52	226.515	225.42	225.85	2040001.0
2025-01-07 10:00:00	IWM	ETF	225.77	225.83	221.45	223.56	5755357.0
2025-01-07 11:00:00	IWM	ETF	223.57	224.05	222.08	222.225	2929406.0
2025-01-07 12:00:00	IWM	ETF	222.25	223.17	222.14	222.62	1724386.0
2025-01-07 13:00:00	IWM	ETF	222.61	223.5	222.58	222.8	1552799.0
2025-01-07 14:00:00	IWM	ETF	222.8	223.08	222.48	222.57	1223405.0
2025-01-07 15:00:00	IWM	ETF	222.575	222.86	221.38	222.74	4852028.0
2025-01-07 16:00:00	IWM	ETF	222.72	223.07	222.64	222.69	1212927.0
2025-01-07 17:00:00	IWM	ETF	222.69	222.7	222.44	222.52	29528.0
2025-01-07 18:00:00	IWM	ETF	222.64	222.69	222.38	222.69	19730.0
2025-01-07 19:00:00	IWM	ETF	222.7	222.94	222.57	222.82	9484.0
2025-01-07 04:00:00	DIA	ETF	427.28	427.28	427.1	427.15	2000.0
2025-01-07 06:00:00	DIA	ETF	427.57	427.57	427.57	427.57	256.0

> showing 50 of 23,692 rows — these rows as CSV

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