PREVIEW / etf_1hour / 2003-09-10

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-10.parquet
  size:    17 KB
  rows:    433

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-10 08:00:00	SPY	ETF	102.86	102.9	102.68	102.68	46900.0
2003-09-10 09:00:00	SPY	ETF	102.68	102.77	102.45	102.75	5249900.0
2003-09-10 10:00:00	SPY	ETF	102.75	102.75	102.247	102.38	6585500.0
2003-09-10 11:00:00	SPY	ETF	102.38	102.47	102.15	102.27	3831900.0
2003-09-10 12:00:00	SPY	ETF	102.3	102.57	102.26	102.53	2357200.0
2003-09-10 13:00:00	SPY	ETF	102.5	102.6	102.24	102.26	2058700.0
2003-09-10 14:00:00	SPY	ETF	102.28	102.39	101.7	101.87	10536700.0
2003-09-10 15:00:00	SPY	ETF	101.85	101.9	101.55	101.68	6406900.0
2003-09-10 16:00:00	SPY	ETF	101.7	102.91	101.67	101.93	3035100.0
2003-09-10 17:00:00	SPY	ETF	101.9	101.9	101.83	101.83	225200.0
2003-09-10 18:00:00	SPY	ETF	101.876	101.91	101.84	101.84	16500.0
2003-09-10 19:00:00	SPY	ETF	101.89	101.9	101.84	101.84	6800.0
2003-09-10 08:00:00	QQQ	ETF	33.86	33.9	33.75	33.75	257000.0
2003-09-10 09:00:00	QQQ	ETF	33.75	33.89	33.66	33.864	14906900.0
2003-09-10 10:00:00	QQQ	ETF	33.863	33.87	33.61	33.68	18798400.0
2003-09-10 11:00:00	QQQ	ETF	33.65	33.72	33.441	33.53	13436100.0
2003-09-10 12:00:00	QQQ	ETF	33.53	33.69	33.51	33.63	7252100.0
2003-09-10 13:00:00	QQQ	ETF	33.634	33.67	33.46	33.514	7699900.0
2003-09-10 14:00:00	QQQ	ETF	33.52	33.548	33.25	33.32	17074700.0
2003-09-10 15:00:00	QQQ	ETF	33.32	33.35	33.11	33.13	18038700.0
2003-09-10 16:00:00	QQQ	ETF	33.13	33.28	33.11	33.22	2794000.0
2003-09-10 17:00:00	QQQ	ETF	33.22	33.22	33.129	33.22	248300.0
2003-09-10 18:00:00	QQQ	ETF	33.2	33.23	33.19	33.19	61800.0
2003-09-10 19:00:00	QQQ	ETF	33.2	33.21	33.19	33.19	10300.0
2003-09-10 09:00:00	IWM	ETF	50.955	50.955	50.46	50.78	736600.0
2003-09-10 10:00:00	IWM	ETF	50.775	50.785	50.475	50.64	1315200.0
2003-09-10 11:00:00	IWM	ETF	50.66	50.705	50.415	50.43	829200.0
2003-09-10 12:00:00	IWM	ETF	50.44	50.63	50.4	50.63	546600.0
2003-09-10 13:00:00	IWM	ETF	50.635	50.7	50.465	50.495	486000.0
2003-09-10 14:00:00	IWM	ETF	50.4985	50.52	50.21	50.3	1194000.0
2003-09-10 15:00:00	IWM	ETF	50.305	50.305	50.115	50.135	1504600.0
2003-09-10 16:00:00	IWM	ETF	50.135	50.195	50.125	50.165	84600.0
2003-09-10 08:00:00	DIA	ETF	95.27	95.27	95.15	95.15	400.0
2003-09-10 09:00:00	DIA	ETF	95.11	95.25	94.99	95.23	800500.0
2003-09-10 10:00:00	DIA	ETF	95.21	95.25	94.87	94.95	1137800.0
2003-09-10 11:00:00	DIA	ETF	94.94	95.0	94.77	94.87	681300.0
2003-09-10 12:00:00	DIA	ETF	94.84	95.14	94.84	95.08	738500.0
2003-09-10 13:00:00	DIA	ETF	95.1	95.17	94.9	94.97	328300.0
2003-09-10 14:00:00	DIA	ETF	94.95	95.04	94.47	94.54	1151800.0
2003-09-10 15:00:00	DIA	ETF	94.58	94.58	94.21	94.39	1464500.0
2003-09-10 16:00:00	DIA	ETF	94.42	94.73	94.4	94.6	282400.0
2003-09-10 17:00:00	DIA	ETF	94.6	94.6	94.57	94.57	900.0
2003-09-10 18:00:00	DIA	ETF	94.57	94.57	94.57	94.57	1700.0
2003-09-10 19:00:00	DIA	ETF	94.61	94.67	94.61	94.67	2100.0
2003-09-10 09:00:00	TLT	ETF	83.9	83.96	83.82	83.87	38700.0
2003-09-10 10:00:00	TLT	ETF	83.9	84.06	83.84	83.9	691100.0
2003-09-10 11:00:00	TLT	ETF	83.9	84.08	83.87	84.04	44400.0
2003-09-10 12:00:00	TLT	ETF	84.04	84.09	83.88	83.97	25700.0
2003-09-10 13:00:00	TLT	ETF	83.98	84.27	83.89	84.22	53200.0
2003-09-10 14:00:00	TLT	ETF	84.24	84.7	84.24	84.61	193500.0

> showing 50 of 433 rows — these rows as CSV

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