PREVIEW / stock_1hour / 2008-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-16.parquet
  size:    819 KB
  rows:    41,326
  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-10-16 04:00:00	AAPL	Stock	3.5	3.5	3.4996	3.4996	79044.0
2008-10-16 05:00:00	AAPL	Stock	3.4821	3.4821	3.4821	3.4821	8400.0
2008-10-16 06:00:00	AAPL	Stock	3.4911	3.5171	3.4696	3.4696	51072.0
2008-10-16 07:00:00	AAPL	Stock	3.5	3.5318	3.4861	3.4946	846020.0
2008-10-16 08:00:00	AAPL	Stock	3.4946	3.6014	3.4696	3.5857	7924728.0
2008-10-16 09:00:00	AAPL	Stock	3.5854	3.6136	3.4393	3.4729	207118856.0
2008-10-16 10:00:00	AAPL	Stock	3.4736	3.4746	3.2964	3.3468	395715992.0
2008-10-16 11:00:00	AAPL	Stock	3.3461	3.4379	3.2764	3.4	252032256.0
2008-10-16 12:00:00	AAPL	Stock	3.4007	3.5143	3.3586	3.405	252712040.0
2008-10-16 13:00:00	AAPL	Stock	3.4046	3.4464	3.3571	3.4354	165447128.0
2008-10-16 14:00:00	AAPL	Stock	3.435	3.4857	3.3496	3.4625	191091124.0
2008-10-16 15:00:00	AAPL	Stock	3.4625	3.6939	3.45	3.6364	391731592.0
2008-10-16 16:00:00	AAPL	Stock	3.6379	3.7161	3.4389	3.6786	36913800.0
2008-10-16 17:00:00	AAPL	Stock	3.6786	3.7143	3.6389	3.7143	2641940.0
2008-10-16 18:00:00	AAPL	Stock	3.7136	3.7668	3.7061	3.7504	1491476.0
2008-10-16 19:00:00	AAPL	Stock	3.7536	3.7854	3.7375	3.7393	3117716.0
2008-10-16 06:00:00	MSFT	Stock	22.66	22.66	22.66	22.66	200.0
2008-10-16 07:00:00	MSFT	Stock	22.72	22.77	22.66	22.72	21924.0
2008-10-16 08:00:00	MSFT	Stock	22.75	23.2	22.67	23.06	87851.0
2008-10-16 09:00:00	MSFT	Stock	23.06	23.35	22.68	23.32	15240102.0
2008-10-16 10:00:00	MSFT	Stock	23.32	23.33	21.66	21.69	28724203.0
2008-10-16 11:00:00	MSFT	Stock	21.7	22.45	21.31	22.37	26960732.0
2008-10-16 12:00:00	MSFT	Stock	22.37	23.21	22.14	22.55	18596483.0
2008-10-16 13:00:00	MSFT	Stock	22.54	23.09	22.38	22.96	15316222.0
2008-10-16 14:00:00	MSFT	Stock	22.96	23.09	22.5	22.94	15378125.0
2008-10-16 15:00:00	MSFT	Stock	22.94	24.19	22.86	24.18	31275944.0
2008-10-16 16:00:00	MSFT	Stock	24.19	24.21	22.517	23.9	6979566.0
2008-10-16 17:00:00	MSFT	Stock	23.9	24.19	23.85	23.93	70563.0
2008-10-16 18:00:00	MSFT	Stock	23.95	24.13	23.92	24.0	9554.0
2008-10-16 19:00:00	MSFT	Stock	23.98	24.15	23.98	24.0	13760.0
2008-10-16 08:00:00	NVDA	Stock	0.182	0.182	0.1688	0.1788	1409800.0
2008-10-16 09:00:00	NVDA	Stock	0.1795	0.1848	0.175	0.1805	98565360.0
2008-10-16 10:00:00	NVDA	Stock	0.1805	0.1813	0.1725	0.1743	167275560.0
2008-10-16 11:00:00	NVDA	Stock	0.1745	0.1845	0.1725	0.1823	138936600.0
2008-10-16 12:00:00	NVDA	Stock	0.1823	0.186	0.1773	0.1838	165368400.0
2008-10-16 13:00:00	NVDA	Stock	0.1835	0.188	0.182	0.187	122711440.0
2008-10-16 14:00:00	NVDA	Stock	0.187	0.189	0.1828	0.1865	85869160.0
2008-10-16 15:00:00	NVDA	Stock	0.1865	0.1935	0.1858	0.1923	198978480.0
2008-10-16 16:00:00	NVDA	Stock	0.1923	0.195	0.1827	0.193	17982800.0
2008-10-16 17:00:00	NVDA	Stock	0.193	0.1962	0.1925	0.1962	534200.0
2008-10-16 18:00:00	NVDA	Stock	0.195	0.1962	0.1913	0.1938	1068200.0
2008-10-16 19:00:00	NVDA	Stock	0.1938	0.1998	0.1938	0.1998	102960.0
2008-10-16 04:00:00	AMZN	Stock	2.435	2.435	2.435	2.435	4000.0
2008-10-16 06:00:00	AMZN	Stock	2.3185	2.3185	2.318	2.318	70000.0
2008-10-16 08:00:00	AMZN	Stock	2.3655	2.3765	2.335	2.3475	1181360.0
2008-10-16 09:00:00	AMZN	Stock	2.3495	2.487	2.2935	2.378	63253080.0
2008-10-16 10:00:00	AMZN	Stock	2.3785	2.379	2.1695	2.2295	101154200.0
2008-10-16 11:00:00	AMZN	Stock	2.2295	2.31	2.193	2.2765	72470660.0
2008-10-16 12:00:00	AMZN	Stock	2.2775	2.387	2.252	2.295	52619720.0
2008-10-16 13:00:00	AMZN	Stock	2.2925	2.4845	2.284	2.4	37204780.0

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

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