PREVIEW / stock_1hour / 2017-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-08.parquet
  size:    1.1 MB
  rows:    48,720
  symbols: 3,098

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
2017-03-08 05:00:00	AAPL	Stock	34.92	34.92	34.92	34.92	1040.0
2017-03-08 06:00:00	AAPL	Stock	34.9075	34.9125	34.875	34.9075	12204.0
2017-03-08 07:00:00	AAPL	Stock	34.875	34.875	34.725	34.8075	188288.0
2017-03-08 08:00:00	AAPL	Stock	34.7625	34.8075	34.6775	34.73	753600.0
2017-03-08 09:00:00	AAPL	Stock	34.7375	34.9	34.705	34.8988	12896468.0
2017-03-08 10:00:00	AAPL	Stock	34.9	34.9375	34.8075	34.925	9520836.0
2017-03-08 11:00:00	AAPL	Stock	34.9238	34.95	34.7825	34.7975	8242700.0
2017-03-08 12:00:00	AAPL	Stock	34.7975	34.8488	34.7775	34.81	5492356.0
2017-03-08 13:00:00	AAPL	Stock	34.81	34.8575	34.8038	34.835	4083604.0
2017-03-08 14:00:00	AAPL	Stock	34.8358	34.8575	34.725	34.7762	7249560.0
2017-03-08 15:00:00	AAPL	Stock	34.7762	34.8075	34.705	34.7525	10230668.0
2017-03-08 16:00:00	AAPL	Stock	34.75	34.765	34.7425	34.7425	7455428.0
2017-03-08 17:00:00	AAPL	Stock	34.75	34.7525	34.7275	34.73	40256.0
2017-03-08 18:00:00	AAPL	Stock	34.75	34.76	34.75	34.76	11316.0
2017-03-08 19:00:00	AAPL	Stock	34.76	34.7725	34.75	34.76	11868.0
2017-03-08 04:00:00	MSFT	Stock	64.69	64.69	64.69	64.69	100.0
2017-03-08 07:00:00	MSFT	Stock	64.4	64.48	64.39	64.48	2725.0
2017-03-08 08:00:00	MSFT	Stock	64.2	64.45	64.2	64.45	270.0
2017-03-08 09:00:00	MSFT	Stock	64.26	64.6	64.25	64.57	1738218.0
2017-03-08 10:00:00	MSFT	Stock	64.57	64.9	64.44	64.885	2562480.0
2017-03-08 11:00:00	MSFT	Stock	64.88	65.035	64.75	64.875	2597519.0
2017-03-08 12:00:00	MSFT	Stock	64.874	64.99	64.825	64.985	1131472.0
2017-03-08 13:00:00	MSFT	Stock	64.985	65.085	64.95	64.97	1975913.0
2017-03-08 14:00:00	MSFT	Stock	64.975	65.02	64.75	64.93	2131806.0
2017-03-08 15:00:00	MSFT	Stock	64.94	65.02	64.77	64.99	4281884.0
2017-03-08 16:00:00	MSFT	Stock	64.98	64.99	64.89	64.9	3240884.0
2017-03-08 17:00:00	MSFT	Stock	64.9	64.9	64.89	64.9	2355.0
2017-03-08 19:00:00	MSFT	Stock	64.93	64.97	64.92	64.97	337.0
2017-03-08 04:00:00	NVDA	Stock	2.4825	2.4825	2.4825	2.4825	4000.0
2017-03-08 07:00:00	NVDA	Stock	2.475	2.4888	2.475	2.4888	87000.0
2017-03-08 08:00:00	NVDA	Stock	2.4888	2.5113	2.483	2.5108	3490640.0
2017-03-08 09:00:00	NVDA	Stock	2.5115	2.5325	2.4985	2.5273	146228280.0
2017-03-08 10:00:00	NVDA	Stock	2.5273	2.5312	2.4958	2.5045	114159680.0
2017-03-08 11:00:00	NVDA	Stock	2.5045	2.516	2.469	2.4818	97611960.0
2017-03-08 12:00:00	NVDA	Stock	2.4818	2.4883	2.4715	2.4795	54873080.0
2017-03-08 13:00:00	NVDA	Stock	2.4795	2.483	2.4753	2.4778	37313040.0
2017-03-08 14:00:00	NVDA	Stock	2.4775	2.481	2.4658	2.472	53108320.0
2017-03-08 15:00:00	NVDA	Stock	2.4723	2.518	2.4618	2.4638	79277280.0
2017-03-08 16:00:00	NVDA	Stock	2.464	2.4658	2.4608	2.464	8544320.0
2017-03-08 17:00:00	NVDA	Stock	2.463	2.465	2.4603	2.465	17285280.0
2017-03-08 18:00:00	NVDA	Stock	2.4628	2.465	2.4625	2.4648	254960.0
2017-03-08 19:00:00	NVDA	Stock	2.4648	2.4648	2.4615	2.4615	323040.0
2017-03-08 08:00:00	AMZN	Stock	42.32	42.3665	42.32	42.335	13120.0
2017-03-08 09:00:00	AMZN	Stock	42.375	42.6535	42.3395	42.633	9419200.0
2017-03-08 10:00:00	AMZN	Stock	42.6427	42.65	42.4815	42.575	8483700.0
2017-03-08 11:00:00	AMZN	Stock	42.573	42.6285	42.4585	42.5049	3387280.0
2017-03-08 12:00:00	AMZN	Stock	42.509	42.567	42.4905	42.5315	2215440.0
2017-03-08 13:00:00	AMZN	Stock	42.527	42.5735	42.5162	42.526	4371580.0
2017-03-08 14:00:00	AMZN	Stock	42.529	42.5655	42.45	42.5323	3176940.0
2017-03-08 15:00:00	AMZN	Stock	42.5305	42.545	42.4635	42.527	5992140.0

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

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