PREVIEW / etf_1hour / 2001-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-02-02.parquet
  size:    11 KB
  rows:    209

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-02-02 09:00:00	SPY	ETF	137.4	137.99	137.4	137.64	1079800.0
2001-02-02 10:00:00	SPY	ETF	137.6	137.8	136.75	136.78	925100.0
2001-02-02 11:00:00	SPY	ETF	136.88	136.88	136.01	136.02	1121200.0
2001-02-02 12:00:00	SPY	ETF	136.09	136.51	135.83	135.83	1454100.0
2001-02-02 13:00:00	SPY	ETF	135.85	136.3	135.56	135.98	914100.0
2001-02-02 14:00:00	SPY	ETF	135.95	136.3	135.56	135.56	891300.0
2001-02-02 15:00:00	SPY	ETF	135.56	136.26	135.0	135.08	1240500.0
2001-02-02 16:00:00	SPY	ETF	135.0	135.09	134.75	134.8	638900.0
2001-02-02 17:00:00	SPY	ETF	135.0	135.0	135.0	135.0	300.0
2001-02-02 18:00:00	SPY	ETF	135.0	135.0	135.0	135.0	200.0
2001-02-02 09:00:00	QQQ	ETF	64.94	65.29	64.14	64.5	5592500.0
2001-02-02 10:00:00	QQQ	ETF	64.35	64.68	63.29	63.35	7873000.0
2001-02-02 11:00:00	QQQ	ETF	63.31	63.66	62.8	62.88	6924400.0
2001-02-02 12:00:00	QQQ	ETF	62.85	63.48	62.8	63.11	4525900.0
2001-02-02 13:00:00	QQQ	ETF	63.0	63.35	62.68	62.98	5892700.0
2001-02-02 14:00:00	QQQ	ETF	62.91	63.2	62.4	62.54	3778800.0
2001-02-02 15:00:00	QQQ	ETF	62.51	62.62	61.54	61.7	10127600.0
2001-02-02 16:00:00	QQQ	ETF	61.7	62.29	61.48	61.6	1817200.0
2001-02-02 17:00:00	QQQ	ETF	61.55	61.99	61.36	61.45	32400.0
2001-02-02 18:00:00	QQQ	ETF	61.44	61.6	61.4	61.4	32700.0
2001-02-02 09:00:00	IWM	ETF	50.9	50.9	50.825	50.825	8600.0
2001-02-02 10:00:00	IWM	ETF	50.825	50.825	50.575	50.575	1200.0
2001-02-02 11:00:00	IWM	ETF	50.5	50.675	50.25	50.45	148200.0
2001-02-02 12:00:00	IWM	ETF	50.3	50.475	50.25	50.41	84400.0
2001-02-02 13:00:00	IWM	ETF	50.225	50.4	50.1	50.175	171000.0
2001-02-02 14:00:00	IWM	ETF	50.25	50.45	50.0	50.05	219200.0
2001-02-02 15:00:00	IWM	ETF	50.175	50.175	49.7	49.7	224400.0
2001-02-02 16:00:00	IWM	ETF	49.685	49.685	49.685	49.685	200.0
2001-02-02 09:00:00	DIA	ETF	109.8	110.38	109.79	110.2	208800.0
2001-02-02 10:00:00	DIA	ETF	110.2	110.39	109.78	109.9	298500.0
2001-02-02 11:00:00	DIA	ETF	109.82	109.9	109.26	109.35	372600.0
2001-02-02 12:00:00	DIA	ETF	109.43	109.59	109.13	109.13	171800.0
2001-02-02 13:00:00	DIA	ETF	109.15	109.37	108.87	109.2	427700.0
2001-02-02 14:00:00	DIA	ETF	109.24	109.36	108.94	108.96	114200.0
2001-02-02 15:00:00	DIA	ETF	109.01	109.13	108.5	108.59	290800.0
2001-02-02 16:00:00	DIA	ETF	108.72	108.72	108.51	108.63	35800.0

> showing 36 of 209 rows — these rows as CSV

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