PREVIEW / stock_1hour / 2013-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-22.parquet
  size:    1.0 MB
  rows:    47,681
  symbols: 3,569

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-22 04:00:00	AAPL	Stock	18.67	18.6786	18.6539	18.6539	18200.0
2013-11-22 05:00:00	AAPL	Stock	18.6479	18.6479	18.6479	18.6479	2800.0
2013-11-22 06:00:00	AAPL	Stock	18.6286	18.6286	18.6286	18.6286	2800.0
2013-11-22 07:00:00	AAPL	Stock	18.6207	18.6289	18.6143	18.6214	120596.0
2013-11-22 08:00:00	AAPL	Stock	18.6214	18.6357	18.5929	18.6061	901768.0
2013-11-22 09:00:00	AAPL	Stock	18.6018	18.6282	18.5189	18.6007	39653684.0
2013-11-22 10:00:00	AAPL	Stock	18.6036	18.6486	18.5782	18.5861	48664728.0
2013-11-22 11:00:00	AAPL	Stock	18.5864	18.6054	18.5637	18.5804	26045572.0
2013-11-22 12:00:00	AAPL	Stock	18.5804	18.5871	18.5632	18.5744	12740056.0
2013-11-22 13:00:00	AAPL	Stock	18.5743	18.5768	18.5425	18.5454	12367852.0
2013-11-22 14:00:00	AAPL	Stock	18.5475	18.5714	18.5429	18.5668	15453592.0
2013-11-22 15:00:00	AAPL	Stock	18.5668	18.5693	18.5468	18.5604	31027528.0
2013-11-22 16:00:00	AAPL	Stock	18.5643	18.582	18.5504	18.5625	13781488.0
2013-11-22 17:00:00	AAPL	Stock	18.6107	18.6107	18.5564	18.5632	19018916.0
2013-11-22 18:00:00	AAPL	Stock	18.5625	18.5636	18.5607	18.5636	84840.0
2013-11-22 19:00:00	AAPL	Stock	18.5589	18.5643	18.5589	18.5643	164220.0
2013-11-22 05:00:00	MSFT	Stock	37.42	37.42	37.42	37.42	978.0
2013-11-22 06:00:00	MSFT	Stock	37.46	37.46	37.4	37.45	4942.0
2013-11-22 07:00:00	MSFT	Stock	37.47	37.47	37.46	37.46	600.0
2013-11-22 08:00:00	MSFT	Stock	37.46	37.49	37.43	37.49	11759.0
2013-11-22 09:00:00	MSFT	Stock	37.49	37.54	37.33	37.478	2382792.0
2013-11-22 10:00:00	MSFT	Stock	37.48	37.54	37.4	37.42	4098707.0
2013-11-22 11:00:00	MSFT	Stock	37.42	37.64	37.42	37.62	2346783.0
2013-11-22 12:00:00	MSFT	Stock	37.625	37.68	37.57	37.62	1775261.0
2013-11-22 13:00:00	MSFT	Stock	37.62	37.62	37.469	37.52	4802036.0
2013-11-22 14:00:00	MSFT	Stock	37.53	37.67	37.51	37.545	2595848.0
2013-11-22 15:00:00	MSFT	Stock	37.534	37.62	37.51	37.56	5011685.0
2013-11-22 16:00:00	MSFT	Stock	37.57	37.584	37.408	37.55	3732282.0
2013-11-22 17:00:00	MSFT	Stock	37.55	37.6	37.54	37.57	12710.0
2013-11-22 19:00:00	MSFT	Stock	37.55	37.55	37.51	37.55	600.0
2013-11-22 09:00:00	NVDA	Stock	0.3835	0.3838	0.381	0.3818	19528880.0
2013-11-22 10:00:00	NVDA	Stock	0.3818	0.3818	0.3795	0.3813	24618320.0
2013-11-22 11:00:00	NVDA	Stock	0.3813	0.3813	0.3794	0.3801	17815160.0
2013-11-22 12:00:00	NVDA	Stock	0.3803	0.3808	0.3798	0.3805	10721840.0
2013-11-22 13:00:00	NVDA	Stock	0.3805	0.3805	0.3788	0.3794	15307040.0
2013-11-22 14:00:00	NVDA	Stock	0.3793	0.3803	0.3793	0.3803	13889080.0
2013-11-22 15:00:00	NVDA	Stock	0.3803	0.3808	0.3795	0.3798	38355360.0
2013-11-22 16:00:00	NVDA	Stock	0.3795	0.3824	0.3788	0.3803	17304800.0
2013-11-22 04:00:00	AMZN	Stock	18.5	18.5	18.5	18.5	2000.0
2013-11-22 05:00:00	AMZN	Stock	18.5015	18.5075	18.5015	18.5075	4000.0
2013-11-22 07:00:00	AMZN	Stock	18.5075	18.5075	18.5075	18.5075	2560.0
2013-11-22 08:00:00	AMZN	Stock	18.525	18.525	18.4875	18.5	46000.0
2013-11-22 09:00:00	AMZN	Stock	18.488	18.5115	18.3155	18.4545	8154040.0
2013-11-22 10:00:00	AMZN	Stock	18.44	18.57	18.4085	18.5245	9387880.0
2013-11-22 11:00:00	AMZN	Stock	18.5274	18.64	18.517	18.6268	6348540.0
2013-11-22 12:00:00	AMZN	Stock	18.6296	18.725	18.6045	18.7025	8783220.0
2013-11-22 13:00:00	AMZN	Stock	18.702	18.71	18.6295	18.6644	5538360.0
2013-11-22 14:00:00	AMZN	Stock	18.6628	18.695	18.6052	18.613	6020160.0
2013-11-22 15:00:00	AMZN	Stock	18.6125	18.644	18.5765	18.6105	8711060.0
2013-11-22 16:00:00	AMZN	Stock	18.6155	18.625	18.4476	18.5871	6094960.0

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

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