PREVIEW / etf_1hour / 2003-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-24.parquet
  size:    19 KB
  rows:    502

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-24 08:00:00	SPY	ETF	104.76	104.83	104.71	104.75	41000.0
2003-11-24 09:00:00	SPY	ETF	104.76	105.04	104.65	104.97	3931800.0
2003-11-24 10:00:00	SPY	ETF	104.97	105.47	104.92	105.42	5601200.0
2003-11-24 11:00:00	SPY	ETF	105.41	105.54	105.28	105.43	3026400.0
2003-11-24 12:00:00	SPY	ETF	105.43	105.45	105.26	105.36	1045400.0
2003-11-24 13:00:00	SPY	ETF	105.36	105.5	105.24	105.39	1793700.0
2003-11-24 14:00:00	SPY	ETF	105.39	105.56	105.33	105.48	2255100.0
2003-11-24 15:00:00	SPY	ETF	105.49	105.77	105.45	105.73	5732700.0
2003-11-24 16:00:00	SPY	ETF	105.76	105.78	105.54	105.59	2467800.0
2003-11-24 17:00:00	SPY	ETF	105.59	105.64	105.57	105.6	70400.0
2003-11-24 18:00:00	SPY	ETF	105.6	105.67	105.6	105.6	4300.0
2003-11-24 19:00:00	SPY	ETF	105.67	105.67	105.65	105.65	6500.0
2003-11-24 08:00:00	QQQ	ETF	34.49	34.51	34.46	34.5	176300.0
2003-11-24 09:00:00	QQQ	ETF	34.49	34.66	34.47	34.585	11413700.0
2003-11-24 10:00:00	QQQ	ETF	34.57	34.87	34.56	34.87	16262900.0
2003-11-24 11:00:00	QQQ	ETF	34.87	34.941	34.81	34.89	10534300.0
2003-11-24 12:00:00	QQQ	ETF	34.89	34.921	34.8	34.87	3448600.0
2003-11-24 13:00:00	QQQ	ETF	34.87	34.93	34.8	34.85	5327700.0
2003-11-24 14:00:00	QQQ	ETF	34.85	35.0	34.82	34.952	8706700.0
2003-11-24 15:00:00	QQQ	ETF	34.953	35.24	34.95	35.236	20168500.0
2003-11-24 16:00:00	QQQ	ETF	35.23	35.257	34.1554	35.18	6889500.0
2003-11-24 17:00:00	QQQ	ETF	35.19	35.21	35.15	35.17	176100.0
2003-11-24 18:00:00	QQQ	ETF	35.18	35.24	35.18	35.24	37300.0
2003-11-24 19:00:00	QQQ	ETF	35.23	35.24	35.22	35.23	16800.0
2003-11-24 09:00:00	IWM	ETF	52.975	53.35	52.9	53.29	1438600.0
2003-11-24 10:00:00	IWM	ETF	53.2865	53.66	53.22	53.525	1287400.0
2003-11-24 11:00:00	IWM	ETF	53.525	53.65	53.4	53.435	621600.0
2003-11-24 12:00:00	IWM	ETF	53.455	53.475	53.357	53.455	647000.0
2003-11-24 13:00:00	IWM	ETF	53.455	53.5	53.35	53.437	305000.0
2003-11-24 14:00:00	IWM	ETF	53.43	53.575	53.41	53.505	758200.0
2003-11-24 15:00:00	IWM	ETF	53.495	53.845	53.495	53.825	1371000.0
2003-11-24 16:00:00	IWM	ETF	53.82	53.9	53.8	53.845	646000.0
2003-11-24 17:00:00	IWM	ETF	53.825	53.825	53.825	53.825	10000.0
2003-11-24 18:00:00	IWM	ETF	53.798	53.824	53.798	53.824	2000.0
2003-11-24 08:00:00	DIA	ETF	96.9	96.95	96.89	96.89	14800.0
2003-11-24 09:00:00	DIA	ETF	96.89	97.11	96.55	97.04	538800.0
2003-11-24 10:00:00	DIA	ETF	97.04	97.5	97.0	97.47	1121200.0
2003-11-24 11:00:00	DIA	ETF	97.48	97.64	97.38	97.5	669700.0
2003-11-24 12:00:00	DIA	ETF	97.5	97.51	97.34	97.42	125400.0
2003-11-24 13:00:00	DIA	ETF	97.4	97.53	97.28	97.402	172700.0
2003-11-24 14:00:00	DIA	ETF	97.4	97.54	97.38	97.43	395000.0
2003-11-24 15:00:00	DIA	ETF	97.43	97.65	97.38	97.59	1040800.0
2003-11-24 16:00:00	DIA	ETF	97.59	97.64	97.47	97.55	141400.0
2003-11-24 17:00:00	DIA	ETF	97.52	97.52	97.51	97.51	1200.0
2003-11-24 18:00:00	DIA	ETF	97.52	97.52	97.52	97.52	100.0
2003-11-24 19:00:00	DIA	ETF	97.6	97.6	97.6	97.6	100.0
2003-11-24 09:00:00	TLT	ETF	86.18	86.28	86.15	86.25	53500.0
2003-11-24 10:00:00	TLT	ETF	86.25	86.31	86.07	86.1	146100.0
2003-11-24 11:00:00	TLT	ETF	86.06	86.1	85.87	85.9	70300.0
2003-11-24 12:00:00	TLT	ETF	85.87	85.96	85.79	85.83	92200.0

> showing 50 of 502 rows — these rows as CSV

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