PREVIEW / stock_1hour / 2013-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-17.parquet
  size:    1.0 MB
  rows:    47,625
  symbols: 3,522

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-17 04:00:00	AAPL	Stock	17.8939	17.8939	17.8939	17.8939	2800.0
2013-10-17 05:00:00	AAPL	Stock	17.8718	17.8718	17.8607	17.8607	39200.0
2013-10-17 06:00:00	AAPL	Stock	17.8571	17.9018	17.8571	17.9018	29400.0
2013-10-17 07:00:00	AAPL	Stock	17.8936	17.9439	17.8893	17.9054	450744.0
2013-10-17 08:00:00	AAPL	Stock	17.91	17.9464	17.81	17.8679	1893780.0
2013-10-17 09:00:00	AAPL	Stock	17.8568	17.9789	17.8214	17.9439	51358524.0
2013-10-17 10:00:00	AAPL	Stock	17.9493	18.0193	17.9189	17.9721	45926104.0
2013-10-17 11:00:00	AAPL	Stock	17.9725	18.0171	17.9718	18.0058	27044948.0
2013-10-17 12:00:00	AAPL	Stock	18.0075	18.0268	17.9907	18.0254	19211724.0
2013-10-17 13:00:00	AAPL	Stock	18.0248	18.0279	17.965	17.9771	19370008.0
2013-10-17 14:00:00	AAPL	Stock	17.9754	18.005	17.9646	17.9939	15280272.0
2013-10-17 15:00:00	AAPL	Stock	17.9927	18.0257	17.9857	18.0236	39178104.0
2013-10-17 16:00:00	AAPL	Stock	18.0236	18.0632	17.9793	18.0518	18707864.0
2013-10-17 17:00:00	AAPL	Stock	18.0518	18.0893	18.05	18.0707	706580.0
2013-10-17 18:00:00	AAPL	Stock	18.0764	18.0964	18.075	18.0964	232932.0
2013-10-17 19:00:00	AAPL	Stock	18.0932	18.1007	18.0236	18.0989	671720.0
2013-10-17 07:00:00	MSFT	Stock	34.6	34.6	34.6	34.6	100.0
2013-10-17 08:00:00	MSFT	Stock	34.62	34.62	34.4	34.47	8864.0
2013-10-17 09:00:00	MSFT	Stock	34.44	34.74	34.37	34.71	3566106.0
2013-10-17 10:00:00	MSFT	Stock	34.71	34.92	34.71	34.84	5583759.0
2013-10-17 11:00:00	MSFT	Stock	34.845	34.97	34.8	34.935	3607147.0
2013-10-17 12:00:00	MSFT	Stock	34.93	34.99	34.873	34.99	2478009.0
2013-10-17 13:00:00	MSFT	Stock	34.98	34.99	34.89	34.9	2121228.0
2013-10-17 14:00:00	MSFT	Stock	34.91	34.95	34.8	34.92	2788272.0
2013-10-17 15:00:00	MSFT	Stock	34.917	34.97	34.88	34.92	7850712.0
2013-10-17 16:00:00	MSFT	Stock	34.93	35.01	34.853	34.93	3001282.0
2013-10-17 17:00:00	MSFT	Stock	34.9	34.94	34.9	34.92	15600.0
2013-10-17 18:00:00	MSFT	Stock	34.9	34.95	34.9	34.95	3050.0
2013-10-17 19:00:00	MSFT	Stock	34.93	35.0	34.87	35.0	13990.0
2013-10-17 09:00:00	NVDA	Stock	0.3878	0.39	0.387	0.3898	21685360.0
2013-10-17 10:00:00	NVDA	Stock	0.3898	0.3915	0.3885	0.3896	41188880.0
2013-10-17 11:00:00	NVDA	Stock	0.3895	0.3908	0.389	0.3905	37352720.0
2013-10-17 12:00:00	NVDA	Stock	0.3902	0.3915	0.3898	0.3914	20151160.0
2013-10-17 13:00:00	NVDA	Stock	0.3914	0.3918	0.3898	0.3901	20910080.0
2013-10-17 14:00:00	NVDA	Stock	0.3902	0.3905	0.3895	0.3895	23312440.0
2013-10-17 15:00:00	NVDA	Stock	0.3896	0.3915	0.389	0.3905	39238080.0
2013-10-17 16:00:00	NVDA	Stock	0.3905	0.3906	0.3898	0.3905	1169040.0
2013-10-17 04:00:00	AMZN	Stock	15.45	15.45	15.45	15.45	4000.0
2013-10-17 05:00:00	AMZN	Stock	15.4	15.4	15.35	15.35	8000.0
2013-10-17 06:00:00	AMZN	Stock	15.3195	15.3195	15.3195	15.3195	2000.0
2013-10-17 07:00:00	AMZN	Stock	15.3275	15.3275	15.3275	15.3275	2000.0
2013-10-17 08:00:00	AMZN	Stock	15.39	15.409	15.323	15.323	173840.0
2013-10-17 09:00:00	AMZN	Stock	15.3255	15.4075	15.2845	15.3	10336180.0
2013-10-17 10:00:00	AMZN	Stock	15.2965	15.375	15.262	15.3648	10217820.0
2013-10-17 11:00:00	AMZN	Stock	15.3667	15.4895	15.3665	15.438	6969500.0
2013-10-17 12:00:00	AMZN	Stock	15.4365	15.5055	15.4305	15.472	4328900.0
2013-10-17 13:00:00	AMZN	Stock	15.474	15.5	15.4565	15.4585	2774980.0
2013-10-17 14:00:00	AMZN	Stock	15.456	15.486	15.4435	15.486	4697500.0
2013-10-17 15:00:00	AMZN	Stock	15.485	15.55	15.4655	15.539	8983780.0
2013-10-17 16:00:00	AMZN	Stock	15.532	15.8	15.3907	15.75	3662960.0

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

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