PREVIEW / etf_1hour / 2003-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-01.parquet
  size:    18 KB
  rows:    440

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
2003-10-01 08:00:00	SPY	ETF	100.32	100.33	100.2	100.25	35800.0
2003-10-01 09:00:00	SPY	ETF	100.25	100.78	100.2	100.65	5077200.0
2003-10-01 10:00:00	SPY	ETF	100.61	100.93	100.41	100.427	9985400.0
2003-10-01 11:00:00	SPY	ETF	100.42	101.08	100.41	100.97	4961200.0
2003-10-01 12:00:00	SPY	ETF	100.94	101.33	100.88	101.19	3783600.0
2003-10-01 13:00:00	SPY	ETF	101.19	101.6	101.15	101.56	6112200.0
2003-10-01 14:00:00	SPY	ETF	101.51	101.63	101.28	101.46	8975300.0
2003-10-01 15:00:00	SPY	ETF	101.45	102.12	101.43	102.0	12047600.0
2003-10-01 16:00:00	SPY	ETF	102.0	102.57	101.95	102.06	2896200.0
2003-10-01 17:00:00	SPY	ETF	102.01	102.08	101.98	102.03	99000.0
2003-10-01 18:00:00	SPY	ETF	102.03	102.07	102.03	102.07	1300.0
2003-10-01 19:00:00	SPY	ETF	102.04	102.06	102.02	102.02	2600.0
2003-10-01 08:00:00	QQQ	ETF	32.63	32.65	32.6	32.63	116600.0
2003-10-01 09:00:00	QQQ	ETF	32.65	32.87	32.6	32.8	11876900.0
2003-10-01 10:00:00	QQQ	ETF	32.788	32.97	32.45	32.47	20567000.0
2003-10-01 11:00:00	QQQ	ETF	32.465	32.82	32.42	32.719	10883000.0
2003-10-01 12:00:00	QQQ	ETF	32.71	32.91	32.68	32.83	7445800.0
2003-10-01 13:00:00	QQQ	ETF	32.82	33.066	32.82	33.04	12330700.0
2003-10-01 14:00:00	QQQ	ETF	33.04	33.07	32.88	32.901	11757000.0
2003-10-01 15:00:00	QQQ	ETF	32.9	33.23	32.896	33.13	16164600.0
2003-10-01 16:00:00	QQQ	ETF	33.13	33.19	33.09	33.12	3659700.0
2003-10-01 17:00:00	QQQ	ETF	33.14	33.19	33.12	33.13	202100.0
2003-10-01 18:00:00	QQQ	ETF	33.14	33.16	33.14	33.15	54000.0
2003-10-01 19:00:00	QQQ	ETF	33.15	33.15	33.14	33.14	5000.0
2003-10-01 08:00:00	IWM	ETF	48.75	48.75	48.75	48.75	6000.0
2003-10-01 09:00:00	IWM	ETF	48.775	49.17	48.65	49.125	880400.0
2003-10-01 10:00:00	IWM	ETF	49.125	49.315	49.055	49.06	1638800.0
2003-10-01 11:00:00	IWM	ETF	49.065	49.275	49.035	49.22	714600.0
2003-10-01 12:00:00	IWM	ETF	49.21	49.485	49.185	49.485	1108200.0
2003-10-01 13:00:00	IWM	ETF	49.485	49.695	49.475	49.675	645800.0
2003-10-01 14:00:00	IWM	ETF	49.69	49.735	49.59	49.655	854200.0
2003-10-01 15:00:00	IWM	ETF	49.655	49.97	49.635	49.815	2869000.0
2003-10-01 16:00:00	IWM	ETF	49.805	49.885	49.755	49.885	259600.0
2003-10-01 08:00:00	DIA	ETF	93.36	93.39	93.36	93.36	900.0
2003-10-01 09:00:00	DIA	ETF	93.35	93.72	93.28	93.61	573700.0
2003-10-01 10:00:00	DIA	ETF	93.64	93.87	93.4	93.47	1248300.0
2003-10-01 11:00:00	DIA	ETF	93.47	93.96	93.46	93.9	674800.0
2003-10-01 12:00:00	DIA	ETF	93.9	94.27	93.82	94.18	714700.0
2003-10-01 13:00:00	DIA	ETF	94.15	94.4	94.07	94.39	561200.0
2003-10-01 14:00:00	DIA	ETF	94.39	94.44	94.13	94.33	536600.0
2003-10-01 15:00:00	DIA	ETF	94.28	94.88	94.28	94.76	1658000.0
2003-10-01 16:00:00	DIA	ETF	94.78	94.88	94.73	94.75	196800.0
2003-10-01 17:00:00	DIA	ETF	94.75	94.8	94.75	94.8	800.0
2003-10-01 18:00:00	DIA	ETF	94.78	94.78	94.75	94.77	600.0
2003-10-01 09:00:00	TLT	ETF	87.5	87.65	87.5	87.54	213700.0
2003-10-01 10:00:00	TLT	ETF	87.65	87.76	87.35	87.68	344000.0
2003-10-01 11:00:00	TLT	ETF	87.72	87.93	87.63	87.66	59900.0
2003-10-01 12:00:00	TLT	ETF	87.67	87.77	87.56	87.64	63800.0
2003-10-01 13:00:00	TLT	ETF	87.65	87.7	87.59	87.64	33100.0
2003-10-01 14:00:00	TLT	ETF	87.72	87.85	87.65	87.75	45400.0

> showing 50 of 440 rows — these rows as CSV

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