PREVIEW / etf_1hour / 2003-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-22.parquet
  size:    18 KB
  rows:    468

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-10-22 08:00:00	SPY	ETF	104.27	104.28	104.19	104.2	171700.0
2003-10-22 09:00:00	SPY	ETF	104.2	104.23	103.75	103.828	4678900.0
2003-10-22 10:00:00	SPY	ETF	103.83	104.19	103.56	103.66	6491300.0
2003-10-22 11:00:00	SPY	ETF	103.69	103.78	103.55	103.7	2793300.0
2003-10-22 12:00:00	SPY	ETF	103.71	103.75	103.51	103.61	2394100.0
2003-10-22 13:00:00	SPY	ETF	103.584	103.62	103.19	103.359	4017400.0
2003-10-22 14:00:00	SPY	ETF	103.349	103.59	103.19	103.51	4359100.0
2003-10-22 15:00:00	SPY	ETF	103.55	103.65	103.26	103.4	4904400.0
2003-10-22 16:00:00	SPY	ETF	103.42	103.65	103.41	103.45	1543500.0
2003-10-22 17:00:00	SPY	ETF	103.523	103.53	103.08	103.18	491400.0
2003-10-22 18:00:00	SPY	ETF	103.17	103.22	103.1	103.22	28500.0
2003-10-22 19:00:00	SPY	ETF	103.25	103.25	103.16	103.2	6200.0
2003-10-22 08:00:00	QQQ	ETF	35.0	35.0	34.91	34.93	172300.0
2003-10-22 09:00:00	QQQ	ETF	34.93	34.94	34.68	34.79	14380500.0
2003-10-22 10:00:00	QQQ	ETF	34.78	34.93	34.56	34.66	14512000.0
2003-10-22 11:00:00	QQQ	ETF	34.679	34.73	34.62	34.709	11366500.0
2003-10-22 12:00:00	QQQ	ETF	34.71	34.72	34.58	34.61	3607900.0
2003-10-22 13:00:00	QQQ	ETF	34.61	34.62	34.44	34.52	10795700.0
2003-10-22 14:00:00	QQQ	ETF	34.53	34.67	34.48	34.61	9449500.0
2003-10-22 15:00:00	QQQ	ETF	34.61	34.67	34.46	34.56	12317000.0
2003-10-22 16:00:00	QQQ	ETF	34.562	34.61	34.4	34.52	3155500.0
2003-10-22 17:00:00	QQQ	ETF	34.499	34.52	34.15	34.24	1710200.0
2003-10-22 18:00:00	QQQ	ETF	34.242	34.27	34.21	34.25	353800.0
2003-10-22 19:00:00	QQQ	ETF	34.24	34.27	34.23	34.26	37900.0
2003-10-22 09:00:00	IWM	ETF	51.833	51.945	51.405	51.4725	1034200.0
2003-10-22 10:00:00	IWM	ETF	51.51	51.75	51.375	51.57	754800.0
2003-10-22 11:00:00	IWM	ETF	51.56	51.655	51.5	51.655	518200.0
2003-10-22 12:00:00	IWM	ETF	51.66	51.695	51.53	51.57	666200.0
2003-10-22 13:00:00	IWM	ETF	51.56	51.57	51.195	51.31	731800.0
2003-10-22 14:00:00	IWM	ETF	51.308	51.56	51.275	51.49	778800.0
2003-10-22 15:00:00	IWM	ETF	51.5075	51.625	51.195	51.25	1263000.0
2003-10-22 16:00:00	IWM	ETF	51.22	51.515	51.105	51.105	685400.0
2003-10-22 17:00:00	IWM	ETF	51.1	51.105	51.0	51.0	31200.0
2003-10-22 19:00:00	IWM	ETF	51.05	51.05	51.05	51.05	1000.0
2003-10-22 08:00:00	DIA	ETF	96.96	96.99	96.81	96.84	13000.0
2003-10-22 09:00:00	DIA	ETF	96.84	96.939	96.56	96.62	762500.0
2003-10-22 10:00:00	DIA	ETF	96.63	96.89	96.33	96.51	1141600.0
2003-10-22 11:00:00	DIA	ETF	96.55	96.62	96.44	96.48	664400.0
2003-10-22 12:00:00	DIA	ETF	96.46	96.58	96.32	96.34	727900.0
2003-10-22 13:00:00	DIA	ETF	96.34	96.37	95.98	96.12	1007300.0
2003-10-22 14:00:00	DIA	ETF	96.07	96.35	95.96	96.19	987600.0
2003-10-22 15:00:00	DIA	ETF	96.21	96.34	96.0	96.2	834300.0
2003-10-22 16:00:00	DIA	ETF	96.17	96.29	96.16	96.2	263600.0
2003-10-22 17:00:00	DIA	ETF	96.15	96.21	95.8	95.91	9100.0
2003-10-22 18:00:00	DIA	ETF	95.9	95.94	95.9	95.94	1600.0
2003-10-22 19:00:00	DIA	ETF	95.94	95.94	95.9	95.9	300.0
2003-10-22 09:00:00	TLT	ETF	84.6	84.73	84.51	84.62	113600.0
2003-10-22 10:00:00	TLT	ETF	84.6	84.64	84.4	84.59	91000.0
2003-10-22 11:00:00	TLT	ETF	84.58	84.76	84.58	84.73	233500.0
2003-10-22 12:00:00	TLT	ETF	84.78	84.83	84.72	84.76	13700.0

> showing 50 of 468 rows — these rows as CSV

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