PREVIEW / stock_1hour / 2013-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-01.parquet
  size:    1.0 MB
  rows:    48,342
  symbols: 3,531

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-11-01 04:00:00	AAPL	Stock	18.6786	18.6786	18.6786	18.6786	2800.0
2013-11-01 05:00:00	AAPL	Stock	18.6786	18.6875	18.6786	18.6875	9744.0
2013-11-01 06:00:00	AAPL	Stock	18.6786	18.6786	18.5714	18.5893	263704.0
2013-11-01 07:00:00	AAPL	Stock	18.6071	18.7486	18.6071	18.7454	314776.0
2013-11-01 08:00:00	AAPL	Stock	18.7411	18.7493	18.6554	18.7232	961296.0
2013-11-01 09:00:00	AAPL	Stock	18.7239	18.7429	18.6436	18.7007	36000132.0
2013-11-01 10:00:00	AAPL	Stock	18.7029	18.725	18.6232	18.6364	37170756.0
2013-11-01 11:00:00	AAPL	Stock	18.6382	18.6429	18.5146	18.5207	41558692.0
2013-11-01 12:00:00	AAPL	Stock	18.5204	18.5846	18.5189	18.5369	22797684.0
2013-11-01 13:00:00	AAPL	Stock	18.5325	18.55	18.4229	18.4954	41113688.0
2013-11-01 14:00:00	AAPL	Stock	18.4939	18.5225	18.4404	18.4804	27623792.0
2013-11-01 15:00:00	AAPL	Stock	18.4806	18.5875	18.4804	18.5693	50098440.0
2013-11-01 16:00:00	AAPL	Stock	18.5729	18.5921	18.5622	18.5729	11534572.0
2013-11-01 17:00:00	AAPL	Stock	18.5725	18.5796	18.5579	18.5636	682220.0
2013-11-01 18:00:00	AAPL	Stock	18.5729	18.5804	18.5443	18.5793	382340.0
2013-11-01 19:00:00	AAPL	Stock	18.5725	18.5725	18.5375	18.5429	183848.0
2013-11-01 04:00:00	MSFT	Stock	35.39	35.39	35.39	35.39	100.0
2013-11-01 06:00:00	MSFT	Stock	35.5	35.5	35.5	35.5	1000.0
2013-11-01 07:00:00	MSFT	Stock	35.5	35.5	35.5	35.5	1000.0
2013-11-01 08:00:00	MSFT	Stock	35.45	35.56	35.4	35.55	8200.0
2013-11-01 09:00:00	MSFT	Stock	35.55	35.69	35.35	35.635	4041421.0
2013-11-01 10:00:00	MSFT	Stock	35.64	35.66	35.51	35.543	6138973.0
2013-11-01 11:00:00	MSFT	Stock	35.545	35.57	35.39	35.41	6411594.0
2013-11-01 12:00:00	MSFT	Stock	35.405	35.54	35.395	35.485	4599070.0
2013-11-01 13:00:00	MSFT	Stock	35.485	35.56	35.4	35.53	5095432.0
2013-11-01 14:00:00	MSFT	Stock	35.54	35.57	35.5	35.51	2896937.0
2013-11-01 15:00:00	MSFT	Stock	35.51	35.6	35.49	35.51	7927065.0
2013-11-01 16:00:00	MSFT	Stock	35.51	35.58	35.44	35.47	2723630.0
2013-11-01 17:00:00	MSFT	Stock	35.51	35.51	35.47	35.47	36391.0
2013-11-01 18:00:00	MSFT	Stock	35.51	35.59	35.48	35.48	6854.0
2013-11-01 19:00:00	MSFT	Stock	35.48	35.48	35.48	35.48	400.0
2013-11-01 08:00:00	NVDA	Stock	0.3808	0.3808	0.3808	0.3808	32160.0
2013-11-01 09:00:00	NVDA	Stock	0.3815	0.382	0.3788	0.381	23929320.0
2013-11-01 10:00:00	NVDA	Stock	0.3813	0.383	0.3803	0.3818	43098800.0
2013-11-01 11:00:00	NVDA	Stock	0.3818	0.3822	0.3798	0.3811	32165440.0
2013-11-01 12:00:00	NVDA	Stock	0.3811	0.3833	0.381	0.3829	18903080.0
2013-11-01 13:00:00	NVDA	Stock	0.3828	0.3828	0.3805	0.3815	23085080.0
2013-11-01 14:00:00	NVDA	Stock	0.3815	0.3825	0.3814	0.3815	19533240.0
2013-11-01 15:00:00	NVDA	Stock	0.3816	0.3822	0.3813	0.3813	36024960.0
2013-11-01 16:00:00	NVDA	Stock	0.3815	0.3818	0.3805	0.3813	8737040.0
2013-11-01 07:00:00	AMZN	Stock	18.1845	18.2405	18.1845	18.2405	12600.0
2013-11-01 08:00:00	AMZN	Stock	18.2015	18.2385	18.2015	18.235	76540.0
2013-11-01 09:00:00	AMZN	Stock	18.2015	18.2885	18.0911	18.12	10181840.0
2013-11-01 10:00:00	AMZN	Stock	18.118	18.132	17.9835	18.0335	11012660.0
2013-11-01 11:00:00	AMZN	Stock	18.0375	18.045	17.9095	17.914	9127640.0
2013-11-01 12:00:00	AMZN	Stock	17.9136	17.9894	17.8145	17.834	9855760.0
2013-11-01 13:00:00	AMZN	Stock	17.84	17.9145	17.805	17.8795	7785580.0
2013-11-01 14:00:00	AMZN	Stock	17.8825	17.924	17.875	17.875	4492460.0
2013-11-01 15:00:00	AMZN	Stock	17.88	17.975	17.8685	17.945	9909340.0
2013-11-01 16:00:00	AMZN	Stock	17.954	18.055	17.9224	17.954	3859480.0

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

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