PREVIEW / etf_1hour / 2005-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-26.parquet
  size:    31 KB
  rows:    927

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
2005-08-26 07:00:00	SPY	ETF	121.65	121.69	121.65	121.69	119400.0
2005-08-26 08:00:00	SPY	ETF	121.65	121.65	121.4	121.4	174100.0
2005-08-26 09:00:00	SPY	ETF	121.39	121.55	121.05	121.19	8197500.0
2005-08-26 10:00:00	SPY	ETF	121.18	121.18	120.81	121.06	11735400.0
2005-08-26 11:00:00	SPY	ETF	121.05	121.49	120.68	120.79	6764800.0
2005-08-26 12:00:00	SPY	ETF	120.79	121.02	120.77	120.86	7068400.0
2005-08-26 13:00:00	SPY	ETF	120.86	120.96	120.75	120.84	3391300.0
2005-08-26 14:00:00	SPY	ETF	120.87	121.36	120.74	121.09	11761100.0
2005-08-26 15:00:00	SPY	ETF	121.09	121.38	120.81	120.82	7748000.0
2005-08-26 16:00:00	SPY	ETF	120.83	121.0211	120.71	120.72	2723200.0
2005-08-26 17:00:00	SPY	ETF	120.71	120.72	120.53	120.7	33600.0
2005-08-26 18:00:00	SPY	ETF	120.7	120.74	120.7	120.74	3700.0
2005-08-26 19:00:00	SPY	ETF	120.75	120.75	120.75	120.75	200.0
2005-08-26 09:00:00	QQQ	ETF	38.54	38.56	38.4	38.45	7730700.0
2005-08-26 10:00:00	QQQ	ETF	38.45	38.45	38.27	38.39	16785000.0
2005-08-26 11:00:00	QQQ	ETF	38.38	38.41	38.32	38.36	6521900.0
2005-08-26 12:00:00	QQQ	ETF	38.36	38.47	38.36	38.43	5332800.0
2005-08-26 13:00:00	QQQ	ETF	38.43	38.45	38.37	38.41	4185100.0
2005-08-26 14:00:00	QQQ	ETF	38.42	38.57	38.37	38.52	8450000.0
2005-08-26 15:00:00	QQQ	ETF	38.52	38.6	38.43	38.46	9778600.0
2005-08-26 08:00:00	IWM	ETF	65.56	65.56	65.56	65.56	500.0
2005-08-26 09:00:00	IWM	ETF	65.5	65.57	64.88	64.99	1945700.0
2005-08-26 10:00:00	IWM	ETF	64.97	64.97	64.652	64.79	4218500.0
2005-08-26 11:00:00	IWM	ETF	64.8	64.82	64.44	64.5	4258400.0
2005-08-26 12:00:00	IWM	ETF	64.5	64.7	64.49	64.6	1195100.0
2005-08-26 13:00:00	IWM	ETF	64.6	64.78	64.55	64.73	1093600.0
2005-08-26 14:00:00	IWM	ETF	64.72	64.89	64.54	64.72	2228600.0
2005-08-26 15:00:00	IWM	ETF	64.72	64.8	64.56	64.58	2572300.0
2005-08-26 16:00:00	IWM	ETF	64.57	64.59	64.5	64.58	411000.0
2005-08-26 17:00:00	IWM	ETF	64.58	64.58	64.5	64.5	400.0
2005-08-26 19:00:00	IWM	ETF	64.5	64.5	64.5	64.5	200.0
2005-08-26 07:00:00	DIA	ETF	104.52	104.52	104.52	104.52	3800.0
2005-08-26 08:00:00	DIA	ETF	104.45	104.45	104.32	104.36	96700.0
2005-08-26 09:00:00	DIA	ETF	104.36	104.39	103.97	104.08	796000.0
2005-08-26 10:00:00	DIA	ETF	104.06	104.14	103.84	104.07	1400700.0
2005-08-26 11:00:00	DIA	ETF	104.07	104.1	103.79	103.85	585600.0
2005-08-26 12:00:00	DIA	ETF	103.83	104.05	103.83	103.93	292200.0
2005-08-26 13:00:00	DIA	ETF	103.94	104.02	103.83	103.93	227400.0
2005-08-26 14:00:00	DIA	ETF	103.9	104.38	103.82	104.16	1091000.0
2005-08-26 15:00:00	DIA	ETF	104.16	104.33	103.91	103.93	937100.0
2005-08-26 16:00:00	DIA	ETF	103.97	103.97	103.89	103.92	6400.0
2005-08-26 17:00:00	DIA	ETF	103.86	103.86	103.84	103.85	5500.0
2005-08-26 19:00:00	DIA	ETF	103.9	103.9	103.9	103.9	100.0
2005-08-26 09:00:00	GLD	ETF	43.78	43.78	43.53	43.53	252500.0
2005-08-26 10:00:00	GLD	ETF	43.52	43.85	43.51	43.85	425100.0
2005-08-26 11:00:00	GLD	ETF	43.85	43.9	43.75	43.82	202900.0
2005-08-26 12:00:00	GLD	ETF	43.83	43.83	43.76	43.77	16100.0
2005-08-26 13:00:00	GLD	ETF	43.77	43.77	43.59	43.6	140300.0
2005-08-26 14:00:00	GLD	ETF	43.61	43.65	43.59	43.59	134100.0
2005-08-26 15:00:00	GLD	ETF	43.6	43.67	43.59	43.61	129700.0

> showing 50 of 927 rows — these rows as CSV

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