PREVIEW / etf_1hour / 2001-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-17.parquet
  size:    13 KB
  rows:    263

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-17 09:00:00	SPY	ETF	111.07	111.15	110.64	110.81	2558900.0
2001-10-17 10:00:00	SPY	ETF	110.74	110.84	109.3	110.33	6491700.0
2001-10-17 11:00:00	SPY	ETF	110.37	110.54	109.37	109.51	2802600.0
2001-10-17 12:00:00	SPY	ETF	109.51	109.84	108.76	109.08	3727100.0
2001-10-17 13:00:00	SPY	ETF	109.08	109.38	108.49	109.0	3456600.0
2001-10-17 14:00:00	SPY	ETF	108.99	109.48	108.76	109.25	1905100.0
2001-10-17 15:00:00	SPY	ETF	109.25	109.3	107.9	107.9	5143600.0
2001-10-17 16:00:00	SPY	ETF	107.9	108.4	107.5	107.8	1447000.0
2001-10-17 17:00:00	SPY	ETF	107.71	107.71	107.35	107.65	42100.0
2001-10-17 09:00:00	QQQ	ETF	35.87	35.95	35.3	35.39	17536800.0
2001-10-17 10:00:00	QQQ	ETF	35.38	35.44	34.3	34.94	35771000.0
2001-10-17 11:00:00	QQQ	ETF	34.89	35.05	34.2	34.38	11622200.0
2001-10-17 12:00:00	QQQ	ETF	34.33	34.47	33.66	33.84	13906600.0
2001-10-17 13:00:00	QQQ	ETF	33.84	34.07	33.45	33.76	12409500.0
2001-10-17 14:00:00	QQQ	ETF	33.78	34.09	33.51	34.0	13863200.0
2001-10-17 15:00:00	QQQ	ETF	34.0	34.02	32.76	32.83	25075600.0
2001-10-17 16:00:00	QQQ	ETF	32.79	33.35	32.32	32.61	4407600.0
2001-10-17 17:00:00	QQQ	ETF	32.6	32.65	32.4	32.65	273500.0
2001-10-17 18:00:00	QQQ	ETF	32.63	32.68	32.6	32.66	42200.0
2001-10-17 09:00:00	IWM	ETF	43.65	43.725	43.405	43.525	57600.0
2001-10-17 10:00:00	IWM	ETF	43.45	43.45	42.755	43.06	103400.0
2001-10-17 11:00:00	IWM	ETF	43.09	43.135	42.89	42.89	29800.0
2001-10-17 12:00:00	IWM	ETF	42.875	42.88	42.62	42.62	226200.0
2001-10-17 13:00:00	IWM	ETF	42.7	42.74	42.4	42.485	256000.0
2001-10-17 14:00:00	IWM	ETF	42.615	42.75	42.595	42.66	42200.0
2001-10-17 15:00:00	IWM	ETF	42.66	42.8	42.16	42.16	57600.0
2001-10-17 16:00:00	IWM	ETF	42.075	42.075	42.0	42.0	4400.0
2001-10-17 17:00:00	IWM	ETF	42.0	42.0	42.0	42.0	600.0
2001-10-17 09:00:00	DIA	ETF	95.1	95.18	94.7	94.91	1154800.0
2001-10-17 10:00:00	DIA	ETF	94.92	95.01	93.8	94.5	2252400.0
2001-10-17 11:00:00	DIA	ETF	94.48	94.63	93.6	93.75	763100.0
2001-10-17 12:00:00	DIA	ETF	93.7	94.0	93.1	93.33	652300.0
2001-10-17 13:00:00	DIA	ETF	93.38	93.65	92.75	93.05	672000.0
2001-10-17 14:00:00	DIA	ETF	93.14	93.5	92.9	93.34	566500.0
2001-10-17 15:00:00	DIA	ETF	93.32	93.34	92.3	92.31	1357600.0
2001-10-17 16:00:00	DIA	ETF	92.32	92.35	92.01	92.1	3368200.0
2001-10-17 17:00:00	DIA	ETF	92.01	92.46	91.97	92.01	3004500.0

> showing 37 of 263 rows — these rows as CSV

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