PREVIEW / etf_1hour / 2003-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-15.parquet
  size:    18 KB
  rows:    431

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-07-15 08:00:00	SPY	ETF	101.11	101.5	101.09	101.46	130600.0
2003-07-15 09:00:00	SPY	ETF	101.46	101.55	100.78	101.05	4238200.0
2003-07-15 10:00:00	SPY	ETF	101.01	101.32	100.59	101.09	8404100.0
2003-07-15 11:00:00	SPY	ETF	101.09	101.25	100.48	100.83	3106500.0
2003-07-15 12:00:00	SPY	ETF	100.81	100.86	100.3	100.49	2774300.0
2003-07-15 13:00:00	SPY	ETF	100.45	100.63	100.06	100.53	4458200.0
2003-07-15 14:00:00	SPY	ETF	100.54	100.55	100.0	100.18	3874700.0
2003-07-15 15:00:00	SPY	ETF	100.2	100.39	99.95	100.38	6460200.0
2003-07-15 16:00:00	SPY	ETF	100.39	101.061	100.36	100.99	3857100.0
2003-07-15 17:00:00	SPY	ETF	101.01	101.12	100.43	100.96	509600.0
2003-07-15 18:00:00	SPY	ETF	100.96	101.0	100.3785	100.98	20688000.0
2003-07-15 19:00:00	SPY	ETF	100.93	101.01	100.87	100.89	10300.0
2003-07-15 08:00:00	QQQ	ETF	32.45	32.57	32.4	32.55	228100.0
2003-07-15 09:00:00	QQQ	ETF	32.56	32.65	32.31	32.5	11731700.0
2003-07-15 10:00:00	QQQ	ETF	32.46	32.57	32.25	32.47	15050300.0
2003-07-15 11:00:00	QQQ	ETF	32.46	32.53	32.25	32.43	6956400.0
2003-07-15 12:00:00	QQQ	ETF	32.41	32.45	32.22	32.318	5378600.0
2003-07-15 13:00:00	QQQ	ETF	32.32	32.34	32.05	32.29	7454900.0
2003-07-15 14:00:00	QQQ	ETF	32.28	32.29	32.013	32.04	6498500.0
2003-07-15 15:00:00	QQQ	ETF	32.04	32.19	31.94	32.17	9990300.0
2003-07-15 16:00:00	QQQ	ETF	32.17	32.55	32.15	32.48	5844500.0
2003-07-15 17:00:00	QQQ	ETF	32.5	32.55	32.26	32.501	1004900.0
2003-07-15 18:00:00	QQQ	ETF	32.5	32.62	32.5	32.62	641300.0
2003-07-15 19:00:00	QQQ	ETF	32.61	32.61	32.56	32.6	171200.0
2003-07-15 09:00:00	IWM	ETF	48.22	48.22	47.755	47.885	457000.0
2003-07-15 10:00:00	IWM	ETF	47.875	47.9	47.685	47.82	686000.0
2003-07-15 11:00:00	IWM	ETF	47.82	47.85	47.605	47.64	234400.0
2003-07-15 12:00:00	IWM	ETF	47.655	47.665	47.515	47.55	93600.0
2003-07-15 13:00:00	IWM	ETF	47.54	47.55	47.375	47.495	246000.0
2003-07-15 14:00:00	IWM	ETF	47.465	47.47	47.31	47.35	197800.0
2003-07-15 15:00:00	IWM	ETF	47.335	47.5	47.245	47.485	807200.0
2003-07-15 16:00:00	IWM	ETF	47.515	47.825	47.45	47.775	246800.0
2003-07-15 08:00:00	DIA	ETF	92.2	92.54	92.2	92.51	18300.0
2003-07-15 09:00:00	DIA	ETF	92.51	92.55	91.8	92.0	1185900.0
2003-07-15 10:00:00	DIA	ETF	92.0	92.2	91.61	92.07	1381700.0
2003-07-15 11:00:00	DIA	ETF	92.01	92.11	91.5	91.83	1041100.0
2003-07-15 12:00:00	DIA	ETF	91.78	91.89	91.4	91.56	360500.0
2003-07-15 13:00:00	DIA	ETF	91.54	91.64	91.22	91.6	1220100.0
2003-07-15 14:00:00	DIA	ETF	91.59	91.59	91.1	91.25	446200.0
2003-07-15 15:00:00	DIA	ETF	91.22	91.51	91.07	91.47	656700.0
2003-07-15 16:00:00	DIA	ETF	91.5	91.99	91.44	91.98	112800.0
2003-07-15 17:00:00	DIA	ETF	91.99	92.15	91.99	92.1	7500.0
2003-07-15 18:00:00	DIA	ETF	92.02	92.17	92.02	92.08	1400.0
2003-07-15 19:00:00	DIA	ETF	92.06	92.06	92.0	92.0	1200.0
2003-07-15 09:00:00	TLT	ETF	89.54	89.79	89.54	89.65	126800.0
2003-07-15 10:00:00	TLT	ETF	89.85	89.86	88.5	88.61	894900.0
2003-07-15 11:00:00	TLT	ETF	88.69	88.72	88.38	88.5	511100.0
2003-07-15 12:00:00	TLT	ETF	88.48	88.57	87.91	88.0	278000.0
2003-07-15 13:00:00	TLT	ETF	87.99	88.2	87.55	87.55	625800.0
2003-07-15 14:00:00	TLT	ETF	87.56	87.96	87.4	87.88	365500.0

> showing 50 of 431 rows — these rows as CSV

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