PREVIEW / stock_1hour / 2011-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-28.parquet
  size:    935 KB
  rows:    44,297
  symbols: 3,537

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-28 04:00:00	AAPL	Stock	12.5871	12.6071	12.5871	12.6071	28000.0
2011-03-28 05:00:00	AAPL	Stock	12.625	12.625	12.6168	12.6196	14280.0
2011-03-28 07:00:00	AAPL	Stock	12.6071	12.655	12.5964	12.6311	363580.0
2011-03-28 08:00:00	AAPL	Stock	12.625	12.6429	12.5979	12.6196	1831228.0
2011-03-28 09:00:00	AAPL	Stock	12.6232	12.6479	12.5714	12.6089	60734660.0
2011-03-28 10:00:00	AAPL	Stock	12.6071	12.6543	12.5918	12.6368	51983820.0
2011-03-28 11:00:00	AAPL	Stock	12.6371	12.6411	12.5643	12.5954	42982632.0
2011-03-28 12:00:00	AAPL	Stock	12.5957	12.6157	12.5782	12.6071	19954984.0
2011-03-28 13:00:00	AAPL	Stock	12.6071	12.6321	12.6068	12.6139	18758432.0
2011-03-28 14:00:00	AAPL	Stock	12.6136	12.6246	12.5811	12.5841	26878040.0
2011-03-28 15:00:00	AAPL	Stock	12.5831	12.605	12.5157	12.5161	68054924.0
2011-03-28 16:00:00	AAPL	Stock	12.5179	12.6029	12.5004	12.5125	10368120.0
2011-03-28 17:00:00	AAPL	Stock	12.5118	12.5157	12.4936	12.4982	1146040.0
2011-03-28 18:00:00	AAPL	Stock	12.4975	12.5157	12.4954	12.5	305312.0
2011-03-28 19:00:00	AAPL	Stock	12.5	12.5	12.4936	12.4993	223748.0
2011-03-28 07:00:00	MSFT	Stock	25.68	25.68	25.68	25.68	200.0
2011-03-28 08:00:00	MSFT	Stock	25.65	25.73	25.63	25.68	19130.0
2011-03-28 09:00:00	MSFT	Stock	25.72	25.73	25.53	25.63	2819008.0
2011-03-28 10:00:00	MSFT	Stock	25.63	25.7	25.6	25.63	5073240.0
2011-03-28 11:00:00	MSFT	Stock	25.63	25.64	25.59	25.63	3964635.0
2011-03-28 12:00:00	MSFT	Stock	25.62	25.64	25.57	25.61	5759775.0
2011-03-28 13:00:00	MSFT	Stock	25.6	25.62	25.54	25.541	4495213.0
2011-03-28 14:00:00	MSFT	Stock	25.54	25.59	25.52	25.57	8144512.0
2011-03-28 15:00:00	MSFT	Stock	25.575	25.585	25.38	25.41	15195866.0
2011-03-28 16:00:00	MSFT	Stock	25.41	25.63	25.34	25.42	1986584.0
2011-03-28 17:00:00	MSFT	Stock	25.42	25.42	25.4	25.4	44514.0
2011-03-28 18:00:00	MSFT	Stock	25.41	25.41	25.41	25.41	4578.0
2011-03-28 19:00:00	MSFT	Stock	25.41	25.41	25.39	25.4	2050.0
2011-03-28 05:00:00	NVDA	Stock	0.4772	0.4775	0.4772	0.4775	36000.0
2011-03-28 07:00:00	NVDA	Stock	0.4768	0.4798	0.476	0.4775	992000.0
2011-03-28 08:00:00	NVDA	Stock	0.4735	0.4788	0.4735	0.4775	3568680.0
2011-03-28 09:00:00	NVDA	Stock	0.4763	0.481	0.4725	0.4793	204724080.0
2011-03-28 10:00:00	NVDA	Stock	0.479	0.4908	0.476	0.4858	275920320.0
2011-03-28 11:00:00	NVDA	Stock	0.4858	0.4875	0.4832	0.487	144705840.0
2011-03-28 12:00:00	NVDA	Stock	0.4869	0.4883	0.4855	0.487	93261360.0
2011-03-28 13:00:00	NVDA	Stock	0.4868	0.491	0.4868	0.4876	128527760.0
2011-03-28 14:00:00	NVDA	Stock	0.4878	0.4898	0.4838	0.4843	120419920.0
2011-03-28 15:00:00	NVDA	Stock	0.4844	0.4855	0.482	0.4828	204458640.0
2011-03-28 16:00:00	NVDA	Stock	0.483	0.4854	0.4808	0.4822	5693600.0
2011-03-28 17:00:00	NVDA	Stock	0.4822	0.4864	0.4818	0.4825	2712200.0
2011-03-28 18:00:00	NVDA	Stock	0.4825	0.4828	0.482	0.482	135680.0
2011-03-28 19:00:00	NVDA	Stock	0.483	0.483	0.4812	0.4815	428600.0
2011-03-28 04:00:00	AMZN	Stock	8.6065	8.6065	8.6065	8.6065	2000.0
2011-03-28 08:00:00	AMZN	Stock	8.6	8.6	8.589	8.589	25620.0
2011-03-28 09:00:00	AMZN	Stock	8.586	8.625	8.536	8.5425	10073740.0
2011-03-28 10:00:00	AMZN	Stock	8.545	8.545	8.475	8.523	17629080.0
2011-03-28 11:00:00	AMZN	Stock	8.5235	8.5465	8.501	8.5275	6702060.0
2011-03-28 12:00:00	AMZN	Stock	8.5263	8.546	8.5175	8.5325	5521980.0
2011-03-28 13:00:00	AMZN	Stock	8.5325	8.57	8.5275	8.5275	6057860.0
2011-03-28 14:00:00	AMZN	Stock	8.5275	8.5545	8.504	8.509	6258600.0

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

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