PREVIEW / etf_1hour / 2005-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-03.parquet
  size:    34 KB
  rows:    1,041

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
2005-11-03 07:00:00	SPY	ETF	121.69	121.76	121.65	121.65	11900.0
2005-11-03 08:00:00	SPY	ETF	121.71	122.18	121.59	122.17	2771600.0
2005-11-03 09:00:00	SPY	ETF	122.15	122.55	122.09	122.43	15956600.0
2005-11-03 10:00:00	SPY	ETF	122.43	122.51	121.96	122.22	21313700.0
2005-11-03 11:00:00	SPY	ETF	122.23	122.51	122.22	122.36	5212700.0
2005-11-03 12:00:00	SPY	ETF	122.35	122.66	122.33	122.41	5276100.0
2005-11-03 13:00:00	SPY	ETF	122.41	122.46	122.17	122.33	7115900.0
2005-11-03 14:00:00	SPY	ETF	122.33	122.46	121.89	122.03	7496500.0
2005-11-03 15:00:00	SPY	ETF	122.03	122.17	121.75	122.14	17128500.0
2005-11-03 16:00:00	SPY	ETF	122.15	122.27	122.0173	122.2	1422600.0
2005-11-03 17:00:00	SPY	ETF	122.21	122.29	122.2	122.29	63000.0
2005-11-03 18:00:00	SPY	ETF	122.22	122.24	122.11	122.21	254300.0
2005-11-03 19:00:00	SPY	ETF	122.21	122.21	122.15	122.15	3200.0
2005-11-03 09:00:00	QQQ	ETF	39.74	39.86	39.69	39.82	17101300.0
2005-11-03 10:00:00	QQQ	ETF	39.81	39.91	38.86	39.85	27162500.0
2005-11-03 11:00:00	QQQ	ETF	39.83	39.98	39.83	39.94	19476900.0
2005-11-03 12:00:00	QQQ	ETF	39.94	40.09	39.9	39.98	18471400.0
2005-11-03 13:00:00	QQQ	ETF	39.98	40.01	39.9	39.94	7696400.0
2005-11-03 14:00:00	QQQ	ETF	39.93	39.98	39.79	39.85	14855800.0
2005-11-03 15:00:00	QQQ	ETF	39.85	39.98	39.75	39.95	17821600.0
2005-11-03 08:00:00	IWM	ETF	65.3	65.76	65.25	65.72	784800.0
2005-11-03 09:00:00	IWM	ETF	65.72	66.16	65.72	66.07	6948100.0
2005-11-03 10:00:00	IWM	ETF	66.07	66.08	65.66	65.93	14871900.0
2005-11-03 11:00:00	IWM	ETF	65.92	66.11	65.89	65.91	3764700.0
2005-11-03 12:00:00	IWM	ETF	65.88	66.09	65.88	65.97	2516200.0
2005-11-03 13:00:00	IWM	ETF	65.96	66.0	65.78	65.82	1712700.0
2005-11-03 14:00:00	IWM	ETF	65.81	65.95	65.5	65.61	4894900.0
2005-11-03 15:00:00	IWM	ETF	65.59	65.62	65.27	65.602	6340900.0
2005-11-03 16:00:00	IWM	ETF	65.6	65.63	65.56	65.6	211900.0
2005-11-03 17:00:00	IWM	ETF	65.63	65.64	65.4228	65.4228	426200.0
2005-11-03 08:00:00	DIA	ETF	104.7	105.13	104.62	105.1	253500.0
2005-11-03 09:00:00	DIA	ETF	105.1	105.36	105.03	105.32	1019000.0
2005-11-03 10:00:00	DIA	ETF	105.31	105.49	105.05	105.3	1751200.0
2005-11-03 11:00:00	DIA	ETF	105.28	105.51	105.28	105.39	460500.0
2005-11-03 12:00:00	DIA	ETF	105.39	105.59	105.35	105.402	754400.0
2005-11-03 13:00:00	DIA	ETF	105.4	105.43	105.24	105.362	509000.0
2005-11-03 14:00:00	DIA	ETF	105.34	105.44	104.99	105.09	480900.0
2005-11-03 15:00:00	DIA	ETF	105.11	105.2	104.88	105.1801	1191000.0
2005-11-03 16:00:00	DIA	ETF	105.2	105.29	105.2	105.27	16300.0
2005-11-03 17:00:00	DIA	ETF	105.22	105.22	104.35	105.17	5500.0
2005-11-03 18:00:00	DIA	ETF	105.17	105.17	105.13	105.13	2000.0
2005-11-03 19:00:00	DIA	ETF	105.15	105.15	105.15	105.15	200.0
2005-11-03 08:00:00	GLD	ETF	46.2	46.2	45.93	45.96	26000.0
2005-11-03 09:00:00	GLD	ETF	45.92	46.08	45.88	46.08	300200.0
2005-11-03 10:00:00	GLD	ETF	46.08	46.08	45.75	45.91	533100.0
2005-11-03 11:00:00	GLD	ETF	45.92	45.95	45.78	45.8	389400.0
2005-11-03 12:00:00	GLD	ETF	45.79	45.89	45.75	45.87	117400.0
2005-11-03 13:00:00	GLD	ETF	45.87	45.96	45.82	45.91	101500.0
2005-11-03 14:00:00	GLD	ETF	45.91	45.99	45.87	45.9	100000.0
2005-11-03 15:00:00	GLD	ETF	45.88	45.93	45.87	45.89	59800.0

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

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