PREVIEW / etf_1hour / 2003-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-07.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-10-07 08:00:00	SPY	ETF	103.45	103.45	103.25	103.29	37600.0
2003-10-07 09:00:00	SPY	ETF	103.31	103.37	103.05	103.26	4817800.0
2003-10-07 10:00:00	SPY	ETF	103.27	103.49	102.91	103.34	5571900.0
2003-10-07 11:00:00	SPY	ETF	103.33	103.84	103.21	103.69	5128800.0
2003-10-07 12:00:00	SPY	ETF	103.66	103.82	103.387	103.51	2414400.0
2003-10-07 13:00:00	SPY	ETF	103.508	103.65	103.11	103.24	2188200.0
2003-10-07 14:00:00	SPY	ETF	103.24	103.969	103.21	103.85	3824000.0
2003-10-07 15:00:00	SPY	ETF	103.86	104.26	103.8	104.19	7793300.0
2003-10-07 16:00:00	SPY	ETF	104.21	104.33	103.7375	104.27	2722100.0
2003-10-07 17:00:00	SPY	ETF	104.28	104.294	104.26	104.26	19200.0
2003-10-07 18:00:00	SPY	ETF	104.28	104.28	104.21	104.21	5400.0
2003-10-07 19:00:00	SPY	ETF	104.25	104.26	104.21	104.21	15500.0
2003-10-07 08:00:00	QQQ	ETF	34.24	34.24	34.15	34.16	110600.0
2003-10-07 09:00:00	QQQ	ETF	34.17	34.21	34.01	34.17	8659300.0
2003-10-07 10:00:00	QQQ	ETF	34.17	34.26	34.02	34.18	12794800.0
2003-10-07 11:00:00	QQQ	ETF	34.2	34.501	34.14	34.408	11508400.0
2003-10-07 12:00:00	QQQ	ETF	34.41	34.465	34.19	34.23	6193700.0
2003-10-07 13:00:00	QQQ	ETF	34.23	34.3	34.06	34.13	5829300.0
2003-10-07 14:00:00	QQQ	ETF	34.118	34.45	34.1	34.42	7802800.0
2003-10-07 15:00:00	QQQ	ETF	34.416	34.611	34.37	34.57	12358300.0
2003-10-07 16:00:00	QQQ	ETF	34.572	34.69	34.55	34.69	2436200.0
2003-10-07 17:00:00	QQQ	ETF	34.661	34.677	34.3476	34.67	2396600.0
2003-10-07 18:00:00	QQQ	ETF	34.67	34.68	34.62	34.62	65500.0
2003-10-07 19:00:00	QQQ	ETF	34.64	34.67	34.62	34.65	12000.0
2003-10-07 08:00:00	IWM	ETF	51.3	51.3	51.3	51.3	200.0
2003-10-07 09:00:00	IWM	ETF	51.205	51.425	51.175	51.375	818400.0
2003-10-07 10:00:00	IWM	ETF	51.36	51.6	51.135	51.525	1197800.0
2003-10-07 11:00:00	IWM	ETF	51.53	51.75	51.465	51.67	722800.0
2003-10-07 12:00:00	IWM	ETF	51.66	51.7	51.425	51.48	739600.0
2003-10-07 13:00:00	IWM	ETF	51.48	51.525	51.335	51.375	611200.0
2003-10-07 14:00:00	IWM	ETF	51.385	51.75	51.375	51.73	875000.0
2003-10-07 15:00:00	IWM	ETF	51.725	51.915	51.7	51.915	1543400.0
2003-10-07 16:00:00	IWM	ETF	51.955	51.955	51.84	51.84	212200.0
2003-10-07 08:00:00	DIA	ETF	95.81	95.86	95.81	95.81	11300.0
2003-10-07 09:00:00	DIA	ETF	95.81	95.89	95.63	95.81	534700.0
2003-10-07 10:00:00	DIA	ETF	95.74	96.04	95.55	95.91	884900.0
2003-10-07 11:00:00	DIA	ETF	95.9	96.38	95.86	96.23	865600.0
2003-10-07 12:00:00	DIA	ETF	96.23	96.35	95.98	96.05	606700.0
2003-10-07 13:00:00	DIA	ETF	96.04	96.18	95.72	95.8	459800.0
2003-10-07 14:00:00	DIA	ETF	95.82	96.47	95.76	96.36	825500.0
2003-10-07 15:00:00	DIA	ETF	96.4	96.69	96.27	96.62	1262200.0
2003-10-07 16:00:00	DIA	ETF	96.66	96.78	96.61	96.73	387100.0
2003-10-07 17:00:00	DIA	ETF	96.69	96.69	96.69	96.69	1000.0
2003-10-07 18:00:00	DIA	ETF	96.74	96.75	96.74	96.75	200.0
2003-10-07 19:00:00	DIA	ETF	96.7	96.7	96.7	96.7	100.0
2003-10-07 09:00:00	TLT	ETF	85.45	85.57	85.23	85.29	169600.0
2003-10-07 10:00:00	TLT	ETF	85.31	85.31	84.91	85.09	58500.0
2003-10-07 11:00:00	TLT	ETF	85.06	85.07	84.9	84.94	52700.0
2003-10-07 12:00:00	TLT	ETF	84.92	85.08	84.88	85.01	17500.0
2003-10-07 13:00:00	TLT	ETF	85.05	85.07	84.8	84.9	29900.0

> showing 50 of 442 rows — these rows as CSV

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