PREVIEW / etf_1hour / 2025-01-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	593.4	594.23	593.26	593.79	24438.0
2025-01-17 05:00:00	SPY	ETF	593.9	594.04	593.61	593.85	12255.0
2025-01-17 06:00:00	SPY	ETF	593.98	594.4	593.65	593.72	83237.0
2025-01-17 07:00:00	SPY	ETF	593.76	594.19	593.16	594.03	312204.0
2025-01-17 08:00:00	SPY	ETF	593.6816	596.36	592.2	596.17	460477.0
2025-01-17 09:00:00	SPY	ETF	596.24	597.74	595.61	596.29	5617399.0
2025-01-17 10:00:00	SPY	ETF	596.32	598.18	596.05	598.16	4153043.0
2025-01-17 11:00:00	SPY	ETF	598.14	599.1	597.714	598.295	3074172.0
2025-01-17 12:00:00	SPY	ETF	598.28	599.1	597.82	598.87	1930824.0
2025-01-17 13:00:00	SPY	ETF	598.89	599.36	598.1701	598.59	2031185.0
2025-01-17 14:00:00	SPY	ETF	598.5512	598.76	598.02	598.24	2249892.0
2025-01-17 15:00:00	SPY	ETF	598.22	598.59	597.35	597.57	8077620.0
2025-01-17 16:00:00	SPY	ETF	597.55	598.2364	597.0	597.45	3274481.0
2025-01-17 17:00:00	SPY	ETF	597.45	597.5	597.19	597.46	81450.0
2025-01-17 18:00:00	SPY	ETF	597.48	597.69	597.4	597.57	36924.0
2025-01-17 19:00:00	SPY	ETF	597.59	597.7	597.54	597.69	11598.0
2025-01-17 04:00:00	QQQ	ETF	514.02	515.97	514.02	515.62	27694.0
2025-01-17 05:00:00	QQQ	ETF	515.6	515.86	515.25	515.55	40286.0
2025-01-17 06:00:00	QQQ	ETF	515.54	516.08	515.15	515.28	102967.0
2025-01-17 07:00:00	QQQ	ETF	515.27	515.889	514.8	515.79	134631.0
2025-01-17 08:00:00	QQQ	ETF	515.03	520.44	513.65	520.34	1144556.0
2025-01-17 09:00:00	QQQ	ETF	520.37	523.62	519.1049	519.56	5680174.0
2025-01-17 10:00:00	QQQ	ETF	519.572	521.68	518.91	521.6006	3212100.0
2025-01-17 11:00:00	QQQ	ETF	521.6026	522.62	521.0538	521.34	2072831.0
2025-01-17 12:00:00	QQQ	ETF	521.31	522.4499	520.8	522.34	2192251.0
2025-01-17 13:00:00	QQQ	ETF	522.35	523.46	522.0	522.465	2917079.0
2025-01-17 14:00:00	QQQ	ETF	522.44	522.78	521.97	522.2409	2480328.0
2025-01-17 15:00:00	QQQ	ETF	522.23	522.65	521.26	521.76	4465631.0
2025-01-17 16:00:00	QQQ	ETF	521.73	521.78	521.09	521.38	2182217.0
2025-01-17 17:00:00	QQQ	ETF	521.41	521.74	521.26	521.55	99036.0
2025-01-17 18:00:00	QQQ	ETF	521.5705	522.05	521.57	522.05	25511.0
2025-01-17 19:00:00	QQQ	ETF	521.81	521.95	521.74	521.93	21066.0
2025-01-17 04:00:00	IWM	ETF	224.68	225.5	224.68	225.23	22183.0
2025-01-17 05:00:00	IWM	ETF	225.27	225.49	225.24	225.34	8892.0
2025-01-17 06:00:00	IWM	ETF	225.48	225.83	225.45	225.5	19262.0
2025-01-17 07:00:00	IWM	ETF	225.43	225.97	225.29	225.96	95993.0
2025-01-17 08:00:00	IWM	ETF	225.94	227.07	224.79	226.8599	190158.0
2025-01-17 09:00:00	IWM	ETF	226.91	227.3	225.94	226.18	2687218.0
2025-01-17 10:00:00	IWM	ETF	226.18	226.54	225.26	226.0	2031312.0
2025-01-17 11:00:00	IWM	ETF	225.98	226.04	225.43	225.85	1345234.0
2025-01-17 12:00:00	IWM	ETF	225.83	226.22	225.71	225.93	962499.0
2025-01-17 13:00:00	IWM	ETF	225.93	226.06	225.32	225.46	1056553.0
2025-01-17 14:00:00	IWM	ETF	225.46	225.73	224.89	224.99	1207575.0
2025-01-17 15:00:00	IWM	ETF	224.99	225.82	224.67	225.45	3250681.0
2025-01-17 16:00:00	IWM	ETF	225.46	225.5116	225.26	225.44	1467378.0
2025-01-17 17:00:00	IWM	ETF	225.45	225.48	225.31	225.39	14176.0
2025-01-17 18:00:00	IWM	ETF	225.44	225.45	225.24	225.31	17503.0
2025-01-17 19:00:00	IWM	ETF	225.33	225.43	225.33	225.38	1512.0
2025-01-17 04:00:00	DIA	ETF	431.6	432.59	431.6	432.53	1015.0
2025-01-17 06:00:00	DIA	ETF	433.01	433.17	432.99	432.99	1664.0

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

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