PREVIEW / etf_1hour / 2006-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-31.parquet
  size:    55 KB
  rows:    1,748

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-31 04:00:00	SPY	ETF	137.9	138.0	137.9	138.0	900.0
2006-10-31 05:00:00	SPY	ETF	138.12	138.12	138.12	138.12	3000.0
2006-10-31 06:00:00	SPY	ETF	138.08	138.08	138.04	138.04	90000.0
2006-10-31 07:00:00	SPY	ETF	138.04	138.09	137.93	138.09	316100.0
2006-10-31 08:00:00	SPY	ETF	138.04	138.15	137.93	138.11	2321400.0
2006-10-31 09:00:00	SPY	ETF	138.08	138.26	137.84	137.96	6411100.0
2006-10-31 10:00:00	SPY	ETF	137.95	138.08	137.59	138.06	9404800.0
2006-10-31 11:00:00	SPY	ETF	138.06	138.09	137.61	137.67	6055100.0
2006-10-31 12:00:00	SPY	ETF	137.66	137.76	137.32	137.35	9820100.0
2006-10-31 13:00:00	SPY	ETF	137.33	137.64	137.25	137.55	5997700.0
2006-10-31 14:00:00	SPY	ETF	137.55	137.68	137.37	137.58	6745000.0
2006-10-31 15:00:00	SPY	ETF	137.57	138.06	137.47	137.78	15987900.0
2006-10-31 16:00:00	SPY	ETF	137.76	138.0	137.62	137.79	2299800.0
2006-10-31 17:00:00	SPY	ETF	137.81	137.82	137.8	137.8	14600.0
2006-10-31 18:00:00	SPY	ETF	137.81	137.86	137.81	137.86	16500.0
2006-10-31 19:00:00	SPY	ETF	137.87	137.9	137.87	137.9	1200.0
2006-10-31 09:00:00	QQQ	ETF	42.56	42.73	42.56	42.66	19477600.0
2006-10-31 10:00:00	QQQ	ETF	42.65	42.75	42.44	42.72	35782800.0
2006-10-31 11:00:00	QQQ	ETF	42.72	42.76	42.52	42.55	13206400.0
2006-10-31 12:00:00	QQQ	ETF	42.54	42.6	42.31	42.36	15462900.0
2006-10-31 13:00:00	QQQ	ETF	42.35	42.5	42.32	42.45	13218200.0
2006-10-31 14:00:00	QQQ	ETF	42.45	42.49	42.34	42.45	10254800.0
2006-10-31 15:00:00	QQQ	ETF	42.44	42.68	42.41	42.56	21079000.0
2006-10-31 07:00:00	IWM	ETF	76.65	76.65	76.65	76.65	4000.0
2006-10-31 08:00:00	IWM	ETF	76.64	76.72	76.55	76.69	1125200.0
2006-10-31 09:00:00	IWM	ETF	76.68	76.79	76.44	76.55	5757200.0
2006-10-31 10:00:00	IWM	ETF	76.55	76.62	76.22	76.59	7643000.0
2006-10-31 11:00:00	IWM	ETF	76.6	76.63	76.18	76.26	3513200.0
2006-10-31 12:00:00	IWM	ETF	76.26	76.32	75.79	75.83	5215200.0
2006-10-31 13:00:00	IWM	ETF	75.82	76.15	75.7	76.08	5213300.0
2006-10-31 14:00:00	IWM	ETF	76.07	76.16	75.89	76.07	3863300.0
2006-10-31 15:00:00	IWM	ETF	76.07	76.46	76.0	76.1	9918400.0
2006-10-31 16:00:00	IWM	ETF	76.076	76.25	76.03	76.13	490100.0
2006-10-31 18:00:00	IWM	ETF	76.16	76.16	76.16	76.16	400.0
2006-10-31 08:00:00	DIA	ETF	120.9	120.96	120.87	120.89	31600.0
2006-10-31 09:00:00	DIA	ETF	120.89	121.03	120.72	120.81	839800.0
2006-10-31 10:00:00	DIA	ETF	120.81	120.93	120.42	120.9	1868100.0
2006-10-31 11:00:00	DIA	ETF	120.9	120.93	120.55	120.57	579000.0
2006-10-31 12:00:00	DIA	ETF	120.58	120.64	120.2	120.2	1050000.0
2006-10-31 13:00:00	DIA	ETF	120.2	120.45	120.12	120.36	1240900.0
2006-10-31 14:00:00	DIA	ETF	120.3501	120.42	120.12	120.33	1013600.0
2006-10-31 15:00:00	DIA	ETF	120.33	120.86	120.3	120.67	1606900.0
2006-10-31 16:00:00	DIA	ETF	120.65	120.75	120.57	120.7	81900.0
2006-10-31 17:00:00	DIA	ETF	120.5	120.5	120.5	120.5	200.0
2006-10-31 18:00:00	DIA	ETF	120.71	120.71	120.71	120.71	100.0
2006-10-31 07:00:00	GLD	ETF	59.69	59.69	59.69	59.69	1000.0
2006-10-31 08:00:00	GLD	ETF	59.75	59.76	59.41	59.45	65200.0
2006-10-31 09:00:00	GLD	ETF	59.4	59.73	59.4	59.72	425800.0
2006-10-31 10:00:00	GLD	ETF	59.73	60.25	59.73	60.05	1152700.0
2006-10-31 11:00:00	GLD	ETF	60.05	60.19	59.83	59.98	687300.0

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

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