PREVIEW / etf_1hour / 2003-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-10-09.parquet
  size:    18 KB
  rows:    464

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-09 08:00:00	SPY	ETF	104.09	104.75	104.05	104.72	419400.0
2003-10-09 09:00:00	SPY	ETF	104.72	104.97	104.54	104.75	4473800.0
2003-10-09 10:00:00	SPY	ETF	104.74	104.83	104.47	104.797	5090800.0
2003-10-09 11:00:00	SPY	ETF	104.83	105.22	104.75	105.07	5272200.0
2003-10-09 12:00:00	SPY	ETF	105.06	105.17	104.94	105.0	1473900.0
2003-10-09 13:00:00	SPY	ETF	104.98	105.04	104.75	104.87	2285200.0
2003-10-09 14:00:00	SPY	ETF	104.9	104.93	103.91	104.062	7255000.0
2003-10-09 15:00:00	SPY	ETF	104.02	104.26	103.83	104.169	5584800.0
2003-10-09 16:00:00	SPY	ETF	104.16	104.34	104.13	104.28	1089900.0
2003-10-09 17:00:00	SPY	ETF	104.28	104.37	104.23	104.3	18600.0
2003-10-09 18:00:00	SPY	ETF	104.32	104.35	104.27	104.29	16500.0
2003-10-09 19:00:00	SPY	ETF	104.32	104.32	104.29	104.31	3500.0
2003-10-09 08:00:00	QQQ	ETF	34.51	34.88	34.51	34.87	625400.0
2003-10-09 09:00:00	QQQ	ETF	34.86	35.0	34.8	34.92	13989600.0
2003-10-09 10:00:00	QQQ	ETF	34.92	35.1	34.81	35.1	14851600.0
2003-10-09 11:00:00	QQQ	ETF	35.095	35.27	35.08	35.2	15305500.0
2003-10-09 12:00:00	QQQ	ETF	35.2	35.27	35.15	35.18	6118000.0
2003-10-09 13:00:00	QQQ	ETF	35.17	35.23	35.06	35.097	9499900.0
2003-10-09 14:00:00	QQQ	ETF	35.1	35.14	34.55	34.63	17767200.0
2003-10-09 15:00:00	QQQ	ETF	34.627	34.76	34.43	34.64	23251100.0
2003-10-09 16:00:00	QQQ	ETF	34.64	34.73	34.63	34.66	2286300.0
2003-10-09 17:00:00	QQQ	ETF	34.66	34.74	34.64	34.67	96600.0
2003-10-09 18:00:00	QQQ	ETF	34.68	34.702	34.65	34.66	37500.0
2003-10-09 19:00:00	QQQ	ETF	34.7	34.72	34.69	34.7	20800.0
2003-10-09 08:00:00	IWM	ETF	51.725	51.94	51.725	51.94	400.0
2003-10-09 09:00:00	IWM	ETF	51.95	52.155	51.95	52.135	1672200.0
2003-10-09 10:00:00	IWM	ETF	52.15	52.375	52.15	52.305	1893800.0
2003-10-09 11:00:00	IWM	ETF	52.3	52.595	52.23	52.475	996200.0
2003-10-09 12:00:00	IWM	ETF	52.48	52.52	52.415	52.47	287400.0
2003-10-09 13:00:00	IWM	ETF	52.45	52.525	52.34	52.345	492400.0
2003-10-09 14:00:00	IWM	ETF	52.34	52.401	51.725	51.725	1399200.0
2003-10-09 15:00:00	IWM	ETF	51.725	51.81	51.455	51.81	2321600.0
2003-10-09 16:00:00	IWM	ETF	51.789	51.975	51.789	51.95	142600.0
2003-10-09 08:00:00	DIA	ETF	96.86	97.43	96.86	97.4	8000.0
2003-10-09 09:00:00	DIA	ETF	97.4	97.55	97.29	97.38	601100.0
2003-10-09 10:00:00	DIA	ETF	97.39	97.49	97.17	97.46	759100.0
2003-10-09 11:00:00	DIA	ETF	97.41	97.9	97.41	97.78	793800.0
2003-10-09 12:00:00	DIA	ETF	97.79	97.89	97.71	97.77	281100.0
2003-10-09 13:00:00	DIA	ETF	97.74	97.8	97.56	97.66	309100.0
2003-10-09 14:00:00	DIA	ETF	97.66	97.7	96.69	96.83	1475200.0
2003-10-09 15:00:00	DIA	ETF	96.86	97.03	96.65	96.95	1075800.0
2003-10-09 16:00:00	DIA	ETF	96.95	97.17	96.92	97.04	252500.0
2003-10-09 17:00:00	DIA	ETF	97.07	97.15	97.07	97.12	4000.0
2003-10-09 18:00:00	DIA	ETF	97.11	97.11	97.11	97.11	300.0
2003-10-09 19:00:00	DIA	ETF	97.12	97.12	97.12	97.12	100.0
2003-10-09 09:00:00	TLT	ETF	83.92	84.01	83.8	83.84	369100.0
2003-10-09 10:00:00	TLT	ETF	83.85	84.12	83.85	84.12	134200.0
2003-10-09 11:00:00	TLT	ETF	84.1	84.13	83.76	83.82	494600.0
2003-10-09 12:00:00	TLT	ETF	83.82	83.95	83.78	83.821	48200.0
2003-10-09 13:00:00	TLT	ETF	83.83	83.9	83.65	83.85	50400.0

> showing 50 of 464 rows — these rows as CSV

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