PREVIEW / etf_1hour / 2006-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-06.parquet
  size:    56 KB
  rows:    1,777

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
2006-11-06 04:00:00	SPY	ETF	136.97	136.97	136.97	136.97	500.0
2006-11-06 06:00:00	SPY	ETF	137.06	137.06	137.06	137.06	900.0
2006-11-06 07:00:00	SPY	ETF	137.02	137.02	136.94	137.0	54700.0
2006-11-06 08:00:00	SPY	ETF	136.97	137.05	136.9	136.93	736200.0
2006-11-06 09:00:00	SPY	ETF	136.93	137.35	136.93	137.29	9701700.0
2006-11-06 10:00:00	SPY	ETF	137.3	137.75	137.27	137.61	13779800.0
2006-11-06 11:00:00	SPY	ETF	137.63	137.86	137.58	137.761	8638300.0
2006-11-06 12:00:00	SPY	ETF	137.78	137.88	137.7	137.76	5013500.0
2006-11-06 13:00:00	SPY	ETF	137.76	138.02	137.75	137.85	5492700.0
2006-11-06 14:00:00	SPY	ETF	137.85	138.08	137.84	138.01	5168400.0
2006-11-06 15:00:00	SPY	ETF	138.0	138.28	137.98	138.09	11304000.0
2006-11-06 16:00:00	SPY	ETF	138.07	138.13	138.01	138.02	1993000.0
2006-11-06 17:00:00	SPY	ETF	138.02	138.06	138.02	138.06	6800.0
2006-11-06 18:00:00	SPY	ETF	138.04	138.05	138.02	138.02	10500.0
2006-11-06 19:00:00	SPY	ETF	138.01	138.01	138.0	138.0	700.0
2006-11-06 09:00:00	QQQ	ETF	42.06	42.36	42.06	42.33	16327700.0
2006-11-06 10:00:00	QQQ	ETF	42.33	42.62	42.27	42.57	26574400.0
2006-11-06 11:00:00	QQQ	ETF	42.57	42.6	42.52	42.56	7661600.0
2006-11-06 12:00:00	QQQ	ETF	42.56	42.62	42.5	42.54	6725100.0
2006-11-06 13:00:00	QQQ	ETF	42.54	42.66	42.53	42.55	10241300.0
2006-11-06 14:00:00	QQQ	ETF	42.55	42.71	42.54	42.65	10552600.0
2006-11-06 15:00:00	QQQ	ETF	42.64	42.7	42.53	42.54	15123500.0
2006-11-06 08:00:00	IWM	ETF	75.1	75.2	75.1	75.18	4000.0
2006-11-06 09:00:00	IWM	ETF	75.2	75.44	75.0	75.27	5834400.0
2006-11-06 10:00:00	IWM	ETF	75.26	75.6	75.11	75.36	9099300.0
2006-11-06 11:00:00	IWM	ETF	75.36	75.51	75.31	75.42	2947100.0
2006-11-06 12:00:00	IWM	ETF	75.43	75.61	75.43	75.53	3041200.0
2006-11-06 13:00:00	IWM	ETF	75.53	75.66	75.4	75.47	4096600.0
2006-11-06 14:00:00	IWM	ETF	75.48	75.83	75.44	75.82	6920500.0
2006-11-06 15:00:00	IWM	ETF	75.82	76.08	75.81	75.91	14035900.0
2006-11-06 16:00:00	IWM	ETF	75.88	75.88	75.69	75.69	318600.0
2006-11-06 18:00:00	IWM	ETF	75.7	75.7	75.7	75.7	1000.0
2006-11-06 07:00:00	DIA	ETF	120.1	120.12	120.1	120.12	1800.0
2006-11-06 08:00:00	DIA	ETF	120.13	120.15	120.01	120.04	9700.0
2006-11-06 09:00:00	DIA	ETF	120.07	120.34	120.02	120.3	922700.0
2006-11-06 10:00:00	DIA	ETF	120.31	120.66	120.29	120.53	2103100.0
2006-11-06 11:00:00	DIA	ETF	120.52	120.82	120.49	120.8	779700.0
2006-11-06 12:00:00	DIA	ETF	120.8	120.87	120.67	120.72	528400.0
2006-11-06 13:00:00	DIA	ETF	120.71	120.96	120.7	120.79	807600.0
2006-11-06 14:00:00	DIA	ETF	120.8	120.93	120.77	120.79	657400.0
2006-11-06 15:00:00	DIA	ETF	120.81	121.1376	120.79	120.97	1529000.0
2006-11-06 16:00:00	DIA	ETF	120.97	121.02	120.96	121.02	60400.0
2006-11-06 08:00:00	GLD	ETF	61.98	62.13	61.81	62.13	64200.0
2006-11-06 09:00:00	GLD	ETF	62.15	62.26	62.1	62.21	699000.0
2006-11-06 10:00:00	GLD	ETF	62.24	62.27	61.96	62.19	658500.0
2006-11-06 11:00:00	GLD	ETF	62.21	62.34	61.98	62.22	405900.0
2006-11-06 12:00:00	GLD	ETF	62.2101	62.34	62.04	62.15	406700.0
2006-11-06 13:00:00	GLD	ETF	62.16	62.18	61.9	61.91	407900.0
2006-11-06 14:00:00	GLD	ETF	61.91	61.98	61.85	61.93	527600.0
2006-11-06 15:00:00	GLD	ETF	61.93	61.94	61.85	61.91	500200.0

> showing 50 of 1,777 rows — these rows as CSV

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