PREVIEW / stock_1hour / 2010-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-05.parquet
  size:    906 KB
  rows:    42,985
  symbols: 3,454

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
2010-01-05 05:00:00	AAPL	Stock	7.6911	7.6911	7.6768	7.6768	28000.0
2010-01-05 06:00:00	AAPL	Stock	7.675	7.6768	7.6714	7.675	44800.0
2010-01-05 07:00:00	AAPL	Stock	7.67	7.6882	7.6686	7.6786	509488.0
2010-01-05 08:00:00	AAPL	Stock	7.6786	7.7036	7.6354	7.645	8624168.0
2010-01-05 09:00:00	AAPL	Stock	7.6443	7.6996	7.6225	7.6871	126296632.0
2010-01-05 10:00:00	AAPL	Stock	7.6864	7.6986	7.6589	7.6723	101031700.0
2010-01-05 11:00:00	AAPL	Stock	7.6721	7.6868	7.6511	7.6821	56161056.0
2010-01-05 12:00:00	AAPL	Stock	7.6829	7.69	7.6618	7.6757	78779148.0
2010-01-05 13:00:00	AAPL	Stock	7.6754	7.6846	7.6575	7.6634	37894892.0
2010-01-05 14:00:00	AAPL	Stock	7.6636	7.6718	7.6161	7.6575	90495272.0
2010-01-05 15:00:00	AAPL	Stock	7.6571	7.6664	7.6396	7.6564	55914656.0
2010-01-05 16:00:00	AAPL	Stock	7.6675	7.683	7.6496	7.6575	10159716.0
2010-01-05 17:00:00	AAPL	Stock	7.6586	7.6671	7.6586	7.6595	406308.0
2010-01-05 18:00:00	AAPL	Stock	7.6595	7.6636	7.6593	7.6614	185360.0
2010-01-05 19:00:00	AAPL	Stock	7.6593	7.6632	7.6571	7.6593	185164.0
2010-01-05 07:00:00	MSFT	Stock	30.81	30.81	30.81	30.81	164.0
2010-01-05 08:00:00	MSFT	Stock	30.89	30.95	30.82	30.89	29885.0
2010-01-05 09:00:00	MSFT	Stock	30.89	31.09	30.85	30.99	8290136.0
2010-01-05 10:00:00	MSFT	Stock	30.99	31.1	30.94	31.015	7436889.0
2010-01-05 11:00:00	MSFT	Stock	31.018	31.08	30.92	30.94	5410644.0
2010-01-05 12:00:00	MSFT	Stock	30.934	30.99	30.75	30.81	5677630.0
2010-01-05 13:00:00	MSFT	Stock	30.81	30.83	30.69	30.75	4008498.0
2010-01-05 14:00:00	MSFT	Stock	30.75	30.92	30.64	30.91	5143474.0
2010-01-05 15:00:00	MSFT	Stock	30.92	31.0	30.87	30.95	8090302.0
2010-01-05 16:00:00	MSFT	Stock	30.94	30.98	30.908	30.96	3960726.0
2010-01-05 17:00:00	MSFT	Stock	30.871	30.99	30.871	30.93	98468.0
2010-01-05 18:00:00	MSFT	Stock	30.93	31.0	30.93	31.0	7457.0
2010-01-05 19:00:00	MSFT	Stock	31.0	31.0	31.0	31.0	2000.0
2010-01-05 04:00:00	NVDA	Stock	0.4635	0.4635	0.4635	0.4635	4000.0
2010-01-05 07:00:00	NVDA	Stock	0.4635	0.4635	0.4635	0.4635	36000.0
2010-01-05 08:00:00	NVDA	Stock	0.4622	0.4625	0.4612	0.4612	75960.0
2010-01-05 09:00:00	NVDA	Stock	0.4605	0.467	0.4603	0.4652	66857320.0
2010-01-05 10:00:00	NVDA	Stock	0.4652	0.474	0.4648	0.4692	177925040.0
2010-01-05 11:00:00	NVDA	Stock	0.4693	0.4708	0.4652	0.4668	83918560.0
2010-01-05 12:00:00	NVDA	Stock	0.4668	0.4671	0.462	0.4629	137716920.0
2010-01-05 13:00:00	NVDA	Stock	0.4628	0.4638	0.4625	0.463	47846120.0
2010-01-05 14:00:00	NVDA	Stock	0.463	0.4658	0.4615	0.4658	102658680.0
2010-01-05 15:00:00	NVDA	Stock	0.4658	0.469	0.4655	0.469	92603040.0
2010-01-05 16:00:00	NVDA	Stock	0.4695	0.47	0.466	0.469	11032880.0
2010-01-05 17:00:00	NVDA	Stock	0.469	0.4695	0.469	0.4695	60000.0
2010-01-05 18:00:00	NVDA	Stock	0.4695	0.4695	0.469	0.469	37000.0
2010-01-05 19:00:00	NVDA	Stock	0.4692	0.4695	0.4692	0.4695	16000.0
2010-01-05 07:00:00	AMZN	Stock	6.73	6.73	6.73	6.73	8000.0
2010-01-05 08:00:00	AMZN	Stock	6.704	6.725	6.69	6.7	120340.0
2010-01-05 09:00:00	AMZN	Stock	6.691	6.705	6.5905	6.695	30691140.0
2010-01-05 10:00:00	AMZN	Stock	6.692	6.7615	6.6725	6.705	43055060.0
2010-01-05 11:00:00	AMZN	Stock	6.703	6.738	6.652	6.6765	22171360.0
2010-01-05 12:00:00	AMZN	Stock	6.678	6.728	6.6735	6.7265	15828960.0
2010-01-05 13:00:00	AMZN	Stock	6.726	6.774	6.6965	6.7448	21458740.0
2010-01-05 14:00:00	AMZN	Stock	6.7435	6.7585	6.701	6.7135	16266880.0

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

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