PREVIEW / etf_1hour / 2006-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-02.parquet
  size:    54 KB
  rows:    1,723

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-02 07:00:00	SPY	ETF	137.07	137.2	137.04	137.14	179600.0
2006-11-02 08:00:00	SPY	ETF	137.12	137.22	136.5	136.6	3986000.0
2006-11-02 09:00:00	SPY	ETF	136.59	136.9094	136.36	136.45	11421400.0
2006-11-02 10:00:00	SPY	ETF	136.45	136.84	136.37	136.76	11498900.0
2006-11-02 11:00:00	SPY	ETF	136.76	137.01	136.55	136.62	8846900.0
2006-11-02 12:00:00	SPY	ETF	136.61	136.85	136.56	136.6	3777300.0
2006-11-02 13:00:00	SPY	ETF	136.6	136.85	136.5	136.77	3653400.0
2006-11-02 14:00:00	SPY	ETF	136.77	136.85	136.54	136.57	5239200.0
2006-11-02 15:00:00	SPY	ETF	136.57	136.91	136.56	136.81	7685700.0
2006-11-02 16:00:00	SPY	ETF	136.8	136.86	136.725	136.79	1242100.0
2006-11-02 17:00:00	SPY	ETF	136.78	136.8	136.77	136.8	11900.0
2006-11-02 18:00:00	SPY	ETF	136.79	136.79	136.75	136.75	10800.0
2006-11-02 09:00:00	QQQ	ETF	41.82	41.92	41.74	41.86	15700900.0
2006-11-02 10:00:00	QQQ	ETF	41.85	42.08	41.81	42.03	21720300.0
2006-11-02 11:00:00	QQQ	ETF	42.04	42.14	41.94	41.97	15711800.0
2006-11-02 12:00:00	QQQ	ETF	41.97	42.07	41.9	41.95	11876100.0
2006-11-02 13:00:00	QQQ	ETF	41.94	42.02	41.88	41.97	7899900.0
2006-11-02 14:00:00	QQQ	ETF	41.97	42.03	41.95	41.95	6105000.0
2006-11-02 15:00:00	QQQ	ETF	41.95	42.06	41.94	42.03	10802100.0
2006-11-02 07:00:00	IWM	ETF	74.69	74.85	74.69	74.85	5000.0
2006-11-02 08:00:00	IWM	ETF	74.71	74.75	74.23	74.3	746300.0
2006-11-02 09:00:00	IWM	ETF	74.29	74.76	74.1	74.24	10089100.0
2006-11-02 10:00:00	IWM	ETF	74.25	74.78	74.17	74.67	9315700.0
2006-11-02 11:00:00	IWM	ETF	74.68	74.9	74.49	74.55	8017300.0
2006-11-02 12:00:00	IWM	ETF	74.55	74.79	74.46	74.57	4764700.0
2006-11-02 13:00:00	IWM	ETF	74.57	74.73	74.5	74.57	2989300.0
2006-11-02 14:00:00	IWM	ETF	74.57	74.68	74.39	74.4	4014100.0
2006-11-02 15:00:00	IWM	ETF	74.4	74.67	74.39	74.51	6757100.0
2006-11-02 16:00:00	IWM	ETF	74.51	74.61	74.41	74.43	320100.0
2006-11-02 17:00:00	IWM	ETF	74.48	74.55	74.48	74.55	60000.0
2006-11-02 07:00:00	DIA	ETF	120.49	120.49	120.4	120.42	11000.0
2006-11-02 08:00:00	DIA	ETF	120.4	120.49	119.96	120.0	93000.0
2006-11-02 09:00:00	DIA	ETF	120.0	120.08	119.72	119.84	1191800.0
2006-11-02 10:00:00	DIA	ETF	119.84	120.11	119.76	120.03	2406900.0
2006-11-02 11:00:00	DIA	ETF	120.02	120.24	119.87	119.92	764400.0
2006-11-02 12:00:00	DIA	ETF	119.92	120.11	119.88	119.9318	375700.0
2006-11-02 13:00:00	DIA	ETF	119.94	120.09	119.84	120.03	560500.0
2006-11-02 14:00:00	DIA	ETF	120.04	120.08	119.88	119.9	640700.0
2006-11-02 15:00:00	DIA	ETF	119.9	120.15	119.89	120.08	845800.0
2006-11-02 16:00:00	DIA	ETF	120.07	120.08	120.0	120.07	9900.0
2006-11-02 19:00:00	DIA	ETF	120.05	120.05	120.05	120.05	200.0
2006-11-02 08:00:00	GLD	ETF	61.27	61.27	61.08	61.2	136500.0
2006-11-02 09:00:00	GLD	ETF	61.2	61.85	61.2	61.7	1481400.0
2006-11-02 10:00:00	GLD	ETF	61.71	61.75	61.57	61.69	780900.0
2006-11-02 11:00:00	GLD	ETF	61.69	62.0	61.61	61.9101	1057400.0
2006-11-02 12:00:00	GLD	ETF	61.95	62.05	61.8	61.99	896300.0
2006-11-02 13:00:00	GLD	ETF	62.0	62.19	61.98	61.9901	851000.0
2006-11-02 14:00:00	GLD	ETF	61.99	62.07	61.9	61.96	732100.0
2006-11-02 15:00:00	GLD	ETF	61.9699	62.0	61.91	61.95	700100.0
2006-11-02 16:00:00	GLD	ETF	61.93	61.95	61.92	61.92	6000.0

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

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