PREVIEW / etf_1hour / 2003-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-05.parquet
  size:    18 KB
  rows:    435

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-09-05 08:00:00	SPY	ETF	103.28	103.36	102.93	102.99	192300.0
2003-09-05 09:00:00	SPY	ETF	102.95	103.12	102.82	103.069	3038000.0
2003-09-05 10:00:00	SPY	ETF	103.08	103.38	103.03	103.33	4238900.0
2003-09-05 11:00:00	SPY	ETF	103.33	103.549	103.14	103.45	3524400.0
2003-09-05 12:00:00	SPY	ETF	103.46	103.5	102.96	103.1	3310500.0
2003-09-05 13:00:00	SPY	ETF	103.1	103.13	102.52	102.58	5188900.0
2003-09-05 14:00:00	SPY	ETF	102.56	102.73	102.4	102.7	4043900.0
2003-09-05 15:00:00	SPY	ETF	102.68	102.92	102.51	102.67	3915600.0
2003-09-05 16:00:00	SPY	ETF	102.733	102.99	102.66	102.8	1678800.0
2003-09-05 17:00:00	SPY	ETF	102.89	102.97	102.84	102.88	18700.0
2003-09-05 18:00:00	SPY	ETF	102.86	102.86	102.86	102.86	100.0
2003-09-05 19:00:00	SPY	ETF	102.87	102.91	102.82	102.89	2000.0
2003-09-05 08:00:00	QQQ	ETF	34.16	34.2	33.98	33.98	481100.0
2003-09-05 09:00:00	QQQ	ETF	33.97	34.04	33.87	33.983	11617500.0
2003-09-05 10:00:00	QQQ	ETF	33.988	34.25	33.95	34.22	14750600.0
2003-09-05 11:00:00	QQQ	ETF	34.22	34.34	34.11	34.292	11085100.0
2003-09-05 12:00:00	QQQ	ETF	34.3	34.32	33.98	34.08	8556500.0
2003-09-05 13:00:00	QQQ	ETF	34.08	34.1	33.799	33.86	13251400.0
2003-09-05 14:00:00	QQQ	ETF	33.85	33.9	33.67	33.87	10664800.0
2003-09-05 15:00:00	QQQ	ETF	33.87	33.99	33.78	33.86	10050700.0
2003-09-05 16:00:00	QQQ	ETF	33.86	33.974	33.83	33.9	1494100.0
2003-09-05 17:00:00	QQQ	ETF	33.9	33.95	33.9	33.93	38200.0
2003-09-05 18:00:00	QQQ	ETF	33.93	33.95	33.92	33.94	20000.0
2003-09-05 19:00:00	QQQ	ETF	33.95	33.95	33.92	33.95	6300.0
2003-09-05 09:00:00	IWM	ETF	50.9	50.965	50.795	50.905	746000.0
2003-09-05 10:00:00	IWM	ETF	50.87	51.2	50.865	51.175	744400.0
2003-09-05 11:00:00	IWM	ETF	51.185	51.415	51.125	51.385	917000.0
2003-09-05 12:00:00	IWM	ETF	51.385	51.49	51.125	51.195	636000.0
2003-09-05 13:00:00	IWM	ETF	51.195	51.195	50.895	50.895	1306800.0
2003-09-05 14:00:00	IWM	ETF	50.9	50.9	50.625	50.845	637800.0
2003-09-05 15:00:00	IWM	ETF	50.845	50.975	50.75	50.775	487800.0
2003-09-05 16:00:00	IWM	ETF	50.86	50.86	50.73	50.81	102000.0
2003-09-05 08:00:00	DIA	ETF	96.0	96.03	95.68	95.75	27300.0
2003-09-05 09:00:00	DIA	ETF	95.66	95.79	95.53	95.64	766500.0
2003-09-05 10:00:00	DIA	ETF	95.64	95.83	95.56	95.82	957600.0
2003-09-05 11:00:00	DIA	ETF	95.79	95.95	95.63	95.82	485500.0
2003-09-05 12:00:00	DIA	ETF	95.82	95.82	95.37	95.52	410800.0
2003-09-05 13:00:00	DIA	ETF	95.52	95.52	95.01	95.02	1005500.0
2003-09-05 14:00:00	DIA	ETF	95.05	95.18	94.86	95.1	1027700.0
2003-09-05 15:00:00	DIA	ETF	95.11	95.43	94.98	95.22	1653700.0
2003-09-05 16:00:00	DIA	ETF	95.23	95.45	95.17	95.42	392500.0
2003-09-05 17:00:00	DIA	ETF	95.35	95.45	95.35	95.35	7900.0
2003-09-05 18:00:00	DIA	ETF	95.4	95.4	95.4	95.4	200.0
2003-09-05 09:00:00	TLT	ETF	83.4	83.49	83.32	83.45	138200.0
2003-09-05 10:00:00	TLT	ETF	83.44	83.45	83.17	83.33	80300.0
2003-09-05 11:00:00	TLT	ETF	83.35	83.38	83.25	83.34	27500.0
2003-09-05 12:00:00	TLT	ETF	83.35	83.6	83.25	83.6	204400.0
2003-09-05 13:00:00	TLT	ETF	83.6	83.85	83.6	83.73	117100.0
2003-09-05 14:00:00	TLT	ETF	83.73	83.95	83.73	83.95	84900.0
2003-09-05 15:00:00	TLT	ETF	83.84	84.09	83.84	84.05	146900.0

> showing 50 of 435 rows — these rows as CSV

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