PREVIEW / etf_1hour / 2003-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-18.parquet
  size:    20 KB
  rows:    503

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-11-18 08:00:00	SPY	ETF	105.09	105.22	105.05	105.2	199400.0
2003-11-18 09:00:00	SPY	ETF	105.21	105.45	105.17	105.329	3769100.0
2003-11-18 10:00:00	SPY	ETF	105.35	105.39	104.78	105.01	4939000.0
2003-11-18 11:00:00	SPY	ETF	105.01	105.23	104.79	104.81	2450000.0
2003-11-18 12:00:00	SPY	ETF	104.81	104.94	104.68	104.89	3115600.0
2003-11-18 13:00:00	SPY	ETF	104.9	105.03	104.37	104.43	3315500.0
2003-11-18 14:00:00	SPY	ETF	104.41	104.52	104.03	104.23	6459900.0
2003-11-18 15:00:00	SPY	ETF	104.22	104.39	103.9	103.91	6920600.0
2003-11-18 16:00:00	SPY	ETF	103.93	104.912	103.7	103.86	4841900.0
2003-11-18 17:00:00	SPY	ETF	103.86	103.86	103.79	103.84	16100.0
2003-11-18 18:00:00	SPY	ETF	103.81	103.82	103.77	103.77	3200.0
2003-11-18 19:00:00	SPY	ETF	103.77	103.77	103.7	103.7	1200.0
2003-11-18 08:00:00	QQQ	ETF	34.81	34.85	34.79	34.84	252000.0
2003-11-18 09:00:00	QQQ	ETF	34.83	34.97	34.8	34.87	11922700.0
2003-11-18 10:00:00	QQQ	ETF	34.87	34.89	34.54	34.68	15747100.0
2003-11-18 11:00:00	QQQ	ETF	34.684	34.8	34.48	34.5	10041300.0
2003-11-18 12:00:00	QQQ	ETF	34.49	34.543	34.407	34.506	8909400.0
2003-11-18 13:00:00	QQQ	ETF	34.51	34.62	34.27	34.33	7158500.0
2003-11-18 14:00:00	QQQ	ETF	34.32	34.42	34.12	34.208	15053100.0
2003-11-18 15:00:00	QQQ	ETF	34.21	34.27	33.95	33.98	21270900.0
2003-11-18 16:00:00	QQQ	ETF	33.98	34.005	33.81	33.88	5970100.0
2003-11-18 17:00:00	QQQ	ETF	33.87	33.9	33.86	33.87	86100.0
2003-11-18 18:00:00	QQQ	ETF	33.87	33.88	33.83	33.83	93400.0
2003-11-18 19:00:00	QQQ	ETF	33.83	33.85	33.79	33.79	25300.0
2003-11-18 09:00:00	IWM	ETF	52.68	53.095	52.68	53.025	1157400.0
2003-11-18 10:00:00	IWM	ETF	53.076	53.095	52.65	52.805	1418400.0
2003-11-18 11:00:00	IWM	ETF	52.805	52.993	52.71	52.81	1344000.0
2003-11-18 12:00:00	IWM	ETF	52.81	52.86	52.65	52.73	603000.0
2003-11-18 13:00:00	IWM	ETF	52.73	52.825	52.335	52.355	1085800.0
2003-11-18 14:00:00	IWM	ETF	52.365	52.43	51.99	52.1	1559200.0
2003-11-18 15:00:00	IWM	ETF	52.125	52.22	51.932	52.02	2270000.0
2003-11-18 16:00:00	IWM	ETF	51.933	52.065	51.845	51.88	1061800.0
2003-11-18 17:00:00	IWM	ETF	52.27	52.27	52.27	52.27	800.0
2003-11-18 18:00:00	IWM	ETF	51.89	51.89	51.89	51.89	800.0
2003-11-18 19:00:00	IWM	ETF	51.825	51.825	51.825	51.825	200.0
2003-11-18 08:00:00	DIA	ETF	97.71	97.71	97.65	97.65	800.0
2003-11-18 09:00:00	DIA	ETF	97.78	97.9	97.6	97.81	468800.0
2003-11-18 10:00:00	DIA	ETF	97.8	97.836	97.3	97.55	726100.0
2003-11-18 11:00:00	DIA	ETF	97.5	97.714	97.37	97.41	391200.0
2003-11-18 12:00:00	DIA	ETF	97.38	97.52	97.32	97.51	230500.0
2003-11-18 13:00:00	DIA	ETF	97.5	97.58	97.0	97.06	394300.0
2003-11-18 14:00:00	DIA	ETF	97.06	97.15	96.7	96.86	628700.0
2003-11-18 15:00:00	DIA	ETF	96.89	97.0	96.58	96.64	955600.0
2003-11-18 16:00:00	DIA	ETF	96.59	96.67	96.47	96.6	153300.0
2003-11-18 17:00:00	DIA	ETF	96.6	96.6	96.6	96.6	300.0
2003-11-18 18:00:00	DIA	ETF	96.5	96.6	96.5	96.58	400.0
2003-11-18 09:00:00	TLT	ETF	85.97	85.97	85.78	85.95	57000.0
2003-11-18 10:00:00	TLT	ETF	86.0	86.24	85.96	86.17	139500.0
2003-11-18 11:00:00	TLT	ETF	86.2	86.3	86.12	86.21	112900.0
2003-11-18 12:00:00	TLT	ETF	86.25	86.33	86.1	86.16	24700.0

> showing 50 of 503 rows — these rows as CSV

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