PREVIEW / stock_1hour / 2014-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-29.parquet
  size:    1.0 MB
  rows:    47,989
  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
2014-01-29 04:00:00	AAPL	Stock	18.1929	18.3125	18.1929	18.2589	301392.0
2014-01-29 05:00:00	AAPL	Stock	18.2589	18.2589	18.1804	18.2143	259980.0
2014-01-29 06:00:00	AAPL	Stock	18.2125	18.2143	18.1429	18.1429	212268.0
2014-01-29 07:00:00	AAPL	Stock	18.1696	18.2107	18.0714	18.125	990696.0
2014-01-29 08:00:00	AAPL	Stock	18.125	18.2143	18.0432	18.0486	1935024.0
2014-01-29 09:00:00	AAPL	Stock	18.0486	18.1204	17.9336	18.0079	84791616.0
2014-01-29 10:00:00	AAPL	Stock	18.009	18.0289	17.8079	17.8754	118581344.0
2014-01-29 11:00:00	AAPL	Stock	17.8829	18.0143	17.8807	17.9675	45526796.0
2014-01-29 12:00:00	AAPL	Stock	17.9643	17.9719	17.8714	17.8864	26545848.0
2014-01-29 13:00:00	AAPL	Stock	17.8857	17.9364	17.8614	17.9279	21541072.0
2014-01-29 14:00:00	AAPL	Stock	17.9294	17.9764	17.8554	17.8629	52580444.0
2014-01-29 15:00:00	AAPL	Stock	17.8643	17.94	17.8311	17.8764	57663536.0
2014-01-29 16:00:00	AAPL	Stock	17.8775	18.0876	17.8668	17.8836	10015236.0
2014-01-29 17:00:00	AAPL	Stock	17.8821	17.9	17.8768	17.9	396620.0
2014-01-29 18:00:00	AAPL	Stock	17.9	17.9243	17.8775	17.9196	326200.0
2014-01-29 19:00:00	AAPL	Stock	17.9136	17.9136	17.8929	17.8929	290640.0
2014-01-29 07:00:00	MSFT	Stock	36.46	36.46	36.23	36.23	2900.0
2014-01-29 08:00:00	MSFT	Stock	36.47	36.47	36.03	36.1	7972.0
2014-01-29 09:00:00	MSFT	Stock	36.17	36.37	35.89	36.29	4279087.0
2014-01-29 10:00:00	MSFT	Stock	36.28	36.585	36.18	36.47	7160613.0
2014-01-29 11:00:00	MSFT	Stock	36.47	36.72	36.47	36.7	4662170.0
2014-01-29 12:00:00	MSFT	Stock	36.704	36.75	36.63	36.69	6313569.0
2014-01-29 13:00:00	MSFT	Stock	36.68	36.75	36.55	36.71	5303242.0
2014-01-29 14:00:00	MSFT	Stock	36.709	36.88	36.495	36.58	7712187.0
2014-01-29 15:00:00	MSFT	Stock	36.57	36.82	36.52	36.65	10764532.0
2014-01-29 16:00:00	MSFT	Stock	36.66	36.76	36.0	36.0	4732621.0
2014-01-29 17:00:00	MSFT	Stock	36.67	36.67	36.6	36.62	300409.0
2014-01-29 18:00:00	MSFT	Stock	36.66	36.71	36.64	36.71	41034.0
2014-01-29 19:00:00	MSFT	Stock	36.71	36.75	36.68	36.68	2640.0
2014-01-29 09:00:00	NVDA	Stock	0.3902	0.391	0.3873	0.3895	14360640.0
2014-01-29 10:00:00	NVDA	Stock	0.3895	0.39	0.3873	0.3895	21657480.0
2014-01-29 11:00:00	NVDA	Stock	0.3895	0.3895	0.3878	0.3886	17548120.0
2014-01-29 12:00:00	NVDA	Stock	0.3888	0.389	0.387	0.388	10553640.0
2014-01-29 13:00:00	NVDA	Stock	0.3879	0.39	0.3873	0.39	18245480.0
2014-01-29 14:00:00	NVDA	Stock	0.3898	0.3908	0.3871	0.3875	33395560.0
2014-01-29 15:00:00	NVDA	Stock	0.3876	0.3882	0.3862	0.3865	25726360.0
2014-01-29 16:00:00	NVDA	Stock	0.3865	0.3884	0.3862	0.3866	5750240.0
2014-01-29 17:00:00	NVDA	Stock	0.3905	0.3905	0.3905	0.3905	160000.0
2014-01-29 18:00:00	NVDA	Stock	0.3905	0.3905	0.3905	0.3905	40000.0
2014-01-29 04:00:00	AMZN	Stock	19.9145	19.9145	19.825	19.825	26000.0
2014-01-29 05:00:00	AMZN	Stock	19.8	19.8	19.72	19.72	10000.0
2014-01-29 06:00:00	AMZN	Stock	19.7625	19.7895	19.7475	19.7895	12320.0
2014-01-29 07:00:00	AMZN	Stock	19.7665	19.775	19.568	19.568	30220.0
2014-01-29 08:00:00	AMZN	Stock	19.7845	19.7845	19.5785	19.6015	162420.0
2014-01-29 09:00:00	AMZN	Stock	19.6015	19.6425	19.375	19.48	8494860.0
2014-01-29 10:00:00	AMZN	Stock	19.48	19.574	19.36	19.372	9587200.0
2014-01-29 11:00:00	AMZN	Stock	19.3925	19.533	19.3875	19.523	5977020.0
2014-01-29 12:00:00	AMZN	Stock	19.5305	19.5395	19.4055	19.427	5042600.0
2014-01-29 13:00:00	AMZN	Stock	19.4228	19.4535	19.34	19.372	4608520.0
2014-01-29 14:00:00	AMZN	Stock	19.354	19.409	19.2125	19.2755	12440520.0

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

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