PREVIEW / etf_1hour / 2003-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-01-27.parquet
  size:    17 KB
  rows:    410

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-27 08:00:00	SPY	ETF	85.34	85.35	85.12	85.18	125700.0
2003-01-27 09:00:00	SPY	ETF	85.18	86.5	85.11	86.43	8980900.0
2003-01-27 10:00:00	SPY	ETF	86.46	86.8	85.48	85.86	11391000.0
2003-01-27 11:00:00	SPY	ETF	85.85	85.93	84.73	84.81	7399000.0
2003-01-27 12:00:00	SPY	ETF	84.81	85.49	84.65	85.25	5999300.0
2003-01-27 13:00:00	SPY	ETF	85.25	85.5	85.04	85.16	4373100.0
2003-01-27 14:00:00	SPY	ETF	85.16	85.26	84.66	84.85	5383700.0
2003-01-27 15:00:00	SPY	ETF	84.85	85.5	84.7	85.03	7604200.0
2003-01-27 16:00:00	SPY	ETF	85.04	85.3	84.94	85.17	1438200.0
2003-01-27 17:00:00	SPY	ETF	85.2	85.23	84.84	85.11	694200.0
2003-01-27 18:00:00	SPY	ETF	85.11	85.24	85.11	85.24	7100.0
2003-01-27 19:00:00	SPY	ETF	85.23	85.25	85.18	85.25	8500.0
2003-01-27 08:00:00	QQQ	ETF	24.51	24.51	24.33	24.43	133100.0
2003-01-27 09:00:00	QQQ	ETF	24.42	24.98	24.4	24.9	10953600.0
2003-01-27 10:00:00	QQQ	ETF	24.95	25.03	24.6	24.73	12828200.0
2003-01-27 11:00:00	QQQ	ETF	24.74	24.81	24.4	24.46	10639600.0
2003-01-27 12:00:00	QQQ	ETF	24.43	24.65	24.41	24.58	8613800.0
2003-01-27 13:00:00	QQQ	ETF	24.58	24.68	24.49	24.56	6211300.0
2003-01-27 14:00:00	QQQ	ETF	24.53	24.56	24.39	24.45	6787600.0
2003-01-27 15:00:00	QQQ	ETF	24.47	24.67	24.37	24.54	11131100.0
2003-01-27 16:00:00	QQQ	ETF	24.54	24.63	24.46	24.61	2764600.0
2003-01-27 17:00:00	QQQ	ETF	24.6	24.63	24.56	24.56	219200.0
2003-01-27 18:00:00	QQQ	ETF	24.55	24.6	24.54	24.58	17000.0
2003-01-27 19:00:00	QQQ	ETF	24.63	24.63	24.56	24.6	13000.0
2003-01-27 09:00:00	IWM	ETF	36.8	37.18	36.8	37.175	319800.0
2003-01-27 10:00:00	IWM	ETF	37.2	37.305	37.0	37.095	739800.0
2003-01-27 11:00:00	IWM	ETF	37.075	37.08	36.745	36.745	481200.0
2003-01-27 12:00:00	IWM	ETF	36.745	36.86	36.7	36.825	225800.0
2003-01-27 13:00:00	IWM	ETF	36.805	36.86	36.735	36.735	277400.0
2003-01-27 14:00:00	IWM	ETF	36.725	36.75	36.575	36.605	720600.0
2003-01-27 15:00:00	IWM	ETF	36.605	36.725	36.575	36.585	531000.0
2003-01-27 16:00:00	IWM	ETF	36.67	36.71	36.6	36.6	33600.0
2003-01-27 08:00:00	DIA	ETF	80.22	80.45	80.05	80.31	6500.0
2003-01-27 09:00:00	DIA	ETF	80.34	81.46	80.26	81.43	1368400.0
2003-01-27 10:00:00	DIA	ETF	81.4	81.8	80.45	80.86	2300000.0
2003-01-27 11:00:00	DIA	ETF	80.83	80.94	79.73	79.81	1537000.0
2003-01-27 12:00:00	DIA	ETF	79.81	80.45	79.61	80.2	1258200.0
2003-01-27 13:00:00	DIA	ETF	80.2	80.45	79.96	80.18	713100.0
2003-01-27 14:00:00	DIA	ETF	80.1	80.2	79.76	79.99	1125700.0
2003-01-27 15:00:00	DIA	ETF	79.94	80.55	79.81	80.02	1390800.0
2003-01-27 16:00:00	DIA	ETF	80.05	80.31	79.98	80.21	166000.0
2003-01-27 17:00:00	DIA	ETF	80.27	80.34	80.2	80.2	8500.0
2003-01-27 18:00:00	DIA	ETF	80.17	80.24	80.15	80.24	1000.0
2003-01-27 19:00:00	DIA	ETF	80.25	80.25	80.18	80.18	1100.0
2003-01-27 09:00:00	TLT	ETF	87.9	87.95	87.61	87.61	37700.0
2003-01-27 10:00:00	TLT	ETF	87.51	87.86	87.5	87.8	54900.0
2003-01-27 11:00:00	TLT	ETF	87.8	88.04	87.79	87.9	16200.0
2003-01-27 12:00:00	TLT	ETF	87.76	87.76	87.53	87.61	11700.0
2003-01-27 13:00:00	TLT	ETF	87.61	87.64	87.51	87.56	15900.0
2003-01-27 14:00:00	TLT	ETF	87.61	87.62	87.55	87.55	2900.0

> showing 50 of 410 rows — these rows as CSV

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