PREVIEW / etf_1hour / 2006-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-16.parquet
  size:    54 KB
  rows:    1,747

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-10-16 07:00:00	SPY	ETF	136.68	136.69	136.64	136.65	13600.0
2006-10-16 08:00:00	SPY	ETF	136.67	136.71	136.51	136.51	1039700.0
2006-10-16 09:00:00	SPY	ETF	136.52	136.63	136.42	136.56	5562700.0
2006-10-16 10:00:00	SPY	ETF	136.57	136.73	136.55	136.57	8316400.0
2006-10-16 11:00:00	SPY	ETF	136.57	136.73	136.54	136.7	3204900.0
2006-10-16 12:00:00	SPY	ETF	136.7	136.77	136.6	136.66	4010300.0
2006-10-16 13:00:00	SPY	ETF	136.66	136.94	136.66	136.89	4886900.0
2006-10-16 14:00:00	SPY	ETF	136.89	136.94	136.82	136.89	3832300.0
2006-10-16 15:00:00	SPY	ETF	136.89	137.05	136.85	136.89	6450600.0
2006-10-16 16:00:00	SPY	ETF	136.89	136.93	136.78	136.82	1530400.0
2006-10-16 17:00:00	SPY	ETF	136.8	136.82	136.74	136.8	152400.0
2006-10-16 18:00:00	SPY	ETF	136.76	136.82	136.75	136.75	50200.0
2006-10-16 09:00:00	QQQ	ETF	42.43	42.52	42.4	42.46	7187900.0
2006-10-16 10:00:00	QQQ	ETF	42.45	42.59	42.44	42.48	12567400.0
2006-10-16 11:00:00	QQQ	ETF	42.49	42.52	42.46	42.49	4515000.0
2006-10-16 12:00:00	QQQ	ETF	42.48	42.51	42.46	42.48	4356100.0
2006-10-16 13:00:00	QQQ	ETF	42.49	42.62	42.47	42.59	7746200.0
2006-10-16 14:00:00	QQQ	ETF	42.6	42.6	42.47	42.47	9262300.0
2006-10-16 15:00:00	QQQ	ETF	42.48	42.54	42.45	42.46	11285800.0
2006-10-16 08:00:00	IWM	ETF	76.02	76.06	75.92	75.92	31700.0
2006-10-16 09:00:00	IWM	ETF	75.9	76.09	75.69	76.04	5397300.0
2006-10-16 10:00:00	IWM	ETF	76.04	76.43	76.03	76.19	9165600.0
2006-10-16 11:00:00	IWM	ETF	76.17	76.42	76.16	76.35	8849300.0
2006-10-16 12:00:00	IWM	ETF	76.3575	76.41	76.23	76.3	2689400.0
2006-10-16 13:00:00	IWM	ETF	76.31	76.5	76.28	76.43	5054500.0
2006-10-16 14:00:00	IWM	ETF	76.44	76.47	76.26	76.34	4279300.0
2006-10-16 15:00:00	IWM	ETF	76.34	76.54	76.3	76.47	8964700.0
2006-10-16 16:00:00	IWM	ETF	76.46	76.51	76.32	76.37	785300.0
2006-10-16 17:00:00	IWM	ETF	76.33	76.45	76.33	76.45	327200.0
2006-10-16 18:00:00	IWM	ETF	76.35	76.35	76.35	76.35	800.0
2006-10-16 19:00:00	IWM	ETF	76.35	76.35	76.35	76.35	400.0
2006-10-16 08:00:00	DIA	ETF	119.69	119.69	119.56	119.6	11600.0
2006-10-16 09:00:00	DIA	ETF	119.61	119.64	119.42	119.58	407000.0
2006-10-16 10:00:00	DIA	ETF	119.58	119.71	119.52	119.54	746800.0
2006-10-16 11:00:00	DIA	ETF	119.54	119.73	119.53	119.7	495100.0
2006-10-16 12:00:00	DIA	ETF	119.71	119.75	119.6	119.65	547900.0
2006-10-16 13:00:00	DIA	ETF	119.64	119.85	119.64	119.81	1748200.0
2006-10-16 14:00:00	DIA	ETF	119.8	119.83	119.73	119.77	509500.0
2006-10-16 15:00:00	DIA	ETF	119.76	119.97	119.75	119.81	1105900.0
2006-10-16 16:00:00	DIA	ETF	119.8	119.83	119.76	119.79	36900.0
2006-10-16 17:00:00	DIA	ETF	119.79	119.79	119.79	119.79	200.0
2006-10-16 19:00:00	DIA	ETF	119.74	119.74	119.74	119.74	300.0
2006-10-16 08:00:00	GLD	ETF	58.85	59.01	58.72	58.91	65000.0
2006-10-16 09:00:00	GLD	ETF	58.88	59.04	58.8	58.97	488300.0
2006-10-16 10:00:00	GLD	ETF	58.97	59.07	58.83	58.89	308800.0
2006-10-16 11:00:00	GLD	ETF	58.9	58.95	58.72	58.79	339600.0
2006-10-16 12:00:00	GLD	ETF	58.8	59.07	58.76	59.06	194900.0
2006-10-16 13:00:00	GLD	ETF	59.05	59.15	58.91	59.08	182900.0
2006-10-16 14:00:00	GLD	ETF	59.08	59.18	59.04	59.06	164700.0
2006-10-16 15:00:00	GLD	ETF	59.07	59.15	59.0301	59.15	221000.0

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

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