PREVIEW / etf_1hour / 2004-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-11-05.parquet
  size:    27 KB
  rows:    780

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
2004-11-05 08:00:00	SPY	ETF	116.65	117.46	116.55	117.21	1306700.0
2004-11-05 09:00:00	SPY	ETF	117.23	117.26	116.79	117.06	10294400.0
2004-11-05 10:00:00	SPY	ETF	117.05	117.64	116.96	117.25	11753100.0
2004-11-05 11:00:00	SPY	ETF	117.26	117.28	116.49	116.68	13516000.0
2004-11-05 12:00:00	SPY	ETF	116.67	117.17	116.55	117.14	5890600.0
2004-11-05 13:00:00	SPY	ETF	117.14	117.24	116.89	117.0	4874400.0
2004-11-05 14:00:00	SPY	ETF	117.01	117.07	116.74	116.94	3938100.0
2004-11-05 15:00:00	SPY	ETF	116.94	117.24	116.77	117.1	6386300.0
2004-11-05 16:00:00	SPY	ETF	117.09	117.28	117.04	117.28	2382100.0
2004-11-05 17:00:00	SPY	ETF	117.3	117.3	117.19	117.27	20400.0
2004-11-05 18:00:00	SPY	ETF	117.29	117.3	117.25	117.25	2000.0
2004-11-05 19:00:00	SPY	ETF	117.27	117.27	117.27	117.27	200.0
2004-11-05 08:00:00	QQQ	ETF	37.78	38.17	37.73	38.07	3551500.0
2004-11-05 09:00:00	QQQ	ETF	38.05	38.09	37.8	38.018	18063000.0
2004-11-05 10:00:00	QQQ	ETF	38.02	38.16	37.95	37.97	20325700.0
2004-11-05 11:00:00	QQQ	ETF	37.97	37.99	37.61	37.68	22757300.0
2004-11-05 12:00:00	QQQ	ETF	37.665	37.91	37.63	37.88	11788100.0
2004-11-05 13:00:00	QQQ	ETF	37.88	37.92	37.79	37.85	8824200.0
2004-11-05 14:00:00	QQQ	ETF	37.85	37.87	37.67	37.83	11823200.0
2004-11-05 15:00:00	QQQ	ETF	37.83	37.98	37.77	37.92	13895200.0
2004-11-05 16:00:00	QQQ	ETF	37.91	38.0	37.79	37.96	3731900.0
2004-11-05 17:00:00	QQQ	ETF	37.96	38.0	37.95	37.99	62900.0
2004-11-05 18:00:00	QQQ	ETF	37.99	38.0	37.95	37.99	16000.0
2004-11-05 19:00:00	QQQ	ETF	38.0	38.0	37.96	37.96	10900.0
2004-11-05 08:00:00	IWM	ETF	60.04	60.585	60.04	60.5	103000.0
2004-11-05 09:00:00	IWM	ETF	60.485	60.485	60.085	60.335	2190000.0
2004-11-05 10:00:00	IWM	ETF	60.335	60.625	60.265	60.45	2059000.0
2004-11-05 11:00:00	IWM	ETF	60.45	60.465	60.05	60.075	1671400.0
2004-11-05 12:00:00	IWM	ETF	60.075	60.345	60.04	60.275	711600.0
2004-11-05 13:00:00	IWM	ETF	60.28	60.3	60.125	60.185	542200.0
2004-11-05 14:00:00	IWM	ETF	60.185	60.19	59.82	60.07	1396400.0
2004-11-05 15:00:00	IWM	ETF	60.055	60.325	59.98	60.305	1514400.0
2004-11-05 16:00:00	IWM	ETF	60.31	60.31	60.22	60.265	244600.0
2004-11-05 08:00:00	DIA	ETF	103.3	104.0	103.3	103.82	86900.0
2004-11-05 09:00:00	DIA	ETF	103.84	103.95	103.5	103.95	1658500.0
2004-11-05 10:00:00	DIA	ETF	103.93	104.43	103.83	104.14	1833300.0
2004-11-05 11:00:00	DIA	ETF	104.13	104.15	103.6	103.74	1346600.0
2004-11-05 12:00:00	DIA	ETF	103.74	104.19	103.61	104.1	740100.0
2004-11-05 13:00:00	DIA	ETF	104.13	104.25	103.91	104.05	592900.0
2004-11-05 14:00:00	DIA	ETF	104.05	104.14	103.82	104.04	759800.0
2004-11-05 15:00:00	DIA	ETF	104.03	104.3	103.93	104.06	1137300.0
2004-11-05 16:00:00	DIA	ETF	104.09	104.27	104.07	104.24	91300.0
2004-11-05 17:00:00	DIA	ETF	104.27	104.27	104.22	104.22	800.0
2004-11-05 18:00:00	DIA	ETF	104.2	104.2	104.2	104.2	100.0
2004-11-05 08:00:00	TLT	ETF	88.78	88.82	86.99	87.76	276700.0
2004-11-05 09:00:00	TLT	ETF	87.76	87.93	87.6	87.7	570400.0
2004-11-05 10:00:00	TLT	ETF	87.7	87.84	87.63	87.73	259100.0
2004-11-05 11:00:00	TLT	ETF	87.75	87.88	87.66	87.74	109700.0
2004-11-05 12:00:00	TLT	ETF	87.73	87.75	87.52	87.56	75700.0
2004-11-05 13:00:00	TLT	ETF	87.56	87.72	87.54	87.7	36300.0

> showing 50 of 780 rows — these rows as CSV

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