PREVIEW / stock_1hour / 2008-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-08.parquet
  size:    818 KB
  rows:    41,349
  symbols: 3,362

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-12-08 06:00:00	AAPL	Stock	3.4168	3.4321	3.4168	3.4321	42000.0
2008-12-08 07:00:00	AAPL	Stock	3.4311	3.4643	3.4286	3.4518	522256.0
2008-12-08 08:00:00	AAPL	Stock	3.4607	3.4868	3.4411	3.4768	3674664.0
2008-12-08 09:00:00	AAPL	Stock	3.4779	3.5	3.4214	3.4568	150049844.0
2008-12-08 10:00:00	AAPL	Stock	3.4561	3.5625	3.4489	3.5432	221759020.0
2008-12-08 11:00:00	AAPL	Stock	3.5432	3.5514	3.5018	3.5211	131368888.0
2008-12-08 12:00:00	AAPL	Stock	3.5214	3.5464	3.5132	3.5329	91610344.0
2008-12-08 13:00:00	AAPL	Stock	3.5325	3.5554	3.5186	3.5364	114103444.0
2008-12-08 14:00:00	AAPL	Stock	3.5379	3.5893	3.5282	3.5879	169493856.0
2008-12-08 15:00:00	AAPL	Stock	3.5882	3.6	3.5146	3.5607	256518416.0
2008-12-08 16:00:00	AAPL	Stock	3.5611	3.5645	3.5286	3.5357	37892288.0
2008-12-08 17:00:00	AAPL	Stock	3.5354	3.5614	3.5307	3.5361	977760.0
2008-12-08 18:00:00	AAPL	Stock	3.5357	3.5614	3.525	3.525	893816.0
2008-12-08 19:00:00	AAPL	Stock	3.5229	3.5268	3.5171	3.5196	433580.0
2008-12-08 07:00:00	MSFT	Stock	20.17	20.22	20.15	20.22	10317.0
2008-12-08 08:00:00	MSFT	Stock	20.18	20.4	20.01	20.34	89765.0
2008-12-08 09:00:00	MSFT	Stock	20.35	20.5	20.16	20.19	9291692.0
2008-12-08 10:00:00	MSFT	Stock	20.19	20.79	20.14	20.6	16326608.0
2008-12-08 11:00:00	MSFT	Stock	20.6	20.72	20.54	20.66	10139425.0
2008-12-08 12:00:00	MSFT	Stock	20.66	20.85	20.58	20.7	9113519.0
2008-12-08 13:00:00	MSFT	Stock	20.701	20.89	20.69	20.742	10623595.0
2008-12-08 14:00:00	MSFT	Stock	20.74	21.1	20.69	21.08	11718371.0
2008-12-08 15:00:00	MSFT	Stock	21.07	21.25	20.76	21.01	28212429.0
2008-12-08 16:00:00	MSFT	Stock	21.01	21.01	20.758	20.81	9644856.0
2008-12-08 17:00:00	MSFT	Stock	21.01	21.01	20.76	20.76	139589.0
2008-12-08 18:00:00	MSFT	Stock	20.77	20.77	20.73	20.73	1950.0
2008-12-08 19:00:00	MSFT	Stock	20.72	20.8	20.7	20.72	3740.0
2008-12-08 07:00:00	NVDA	Stock	0.1925	0.1925	0.1925	0.1925	60000.0
2008-12-08 08:00:00	NVDA	Stock	0.1873	0.1962	0.185	0.1955	669800.0
2008-12-08 09:00:00	NVDA	Stock	0.194	0.194	0.1753	0.1863	102164160.0
2008-12-08 10:00:00	NVDA	Stock	0.1863	0.1898	0.1855	0.1855	106034400.0
2008-12-08 11:00:00	NVDA	Stock	0.1858	0.1863	0.1813	0.1818	61197880.0
2008-12-08 12:00:00	NVDA	Stock	0.182	0.1825	0.178	0.1789	49759640.0
2008-12-08 13:00:00	NVDA	Stock	0.179	0.181	0.1738	0.1748	91846800.0
2008-12-08 14:00:00	NVDA	Stock	0.1745	0.1805	0.174	0.1803	109056800.0
2008-12-08 15:00:00	NVDA	Stock	0.1803	0.181	0.176	0.178	149847840.0
2008-12-08 16:00:00	NVDA	Stock	0.1778	0.1873	0.1728	0.1735	13073320.0
2008-12-08 17:00:00	NVDA	Stock	0.1748	0.1755	0.1743	0.1755	805520.0
2008-12-08 18:00:00	NVDA	Stock	0.1755	0.1755	0.1755	0.1755	50000.0
2008-12-08 19:00:00	NVDA	Stock	0.1755	0.178	0.1743	0.178	325400.0
2008-12-08 04:00:00	AMZN	Stock	2.4995	2.4995	2.4995	2.4995	4000.0
2008-12-08 07:00:00	AMZN	Stock	2.45	2.45	2.45	2.45	10000.0
2008-12-08 08:00:00	AMZN	Stock	2.45	2.4875	2.4495	2.4625	383400.0
2008-12-08 09:00:00	AMZN	Stock	2.465	2.487	2.368	2.4405	36721360.0
2008-12-08 10:00:00	AMZN	Stock	2.4395	2.5225	2.4205	2.503	31596480.0
2008-12-08 11:00:00	AMZN	Stock	2.5015	2.508	2.4675	2.489	17221200.0
2008-12-08 12:00:00	AMZN	Stock	2.4895	2.5165	2.4805	2.496	14414680.0
2008-12-08 13:00:00	AMZN	Stock	2.497	2.515	2.474	2.4925	18634120.0
2008-12-08 14:00:00	AMZN	Stock	2.492	2.5695	2.49	2.568	24411800.0
2008-12-08 15:00:00	AMZN	Stock	2.5685	2.607	2.5395	2.5705	65069340.0

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

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