PREVIEW / etf_1hour / 2006-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-14.parquet
  size:    58 KB
  rows:    1,789

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-14 04:00:00	SPY	ETF	138.86	138.86	138.86	138.86	500.0
2006-11-14 06:00:00	SPY	ETF	138.7	138.7	138.66	138.66	20000.0
2006-11-14 07:00:00	SPY	ETF	138.7	138.75	138.65	138.65	18600.0
2006-11-14 08:00:00	SPY	ETF	138.67	139.32	138.65	139.11	5947500.0
2006-11-14 09:00:00	SPY	ETF	139.12	139.23	138.56	138.64	12867500.0
2006-11-14 10:00:00	SPY	ETF	138.64	138.96	138.12	138.33	15489700.0
2006-11-14 11:00:00	SPY	ETF	138.33	138.6292	138.21	138.32	9603200.0
2006-11-14 12:00:00	SPY	ETF	138.34	138.59	138.22	138.55	5968600.0
2006-11-14 13:00:00	SPY	ETF	138.55	138.8	138.55	138.66	5593400.0
2006-11-14 14:00:00	SPY	ETF	138.67	139.56	138.6	139.48	14933800.0
2006-11-14 15:00:00	SPY	ETF	139.48	139.74	139.42	139.56	19210000.0
2006-11-14 16:00:00	SPY	ETF	139.53	139.68	139.5	139.54	2268200.0
2006-11-14 17:00:00	SPY	ETF	139.57	139.59	139.54	139.59	5200.0
2006-11-14 18:00:00	SPY	ETF	139.57	139.59	139.57	139.59	500.0
2006-11-14 19:00:00	SPY	ETF	139.59	139.62	139.59	139.61	17700.0
2006-11-14 09:00:00	QQQ	ETF	43.5	43.57	42.43	43.44	18386200.0
2006-11-14 10:00:00	QQQ	ETF	43.43	43.52	43.24	43.35	19174400.0
2006-11-14 11:00:00	QQQ	ETF	43.35	43.41	43.29	43.38	8214200.0
2006-11-14 12:00:00	QQQ	ETF	43.38	43.56	43.33	43.55	8377600.0
2006-11-14 13:00:00	QQQ	ETF	43.54	43.62	43.5	43.5	8667600.0
2006-11-14 14:00:00	QQQ	ETF	43.5	43.81	43.49	43.78	14496700.0
2006-11-14 15:00:00	QQQ	ETF	43.78	43.97	43.78	43.93	21424300.0
2006-11-14 07:00:00	IWM	ETF	76.7	76.7	76.6	76.6	2100.0
2006-11-14 08:00:00	IWM	ETF	76.7	77.02	76.61	76.94	1316900.0
2006-11-14 09:00:00	IWM	ETF	76.94	77.09	76.6	76.7	5185900.0
2006-11-14 10:00:00	IWM	ETF	76.7	76.82	76.43	76.65	7694900.0
2006-11-14 11:00:00	IWM	ETF	76.64	76.77	76.53	76.74	4286300.0
2006-11-14 12:00:00	IWM	ETF	76.74	76.96	76.66	76.9	4616600.0
2006-11-14 13:00:00	IWM	ETF	76.9	77.09	76.87	76.91	3684600.0
2006-11-14 14:00:00	IWM	ETF	76.9	77.57	76.88	77.54	11352000.0
2006-11-14 15:00:00	IWM	ETF	77.55	78.1	77.52	78.08	21745900.0
2006-11-14 16:00:00	IWM	ETF	78.07	78.4	78.03	78.13	3790300.0
2006-11-14 17:00:00	IWM	ETF	78.12	78.13	78.11	78.13	507900.0
2006-11-14 18:00:00	IWM	ETF	78.13	78.14	78.13	78.13	1800.0
2006-11-14 08:00:00	DIA	ETF	121.45	121.87	121.45	121.82	64500.0
2006-11-14 09:00:00	DIA	ETF	121.82	121.87	121.34	121.4	886500.0
2006-11-14 10:00:00	DIA	ETF	121.41	121.54	120.99	121.11	1062700.0
2006-11-14 11:00:00	DIA	ETF	121.11	121.22	121.02	121.1	626000.0
2006-11-14 12:00:00	DIA	ETF	121.12	121.36	121.04	121.32	447500.0
2006-11-14 13:00:00	DIA	ETF	121.32	121.56	121.3125	121.46	520900.0
2006-11-14 14:00:00	DIA	ETF	121.46	122.27	121.42	122.22	1727900.0
2006-11-14 15:00:00	DIA	ETF	122.23	122.45	122.22	122.33	1830300.0
2006-11-14 16:00:00	DIA	ETF	122.32	122.38	122.31	122.33	15700.0
2006-11-14 17:00:00	DIA	ETF	122.4	122.4	122.31	122.31	300.0
2006-11-14 18:00:00	DIA	ETF	122.31	122.31	122.31	122.31	100.0
2006-11-14 07:00:00	GLD	ETF	62.09	62.09	62.08	62.08	1500.0
2006-11-14 08:00:00	GLD	ETF	62.1	62.4	62.1	62.35	225200.0
2006-11-14 09:00:00	GLD	ETF	62.38	62.52	62.18	62.43	1197400.0
2006-11-14 10:00:00	GLD	ETF	62.43	62.45	61.46	61.64	1691000.0
2006-11-14 11:00:00	GLD	ETF	61.65	61.85	61.52	61.68	759900.0

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

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