PREVIEW / stock_1hour / 2011-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-30.parquet
  size:    945 KB
  rows:    44,603
  symbols: 3,522

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
2011-03-30 04:00:00	AAPL	Stock	12.6518	12.655	12.6214	12.6214	44800.0
2011-03-30 05:00:00	AAPL	Stock	12.625	12.625	12.6096	12.6096	11200.0
2011-03-30 06:00:00	AAPL	Stock	12.6096	12.6221	12.6089	12.6089	57736.0
2011-03-30 07:00:00	AAPL	Stock	12.6204	12.6204	12.5607	12.5854	1523312.0
2011-03-30 08:00:00	AAPL	Stock	12.5764	12.5854	12.5171	12.52	4148452.0
2011-03-30 09:00:00	AAPL	Stock	12.5211	12.5325	12.4214	12.4739	80916388.0
2011-03-30 10:00:00	AAPL	Stock	12.4739	12.4768	12.4086	12.4539	72810360.0
2011-03-30 11:00:00	AAPL	Stock	12.4521	12.4643	12.435	12.4424	25872084.0
2011-03-30 12:00:00	AAPL	Stock	12.4425	12.4714	12.4421	12.4514	25715004.0
2011-03-30 13:00:00	AAPL	Stock	12.4504	12.4668	12.4418	12.4486	22595804.0
2011-03-30 14:00:00	AAPL	Stock	12.4482	12.4704	12.4479	12.4543	23612792.0
2011-03-30 15:00:00	AAPL	Stock	12.453	12.4854	12.4379	12.4561	59433584.0
2011-03-30 16:00:00	AAPL	Stock	12.4564	12.5343	12.4382	12.4536	6423844.0
2011-03-30 17:00:00	AAPL	Stock	12.4564	12.4564	12.4393	12.4393	664944.0
2011-03-30 18:00:00	AAPL	Stock	12.4375	12.4511	12.4064	12.4107	508116.0
2011-03-30 19:00:00	AAPL	Stock	12.4179	12.4318	12.4107	12.4318	219856.0
2011-03-30 04:00:00	MSFT	Stock	25.62	25.67	25.62	25.67	549.0
2011-03-30 07:00:00	MSFT	Stock	25.6	25.6	25.6	25.6	100.0
2011-03-30 08:00:00	MSFT	Stock	25.63	25.68	25.56	25.59	41040.0
2011-03-30 09:00:00	MSFT	Stock	25.58	25.65	25.5	25.65	3785971.0
2011-03-30 10:00:00	MSFT	Stock	25.65	25.7	25.55	25.69	4701067.0
2011-03-30 11:00:00	MSFT	Stock	25.69	25.71	25.63	25.63	3786419.0
2011-03-30 12:00:00	MSFT	Stock	25.635	25.67	25.61	25.63	4915293.0
2011-03-30 13:00:00	MSFT	Stock	25.62	25.72	25.61	25.7	4523094.0
2011-03-30 14:00:00	MSFT	Stock	25.69	25.72	25.63	25.67	3909334.0
2011-03-30 15:00:00	MSFT	Stock	25.662	25.69	25.57	25.58	8294048.0
2011-03-30 16:00:00	MSFT	Stock	25.61	25.792	25.58	25.61	1636092.0
2011-03-30 17:00:00	MSFT	Stock	25.58	25.62	25.58	25.58	5592491.0
2011-03-30 18:00:00	MSFT	Stock	25.61	25.64	25.61	25.64	7002.0
2011-03-30 19:00:00	MSFT	Stock	25.62	25.62	25.62	25.62	781.0
2011-03-30 08:00:00	NVDA	Stock	0.4845	0.4892	0.4838	0.485	3389440.0
2011-03-30 09:00:00	NVDA	Stock	0.485	0.486	0.4673	0.4692	192237120.0
2011-03-30 10:00:00	NVDA	Stock	0.4692	0.4705	0.458	0.4608	327935000.0
2011-03-30 11:00:00	NVDA	Stock	0.4608	0.4628	0.4552	0.461	225251120.0
2011-03-30 12:00:00	NVDA	Stock	0.4612	0.4635	0.458	0.4585	106781960.0
2011-03-30 13:00:00	NVDA	Stock	0.4588	0.4615	0.4575	0.46	87692680.0
2011-03-30 14:00:00	NVDA	Stock	0.46	0.4612	0.4578	0.4585	70493400.0
2011-03-30 15:00:00	NVDA	Stock	0.4585	0.4625	0.4582	0.4615	152252160.0
2011-03-30 16:00:00	NVDA	Stock	0.4612	0.4632	0.4557	0.4622	8697640.0
2011-03-30 17:00:00	NVDA	Stock	0.4612	0.4622	0.4612	0.462	263680.0
2011-03-30 18:00:00	NVDA	Stock	0.462	0.4633	0.4618	0.4633	220000.0
2011-03-30 19:00:00	NVDA	Stock	0.4633	0.4633	0.4622	0.4622	308240.0
2011-03-30 04:00:00	AMZN	Stock	8.7835	8.7835	8.7835	8.7835	2000.0
2011-03-30 05:00:00	AMZN	Stock	8.8	8.8	8.8	8.8	12000.0
2011-03-30 06:00:00	AMZN	Stock	8.8215	8.8415	8.7925	8.7925	20000.0
2011-03-30 07:00:00	AMZN	Stock	8.83	8.8915	8.83	8.8625	350820.0
2011-03-30 08:00:00	AMZN	Stock	8.847	8.8735	8.815	8.864	762140.0
2011-03-30 09:00:00	AMZN	Stock	8.8645	8.987	8.86	8.97	28100440.0
2011-03-30 10:00:00	AMZN	Stock	8.9705	8.977	8.9025	8.965	18690100.0
2011-03-30 11:00:00	AMZN	Stock	8.9645	8.965	8.917	8.9505	10823500.0

> showing 50 of 44,603 rows — these rows as CSV

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