PREVIEW / stock_1hour / 2014-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-19.parquet
  size:    1.0 MB
  rows:    47,927
  symbols: 3,540

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
2014-03-19 05:00:00	AAPL	Stock	19.0264	19.0304	19.0179	19.0229	30800.0
2014-03-19 06:00:00	AAPL	Stock	19.0243	19.0243	19.0196	19.0196	11200.0
2014-03-19 07:00:00	AAPL	Stock	19.0211	19.05	19.0211	19.035	58996.0
2014-03-19 08:00:00	AAPL	Stock	19.0475	19.0518	19.0129	19.0511	516880.0
2014-03-19 09:00:00	AAPL	Stock	19.0482	19.1268	18.97	19.1139	35664776.0
2014-03-19 10:00:00	AAPL	Stock	19.1136	19.1514	19.055	19.0892	32682972.0
2014-03-19 11:00:00	AAPL	Stock	19.0911	19.1282	19.0761	19.1068	14208432.0
2014-03-19 12:00:00	AAPL	Stock	19.105	19.1171	19.0946	19.1157	11627532.0
2014-03-19 13:00:00	AAPL	Stock	19.1161	19.1321	19.0893	19.0936	9253188.0
2014-03-19 14:00:00	AAPL	Stock	19.1004	19.1004	19.0196	19.0352	26202792.0
2014-03-19 15:00:00	AAPL	Stock	19.0343	19.05	18.8929	18.9736	44572892.0
2014-03-19 16:00:00	AAPL	Stock	18.9736	19.1008	18.9557	18.9821	9632056.0
2014-03-19 17:00:00	AAPL	Stock	18.9821	18.9911	18.9736	18.9736	289352.0
2014-03-19 18:00:00	AAPL	Stock	18.9911	19.0	18.9911	19.0	47432.0
2014-03-19 19:00:00	AAPL	Stock	18.9918	19.0	18.9822	19.0	88228.0
2014-03-19 05:00:00	MSFT	Stock	39.66	39.79	39.65	39.73	2070.0
2014-03-19 06:00:00	MSFT	Stock	39.77	39.78	39.66	39.66	11567.0
2014-03-19 07:00:00	MSFT	Stock	39.66	39.7	39.6	39.6	5677.0
2014-03-19 08:00:00	MSFT	Stock	39.62	39.78	39.47	39.47	51466.0
2014-03-19 09:00:00	MSFT	Stock	39.5	39.55	39.24	39.35	5477352.0
2014-03-19 10:00:00	MSFT	Stock	39.35	39.49	39.18	39.266	6539328.0
2014-03-19 11:00:00	MSFT	Stock	39.26	39.34	39.22	39.31	3173972.0
2014-03-19 12:00:00	MSFT	Stock	39.31	39.39	39.25	39.38	2451229.0
2014-03-19 13:00:00	MSFT	Stock	39.38	39.45	39.3	39.445	1905115.0
2014-03-19 14:00:00	MSFT	Stock	39.45	39.48	39.24	39.37	4630628.0
2014-03-19 15:00:00	MSFT	Stock	39.37	39.37	38.91	39.26	7670388.0
2014-03-19 16:00:00	MSFT	Stock	39.27	39.495	39.22	39.27	2171299.0
2014-03-19 17:00:00	MSFT	Stock	39.23	39.24	39.2	39.2	2000.0
2014-03-19 18:00:00	MSFT	Stock	39.23	39.27	39.23	39.27	454189.0
2014-03-19 19:00:00	MSFT	Stock	39.27	39.27	39.27	39.27	900.0
2014-03-19 08:00:00	NVDA	Stock	0.4588	0.4588	0.4588	0.4588	4400.0
2014-03-19 09:00:00	NVDA	Stock	0.4595	0.4705	0.4582	0.4702	66349240.0
2014-03-19 10:00:00	NVDA	Stock	0.47	0.4728	0.468	0.4702	68811400.0
2014-03-19 11:00:00	NVDA	Stock	0.4701	0.4701	0.4662	0.4674	41718600.0
2014-03-19 12:00:00	NVDA	Stock	0.4674	0.4683	0.4662	0.467	22794840.0
2014-03-19 13:00:00	NVDA	Stock	0.467	0.4673	0.4661	0.4665	17184960.0
2014-03-19 14:00:00	NVDA	Stock	0.4662	0.4668	0.464	0.465	41342040.0
2014-03-19 15:00:00	NVDA	Stock	0.4651	0.4655	0.4608	0.4639	80681160.0
2014-03-19 16:00:00	NVDA	Stock	0.464	0.4666	0.4568	0.4639	397120.0
2014-03-19 07:00:00	AMZN	Stock	18.9745	18.975	18.928	18.93	30000.0
2014-03-19 08:00:00	AMZN	Stock	18.9335	18.9705	18.925	18.9575	114980.0
2014-03-19 09:00:00	AMZN	Stock	18.961	18.9715	18.7805	18.8565	7191940.0
2014-03-19 10:00:00	AMZN	Stock	18.86	18.876	18.734	18.7925	6830140.0
2014-03-19 11:00:00	AMZN	Stock	18.7825	18.823	18.75	18.7865	3747940.0
2014-03-19 12:00:00	AMZN	Stock	18.7825	18.866	18.7705	18.8235	3319600.0
2014-03-19 13:00:00	AMZN	Stock	18.8235	18.8365	18.793	18.817	4330180.0
2014-03-19 14:00:00	AMZN	Stock	18.8135	18.814	18.705	18.711	5598400.0
2014-03-19 15:00:00	AMZN	Stock	18.7085	18.719	18.471	18.6615	13810280.0
2014-03-19 16:00:00	AMZN	Stock	18.676	18.8105	18.6565	18.6615	195920.0
2014-03-19 17:00:00	AMZN	Stock	18.648	18.648	18.648	18.648	2000.0

> showing 50 of 47,927 rows — these rows as CSV

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