PREVIEW / etf_1hour / 2003-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-23.parquet
  size:    19 KB
  rows:    470

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-23 08:00:00	SPY	ETF	102.8	102.93	102.63	102.86	218900.0
2003-10-23 09:00:00	SPY	ETF	102.86	103.53	102.82	103.5	8108500.0
2003-10-23 10:00:00	SPY	ETF	103.486	103.69	103.16	103.29	8951700.0
2003-10-23 11:00:00	SPY	ETF	103.26	103.35	102.97	103.28	4143600.0
2003-10-23 12:00:00	SPY	ETF	103.28	103.62	103.18	103.46	3059200.0
2003-10-23 13:00:00	SPY	ETF	103.47	103.79	103.36	103.73	4175400.0
2003-10-23 14:00:00	SPY	ETF	103.72	103.95	103.43	103.48	5389100.0
2003-10-23 15:00:00	SPY	ETF	103.49	103.756	103.33	103.74	3846900.0
2003-10-23 16:00:00	SPY	ETF	103.74	103.85	103.0	103.07	2761000.0
2003-10-23 17:00:00	SPY	ETF	103.09	103.2	103.05	103.15	176400.0
2003-10-23 18:00:00	SPY	ETF	103.14	103.14	102.42	102.66	471100.0
2003-10-23 19:00:00	SPY	ETF	102.7	102.7	102.64	102.7	17900.0
2003-10-23 08:00:00	QQQ	ETF	34.15	34.15	33.99	34.13	533300.0
2003-10-23 09:00:00	QQQ	ETF	34.12	34.43	34.05	34.39	13643700.0
2003-10-23 10:00:00	QQQ	ETF	34.39	34.507	34.16	34.28	17687900.0
2003-10-23 11:00:00	QQQ	ETF	34.28	34.34	34.1	34.21	11121400.0
2003-10-23 12:00:00	QQQ	ETF	34.2	34.36	34.15	34.31	8231000.0
2003-10-23 13:00:00	QQQ	ETF	34.31	34.42	34.26	34.39	6200800.0
2003-10-23 14:00:00	QQQ	ETF	34.39	34.46	34.23	34.28	7502900.0
2003-10-23 15:00:00	QQQ	ETF	34.29	34.36	34.2	34.34	10629500.0
2003-10-23 16:00:00	QQQ	ETF	34.34	34.44	33.94	33.97	9003800.0
2003-10-23 17:00:00	QQQ	ETF	33.962	34.02	33.95	33.95	1552300.0
2003-10-23 18:00:00	QQQ	ETF	33.96	33.97	33.61	33.75	3829900.0
2003-10-23 19:00:00	QQQ	ETF	33.76	33.77	33.72	33.76	77900.0
2003-10-23 20:00:00	QQQ	ETF	33.75	33.75	33.75	33.75	100.0
2003-10-23 08:00:00	IWM	ETF	50.745	50.745	50.745	50.745	400.0
2003-10-23 09:00:00	IWM	ETF	50.785	51.095	50.48	51.085	1824200.0
2003-10-23 10:00:00	IWM	ETF	51.085	51.085	50.66	50.66	1765800.0
2003-10-23 11:00:00	IWM	ETF	50.679	50.71	50.435	50.615	1563200.0
2003-10-23 12:00:00	IWM	ETF	50.63	50.84	50.595	50.78	421800.0
2003-10-23 13:00:00	IWM	ETF	50.785	50.965	50.755	50.965	446800.0
2003-10-23 14:00:00	IWM	ETF	50.975	51.251	50.955	51.05	827800.0
2003-10-23 15:00:00	IWM	ETF	51.04	51.07	50.88	50.92	676800.0
2003-10-23 16:00:00	IWM	ETF	50.92	51.01	50.566	50.57	573600.0
2003-10-23 18:00:00	IWM	ETF	50.56	50.56	50.285	50.285	3800.0
2003-10-23 08:00:00	DIA	ETF	95.59	95.75	95.47	95.68	48100.0
2003-10-23 09:00:00	DIA	ETF	95.7	96.34	95.64	96.28	1084400.0
2003-10-23 10:00:00	DIA	ETF	96.26	96.36	95.88	95.98	1263000.0
2003-10-23 11:00:00	DIA	ETF	95.97	96.02	95.67	95.89	790200.0
2003-10-23 12:00:00	DIA	ETF	95.92	96.13	95.81	96.07	583300.0
2003-10-23 13:00:00	DIA	ETF	96.02	96.32	95.95	96.25	611300.0
2003-10-23 14:00:00	DIA	ETF	96.27	96.37	95.92	95.98	683100.0
2003-10-23 15:00:00	DIA	ETF	96.0	96.3	95.89	96.255	734500.0
2003-10-23 16:00:00	DIA	ETF	96.253	96.26	95.65	95.75	210900.0
2003-10-23 18:00:00	DIA	ETF	95.67	95.67	95.33	95.53	7200.0
2003-10-23 19:00:00	DIA	ETF	95.52	95.52	95.5	95.5	700.0
2003-10-23 09:00:00	TLT	ETF	85.0	85.0	84.77	84.79	159800.0
2003-10-23 10:00:00	TLT	ETF	84.79	84.8	84.45	84.55	641300.0
2003-10-23 11:00:00	TLT	ETF	84.5	84.64	84.26	84.3	91100.0
2003-10-23 12:00:00	TLT	ETF	84.3	84.33	84.02	84.2	76900.0

> showing 50 of 470 rows — these rows as CSV

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