PREVIEW / etf_1hour / 2003-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-23.parquet
  size:    16 KB
  rows:    389

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-01-23 08:00:00	SPY	ETF	88.7	88.83	88.66	88.75	79600.0
2003-01-23 09:00:00	SPY	ETF	88.75	88.97	88.49	88.62	4950600.0
2003-01-23 10:00:00	SPY	ETF	88.6	88.79	87.95	88.5	8150600.0
2003-01-23 11:00:00	SPY	ETF	88.5	88.5	88.0	88.35	4019500.0
2003-01-23 12:00:00	SPY	ETF	88.37	88.64	88.08	88.48	5714400.0
2003-01-23 13:00:00	SPY	ETF	88.48	88.92	88.38	88.8	4965400.0
2003-01-23 14:00:00	SPY	ETF	88.8	89.02	88.55	88.83	4489000.0
2003-01-23 15:00:00	SPY	ETF	88.86	89.38	88.83	89.08	7913400.0
2003-01-23 16:00:00	SPY	ETF	89.04	89.09	88.67	88.8	13389400.0
2003-01-23 17:00:00	SPY	ETF	88.8	88.9	88.76	88.88	174900.0
2003-01-23 18:00:00	SPY	ETF	88.89	88.9	88.8	88.9	1800.0
2003-01-23 19:00:00	SPY	ETF	88.9	88.9	88.9	88.9	900.0
2003-01-23 08:00:00	QQQ	ETF	25.37	25.44	25.35	25.41	141300.0
2003-01-23 09:00:00	QQQ	ETF	25.4	25.63	25.36	25.47	11633200.0
2003-01-23 10:00:00	QQQ	ETF	25.49	25.55	25.11	25.35	17055200.0
2003-01-23 11:00:00	QQQ	ETF	25.35	25.37	25.13	25.3	5874200.0
2003-01-23 12:00:00	QQQ	ETF	25.3	25.48	25.26	25.41	5011700.0
2003-01-23 13:00:00	QQQ	ETF	25.41	25.59	25.35	25.52	6372400.0
2003-01-23 14:00:00	QQQ	ETF	25.52	25.59	25.39	25.54	7730800.0
2003-01-23 15:00:00	QQQ	ETF	25.54	25.84	25.52	25.66	15544900.0
2003-01-23 16:00:00	QQQ	ETF	25.65	25.69	25.45	25.49	4304200.0
2003-01-23 17:00:00	QQQ	ETF	25.49	25.6	25.46	25.52	736100.0
2003-01-23 18:00:00	QQQ	ETF	25.55	25.57	25.5	25.57	29100.0
2003-01-23 19:00:00	QQQ	ETF	25.55	25.57	25.52	25.53	11900.0
2003-01-23 08:00:00	IWM	ETF	38.03	38.03	38.03	38.03	200.0
2003-01-23 09:00:00	IWM	ETF	37.975	38.17	37.975	38.0	169600.0
2003-01-23 10:00:00	IWM	ETF	38.075	38.1	37.785	38.005	421200.0
2003-01-23 11:00:00	IWM	ETF	38.0	38.0	37.82	37.91	143000.0
2003-01-23 12:00:00	IWM	ETF	37.925	38.005	37.9	37.985	67200.0
2003-01-23 13:00:00	IWM	ETF	38.005	38.09	37.945	38.08	86800.0
2003-01-23 14:00:00	IWM	ETF	38.095	38.175	38.03	38.105	258000.0
2003-01-23 15:00:00	IWM	ETF	38.155	38.27	38.09	38.09	455400.0
2003-01-23 16:00:00	IWM	ETF	38.04	38.14	37.93	37.93	347200.0
2003-01-23 17:00:00	IWM	ETF	38.19	38.19	38.19	38.19	104800.0
2003-01-23 08:00:00	DIA	ETF	83.8	83.9	83.7	83.78	25800.0
2003-01-23 09:00:00	DIA	ETF	83.77	83.9	83.22	83.39	1256600.0
2003-01-23 10:00:00	DIA	ETF	83.35	83.45	82.69	83.22	1481900.0
2003-01-23 11:00:00	DIA	ETF	83.21	83.25	82.75	83.1	1134500.0
2003-01-23 12:00:00	DIA	ETF	83.08	83.32	82.84	83.19	865000.0
2003-01-23 13:00:00	DIA	ETF	83.21	83.65	83.1	83.51	1000400.0
2003-01-23 14:00:00	DIA	ETF	83.5	83.75	83.31	83.58	973400.0
2003-01-23 15:00:00	DIA	ETF	83.59	84.03	83.59	83.74	1327100.0
2003-01-23 16:00:00	DIA	ETF	83.74	83.83	83.44	83.52	198700.0
2003-01-23 17:00:00	DIA	ETF	83.49	83.6	83.4	83.6	8200.0
2003-01-23 18:00:00	DIA	ETF	83.53	83.53	83.53	83.53	800.0
2003-01-23 19:00:00	DIA	ETF	83.52	83.53	83.52	83.53	1800.0
2003-01-23 09:00:00	TLT	ETF	87.32	87.47	87.3	87.39	4300.0
2003-01-23 10:00:00	TLT	ETF	87.49	87.65	87.43	87.43	63500.0
2003-01-23 11:00:00	TLT	ETF	87.57	87.7	87.57	87.7	6500.0
2003-01-23 12:00:00	TLT	ETF	87.5	87.62	87.45	87.45	6800.0

> showing 50 of 389 rows — these rows as CSV

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