PREVIEW / stock_1hour / 2014-10-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-29.parquet
  size:    1.0 MB
  rows:    48,313
  symbols: 3,550

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
2014-10-29 04:00:00	AAPL	Stock	26.62	26.6875	26.62	26.65	5508.0
2014-10-29 05:00:00	AAPL	Stock	26.6875	26.7	26.675	26.7	35756.0
2014-10-29 06:00:00	AAPL	Stock	26.7	26.7125	26.6725	26.675	57156.0
2014-10-29 07:00:00	AAPL	Stock	26.675	26.685	26.645	26.6475	89728.0
2014-10-29 08:00:00	AAPL	Stock	26.655	26.8175	26.645	26.6525	485540.0
2014-10-29 09:00:00	AAPL	Stock	26.6525	26.8075	26.6475	26.7225	22921568.0
2014-10-29 10:00:00	AAPL	Stock	26.7225	26.7975	26.69	26.79	23262368.0
2014-10-29 11:00:00	AAPL	Stock	26.7925	26.835	26.7575	26.7875	17043080.0
2014-10-29 12:00:00	AAPL	Stock	26.7865	26.79	26.6275	26.655	17366712.0
2014-10-29 13:00:00	AAPL	Stock	26.6575	26.7325	26.645	26.72	12625532.0
2014-10-29 14:00:00	AAPL	Stock	26.7198	26.815	26.59	26.8038	27963156.0
2014-10-29 15:00:00	AAPL	Stock	26.8025	26.8425	26.7312	26.835	27729716.0
2014-10-29 16:00:00	AAPL	Stock	26.835	26.8375	26.6772	26.805	44368452.0
2014-10-29 17:00:00	AAPL	Stock	26.7975	26.835	26.7702	26.79	147032.0
2014-10-29 18:00:00	AAPL	Stock	26.79	26.835	26.72	26.8	379892.0
2014-10-29 19:00:00	AAPL	Stock	26.8	26.8	26.7625	26.7875	52312.0
2014-10-29 05:00:00	MSFT	Stock	46.48	46.48	46.38	46.38	700.0
2014-10-29 07:00:00	MSFT	Stock	46.4	46.4	46.38	46.38	3000.0
2014-10-29 08:00:00	MSFT	Stock	46.38	46.52	46.38	46.44	8702.0
2014-10-29 09:00:00	MSFT	Stock	46.44	46.58	46.37	46.51	2991000.0
2014-10-29 10:00:00	MSFT	Stock	46.51	46.58	46.41	46.46	3040887.0
2014-10-29 11:00:00	MSFT	Stock	46.465	46.54	46.36	46.51	3676644.0
2014-10-29 12:00:00	MSFT	Stock	46.505	46.565	46.445	46.545	2783833.0
2014-10-29 13:00:00	MSFT	Stock	46.545	46.67	46.49	46.66	2466387.0
2014-10-29 14:00:00	MSFT	Stock	46.66	46.7	46.34	46.545	5520985.0
2014-10-29 15:00:00	MSFT	Stock	46.54	46.69	46.39	46.63	6667101.0
2014-10-29 16:00:00	MSFT	Stock	46.62	46.62	46.525	46.62	2035382.0
2014-10-29 17:00:00	MSFT	Stock	46.56	46.62	46.549	46.62	1415.0
2014-10-29 18:00:00	MSFT	Stock	46.54	46.62	46.54	46.61	7464.0
2014-10-29 09:00:00	NVDA	Stock	0.473	0.474	0.47	0.4725	11384440.0
2014-10-29 10:00:00	NVDA	Stock	0.4725	0.4725	0.4668	0.47	18752160.0
2014-10-29 11:00:00	NVDA	Stock	0.47	0.4723	0.4692	0.4698	10244560.0
2014-10-29 12:00:00	NVDA	Stock	0.4699	0.4705	0.4688	0.47	8957440.0
2014-10-29 13:00:00	NVDA	Stock	0.4698	0.4708	0.4683	0.4695	15712840.0
2014-10-29 14:00:00	NVDA	Stock	0.4692	0.4699	0.466	0.4685	31358920.0
2014-10-29 15:00:00	NVDA	Stock	0.4685	0.4709	0.4665	0.4702	52423120.0
2014-10-29 16:00:00	NVDA	Stock	0.4701	0.4724	0.4687	0.4701	2663120.0
2014-10-29 04:00:00	AMZN	Stock	14.8	14.925	14.8	14.925	31400.0
2014-10-29 05:00:00	AMZN	Stock	14.92	14.925	14.9	14.925	75600.0
2014-10-29 06:00:00	AMZN	Stock	14.925	14.9955	14.925	14.925	87520.0
2014-10-29 07:00:00	AMZN	Stock	14.925	14.9645	14.8955	14.96	193400.0
2014-10-29 08:00:00	AMZN	Stock	14.938	15.0155	14.8535	14.975	833860.0
2014-10-29 09:00:00	AMZN	Stock	14.966	14.9875	14.8058	14.8775	15887560.0
2014-10-29 10:00:00	AMZN	Stock	14.875	14.892	14.78	14.806	16075300.0
2014-10-29 11:00:00	AMZN	Stock	14.801	14.9215	14.793	14.87	7106740.0
2014-10-29 12:00:00	AMZN	Stock	14.8705	14.9	14.8382	14.8805	6223260.0
2014-10-29 13:00:00	AMZN	Stock	14.8805	14.901	14.847	14.8676	4761420.0
2014-10-29 14:00:00	AMZN	Stock	14.869	14.895	14.709	14.753	16433820.0
2014-10-29 15:00:00	AMZN	Stock	14.7575	14.7625	14.6535	14.706	20876800.0
2014-10-29 16:00:00	AMZN	Stock	14.706	14.857	14.6665	14.703	305000.0

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

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