PREVIEW / stock_1hour / 2013-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-02.parquet
  size:    1.0 MB
  rows:    48,725
  symbols: 3,524

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-02 04:00:00	AAPL	Stock	17.3357	17.3357	17.2929	17.3036	48720.0
2013-10-02 05:00:00	AAPL	Stock	17.2964	17.3071	17.2925	17.2925	54600.0
2013-10-02 06:00:00	AAPL	Stock	17.2932	17.3575	17.2857	17.3214	213556.0
2013-10-02 07:00:00	AAPL	Stock	17.3304	17.4336	17.3161	17.3889	1067612.0
2013-10-02 08:00:00	AAPL	Stock	17.3921	17.4282	17.31	17.3518	2103416.0
2013-10-02 09:00:00	AAPL	Stock	17.3532	17.3886	17.2768	17.3311	51198140.0
2013-10-02 10:00:00	AAPL	Stock	17.3254	17.555	17.2786	17.5043	77640948.0
2013-10-02 11:00:00	AAPL	Stock	17.5046	17.5507	17.4839	17.5261	30858940.0
2013-10-02 12:00:00	AAPL	Stock	17.5246	17.5643	17.4707	17.4889	22984248.0
2013-10-02 13:00:00	AAPL	Stock	17.4884	17.5268	17.4321	17.5032	24321976.0
2013-10-02 14:00:00	AAPL	Stock	17.5039	17.5114	17.4475	17.4704	20026440.0
2013-10-02 15:00:00	AAPL	Stock	17.4704	17.5018	17.4571	17.4843	28259056.0
2013-10-02 16:00:00	AAPL	Stock	17.4857	17.4928	17.4271	17.4793	17811416.0
2013-10-02 17:00:00	AAPL	Stock	17.4836	17.4857	17.4714	17.4732	777084.0
2013-10-02 18:00:00	AAPL	Stock	17.4786	17.4843	17.4661	17.475	1220884.0
2013-10-02 19:00:00	AAPL	Stock	17.4739	17.4739	17.3929	17.4318	564004.0
2013-10-02 07:00:00	MSFT	Stock	33.48	33.48	33.35	33.48	2914.0
2013-10-02 08:00:00	MSFT	Stock	33.43	33.47	33.35	33.4	11679.0
2013-10-02 09:00:00	MSFT	Stock	33.4	33.57	33.29	33.48	3527752.0
2013-10-02 10:00:00	MSFT	Stock	33.48	33.62	33.42	33.545	9195586.0
2013-10-02 11:00:00	MSFT	Stock	33.547	33.79	33.54	33.78	5052299.0
2013-10-02 12:00:00	MSFT	Stock	33.775	33.9	33.76	33.9	4076528.0
2013-10-02 13:00:00	MSFT	Stock	33.9	34.0	33.82	33.969	4452816.0
2013-10-02 14:00:00	MSFT	Stock	33.966	34.02	33.91	33.95	4502044.0
2013-10-02 15:00:00	MSFT	Stock	33.955	34.03	33.89	33.9	7800858.0
2013-10-02 16:00:00	MSFT	Stock	33.91	33.954	33.533	33.92	2491001.0
2013-10-02 17:00:00	MSFT	Stock	33.91	33.94	33.82	33.88	132081.0
2013-10-02 18:00:00	MSFT	Stock	33.91	33.91	33.85	33.89	897.0
2013-10-02 19:00:00	MSFT	Stock	33.85	33.85	33.72	33.72	14050.0
2013-10-02 06:00:00	NVDA	Stock	0.3878	0.3878	0.3878	0.3878	8000.0
2013-10-02 09:00:00	NVDA	Stock	0.3853	0.389	0.3828	0.3873	23769160.0
2013-10-02 10:00:00	NVDA	Stock	0.3875	0.3878	0.3853	0.3878	28228480.0
2013-10-02 11:00:00	NVDA	Stock	0.3878	0.3888	0.3873	0.3882	17019520.0
2013-10-02 12:00:00	NVDA	Stock	0.3881	0.39	0.388	0.3898	18917200.0
2013-10-02 13:00:00	NVDA	Stock	0.3898	0.39	0.3885	0.3885	14049680.0
2013-10-02 14:00:00	NVDA	Stock	0.3886	0.3893	0.388	0.3884	18771480.0
2013-10-02 15:00:00	NVDA	Stock	0.3884	0.3893	0.3879	0.3888	30089800.0
2013-10-02 16:00:00	NVDA	Stock	0.3885	0.3888	0.387	0.3888	7539480.0
2013-10-02 17:00:00	NVDA	Stock	0.3885	0.3885	0.3885	0.3885	380960.0
2013-10-02 04:00:00	AMZN	Stock	15.9615	15.9615	15.9615	15.9615	2000.0
2013-10-02 05:00:00	AMZN	Stock	15.9625	15.9625	15.9625	15.9625	2000.0
2013-10-02 06:00:00	AMZN	Stock	15.925	15.925	15.925	15.925	26000.0
2013-10-02 07:00:00	AMZN	Stock	15.958	15.961	15.9375	15.961	47100.0
2013-10-02 08:00:00	AMZN	Stock	15.961	16.046	15.92	15.92	123600.0
2013-10-02 09:00:00	AMZN	Stock	15.9335	16.0865	15.876	16.06	9693460.0
2013-10-02 10:00:00	AMZN	Stock	16.046	16.0765	15.89	15.9645	9019140.0
2013-10-02 11:00:00	AMZN	Stock	15.9625	16.0	15.9155	15.991	4052360.0
2013-10-02 12:00:00	AMZN	Stock	15.987	16.046	15.9395	15.9495	2533380.0
2013-10-02 13:00:00	AMZN	Stock	15.9525	16.0435	15.9	16.0235	4434080.0
2013-10-02 14:00:00	AMZN	Stock	16.0225	16.047	15.966	15.9995	3353360.0

> showing 50 of 48,725 rows — these rows as CSV

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