PREVIEW / etf_1hour / 2003-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-09.parquet
  size:    16 KB
  rows:    387

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-04-09 08:00:00	SPY	ETF	87.87	88.15	87.75	88.05	48800.0
2003-04-09 09:00:00	SPY	ETF	88.08	88.78	87.83	88.25	6492500.0
2003-04-09 10:00:00	SPY	ETF	88.21	89.1	88.1	88.56	12316400.0
2003-04-09 11:00:00	SPY	ETF	88.55	88.72	87.94	88.0	5245100.0
2003-04-09 12:00:00	SPY	ETF	87.99	88.09	87.12	87.28	7549700.0
2003-04-09 13:00:00	SPY	ETF	87.28	87.51	87.11	87.11	4984300.0
2003-04-09 14:00:00	SPY	ETF	87.1	87.64	87.01	87.3	4881100.0
2003-04-09 15:00:00	SPY	ETF	87.3	87.8	86.77	86.86	7501500.0
2003-04-09 16:00:00	SPY	ETF	86.87	88.89	86.81	87.0	1797100.0
2003-04-09 17:00:00	SPY	ETF	87.0	87.09	86.99	87.09	49700.0
2003-04-09 18:00:00	SPY	ETF	87.09	87.1	87.02	87.03	15700.0
2003-04-09 19:00:00	SPY	ETF	87.03	87.15	87.03	87.03	15000.0
2003-04-09 08:00:00	QQQ	ETF	25.98	26.04	25.9	26.01	53500.0
2003-04-09 09:00:00	QQQ	ETF	26.01	26.32	25.86	26.03	9212500.0
2003-04-09 10:00:00	QQQ	ETF	26.0	26.28	25.94	26.08	16054000.0
2003-04-09 11:00:00	QQQ	ETF	26.07	26.15	25.86	25.88	9670400.0
2003-04-09 12:00:00	QQQ	ETF	25.9	25.9	25.57	25.64	9367600.0
2003-04-09 13:00:00	QQQ	ETF	25.66	25.71	25.56	25.58	5474600.0
2003-04-09 14:00:00	QQQ	ETF	25.56	25.74	25.53	25.64	7594800.0
2003-04-09 15:00:00	QQQ	ETF	25.61	25.77	25.43	25.46	10381500.0
2003-04-09 16:00:00	QQQ	ETF	25.46	25.57	25.41	25.47	2341100.0
2003-04-09 17:00:00	QQQ	ETF	25.45	25.51	25.45	25.5	179800.0
2003-04-09 18:00:00	QQQ	ETF	25.48	25.54	25.48	25.54	54900.0
2003-04-09 19:00:00	QQQ	ETF	25.53	25.56	25.51	25.54	25600.0
2003-04-09 09:00:00	IWM	ETF	37.315	37.46	37.25	37.45	459400.0
2003-04-09 10:00:00	IWM	ETF	37.44	37.8	37.44	37.675	358600.0
2003-04-09 11:00:00	IWM	ETF	37.625	37.685	37.475	37.515	449400.0
2003-04-09 12:00:00	IWM	ETF	37.485	37.49	37.17	37.225	539600.0
2003-04-09 13:00:00	IWM	ETF	37.2	37.32	37.19	37.215	158600.0
2003-04-09 14:00:00	IWM	ETF	37.205	37.325	37.19	37.25	368000.0
2003-04-09 15:00:00	IWM	ETF	37.24	37.365	36.91	37.04	1009000.0
2003-04-09 16:00:00	IWM	ETF	37.04	37.115	37.035	37.115	475000.0
2003-04-09 08:00:00	DIA	ETF	82.89	83.1	82.77	83.08	26500.0
2003-04-09 09:00:00	DIA	ETF	83.08	83.93	82.85	83.32	1183000.0
2003-04-09 10:00:00	DIA	ETF	83.28	84.1	83.17	83.53	2543400.0
2003-04-09 11:00:00	DIA	ETF	83.55	83.8	83.06	83.09	1330600.0
2003-04-09 12:00:00	DIA	ETF	83.1	83.18	82.32	82.43	1358400.0
2003-04-09 13:00:00	DIA	ETF	82.47	82.76	82.3	82.34	1105700.0
2003-04-09 14:00:00	DIA	ETF	82.35	82.81	82.26	82.55	812700.0
2003-04-09 15:00:00	DIA	ETF	82.6	82.95	82.02	82.07	1340800.0
2003-04-09 16:00:00	DIA	ETF	82.13	82.3	82.02	82.27	363700.0
2003-04-09 17:00:00	DIA	ETF	82.25	82.25	82.14	82.22	2800.0
2003-04-09 18:00:00	DIA	ETF	82.17	82.28	82.17	82.24	5400.0
2003-04-09 19:00:00	DIA	ETF	82.17	82.17	82.14	82.14	300.0
2003-04-09 09:00:00	TLT	ETF	87.4	87.72	87.4	87.6	8100.0
2003-04-09 10:00:00	TLT	ETF	87.42	87.44	87.17	87.35	28000.0
2003-04-09 11:00:00	TLT	ETF	87.41	87.62	87.41	87.62	7400.0
2003-04-09 12:00:00	TLT	ETF	87.75	87.82	87.74	87.74	6600.0
2003-04-09 13:00:00	TLT	ETF	87.6	87.86	87.56	87.86	11500.0
2003-04-09 14:00:00	TLT	ETF	87.76	87.84	87.68	87.68	1300.0

> showing 50 of 387 rows — these rows as CSV

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