PREVIEW / stock_1hour / 2008-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-06.parquet
  size:    855 KB
  rows:    42,469
  symbols: 3,394

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-10-06 07:00:00	AAPL	Stock	3.3004	3.3607	3.2714	3.3429	1336300.0
2008-10-06 08:00:00	AAPL	Stock	3.35	3.3739	3.295	3.3289	7920808.0
2008-10-06 09:00:00	AAPL	Stock	3.3271	3.3696	3.2539	3.3207	209987708.0
2008-10-06 10:00:00	AAPL	Stock	3.3199	3.3571	3.1264	3.29	371699272.0
2008-10-06 11:00:00	AAPL	Stock	3.2921	3.3211	3.2304	3.2493	229887588.0
2008-10-06 12:00:00	AAPL	Stock	3.2489	3.2768	3.1468	3.1679	190158920.0
2008-10-06 13:00:00	AAPL	Stock	3.1689	3.2421	3.1429	3.1914	228567444.0
2008-10-06 14:00:00	AAPL	Stock	3.1921	3.2529	3.1546	3.2356	272429976.0
2008-10-06 15:00:00	AAPL	Stock	3.2354	3.5279	3.2036	3.4896	506837240.0
2008-10-06 16:00:00	AAPL	Stock	3.4671	3.5268	3.2715	3.4729	51526944.0
2008-10-06 17:00:00	AAPL	Stock	3.4732	3.4825	3.4643	3.4804	1452108.0
2008-10-06 18:00:00	AAPL	Stock	3.475	3.4821	3.4611	3.4782	498344.0
2008-10-06 19:00:00	AAPL	Stock	3.4764	3.4911	3.475	3.4893	330848.0
2008-10-06 07:00:00	MSFT	Stock	25.5	25.79	25.5	25.79	3585.0
2008-10-06 08:00:00	MSFT	Stock	25.67	26.2	25.61	25.7	45728.0
2008-10-06 09:00:00	MSFT	Stock	25.76	26.0	25.31	25.47	13393118.0
2008-10-06 10:00:00	MSFT	Stock	25.46	25.6	24.6	25.08	22569101.0
2008-10-06 11:00:00	MSFT	Stock	25.08	25.25	24.69	24.69	17946454.0
2008-10-06 12:00:00	MSFT	Stock	24.69	24.82	24.5	24.6	14213077.0
2008-10-06 13:00:00	MSFT	Stock	24.602	24.83	24.5	24.63	12754310.0
2008-10-06 14:00:00	MSFT	Stock	24.63	24.645	24.14	24.53	20282829.0
2008-10-06 15:00:00	MSFT	Stock	24.528	25.1	24.28	24.93	33243512.0
2008-10-06 16:00:00	MSFT	Stock	24.97	24.98	24.417	24.7	9908913.0
2008-10-06 17:00:00	MSFT	Stock	24.7	24.75	24.61	24.75	16033.0
2008-10-06 18:00:00	MSFT	Stock	24.73	24.75	24.7	24.7	2313.0
2008-10-06 19:00:00	MSFT	Stock	24.75	24.77	24.68	24.7	33550.0
2008-10-06 08:00:00	NVDA	Stock	0.22	0.224	0.2145	0.2163	456080.0
2008-10-06 09:00:00	NVDA	Stock	0.2168	0.2175	0.2	0.2015	185213800.0
2008-10-06 10:00:00	NVDA	Stock	0.2015	0.205	0.1958	0.2	242207560.0
2008-10-06 11:00:00	NVDA	Stock	0.1999	0.2018	0.1915	0.1935	225679640.0
2008-10-06 12:00:00	NVDA	Stock	0.1935	0.1988	0.1925	0.1928	132745200.0
2008-10-06 13:00:00	NVDA	Stock	0.1926	0.1955	0.1895	0.1895	154602280.0
2008-10-06 14:00:00	NVDA	Stock	0.1895	0.1895	0.1828	0.1853	255332800.0
2008-10-06 15:00:00	NVDA	Stock	0.1855	0.1965	0.1848	0.1955	434162720.0
2008-10-06 16:00:00	NVDA	Stock	0.195	0.2023	0.1917	0.197	39950840.0
2008-10-06 17:00:00	NVDA	Stock	0.197	0.2013	0.197	0.2007	84200.0
2008-10-06 18:00:00	NVDA	Stock	0.2013	0.2015	0.2	0.2	184000.0
2008-10-06 19:00:00	NVDA	Stock	0.1988	0.1988	0.1975	0.1975	174800.0
2008-10-06 08:00:00	AMZN	Stock	3.2845	3.285	3.225	3.245	153800.0
2008-10-06 09:00:00	AMZN	Stock	3.23	3.2445	3.1325	3.1425	29256080.0
2008-10-06 10:00:00	AMZN	Stock	3.144	3.1765	3.0567	3.1475	61929800.0
2008-10-06 11:00:00	AMZN	Stock	3.1435	3.188	3.1205	3.1365	23811900.0
2008-10-06 12:00:00	AMZN	Stock	3.137	3.166	3.1	3.112	18426060.0
2008-10-06 13:00:00	AMZN	Stock	3.1123	3.16	3.073	3.1035	21250040.0
2008-10-06 14:00:00	AMZN	Stock	3.1025	3.1025	3.0235	3.085	30511160.0
2008-10-06 15:00:00	AMZN	Stock	3.0848	3.2945	3.0685	3.2575	67574220.0
2008-10-06 16:00:00	AMZN	Stock	3.2575	3.423	3.1137	3.253	12146140.0
2008-10-06 17:00:00	AMZN	Stock	3.236	3.236	3.225	3.23	55600.0
2008-10-06 18:00:00	AMZN	Stock	3.2255	3.23	3.2255	3.23	4000.0
2008-10-06 19:00:00	AMZN	Stock	3.23	3.244	3.225	3.225	12800.0

> showing 50 of 42,469 rows — these rows as CSV

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