PREVIEW / stock_1hour / 2005-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-02-07.parquet
  size:    549 KB
  rows:    26,036
  symbols: 1,931

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-02-07 08:00:00	AAPL	Stock	1.4146	1.417	1.4107	1.4139	1216320.0
2005-02-07 09:00:00	AAPL	Stock	1.4134	1.417	1.4084	1.4116	64963080.0
2005-02-07 10:00:00	AAPL	Stock	1.4114	1.4125	1.3839	1.3945	164461976.0
2005-02-07 11:00:00	AAPL	Stock	1.3946	1.408	1.3916	1.4025	77408184.0
2005-02-07 12:00:00	AAPL	Stock	1.4023	1.4084	1.3984	1.4046	59996888.0
2005-02-07 13:00:00	AAPL	Stock	1.4048	1.4048	1.3968	1.3968	33028128.0
2005-02-07 14:00:00	AAPL	Stock	1.3968	1.4093	1.3966	1.408	46337536.0
2005-02-07 15:00:00	AAPL	Stock	1.4079	1.4116	1.4045	1.4093	69542256.0
2005-02-07 16:00:00	AAPL	Stock	1.4107	1.4107	1.4087	1.4098	2946664.0
2005-02-07 17:00:00	AAPL	Stock	1.4096	1.4125	1.4096	1.4125	550312.0
2005-02-07 18:00:00	AAPL	Stock	1.4123	1.4123	1.4107	1.4123	72800.0
2005-02-07 08:00:00	MSFT	Stock	26.3	26.32	26.28	26.28	3250.0
2005-02-07 09:00:00	MSFT	Stock	26.28	26.31	26.2	26.211	7467480.0
2005-02-07 10:00:00	MSFT	Stock	26.21	26.25	26.15	26.18	11500188.0
2005-02-07 11:00:00	MSFT	Stock	26.19	26.2	26.13	26.13	5320799.0
2005-02-07 12:00:00	MSFT	Stock	26.13	26.17	26.1	26.13	5196532.0
2005-02-07 13:00:00	MSFT	Stock	26.13	26.16	26.06	26.1	6635402.0
2005-02-07 14:00:00	MSFT	Stock	26.09	26.19	26.07	26.17	6687934.0
2005-02-07 15:00:00	MSFT	Stock	26.17	26.2	26.06	26.15	10648663.0
2005-02-07 16:00:00	MSFT	Stock	26.15	26.17	26.12	26.15	513880.0
2005-02-07 17:00:00	MSFT	Stock	26.16	26.16	26.13	26.15	2950.0
2005-02-07 18:00:00	MSFT	Stock	26.16	26.16	26.16	26.16	10393.0
2005-02-07 08:00:00	NVDA	Stock	0.2175	0.2175	0.2145	0.2157	263880.0
2005-02-07 09:00:00	NVDA	Stock	0.2149	0.2167	0.2134	0.2167	59322000.0
2005-02-07 10:00:00	NVDA	Stock	0.2166	0.2192	0.213	0.2136	149932560.0
2005-02-07 11:00:00	NVDA	Stock	0.2137	0.2139	0.2127	0.2127	82530600.0
2005-02-07 12:00:00	NVDA	Stock	0.2127	0.2139	0.2117	0.2139	45291840.0
2005-02-07 13:00:00	NVDA	Stock	0.2139	0.2139	0.2104	0.2108	44565840.0
2005-02-07 14:00:00	NVDA	Stock	0.2108	0.2129	0.2108	0.2124	47061000.0
2005-02-07 15:00:00	NVDA	Stock	0.2124	0.2135	0.2119	0.2122	87250800.0
2005-02-07 16:00:00	NVDA	Stock	0.2118	0.2123	0.2108	0.212	887160.0
2005-02-07 17:00:00	NVDA	Stock	0.212	0.2122	0.212	0.2122	168000.0
2005-02-07 08:00:00	AMZN	Stock	1.789	1.789	1.7755	1.7835	210000.0
2005-02-07 09:00:00	AMZN	Stock	1.785	1.792	1.78	1.785	23223380.0
2005-02-07 10:00:00	AMZN	Stock	1.785	1.7865	1.7775	1.784	28611180.0
2005-02-07 11:00:00	AMZN	Stock	1.7845	1.7895	1.78	1.784	15025160.0
2005-02-07 12:00:00	AMZN	Stock	1.784	1.786	1.782	1.784	8522320.0
2005-02-07 13:00:00	AMZN	Stock	1.7844	1.7845	1.779	1.78	10879220.0
2005-02-07 14:00:00	AMZN	Stock	1.78	1.7885	1.78	1.784	23549600.0
2005-02-07 15:00:00	AMZN	Stock	1.784	1.787	1.783	1.7835	29961360.0
2005-02-07 16:00:00	AMZN	Stock	1.783	1.7845	1.7815	1.7845	797280.0
2005-02-07 17:00:00	AMZN	Stock	1.783	1.783	1.7815	1.782	118000.0
2005-02-07 18:00:00	AMZN	Stock	1.781	1.7845	1.778	1.778	273000.0
2005-02-07 09:00:00	CL	Stock	27.415	27.415	27.23	27.345	502800.0
2005-02-07 10:00:00	CL	Stock	27.3415	27.59	27.295	27.575	967200.0
2005-02-07 11:00:00	CL	Stock	27.58	27.685	27.515	27.625	985400.0
2005-02-07 12:00:00	CL	Stock	27.625	27.655	27.525	27.555	670400.0
2005-02-07 13:00:00	CL	Stock	27.555	27.585	27.55	27.56	613200.0
2005-02-07 14:00:00	CL	Stock	27.56	27.63	27.53	27.625	925600.0
2005-02-07 15:00:00	CL	Stock	27.625	27.63	27.575	27.585	1272000.0

> showing 50 of 26,036 rows — these rows as CSV

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