PREVIEW / stock_1hour / 2015-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-28.parquet
  size:    1.0 MB
  rows:    49,178
  symbols: 3,488

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
2015-07-28 04:00:00	AAPL	Stock	30.8675	30.975	30.8675	30.9425	10000.0
2015-07-28 05:00:00	AAPL	Stock	30.9425	31.05	30.9425	31.045	19208.0
2015-07-28 06:00:00	AAPL	Stock	31.02	31.075	30.93	30.9525	72976.0
2015-07-28 07:00:00	AAPL	Stock	30.94	30.95	30.88	30.9025	130924.0
2015-07-28 08:00:00	AAPL	Stock	30.9	31.07	30.875	30.9175	493892.0
2015-07-28 09:00:00	AAPL	Stock	30.9175	30.9325	30.7288	30.819	19438980.0
2015-07-28 10:00:00	AAPL	Stock	30.82	30.8325	30.6375	30.8075	22843684.0
2015-07-28 11:00:00	AAPL	Stock	30.805	30.885	30.785	30.815	13684972.0
2015-07-28 12:00:00	AAPL	Stock	30.815	30.9045	30.7885	30.8025	10856944.0
2015-07-28 13:00:00	AAPL	Stock	30.805	30.9025	30.795	30.8838	9328084.0
2015-07-28 14:00:00	AAPL	Stock	30.8832	30.9775	30.865	30.97	13720320.0
2015-07-28 15:00:00	AAPL	Stock	30.9675	30.9725	30.7925	30.8475	24701724.0
2015-07-28 16:00:00	AAPL	Stock	30.845	30.8675	30.8145	30.8375	11023312.0
2015-07-28 17:00:00	AAPL	Stock	30.8375	30.8592	30.8375	30.845	64212.0
2015-07-28 18:00:00	AAPL	Stock	30.84	30.85	30.825	30.8275	98604.0
2015-07-28 19:00:00	AAPL	Stock	30.8275	30.8375	30.7875	30.8	48528.0
2015-07-28 06:00:00	MSFT	Stock	45.65	45.65	45.65	45.65	100.0
2015-07-28 07:00:00	MSFT	Stock	45.65	45.65	45.61	45.61	1276.0
2015-07-28 08:00:00	MSFT	Stock	45.65	45.72	45.61	45.62	13595.0
2015-07-28 09:00:00	MSFT	Stock	45.63	45.63	45.155	45.305	3589750.0
2015-07-28 10:00:00	MSFT	Stock	45.305	45.34	44.79	45.116	6492929.0
2015-07-28 11:00:00	MSFT	Stock	45.12	45.44	45.07	45.345	3703292.0
2015-07-28 12:00:00	MSFT	Stock	45.34	45.49	45.265	45.32	3099094.0
2015-07-28 13:00:00	MSFT	Stock	45.32	45.46	45.28	45.45	3503812.0
2015-07-28 14:00:00	MSFT	Stock	45.45	45.615	45.39	45.53	3797635.0
2015-07-28 15:00:00	MSFT	Stock	45.525	45.639	45.32	45.35	6044055.0
2015-07-28 16:00:00	MSFT	Stock	45.35	45.47	45.336	45.47	3146708.0
2015-07-28 17:00:00	MSFT	Stock	45.45	45.47	45.45	45.47	300.0
2015-07-28 18:00:00	MSFT	Stock	45.45	45.45	45.37	45.37	865.0
2015-07-28 19:00:00	MSFT	Stock	45.45	45.45	45.36	45.36	400.0
2015-07-28 09:00:00	NVDA	Stock	0.484	0.486	0.479	0.4818	20414160.0
2015-07-28 10:00:00	NVDA	Stock	0.4812	0.4852	0.4799	0.485	22170280.0
2015-07-28 11:00:00	NVDA	Stock	0.4852	0.4905	0.4852	0.4892	24981440.0
2015-07-28 12:00:00	NVDA	Stock	0.4892	0.4908	0.4883	0.4896	22626240.0
2015-07-28 13:00:00	NVDA	Stock	0.4898	0.4935	0.4898	0.4935	17016200.0
2015-07-28 14:00:00	NVDA	Stock	0.4935	0.4965	0.4932	0.4951	24946600.0
2015-07-28 15:00:00	NVDA	Stock	0.4952	0.4952	0.4928	0.4934	44736560.0
2015-07-28 16:00:00	NVDA	Stock	0.4932	0.4932	0.4932	0.4932	12561800.0
2015-07-28 05:00:00	AMZN	Stock	26.782	26.8205	26.782	26.8205	32360.0
2015-07-28 06:00:00	AMZN	Stock	26.86	26.913	26.86	26.9125	100220.0
2015-07-28 07:00:00	AMZN	Stock	26.86	26.8815	26.8325	26.8325	57720.0
2015-07-28 08:00:00	AMZN	Stock	26.85	26.939	26.825	26.925	318620.0
2015-07-28 09:00:00	AMZN	Stock	26.9052	26.924	26.156	26.4426	25407220.0
2015-07-28 10:00:00	AMZN	Stock	26.4622	26.59	26.2815	26.55	16998920.0
2015-07-28 11:00:00	AMZN	Stock	26.55	26.5635	26.3745	26.4725	7506800.0
2015-07-28 12:00:00	AMZN	Stock	26.474	26.5395	26.21	26.2284	9440720.0
2015-07-28 13:00:00	AMZN	Stock	26.2175	26.334	26.1575	26.251	8829000.0
2015-07-28 14:00:00	AMZN	Stock	26.2655	26.41	26.2375	26.4095	7445320.0
2015-07-28 15:00:00	AMZN	Stock	26.41	26.45	26.25	26.3015	13630880.0
2015-07-28 16:00:00	AMZN	Stock	26.3015	26.3125	26.2775	26.2775	5074420.0

> showing 50 of 49,178 rows — these rows as CSV

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