PREVIEW / stock_1hour / 2017-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-10.parquet
  size:    1.1 MB
  rows:    48,963
  symbols: 3,084

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-10 04:00:00	AAPL	Stock	34.8225	34.825	34.8225	34.825	4296.0
2017-03-10 05:00:00	AAPL	Stock	34.845	34.845	34.825	34.825	2400.0
2017-03-10 06:00:00	AAPL	Stock	34.83	34.85	34.8275	34.8375	17788.0
2017-03-10 07:00:00	AAPL	Stock	34.8275	34.8425	34.7875	34.8	47908.0
2017-03-10 08:00:00	AAPL	Stock	34.81	34.8375	34.75	34.8175	354768.0
2017-03-10 09:00:00	AAPL	Stock	34.7925	34.8525	34.66	34.7625	12829416.0
2017-03-10 10:00:00	AAPL	Stock	34.76	34.815	34.69	34.745	11739820.0
2017-03-10 11:00:00	AAPL	Stock	34.7425	34.8392	34.7175	34.7975	8706280.0
2017-03-10 12:00:00	AAPL	Stock	34.7962	34.82	34.6925	34.7575	6577204.0
2017-03-10 13:00:00	AAPL	Stock	34.7575	34.775	34.7025	34.76	5866348.0
2017-03-10 14:00:00	AAPL	Stock	34.7592	34.8175	34.7463	34.7975	5882940.0
2017-03-10 15:00:00	AAPL	Stock	34.7975	34.83	34.75	34.7875	11380528.0
2017-03-10 16:00:00	AAPL	Stock	34.785	34.7975	34.755	34.7675	8357536.0
2017-03-10 17:00:00	AAPL	Stock	34.77	34.775	34.77	34.775	85516.0
2017-03-10 18:00:00	AAPL	Stock	34.7775	34.785	34.77	34.7725	40772.0
2017-03-10 19:00:00	AAPL	Stock	34.775	34.78	34.77	34.78	12292.0
2017-03-10 05:00:00	MSFT	Stock	65.09	65.1	65.09	65.1	1110.0
2017-03-10 07:00:00	MSFT	Stock	65.1	65.1	65.05	65.05	1989.0
2017-03-10 08:00:00	MSFT	Stock	64.95	65.1	64.95	65.03	2039.0
2017-03-10 09:00:00	MSFT	Stock	65.03	65.2	64.86	65.09	2380087.0
2017-03-10 10:00:00	MSFT	Stock	65.1	65.26	64.92	64.955	3464412.0
2017-03-10 11:00:00	MSFT	Stock	64.95	65.035	64.89	64.915	1458693.0
2017-03-10 12:00:00	MSFT	Stock	64.92	64.99	64.77	64.865	1234902.0
2017-03-10 13:00:00	MSFT	Stock	64.862	64.95	64.75	64.89	1350865.0
2017-03-10 14:00:00	MSFT	Stock	64.896	64.99	64.86	64.95	1517820.0
2017-03-10 15:00:00	MSFT	Stock	64.95	65.0	64.82	64.95	4168452.0
2017-03-10 16:00:00	MSFT	Stock	64.93	64.95	64.84	64.94	2807719.0
2017-03-10 17:00:00	MSFT	Stock	64.93	64.93	64.93	64.93	124.0
2017-03-10 19:00:00	MSFT	Stock	64.96	65.0	64.96	65.0	491.0
2017-03-10 06:00:00	NVDA	Stock	2.4835	2.4845	2.4835	2.4845	55600.0
2017-03-10 07:00:00	NVDA	Stock	2.4845	2.4875	2.483	2.485	489400.0
2017-03-10 08:00:00	NVDA	Stock	2.4852	2.4983	2.482	2.4945	3386800.0
2017-03-10 09:00:00	NVDA	Stock	2.4945	2.5022	2.4683	2.4888	102459040.0
2017-03-10 10:00:00	NVDA	Stock	2.4893	2.4905	2.4702	2.483	82956000.0
2017-03-10 11:00:00	NVDA	Stock	2.4825	2.4872	2.4735	2.4755	44759400.0
2017-03-10 12:00:00	NVDA	Stock	2.4758	2.4768	2.4595	2.473	70138480.0
2017-03-10 13:00:00	NVDA	Stock	2.4726	2.4728	2.4615	2.4708	44607920.0
2017-03-10 14:00:00	NVDA	Stock	2.471	2.4815	2.4688	2.4793	44293400.0
2017-03-10 15:00:00	NVDA	Stock	2.4795	2.4825	2.4745	2.4775	59347320.0
2017-03-10 16:00:00	NVDA	Stock	2.4772	2.4778	2.4738	2.474	7617040.0
2017-03-10 17:00:00	NVDA	Stock	2.4772	2.478	2.477	2.4775	216000.0
2017-03-10 18:00:00	NVDA	Stock	2.478	2.4788	2.475	2.4788	365960.0
2017-03-10 19:00:00	NVDA	Stock	2.4753	2.4825	2.4753	2.4825	120880.0
2017-03-10 05:00:00	AMZN	Stock	42.758	42.758	42.758	42.758	2000.0
2017-03-10 07:00:00	AMZN	Stock	42.8375	42.8375	42.8	42.822	31500.0
2017-03-10 08:00:00	AMZN	Stock	42.775	42.87	42.775	42.85	277940.0
2017-03-10 09:00:00	AMZN	Stock	42.85	42.8675	42.749	42.819	7030660.0
2017-03-10 10:00:00	AMZN	Stock	42.81	42.825	42.603	42.7055	8258500.0
2017-03-10 11:00:00	AMZN	Stock	42.6962	42.752	42.6508	42.7325	3189120.0
2017-03-10 12:00:00	AMZN	Stock	42.7455	42.75	42.601	42.6336	3403940.0

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

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