PREVIEW / etf_1hour / 2003-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-30.parquet
  size:    16 KB
  rows:    388

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-30 08:00:00	SPY	ETF	86.7	87.1	86.4	87.0	68100.0
2003-01-30 09:00:00	SPY	ETF	87.0	87.05	86.25	86.26	4915800.0
2003-01-30 10:00:00	SPY	ETF	86.26	86.87	86.04	86.35	7006500.0
2003-01-30 11:00:00	SPY	ETF	86.35	86.44	85.76	85.8	4797100.0
2003-01-30 12:00:00	SPY	ETF	85.78	85.98	85.56	85.89	6669100.0
2003-01-30 13:00:00	SPY	ETF	85.91	85.98	85.66	85.77	2665000.0
2003-01-30 14:00:00	SPY	ETF	85.76	85.88	85.27	85.36	4598200.0
2003-01-30 15:00:00	SPY	ETF	85.32	85.45	84.63	84.77	8979000.0
2003-01-30 16:00:00	SPY	ETF	84.77	84.85	84.2	84.3	2802400.0
2003-01-30 17:00:00	SPY	ETF	84.3	84.72	84.14	84.72	154600.0
2003-01-30 18:00:00	SPY	ETF	84.18	84.34	84.15	84.34	13900.0
2003-01-30 19:00:00	SPY	ETF	84.22	84.39	84.22	84.39	2400.0
2003-01-30 08:00:00	QQQ	ETF	25.35	25.48	25.16	25.43	148100.0
2003-01-30 09:00:00	QQQ	ETF	25.45	25.45	25.02	25.2	8625200.0
2003-01-30 10:00:00	QQQ	ETF	25.2	25.42	25.08	25.19	10763100.0
2003-01-30 11:00:00	QQQ	ETF	25.18	25.23	24.89	24.92	6799000.0
2003-01-30 12:00:00	QQQ	ETF	24.91	25.03	24.82	25.0	7438100.0
2003-01-30 13:00:00	QQQ	ETF	24.98	25.01	24.86	24.9	4008800.0
2003-01-30 14:00:00	QQQ	ETF	24.9	24.96	24.67	24.68	8365600.0
2003-01-30 15:00:00	QQQ	ETF	24.71	24.74	24.49	24.54	12538200.0
2003-01-30 16:00:00	QQQ	ETF	24.51	24.56	24.38	24.39	2176400.0
2003-01-30 17:00:00	QQQ	ETF	24.39	24.46	24.25	24.3	774200.0
2003-01-30 18:00:00	QQQ	ETF	24.3	24.43	24.29	24.4	93900.0
2003-01-30 19:00:00	QQQ	ETF	24.39	24.43	24.36	24.41	16400.0
2003-01-30 20:00:00	QQQ	ETF	24.41	24.41	24.4	24.4	1100.0
2003-01-30 09:00:00	IWM	ETF	37.335	37.405	37.205	37.275	716200.0
2003-01-30 10:00:00	IWM	ETF	37.2	37.315	37.035	37.08	340000.0
2003-01-30 11:00:00	IWM	ETF	37.075	37.075	36.795	36.795	430000.0
2003-01-30 12:00:00	IWM	ETF	36.795	36.85	36.755	36.85	492000.0
2003-01-30 13:00:00	IWM	ETF	36.865	36.885	36.775	36.8	29200.0
2003-01-30 14:00:00	IWM	ETF	36.8	36.825	36.645	36.685	330600.0
2003-01-30 15:00:00	IWM	ETF	36.695	36.73	36.485	36.57	536600.0
2003-01-30 16:00:00	IWM	ETF	36.55	36.605	36.55	36.605	225800.0
2003-01-30 17:00:00	IWM	ETF	36.5	36.5	36.5	36.5	3400.0
2003-01-30 18:00:00	IWM	ETF	36.605	36.605	36.605	36.605	68200.0
2003-01-30 08:00:00	DIA	ETF	81.34	81.55	81.15	81.53	55200.0
2003-01-30 09:00:00	DIA	ETF	81.57	81.57	80.8	80.9	1045000.0
2003-01-30 10:00:00	DIA	ETF	80.9	81.57	80.62	81.12	1466600.0
2003-01-30 11:00:00	DIA	ETF	81.12	81.2	80.67	80.7	872000.0
2003-01-30 12:00:00	DIA	ETF	80.71	80.8	80.38	80.72	1658000.0
2003-01-30 13:00:00	DIA	ETF	80.71	80.82	80.44	80.6	435500.0
2003-01-30 14:00:00	DIA	ETF	80.58	80.73	80.12	80.2	846700.0
2003-01-30 15:00:00	DIA	ETF	80.21	80.26	79.45	79.51	1783900.0
2003-01-30 16:00:00	DIA	ETF	79.54	79.68	79.09	79.17	165800.0
2003-01-30 17:00:00	DIA	ETF	79.19	79.19	79.0	79.05	4000.0
2003-01-30 18:00:00	DIA	ETF	79.09	79.19	79.03	79.09	3100.0
2003-01-30 19:00:00	DIA	ETF	79.19	79.19	79.19	79.19	200.0
2003-01-30 09:00:00	TLT	ETF	87.2	87.28	87.1	87.25	21000.0
2003-01-30 10:00:00	TLT	ETF	87.26	87.53	87.25	87.53	12300.0
2003-01-30 11:00:00	TLT	ETF	87.56	87.66	87.5	87.66	3900.0

> showing 50 of 388 rows — these rows as CSV

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