PREVIEW / stock_1hour / 2011-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-13.parquet
  size:    934 KB
  rows:    44,106
  symbols: 3,528

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-04-13 04:00:00	AAPL	Stock	11.9236	11.9236	11.9236	11.9236	2800.0
2011-04-13 05:00:00	AAPL	Stock	11.9236	11.95	11.9236	11.9464	19600.0
2011-04-13 06:00:00	AAPL	Stock	11.9682	11.9764	11.9661	11.9764	16800.0
2011-04-13 07:00:00	AAPL	Stock	11.9696	11.9854	11.9479	11.9854	910700.0
2011-04-13 08:00:00	AAPL	Stock	11.9807	11.9893	11.9643	11.9657	1881264.0
2011-04-13 09:00:00	AAPL	Stock	11.9725	11.9725	11.8702	11.8979	53513236.0
2011-04-13 10:00:00	AAPL	Stock	11.8989	11.9714	11.8757	11.9564	66715376.0
2011-04-13 11:00:00	AAPL	Stock	11.9568	11.9643	11.9021	11.9121	39348064.0
2011-04-13 12:00:00	AAPL	Stock	11.9126	11.9464	11.8804	11.8973	35516544.0
2011-04-13 13:00:00	AAPL	Stock	11.8946	11.9154	11.8775	11.8957	26545904.0
2011-04-13 14:00:00	AAPL	Stock	11.8957	11.9611	11.8857	11.9514	34304032.0
2011-04-13 15:00:00	AAPL	Stock	11.9529	12.005	11.9461	12.0031	64749160.0
2011-04-13 16:00:00	AAPL	Stock	12.0032	12.0352	11.8765	11.9982	8175832.0
2011-04-13 17:00:00	AAPL	Stock	11.9979	12.0032	11.9914	11.9929	5487412.0
2011-04-13 18:00:00	AAPL	Stock	11.9961	12.0046	11.9957	11.9964	240632.0
2011-04-13 19:00:00	AAPL	Stock	11.9954	11.9982	11.9786	11.9875	175952.0
2011-04-13 07:00:00	MSFT	Stock	25.84	25.84	25.75	25.75	11565.0
2011-04-13 08:00:00	MSFT	Stock	25.72	25.79	25.64	25.75	23125.0
2011-04-13 09:00:00	MSFT	Stock	25.75	25.87	25.6	25.82	4680482.0
2011-04-13 10:00:00	MSFT	Stock	25.82	25.86	25.75	25.825	5701506.0
2011-04-13 11:00:00	MSFT	Stock	25.83	25.83	25.65	25.65	3129224.0
2011-04-13 12:00:00	MSFT	Stock	25.66	25.69	25.56	25.64	3406476.0
2011-04-13 13:00:00	MSFT	Stock	25.65	25.73	25.62	25.63	2539866.0
2011-04-13 14:00:00	MSFT	Stock	25.62	25.77	25.62	25.75	3057757.0
2011-04-13 15:00:00	MSFT	Stock	25.758	25.81	25.62	25.62	8684117.0
2011-04-13 16:00:00	MSFT	Stock	25.63	25.836	25.57	25.57	951667.0
2011-04-13 17:00:00	MSFT	Stock	25.57	25.63	25.57	25.6	5130291.0
2011-04-13 18:00:00	MSFT	Stock	25.63	25.63	25.58	25.6	20465.0
2011-04-13 19:00:00	MSFT	Stock	25.58	25.6	25.58	25.6	1600.0
2011-04-13 08:00:00	NVDA	Stock	0.4375	0.4438	0.4375	0.4425	735880.0
2011-04-13 09:00:00	NVDA	Stock	0.4425	0.4438	0.4332	0.4345	105631680.0
2011-04-13 10:00:00	NVDA	Stock	0.4348	0.443	0.434	0.442	132527560.0
2011-04-13 11:00:00	NVDA	Stock	0.442	0.4428	0.436	0.4362	65823720.0
2011-04-13 12:00:00	NVDA	Stock	0.4362	0.439	0.4354	0.437	51863480.0
2011-04-13 13:00:00	NVDA	Stock	0.437	0.4388	0.4352	0.436	37970920.0
2011-04-13 14:00:00	NVDA	Stock	0.436	0.4445	0.436	0.4441	133487760.0
2011-04-13 15:00:00	NVDA	Stock	0.4442	0.4468	0.443	0.444	204531080.0
2011-04-13 16:00:00	NVDA	Stock	0.4438	0.4452	0.4376	0.4445	14982480.0
2011-04-13 17:00:00	NVDA	Stock	0.4422	0.4438	0.442	0.4428	356920.0
2011-04-13 18:00:00	NVDA	Stock	0.4448	0.445	0.442	0.4442	380000.0
2011-04-13 19:00:00	NVDA	Stock	0.442	0.4425	0.442	0.4425	475800.0
2011-04-13 07:00:00	AMZN	Stock	9.0375	9.0725	9.0375	9.068	120000.0
2011-04-13 08:00:00	AMZN	Stock	9.0635	9.1135	9.05	9.087	240100.0
2011-04-13 09:00:00	AMZN	Stock	9.084	9.0935	8.99	9.063	15154860.0
2011-04-13 10:00:00	AMZN	Stock	9.0645	9.122	9.0182	9.112	15606760.0
2011-04-13 11:00:00	AMZN	Stock	9.111	9.144	9.082	9.089	12473180.0
2011-04-13 12:00:00	AMZN	Stock	9.087	9.122	9.0475	9.0775	6985200.0
2011-04-13 13:00:00	AMZN	Stock	9.0788	9.0965	9.0275	9.0325	6324820.0
2011-04-13 14:00:00	AMZN	Stock	9.0365	9.114	9.035	9.0975	7284560.0
2011-04-13 15:00:00	AMZN	Stock	9.0955	9.1325	9.0935	9.1145	14260240.0

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

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