PREVIEW / stock_1hour / 2008-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-11.parquet
  size:    819 KB
  rows:    39,963
  symbols: 3,330

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
2008-07-11 06:00:00	AAPL	Stock	6.3179	6.3218	6.3071	6.3143	71400.0
2008-07-11 07:00:00	AAPL	Stock	6.3071	6.3171	6.2429	6.2429	539476.0
2008-07-11 08:00:00	AAPL	Stock	6.25	6.2821	6.2161	6.2268	2877168.0
2008-07-11 09:00:00	AAPL	Stock	6.2254	6.3254	6.1921	6.2957	120827532.0
2008-07-11 10:00:00	AAPL	Stock	6.2943	6.3214	6.2036	6.2443	130297300.0
2008-07-11 11:00:00	AAPL	Stock	6.2432	6.2564	6.1679	6.2218	102423720.0
2008-07-11 12:00:00	AAPL	Stock	6.2214	6.2311	6.1082	6.1179	106227072.0
2008-07-11 13:00:00	AAPL	Stock	6.1175	6.2114	6.1071	6.1893	106802220.0
2008-07-11 14:00:00	AAPL	Stock	6.1893	6.2743	6.1369	6.2711	140051940.0
2008-07-11 15:00:00	AAPL	Stock	6.2714	6.3064	6.13	6.1643	186370408.0
2008-07-11 16:00:00	AAPL	Stock	6.1643	6.2119	6.1471	6.1604	19190052.0
2008-07-11 17:00:00	AAPL	Stock	6.1607	6.1786	6.1543	6.175	701400.0
2008-07-11 18:00:00	AAPL	Stock	6.1782	6.1782	6.1636	6.1743	182168.0
2008-07-11 19:00:00	AAPL	Stock	6.175	6.1779	6.1707	6.1725	119280.0
2008-07-11 07:00:00	MSFT	Stock	25.31	25.31	25.26	25.26	1150.0
2008-07-11 08:00:00	MSFT	Stock	25.21	25.28	25.13	25.15	27050.0
2008-07-11 09:00:00	MSFT	Stock	25.15	25.24	25.05	25.15	6044458.0
2008-07-11 10:00:00	MSFT	Stock	25.15	25.23	24.87	25.01	10912018.0
2008-07-11 11:00:00	MSFT	Stock	25.01	25.15	24.87	25.142	8204138.0
2008-07-11 12:00:00	MSFT	Stock	25.15	25.19	24.99	25.03	6133790.0
2008-07-11 13:00:00	MSFT	Stock	25.03	25.19	24.88	25.135	8748170.0
2008-07-11 14:00:00	MSFT	Stock	25.14	25.52	25.05	25.43	8396606.0
2008-07-11 15:00:00	MSFT	Stock	25.43	25.64	25.08	25.25	15373256.0
2008-07-11 16:00:00	MSFT	Stock	25.25	25.38	24.915	25.25	2821412.0
2008-07-11 17:00:00	MSFT	Stock	25.27	25.28	25.25	25.28	1991.0
2008-07-11 18:00:00	MSFT	Stock	25.28	25.28	25.25	25.27	1426376.0
2008-07-11 19:00:00	MSFT	Stock	25.26	25.28	25.26	25.28	230.0
2008-07-11 07:00:00	NVDA	Stock	0.2948	0.2948	0.2775	0.2775	12000.0
2008-07-11 08:00:00	NVDA	Stock	0.2908	0.2908	0.2875	0.2878	1093600.0
2008-07-11 09:00:00	NVDA	Stock	0.2882	0.296	0.285	0.2942	92406440.0
2008-07-11 10:00:00	NVDA	Stock	0.294	0.299	0.2895	0.2945	135736840.0
2008-07-11 11:00:00	NVDA	Stock	0.2942	0.2945	0.2878	0.2912	100192360.0
2008-07-11 12:00:00	NVDA	Stock	0.2915	0.2915	0.2835	0.2842	64406880.0
2008-07-11 13:00:00	NVDA	Stock	0.2842	0.29	0.283	0.288	80136360.0
2008-07-11 14:00:00	NVDA	Stock	0.288	0.2942	0.2862	0.293	113395160.0
2008-07-11 15:00:00	NVDA	Stock	0.293	0.2955	0.29	0.292	192636640.0
2008-07-11 16:00:00	NVDA	Stock	0.292	0.2938	0.2905	0.2925	17783440.0
2008-07-11 17:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	97760.0
2008-07-11 18:00:00	NVDA	Stock	0.2918	0.2918	0.2918	0.2918	4000.0
2008-07-11 19:00:00	NVDA	Stock	0.2912	0.2925	0.2902	0.2902	52000.0
2008-07-11 08:00:00	AMZN	Stock	3.4875	3.4875	3.4275	3.4625	87900.0
2008-07-11 09:00:00	AMZN	Stock	3.465	3.491	3.4125	3.4545	16744620.0
2008-07-11 10:00:00	AMZN	Stock	3.4545	3.459	3.387	3.401	25711100.0
2008-07-11 11:00:00	AMZN	Stock	3.4005	3.4135	3.351	3.3885	24078300.0
2008-07-11 12:00:00	AMZN	Stock	3.389	3.397	3.3385	3.341	13785840.0
2008-07-11 13:00:00	AMZN	Stock	3.342	3.4175	3.337	3.404	17182240.0
2008-07-11 14:00:00	AMZN	Stock	3.403	3.45	3.37	3.449	23258160.0
2008-07-11 15:00:00	AMZN	Stock	3.4495	3.4995	3.4005	3.427	32534280.0
2008-07-11 16:00:00	AMZN	Stock	3.427	3.4305	3.4109	3.427	3894440.0
2008-07-11 19:00:00	AMZN	Stock	3.4105	3.4245	3.4105	3.4245	12000.0

> showing 50 of 39,963 rows — these rows as CSV

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