PREVIEW / etf_1hour / 2006-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-01.parquet
  size:    57 KB
  rows:    1,790

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-01 04:00:00	SPY	ETF	137.84	137.84	137.84	137.84	500.0
2006-11-01 06:00:00	SPY	ETF	138.02	138.03	138.02	138.03	2000.0
2006-11-01 07:00:00	SPY	ETF	137.97	138.08	137.97	138.04	174800.0
2006-11-01 08:00:00	SPY	ETF	138.03	138.33	137.98	138.33	1893000.0
2006-11-01 09:00:00	SPY	ETF	138.35	138.35	137.79	138.07	7455300.0
2006-11-01 10:00:00	SPY	ETF	138.07	138.22	137.63	137.91	17115300.0
2006-11-01 11:00:00	SPY	ETF	137.92	138.05	137.4	137.48	9010000.0
2006-11-01 12:00:00	SPY	ETF	137.47	137.57	137.21	137.35	8334700.0
2006-11-01 13:00:00	SPY	ETF	137.35	137.58	137.27	137.47	5727700.0
2006-11-01 14:00:00	SPY	ETF	137.46	137.54	137.04	137.04	8144700.0
2006-11-01 15:00:00	SPY	ETF	137.04	137.07	136.72	136.91	18987000.0
2006-11-01 16:00:00	SPY	ETF	136.92	136.99	136.83	136.83	4374600.0
2006-11-01 17:00:00	SPY	ETF	136.85	136.9	136.8	136.8	107100.0
2006-11-01 18:00:00	SPY	ETF	136.82	136.9	136.82	136.9	1100.0
2006-11-01 19:00:00	SPY	ETF	136.9	136.9	136.9	136.9	100.0
2006-11-01 09:00:00	QQQ	ETF	42.73	42.75	42.68	42.7	10440400.0
2006-11-01 10:00:00	QQQ	ETF	42.69	42.77	42.4	42.52	29152000.0
2006-11-01 11:00:00	QQQ	ETF	42.52	42.58	42.33	42.37	14734900.0
2006-11-01 12:00:00	QQQ	ETF	42.37	42.42	42.26	42.33	11911200.0
2006-11-01 13:00:00	QQQ	ETF	42.32	42.42	42.28	42.36	10860100.0
2006-11-01 14:00:00	QQQ	ETF	42.36	42.37	42.1	42.12	14479200.0
2006-11-01 15:00:00	QQQ	ETF	42.12	42.13	41.82	41.99	37512600.0
2006-11-01 07:00:00	IWM	ETF	76.15	76.3	76.15	76.3	300.0
2006-11-01 08:00:00	IWM	ETF	76.33	76.56	76.33	76.54	163000.0
2006-11-01 09:00:00	IWM	ETF	76.55	76.58	76.2	76.22	3276100.0
2006-11-01 10:00:00	IWM	ETF	76.21	76.4	75.69	76.03	8634000.0
2006-11-01 11:00:00	IWM	ETF	76.03	76.12	75.62	75.71	5438900.0
2006-11-01 12:00:00	IWM	ETF	75.7	75.79	75.38	75.51	5585700.0
2006-11-01 13:00:00	IWM	ETF	75.51	75.65	75.42	75.51	2792200.0
2006-11-01 14:00:00	IWM	ETF	75.51	75.54	75.16	75.17	6680100.0
2006-11-01 15:00:00	IWM	ETF	75.17	75.22	74.65	74.7	12638300.0
2006-11-01 16:00:00	IWM	ETF	74.69	76.21	74.58	74.62	276800.0
2006-11-01 17:00:00	IWM	ETF	74.62	74.62	74.61	74.61	7700.0
2006-11-01 18:00:00	IWM	ETF	74.65	74.65	74.65	74.65	2300.0
2006-11-01 19:00:00	IWM	ETF	74.62	74.65	74.62	74.65	1000.0
2006-11-01 07:00:00	DIA	ETF	120.88	120.88	120.88	120.88	1000.0
2006-11-01 08:00:00	DIA	ETF	120.88	121.15	120.88	121.1	34800.0
2006-11-01 09:00:00	DIA	ETF	121.1	121.12	120.84	120.88	572500.0
2006-11-01 10:00:00	DIA	ETF	120.86	120.98	120.43	120.74	1982500.0
2006-11-01 11:00:00	DIA	ETF	120.75	120.83	120.36	120.46	1004700.0
2006-11-01 12:00:00	DIA	ETF	120.47	120.49	120.15	120.26	671900.0
2006-11-01 13:00:00	DIA	ETF	120.26	120.48	120.25	120.35	551100.0
2006-11-01 14:00:00	DIA	ETF	120.35	120.35	120.1	120.17	870900.0
2006-11-01 15:00:00	DIA	ETF	120.16	120.25	119.98	120.22	1737100.0
2006-11-01 16:00:00	DIA	ETF	120.25	120.29	120.2	120.25	50000.0
2006-11-01 07:00:00	GLD	ETF	60.6	60.67	60.57	60.66	16600.0
2006-11-01 08:00:00	GLD	ETF	60.66	61.1	60.45	61.05	158300.0
2006-11-01 09:00:00	GLD	ETF	61.04	61.11	60.87	61.03	1410700.0
2006-11-01 10:00:00	GLD	ETF	61.03	61.3	60.92	61.04	1416800.0
2006-11-01 11:00:00	GLD	ETF	61.03	61.27	60.94	61.1	1082000.0

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

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