PREVIEW / stock_1hour / 2008-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-17.parquet
  size:    849 KB
  rows:    41,513
  symbols: 3,337

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-17 05:00:00	AAPL	Stock	6.1786	6.1786	6.1786	6.1786	2800.0
2008-07-17 06:00:00	AAPL	Stock	6.1929	6.1929	6.1929	6.1929	2800.0
2008-07-17 07:00:00	AAPL	Stock	6.1964	6.2568	6.1964	6.2136	579376.0
2008-07-17 08:00:00	AAPL	Stock	6.2125	6.2204	6.1864	6.2064	1804824.0
2008-07-17 09:00:00	AAPL	Stock	6.2071	6.2493	6.1896	6.1954	100567320.0
2008-07-17 10:00:00	AAPL	Stock	6.195	6.205	6.1511	6.1764	110911248.0
2008-07-17 11:00:00	AAPL	Stock	6.1775	6.2336	6.1489	6.1986	104556172.0
2008-07-17 12:00:00	AAPL	Stock	6.1996	6.2	6.1607	6.1942	51586136.0
2008-07-17 13:00:00	AAPL	Stock	6.1943	6.2464	6.1875	6.1943	87873296.0
2008-07-17 14:00:00	AAPL	Stock	6.1939	6.2093	6.1389	6.1625	104972560.0
2008-07-17 15:00:00	AAPL	Stock	6.1632	6.1786	6.1211	6.1343	111034336.0
2008-07-17 16:00:00	AAPL	Stock	6.1304	6.1886	5.9321	5.9893	65640008.0
2008-07-17 17:00:00	AAPL	Stock	5.9893	6.2158	5.9568	5.9907	6103916.0
2008-07-17 18:00:00	AAPL	Stock	5.9907	6.0039	5.9886	5.9982	579096.0
2008-07-17 19:00:00	AAPL	Stock	5.9982	6.0007	5.9857	6.0	502012.0
2008-07-17 07:00:00	MSFT	Stock	27.49	27.49	27.29	27.41	6128.0
2008-07-17 08:00:00	MSFT	Stock	27.41	27.56	27.33	27.54	52576.0
2008-07-17 09:00:00	MSFT	Stock	27.54	27.73	27.37	27.4	7661369.0
2008-07-17 10:00:00	MSFT	Stock	27.39	27.52	27.11	27.5	12777596.0
2008-07-17 11:00:00	MSFT	Stock	27.5	27.68	27.29	27.66	8809137.0
2008-07-17 12:00:00	MSFT	Stock	27.65	27.655	27.33	27.415	7128084.0
2008-07-17 13:00:00	MSFT	Stock	27.42	27.835	27.4	27.69	9138759.0
2008-07-17 14:00:00	MSFT	Stock	27.7	27.91	27.67	27.81	12554950.0
2008-07-17 15:00:00	MSFT	Stock	27.82	27.9	27.48	27.57	21330483.0
2008-07-17 16:00:00	MSFT	Stock	27.57	27.667	25.77	25.82	9805667.0
2008-07-17 17:00:00	MSFT	Stock	25.82	27.542	25.68	25.81	1572899.0
2008-07-17 18:00:00	MSFT	Stock	25.8	25.86	25.65	25.79	146793.0
2008-07-17 19:00:00	MSFT	Stock	25.77	25.95	25.77	25.87	34149.0
2008-07-17 08:00:00	NVDA	Stock	0.283	0.2888	0.283	0.2875	619480.0
2008-07-17 09:00:00	NVDA	Stock	0.2865	0.2878	0.2805	0.281	103791200.0
2008-07-17 10:00:00	NVDA	Stock	0.281	0.284	0.2758	0.2768	160338240.0
2008-07-17 11:00:00	NVDA	Stock	0.2768	0.2792	0.273	0.2755	121643400.0
2008-07-17 12:00:00	NVDA	Stock	0.2755	0.2775	0.2748	0.2769	71843440.0
2008-07-17 13:00:00	NVDA	Stock	0.2768	0.285	0.276	0.2835	133758640.0
2008-07-17 14:00:00	NVDA	Stock	0.2836	0.284	0.281	0.2827	105806040.0
2008-07-17 15:00:00	NVDA	Stock	0.2827	0.2852	0.2818	0.284	131517200.0
2008-07-17 16:00:00	NVDA	Stock	0.284	0.2842	0.2775	0.2788	15931040.0
2008-07-17 17:00:00	NVDA	Stock	0.2838	0.284	0.2778	0.2803	10253040.0
2008-07-17 18:00:00	NVDA	Stock	0.2795	0.2795	0.277	0.277	145800.0
2008-07-17 19:00:00	NVDA	Stock	0.277	0.277	0.277	0.277	60000.0
2008-07-17 07:00:00	AMZN	Stock	3.6125	3.6125	3.6125	3.6125	2000.0
2008-07-17 08:00:00	AMZN	Stock	3.575	3.5815	3.565	3.567	191660.0
2008-07-17 09:00:00	AMZN	Stock	3.5655	3.6155	3.5165	3.5675	22199920.0
2008-07-17 10:00:00	AMZN	Stock	3.5675	3.5975	3.456	3.4605	35205920.0
2008-07-17 11:00:00	AMZN	Stock	3.4605	3.5005	3.439	3.493	22004880.0
2008-07-17 12:00:00	AMZN	Stock	3.493	3.5405	3.4785	3.5365	15336640.0
2008-07-17 13:00:00	AMZN	Stock	3.5345	3.612	3.526	3.5885	22325320.0
2008-07-17 14:00:00	AMZN	Stock	3.589	3.619	3.5825	3.5865	25343520.0
2008-07-17 15:00:00	AMZN	Stock	3.5865	3.61	3.5745	3.605	37786940.0
2008-07-17 16:00:00	AMZN	Stock	3.6051	3.6125	3.4375	3.4745	6861180.0

> showing 50 of 41,513 rows — these rows as CSV

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