PREVIEW / etf_1hour / 2003-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-24.parquet
  size:    18 KB
  rows:    442

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-09-24 08:00:00	SPY	ETF	103.13	103.13	103.04	103.1	11800.0
2003-09-24 09:00:00	SPY	ETF	103.09	103.22	102.87	102.91	2371700.0
2003-09-24 10:00:00	SPY	ETF	102.9	103.03	102.581	102.68	4198100.0
2003-09-24 11:00:00	SPY	ETF	102.67	102.83	102.15	102.18	3696800.0
2003-09-24 12:00:00	SPY	ETF	102.15	102.2	101.39	101.66	7966700.0
2003-09-24 13:00:00	SPY	ETF	101.65	101.73	101.25	101.46	5676800.0
2003-09-24 14:00:00	SPY	ETF	101.46	101.66	101.26	101.37	3812500.0
2003-09-24 15:00:00	SPY	ETF	101.37	101.54	101.07	101.2	6985900.0
2003-09-24 16:00:00	SPY	ETF	101.19	101.24	101.07	101.07	1605700.0
2003-09-24 17:00:00	SPY	ETF	101.06	101.24	101.05	101.135	44100.0
2003-09-24 18:00:00	SPY	ETF	101.09	101.15	101.08	101.11	7300.0
2003-09-24 19:00:00	SPY	ETF	101.15	101.16	101.13	101.16	2000.0
2003-09-24 08:00:00	QQQ	ETF	34.6	34.6	34.53	34.54	128800.0
2003-09-24 09:00:00	QQQ	ETF	34.54	34.55	34.249	34.28	12730300.0
2003-09-24 10:00:00	QQQ	ETF	34.29	34.36	34.15	34.236	10342500.0
2003-09-24 11:00:00	QQQ	ETF	34.23	34.333	33.988	34.01	10380300.0
2003-09-24 12:00:00	QQQ	ETF	34.01	34.02	33.552	33.73	19165900.0
2003-09-24 13:00:00	QQQ	ETF	33.734	33.75	33.52	33.6	11492100.0
2003-09-24 14:00:00	QQQ	ETF	33.59	33.755	33.5	33.54	11458800.0
2003-09-24 15:00:00	QQQ	ETF	33.531	33.62	33.26	33.35	18047100.0
2003-09-24 16:00:00	QQQ	ETF	33.36	33.4	33.17	33.21	4304400.0
2003-09-24 17:00:00	QQQ	ETF	33.22	33.38	33.15	33.26	1773500.0
2003-09-24 18:00:00	QQQ	ETF	33.26	33.313	33.26	33.3	74900.0
2003-09-24 19:00:00	QQQ	ETF	33.28	33.34	33.27	33.34	34100.0
2003-09-24 09:00:00	IWM	ETF	51.9	51.925	51.635	51.735	138400.0
2003-09-24 10:00:00	IWM	ETF	51.74	51.765	51.53	51.69	886400.0
2003-09-24 11:00:00	IWM	ETF	51.695	51.8	51.41	51.44	1068000.0
2003-09-24 12:00:00	IWM	ETF	51.41	51.41	50.925	51.055	1335800.0
2003-09-24 13:00:00	IWM	ETF	51.085	51.095	50.87	50.91	614200.0
2003-09-24 14:00:00	IWM	ETF	50.925	50.975	50.78	50.79	382800.0
2003-09-24 15:00:00	IWM	ETF	50.795	50.855	50.582	50.61	487000.0
2003-09-24 16:00:00	IWM	ETF	50.565	50.635	50.505	50.6	100200.0
2003-09-24 08:00:00	DIA	ETF	95.93	95.98	95.85	95.85	3300.0
2003-09-24 09:00:00	DIA	ETF	95.9	96.07	95.79	95.81	562600.0
2003-09-24 10:00:00	DIA	ETF	95.81	95.92	95.55	95.61	879600.0
2003-09-24 11:00:00	DIA	ETF	95.61	95.708	95.16	95.16	773900.0
2003-09-24 12:00:00	DIA	ETF	95.2	95.2	94.49	94.79	1220800.0
2003-09-24 13:00:00	DIA	ETF	94.76	94.83	94.44	94.6	613100.0
2003-09-24 14:00:00	DIA	ETF	94.63	94.79	94.42	94.53	380100.0
2003-09-24 15:00:00	DIA	ETF	94.53	94.63	94.31	94.4	903000.0
2003-09-24 16:00:00	DIA	ETF	94.41	94.47	94.33	94.33	104800.0
2003-09-24 17:00:00	DIA	ETF	94.38	94.45	94.33	94.45	1800.0
2003-09-24 18:00:00	DIA	ETF	94.45	94.45	94.26	94.26	300.0
2003-09-24 19:00:00	DIA	ETF	94.33	94.33	94.26	94.26	500.0
2003-09-24 09:00:00	TLT	ETF	85.54	85.6	85.366	85.45	30800.0
2003-09-24 10:00:00	TLT	ETF	85.48	85.69	85.35	85.49	136200.0
2003-09-24 11:00:00	TLT	ETF	85.45	85.54	85.42	85.52	96300.0
2003-09-24 12:00:00	TLT	ETF	85.55	85.88	85.52	85.8	105500.0
2003-09-24 13:00:00	TLT	ETF	85.8	86.3	85.76	86.3	248200.0
2003-09-24 14:00:00	TLT	ETF	86.31	86.49	86.2	86.261	126300.0

> showing 50 of 442 rows — these rows as CSV

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