PREVIEW / stock_1hour / 2013-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-14.parquet
  size:    1014 KB
  rows:    47,203
  symbols: 3,512

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
2013-10-14 04:00:00	AAPL	Stock	17.2789	17.5361	17.2789	17.4732	184744.0
2013-10-14 05:00:00	AAPL	Stock	17.4746	17.4939	17.4739	17.4939	33600.0
2013-10-14 06:00:00	AAPL	Stock	17.5054	17.5118	17.4964	17.5118	30240.0
2013-10-14 07:00:00	AAPL	Stock	17.5054	17.5193	17.4518	17.4839	491568.0
2013-10-14 08:00:00	AAPL	Stock	17.4714	17.5089	17.4196	17.4954	2092832.0
2013-10-14 09:00:00	AAPL	Stock	17.4957	17.7464	17.4704	17.7425	58431296.0
2013-10-14 10:00:00	AAPL	Stock	17.7425	17.76	17.6057	17.6186	54635168.0
2013-10-14 11:00:00	AAPL	Stock	17.6175	17.6914	17.5929	17.6814	25233040.0
2013-10-14 12:00:00	AAPL	Stock	17.6811	17.7446	17.6643	17.7411	19343324.0
2013-10-14 13:00:00	AAPL	Stock	17.7393	17.75	17.7068	17.7218	15730988.0
2013-10-14 14:00:00	AAPL	Stock	17.725	17.7564	17.6829	17.7073	27963628.0
2013-10-14 15:00:00	AAPL	Stock	17.7039	17.7707	17.6893	17.7171	43678488.0
2013-10-14 16:00:00	AAPL	Stock	17.7157	17.7397	17.6734	17.7268	10238900.0
2013-10-14 17:00:00	AAPL	Stock	17.7279	17.7368	17.7125	17.7214	759920.0
2013-10-14 18:00:00	AAPL	Stock	17.7268	17.7318	17.7179	17.7218	90776.0
2013-10-14 19:00:00	AAPL	Stock	17.7218	17.7321	17.7157	17.7311	360360.0
2013-10-14 08:00:00	MSFT	Stock	33.9	34.0	33.89	33.93	4698.0
2013-10-14 09:00:00	MSFT	Stock	33.93	34.0	33.78	33.98	2528298.0
2013-10-14 10:00:00	MSFT	Stock	33.987	34.25	33.95	34.19	4358937.0
2013-10-14 11:00:00	MSFT	Stock	34.19	34.35	34.18	34.34	2633275.0
2013-10-14 12:00:00	MSFT	Stock	34.34	34.35	34.24	34.313	2832823.0
2013-10-14 13:00:00	MSFT	Stock	34.32	34.38	34.285	34.37	2173889.0
2013-10-14 14:00:00	MSFT	Stock	34.37	34.495	34.35	34.435	3300362.0
2013-10-14 15:00:00	MSFT	Stock	34.437	34.5	34.38	34.46	6862295.0
2013-10-14 16:00:00	MSFT	Stock	34.47	34.49	34.161	34.47	1962296.0
2013-10-14 17:00:00	MSFT	Stock	34.47	34.52	34.47	34.48	37600.0
2013-10-14 18:00:00	MSFT	Stock	34.52	34.52	34.5	34.5	900.0
2013-10-14 19:00:00	MSFT	Stock	34.5	34.54	34.49	34.54	5550.0
2013-10-14 08:00:00	NVDA	Stock	0.3803	0.3803	0.378	0.378	18000.0
2013-10-14 09:00:00	NVDA	Stock	0.3805	0.3828	0.3805	0.3826	23424720.0
2013-10-14 10:00:00	NVDA	Stock	0.3828	0.3848	0.3818	0.383	32980200.0
2013-10-14 11:00:00	NVDA	Stock	0.3831	0.3853	0.3826	0.3852	15362280.0
2013-10-14 12:00:00	NVDA	Stock	0.385	0.3858	0.3842	0.3858	22121480.0
2013-10-14 13:00:00	NVDA	Stock	0.3858	0.3862	0.3854	0.386	13961360.0
2013-10-14 14:00:00	NVDA	Stock	0.386	0.387	0.3858	0.3861	19948640.0
2013-10-14 15:00:00	NVDA	Stock	0.3862	0.3873	0.386	0.3871	32756000.0
2013-10-14 16:00:00	NVDA	Stock	0.3873	0.3878	0.3846	0.3878	5692000.0
2013-10-14 06:00:00	AMZN	Stock	15.4195	15.4195	15.4195	15.4195	2000.0
2013-10-14 07:00:00	AMZN	Stock	15.425	15.4265	15.4075	15.4075	21500.0
2013-10-14 08:00:00	AMZN	Stock	15.4275	15.4345	15.4	15.4075	64660.0
2013-10-14 09:00:00	AMZN	Stock	15.425	15.5335	15.4035	15.4775	4291500.0
2013-10-14 10:00:00	AMZN	Stock	15.4675	15.4995	15.353	15.364	4659300.0
2013-10-14 11:00:00	AMZN	Stock	15.357	15.4907	15.35	15.484	2029800.0
2013-10-14 12:00:00	AMZN	Stock	15.484	15.538	15.4665	15.5355	2459060.0
2013-10-14 13:00:00	AMZN	Stock	15.537	15.555	15.4935	15.521	4439940.0
2013-10-14 14:00:00	AMZN	Stock	15.5295	15.5822	15.489	15.5032	5848980.0
2013-10-14 15:00:00	AMZN	Stock	15.4995	15.542	15.462	15.535	9209240.0
2013-10-14 16:00:00	AMZN	Stock	15.535	15.5381	15.4792	15.4836	2252320.0
2013-10-14 17:00:00	AMZN	Stock	15.5	15.5015	15.5	15.5015	20000.0
2013-10-14 18:00:00	AMZN	Stock	15.529	15.535	15.529	15.5295	20000.0

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

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