PREVIEW / stock_1hour / 2017-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-28.parquet
  size:    1.0 MB
  rows:    48,835
  symbols: 3,080

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-28 05:00:00	AAPL	Stock	35.285	35.285	35.24	35.25	9992.0
2017-03-28 06:00:00	AAPL	Stock	35.23	35.285	35.225	35.2675	23664.0
2017-03-28 07:00:00	AAPL	Stock	35.2675	35.2975	35.225	35.24	50400.0
2017-03-28 08:00:00	AAPL	Stock	35.2875	35.2875	35.1875	35.1875	105428.0
2017-03-28 09:00:00	AAPL	Stock	35.18	35.3475	35.155	35.2675	12589848.0
2017-03-28 10:00:00	AAPL	Stock	35.265	35.4625	35.26	35.46	12833060.0
2017-03-28 11:00:00	AAPL	Stock	35.4568	35.6875	35.4475	35.645	20397212.0
2017-03-28 12:00:00	AAPL	Stock	35.6425	35.7675	35.6375	35.7125	15624988.0
2017-03-28 13:00:00	AAPL	Stock	35.7115	35.8975	35.71	35.8838	12517784.0
2017-03-28 14:00:00	AAPL	Stock	35.885	36.0075	35.885	35.99	16695060.0
2017-03-28 15:00:00	AAPL	Stock	35.995	36.01	35.9325	35.9525	21163284.0
2017-03-28 16:00:00	AAPL	Stock	35.95	35.9725	35.9075	35.915	11791552.0
2017-03-28 17:00:00	AAPL	Stock	35.915	35.93	35.9125	35.93	52872.0
2017-03-28 18:00:00	AAPL	Stock	35.93	35.9425	35.925	35.9275	24220.0
2017-03-28 19:00:00	AAPL	Stock	35.9375	35.9475	35.915	35.925	26328.0
2017-03-28 07:00:00	MSFT	Stock	65.19	65.19	65.19	65.19	2900.0
2017-03-28 08:00:00	MSFT	Stock	65.1	65.1	65.09	65.1	361.0
2017-03-28 09:00:00	MSFT	Stock	65.1	65.12	64.65	64.71	2040844.0
2017-03-28 10:00:00	MSFT	Stock	64.7	64.97	64.68	64.775	2139371.0
2017-03-28 11:00:00	MSFT	Stock	64.77	64.93	64.765	64.905	1761804.0
2017-03-28 12:00:00	MSFT	Stock	64.905	65.1	64.9	65.07	1710701.0
2017-03-28 13:00:00	MSFT	Stock	65.07	65.34	65.06	65.325	1890583.0
2017-03-28 14:00:00	MSFT	Stock	65.33	65.47	65.275	65.315	2211748.0
2017-03-28 15:00:00	MSFT	Stock	65.31	65.45	65.27	65.29	4027110.0
2017-03-28 16:00:00	MSFT	Stock	65.29	65.314	64.895	65.29	2473944.0
2017-03-28 17:00:00	MSFT	Stock	65.4	65.4	65.4	65.4	10750.0
2017-03-28 19:00:00	MSFT	Stock	65.3	65.3	65.3	65.3	100.0
2017-03-28 07:00:00	NVDA	Stock	2.7168	2.7235	2.7135	2.7135	193640.0
2017-03-28 08:00:00	NVDA	Stock	2.7138	2.715	2.7075	2.7075	134720.0
2017-03-28 09:00:00	NVDA	Stock	2.7068	2.7223	2.6878	2.6962	70012480.0
2017-03-28 10:00:00	NVDA	Stock	2.6965	2.7116	2.6852	2.691	78336000.0
2017-03-28 11:00:00	NVDA	Stock	2.6907	2.705	2.687	2.6938	53186880.0
2017-03-28 12:00:00	NVDA	Stock	2.6933	2.6952	2.6848	2.6888	37734120.0
2017-03-28 13:00:00	NVDA	Stock	2.6888	2.6958	2.6818	2.694	39552080.0
2017-03-28 14:00:00	NVDA	Stock	2.6948	2.706	2.6927	2.7008	56740040.0
2017-03-28 15:00:00	NVDA	Stock	2.7008	2.702	2.69	2.6925	56411560.0
2017-03-28 16:00:00	NVDA	Stock	2.6922	2.6938	2.6903	2.6905	22754160.0
2017-03-28 17:00:00	NVDA	Stock	2.6905	2.6922	2.6885	2.69	151840.0
2017-03-28 18:00:00	NVDA	Stock	2.69	2.693	2.69	2.693	28800.0
2017-03-28 19:00:00	NVDA	Stock	2.6925	2.6925	2.6925	2.6925	40000.0
2017-03-28 05:00:00	AMZN	Stock	42.4	42.4	42.4	42.4	4480.0
2017-03-28 06:00:00	AMZN	Stock	42.3955	42.487	42.3955	42.452	38160.0
2017-03-28 07:00:00	AMZN	Stock	42.4835	42.4875	42.425	42.425	20280.0
2017-03-28 08:00:00	AMZN	Stock	42.372	42.397	42.2805	42.35	21480.0
2017-03-28 09:00:00	AMZN	Stock	42.415	42.7748	42.415	42.572	9407820.0
2017-03-28 10:00:00	AMZN	Stock	42.5835	42.7075	42.525	42.6	6451900.0
2017-03-28 11:00:00	AMZN	Stock	42.6126	42.789	42.607	42.7562	7159060.0
2017-03-28 12:00:00	AMZN	Stock	42.7535	42.8375	42.706	42.7594	5012160.0
2017-03-28 13:00:00	AMZN	Stock	42.761	42.8735	42.738	42.8322	4701220.0
2017-03-28 14:00:00	AMZN	Stock	42.837	42.923	42.81	42.8546	6081240.0

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

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