PREVIEW / etf_1hour / 2003-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-27.parquet
  size:    17 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-27 08:00:00	SPY	ETF	103.88	103.93	103.82	103.88	132300.0
2003-10-27 09:00:00	SPY	ETF	103.91	104.06	103.71	104.02	5005300.0
2003-10-27 10:00:00	SPY	ETF	104.02	104.18	103.72	103.81	6575900.0
2003-10-27 11:00:00	SPY	ETF	103.78	103.85	103.48	103.6	2897900.0
2003-10-27 12:00:00	SPY	ETF	103.6	103.81	103.58	103.65	2347500.0
2003-10-27 13:00:00	SPY	ETF	103.63	103.81	103.56	103.63	1565500.0
2003-10-27 14:00:00	SPY	ETF	103.64	103.64	103.35	103.43	3180400.0
2003-10-27 15:00:00	SPY	ETF	103.43	103.76	103.27	103.44	4643400.0
2003-10-27 16:00:00	SPY	ETF	103.42	103.76	103.41	103.6	1348600.0
2003-10-27 17:00:00	SPY	ETF	103.6	103.7	103.6	103.65	22900.0
2003-10-27 18:00:00	SPY	ETF	103.69	103.73	103.65	103.65	28300.0
2003-10-27 19:00:00	SPY	ETF	103.64	103.65	103.64	103.65	11000.0
2003-10-27 08:00:00	QQQ	ETF	34.34	34.34	34.27	34.32	228600.0
2003-10-27 09:00:00	QQQ	ETF	34.32	34.4	34.27	34.39	11516900.0
2003-10-27 10:00:00	QQQ	ETF	34.39	34.45	34.12	34.19	13763800.0
2003-10-27 11:00:00	QQQ	ETF	34.21	34.23	34.04	34.11	7768400.0
2003-10-27 12:00:00	QQQ	ETF	34.1	34.22	34.09	34.14	3288400.0
2003-10-27 13:00:00	QQQ	ETF	34.141	34.25	34.12	34.199	3972000.0
2003-10-27 14:00:00	QQQ	ETF	34.19	34.2	34.05	34.135	5018600.0
2003-10-27 15:00:00	QQQ	ETF	34.14	34.29	34.05	34.18	7012900.0
2003-10-27 16:00:00	QQQ	ETF	34.18	34.3	34.1172	34.225	1788800.0
2003-10-27 17:00:00	QQQ	ETF	34.211	34.29	34.211	34.28	40300.0
2003-10-27 18:00:00	QQQ	ETF	34.29	34.3	34.27	34.27	34000.0
2003-10-27 19:00:00	QQQ	ETF	34.28	34.3	34.27	34.27	14200.0
2003-10-27 09:00:00	IWM	ETF	50.655	51.355	50.655	51.355	1065400.0
2003-10-27 10:00:00	IWM	ETF	51.345	51.555	51.165	51.17	2061400.0
2003-10-27 11:00:00	IWM	ETF	51.165	51.25	51.08	51.135	412800.0
2003-10-27 12:00:00	IWM	ETF	51.145	51.25	51.145	51.22	251000.0
2003-10-27 13:00:00	IWM	ETF	51.205	51.33	51.19	51.25	162600.0
2003-10-27 14:00:00	IWM	ETF	51.245	51.285	51.095	51.25	1424000.0
2003-10-27 15:00:00	IWM	ETF	51.25	51.46	51.2	51.328	925600.0
2003-10-27 16:00:00	IWM	ETF	51.325	51.41	51.275	51.275	485800.0
2003-10-27 08:00:00	DIA	ETF	96.5	96.58	96.46	96.58	3400.0
2003-10-27 09:00:00	DIA	ETF	96.54	96.65	96.36	96.62	461600.0
2003-10-27 10:00:00	DIA	ETF	96.64	96.77	96.41	96.52	836200.0
2003-10-27 11:00:00	DIA	ETF	96.47	96.55	96.33	96.4	244700.0
2003-10-27 12:00:00	DIA	ETF	96.42	96.58	96.39	96.45	194600.0
2003-10-27 13:00:00	DIA	ETF	96.41	96.59	96.35	96.4	238800.0
2003-10-27 14:00:00	DIA	ETF	96.39	96.41	96.07	96.2	540300.0
2003-10-27 15:00:00	DIA	ETF	96.24	96.5	96.06	96.2	799200.0
2003-10-27 16:00:00	DIA	ETF	96.21	96.31	96.15	96.29	81000.0
2003-10-27 17:00:00	DIA	ETF	96.29	96.3	96.29	96.3	3700.0
2003-10-27 18:00:00	DIA	ETF	96.3	96.3	96.3	96.3	1500.0
2003-10-27 19:00:00	DIA	ETF	96.3	96.3	96.3	96.3	500.0
2003-10-27 09:00:00	TLT	ETF	85.15	85.15	84.91	84.97	106000.0
2003-10-27 10:00:00	TLT	ETF	85.0	85.12	84.8	85.11	55700.0
2003-10-27 11:00:00	TLT	ETF	85.15	85.26	85.07	85.26	26500.0
2003-10-27 12:00:00	TLT	ETF	85.2	85.33	85.13	85.27	39100.0
2003-10-27 13:00:00	TLT	ETF	85.32	85.32	85.1	85.1	15000.0
2003-10-27 14:00:00	TLT	ETF	85.1	85.3	85.01	85.01	36400.0

> showing 50 of 442 rows — these rows as CSV

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