PREVIEW / etf_1hour / 2003-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-31.parquet
  size:    16 KB
  rows:    372

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-31 08:00:00	SPY	ETF	84.91	84.99	84.67	84.83	56800.0
2003-01-31 09:00:00	SPY	ETF	84.81	85.37	84.14	85.14	8230400.0
2003-01-31 10:00:00	SPY	ETF	85.34	85.7	84.6	85.14	10065900.0
2003-01-31 11:00:00	SPY	ETF	85.14	85.7	84.76	85.47	4384700.0
2003-01-31 12:00:00	SPY	ETF	85.46	86.07	85.26	85.71	3988100.0
2003-01-31 13:00:00	SPY	ETF	85.7	86.14	85.62	85.76	3778800.0
2003-01-31 14:00:00	SPY	ETF	85.76	86.21	85.65	85.83	5519700.0
2003-01-31 15:00:00	SPY	ETF	85.82	86.0	85.16	85.81	7293900.0
2003-01-31 16:00:00	SPY	ETF	85.81	86.15	85.49	86.0	3582100.0
2003-01-31 17:00:00	SPY	ETF	86.0	86.12	85.9	86.12	9900.0
2003-01-31 18:00:00	SPY	ETF	86.1	86.1	86.1	86.1	400.0
2003-01-31 19:00:00	SPY	ETF	86.05	86.05	86.04	86.04	1100.0
2003-01-31 08:00:00	QQQ	ETF	24.57	24.6	24.48	24.55	154300.0
2003-01-31 09:00:00	QQQ	ETF	24.54	24.63	24.01	24.35	16704200.0
2003-01-31 10:00:00	QQQ	ETF	24.42	24.5	24.05	24.32	16444100.0
2003-01-31 11:00:00	QQQ	ETF	24.32	24.63	24.17	24.54	10272700.0
2003-01-31 12:00:00	QQQ	ETF	24.54	24.75	24.37	24.62	10010600.0
2003-01-31 13:00:00	QQQ	ETF	24.62	24.76	24.49	24.56	6344100.0
2003-01-31 14:00:00	QQQ	ETF	24.58	24.68	24.49	24.57	3925700.0
2003-01-31 15:00:00	QQQ	ETF	24.57	24.6	24.26	24.41	13281800.0
2003-01-31 16:00:00	QQQ	ETF	24.4	24.5	24.36	24.46	2555600.0
2003-01-31 17:00:00	QQQ	ETF	24.48	24.5	24.42	24.49	66300.0
2003-01-31 18:00:00	QQQ	ETF	24.49	24.5	24.47	24.47	7900.0
2003-01-31 19:00:00	QQQ	ETF	24.49	24.5	24.45	24.46	9900.0
2003-01-31 09:00:00	IWM	ETF	36.425	36.74	36.325	36.68	348800.0
2003-01-31 10:00:00	IWM	ETF	36.775	36.85	36.51	36.645	478800.0
2003-01-31 11:00:00	IWM	ETF	36.655	36.835	36.615	36.785	248400.0
2003-01-31 12:00:00	IWM	ETF	36.755	36.975	36.745	36.93	196200.0
2003-01-31 13:00:00	IWM	ETF	36.925	37.09	36.9	36.99	208200.0
2003-01-31 14:00:00	IWM	ETF	36.99	37.07	36.915	36.98	187000.0
2003-01-31 15:00:00	IWM	ETF	36.98	37.075	36.74	36.95	831200.0
2003-01-31 16:00:00	IWM	ETF	36.96	37.125	36.96	37.125	33400.0
2003-01-31 08:00:00	DIA	ETF	79.75	79.8	79.4	79.6	9500.0
2003-01-31 09:00:00	DIA	ETF	79.64	80.19	79.1	80.19	1239200.0
2003-01-31 10:00:00	DIA	ETF	80.0	80.6	79.59	80.15	2803200.0
2003-01-31 11:00:00	DIA	ETF	80.15	80.6	79.77	80.38	1126300.0
2003-01-31 12:00:00	DIA	ETF	80.37	80.94	80.22	80.62	1137100.0
2003-01-31 13:00:00	DIA	ETF	80.62	81.02	80.56	80.67	586700.0
2003-01-31 14:00:00	DIA	ETF	80.63	81.03	80.55	80.69	790200.0
2003-01-31 15:00:00	DIA	ETF	80.7	80.77	79.97	80.59	1395500.0
2003-01-31 16:00:00	DIA	ETF	80.6	80.99	80.57	80.98	172300.0
2003-01-31 17:00:00	DIA	ETF	80.97	81.0	80.9	80.98	5900.0
2003-01-31 18:00:00	DIA	ETF	80.98	80.99	80.95	80.99	2200.0
2003-01-31 19:00:00	DIA	ETF	80.82	80.95	80.82	80.95	1000.0
2003-01-31 09:00:00	TLT	ETF	87.9	87.9	87.75	87.77	3600.0
2003-01-31 10:00:00	TLT	ETF	87.55	88.15	87.54	88.03	74100.0
2003-01-31 11:00:00	TLT	ETF	88.04	88.21	88.0	88.08	8400.0
2003-01-31 12:00:00	TLT	ETF	88.1	88.1	87.97	88.05	44200.0
2003-01-31 13:00:00	TLT	ETF	88.12	88.16	87.98	88.07	8100.0
2003-01-31 14:00:00	TLT	ETF	88.07	88.12	88.03	88.03	32800.0

> showing 50 of 372 rows — these rows as CSV

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