PREVIEW / etf_1hour / 2001-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-29.parquet
  size:    13 KB
  rows:    264

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
2001-10-29 09:00:00	SPY	ETF	110.16	110.55	109.67	109.89	2840000.0
2001-10-29 10:00:00	SPY	ETF	109.89	109.9	109.17	109.84	3599700.0
2001-10-29 11:00:00	SPY	ETF	109.8	109.85	108.86	109.08	3175800.0
2001-10-29 12:00:00	SPY	ETF	109.08	109.28	108.87	109.14	769900.0
2001-10-29 13:00:00	SPY	ETF	109.1	109.16	108.6	108.77	1563200.0
2001-10-29 14:00:00	SPY	ETF	108.77	108.99	108.55	108.92	1577500.0
2001-10-29 15:00:00	SPY	ETF	108.9	108.97	108.06	108.23	3530600.0
2001-10-29 16:00:00	SPY	ETF	108.27	109.48	107.0	107.52	1304400.0
2001-10-29 17:00:00	SPY	ETF	107.49	107.5	106.95	107.01	43000.0
2001-10-29 18:00:00	SPY	ETF	107.0	107.0	106.6	106.9	12500.0
2001-10-29 09:00:00	QQQ	ETF	36.0	36.15	35.56	35.68	15806400.0
2001-10-29 10:00:00	QQQ	ETF	35.67	35.83	35.35	35.75	13898300.0
2001-10-29 11:00:00	QQQ	ETF	35.75	35.76	35.19	35.33	10387100.0
2001-10-29 12:00:00	QQQ	ETF	35.33	35.42	35.08	35.2	7938700.0
2001-10-29 13:00:00	QQQ	ETF	35.18	35.23	34.8	34.87	11835200.0
2001-10-29 14:00:00	QQQ	ETF	34.85	34.95	34.56	34.92	12938000.0
2001-10-29 15:00:00	QQQ	ETF	34.92	34.94	34.2	34.25	16316500.0
2001-10-29 16:00:00	QQQ	ETF	34.22	35.52	33.95	33.99	2223200.0
2001-10-29 17:00:00	QQQ	ETF	33.96	34.0	33.6	33.6	237100.0
2001-10-29 18:00:00	QQQ	ETF	33.61	33.69	33.4	33.4	39000.0
2001-10-29 09:00:00	IWM	ETF	43.505	43.51	43.43	43.43	15200.0
2001-10-29 10:00:00	IWM	ETF	43.395	43.46	43.15	43.345	150000.0
2001-10-29 11:00:00	IWM	ETF	43.34	43.34	43.16	43.16	90800.0
2001-10-29 12:00:00	IWM	ETF	43.21	43.24	43.16	43.235	32600.0
2001-10-29 13:00:00	IWM	ETF	43.165	43.165	43.075	43.135	24800.0
2001-10-29 14:00:00	IWM	ETF	43.15	43.15	42.985	43.115	51600.0
2001-10-29 15:00:00	IWM	ETF	43.135	43.2	42.7	42.8	107600.0
2001-10-29 16:00:00	IWM	ETF	42.705	42.75	42.705	42.75	3800.0
2001-10-29 09:00:00	DIA	ETF	95.05	95.05	94.25	94.47	662000.0
2001-10-29 10:00:00	DIA	ETF	94.41	94.46	93.75	94.24	569400.0
2001-10-29 11:00:00	DIA	ETF	94.29	94.3	93.4	93.5	379200.0
2001-10-29 12:00:00	DIA	ETF	93.5	93.84	93.33	93.69	140100.0
2001-10-29 13:00:00	DIA	ETF	93.61	93.68	93.23	93.45	232900.0
2001-10-29 14:00:00	DIA	ETF	93.35	93.56	93.15	93.55	234500.0
2001-10-29 15:00:00	DIA	ETF	93.5	93.55	92.7	92.76	593400.0
2001-10-29 16:00:00	DIA	ETF	92.74	93.06	92.01	93.06	220300.0
2001-10-29 17:00:00	DIA	ETF	92.1	92.25	92.05	92.25	2100.0

> showing 37 of 264 rows — these rows as CSV

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