PREVIEW / stock_1hour / 2017-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-28.parquet
  size:    1.1 MB
  rows:    49,051
  symbols: 3,103

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-02-28 04:00:00	AAPL	Stock	34.2675	34.2675	34.21	34.21	2000.0
2017-02-28 05:00:00	AAPL	Stock	34.2875	34.325	34.285	34.3175	33332.0
2017-02-28 06:00:00	AAPL	Stock	34.3175	34.325	34.2875	34.3075	18856.0
2017-02-28 07:00:00	AAPL	Stock	34.3	34.3025	34.275	34.2975	69152.0
2017-02-28 08:00:00	AAPL	Stock	34.305	34.3075	34.2375	34.25	422812.0
2017-02-28 09:00:00	AAPL	Stock	34.24	34.3525	34.2075	34.2375	11800404.0
2017-02-28 10:00:00	AAPL	Stock	34.2375	34.3588	34.225	34.3062	10168576.0
2017-02-28 11:00:00	AAPL	Stock	34.3062	34.355	34.2725	34.3225	6775212.0
2017-02-28 12:00:00	AAPL	Stock	34.3212	34.325	34.195	34.2488	9898268.0
2017-02-28 13:00:00	AAPL	Stock	34.25	34.3108	34.2425	34.305	6229744.0
2017-02-28 14:00:00	AAPL	Stock	34.3062	34.31	34.23	34.245	6085900.0
2017-02-28 15:00:00	AAPL	Stock	34.245	34.2675	34.175	34.2475	15179892.0
2017-02-28 16:00:00	AAPL	Stock	34.245	34.2525	34.225	34.2475	14464492.0
2017-02-28 17:00:00	AAPL	Stock	34.2475	34.2475	34.23	34.245	17204.0
2017-02-28 18:00:00	AAPL	Stock	34.245	34.245	34.225	34.2375	64892.0
2017-02-28 19:00:00	AAPL	Stock	34.2375	34.2625	34.23	34.2625	61496.0
2017-02-28 07:00:00	MSFT	Stock	64.1	64.1	64.1	64.1	2000.0
2017-02-28 08:00:00	MSFT	Stock	64.13	64.13	64.08	64.08	300.0
2017-02-28 09:00:00	MSFT	Stock	64.1	64.2	63.92	64.06	2500953.0
2017-02-28 10:00:00	MSFT	Stock	64.06	64.18	63.93	64.025	2088875.0
2017-02-28 11:00:00	MSFT	Stock	64.025	64.08	63.92	63.985	1895456.0
2017-02-28 12:00:00	MSFT	Stock	63.985	64.02	63.8	63.805	2338538.0
2017-02-28 13:00:00	MSFT	Stock	63.81	63.86	63.76	63.86	2594065.0
2017-02-28 14:00:00	MSFT	Stock	63.87	63.88	63.775	63.85	1580946.0
2017-02-28 15:00:00	MSFT	Stock	63.86	64.0	63.83	63.98	4277898.0
2017-02-28 16:00:00	MSFT	Stock	63.98	64.03	63.922	64.03	3960798.0
2017-02-28 17:00:00	MSFT	Stock	64.03	64.03	63.99	63.99	3254.0
2017-02-28 18:00:00	MSFT	Stock	63.98	63.99	63.98	63.99	508.0
2017-02-28 19:00:00	MSFT	Stock	64.02	64.02	64.0	64.0	1610.0
2017-02-28 04:00:00	NVDA	Stock	2.595	2.595	2.595	2.595	4000.0
2017-02-28 05:00:00	NVDA	Stock	2.6075	2.6075	2.6075	2.6075	24000.0
2017-02-28 06:00:00	NVDA	Stock	2.6075	2.6075	2.6075	2.6075	20000.0
2017-02-28 07:00:00	NVDA	Stock	2.615	2.62	2.615	2.615	119640.0
2017-02-28 08:00:00	NVDA	Stock	2.615	2.6175	2.6015	2.6073	1174520.0
2017-02-28 09:00:00	NVDA	Stock	2.607	2.63	2.575	2.5775	96435400.0
2017-02-28 10:00:00	NVDA	Stock	2.5778	2.5884	2.5575	2.565	109050920.0
2017-02-28 11:00:00	NVDA	Stock	2.5651	2.5658	2.5525	2.5525	58698680.0
2017-02-28 12:00:00	NVDA	Stock	2.5525	2.5529	2.5208	2.5243	87315000.0
2017-02-28 13:00:00	NVDA	Stock	2.5238	2.5373	2.5215	2.5275	48187320.0
2017-02-28 14:00:00	NVDA	Stock	2.5278	2.5382	2.5194	2.537	61919120.0
2017-02-28 15:00:00	NVDA	Stock	2.537	2.541	2.5278	2.537	78653160.0
2017-02-28 16:00:00	NVDA	Stock	2.5342	2.5435	2.5336	2.5435	9367240.0
2017-02-28 17:00:00	NVDA	Stock	2.5425	2.5465	2.538	2.538	354800.0
2017-02-28 18:00:00	NVDA	Stock	2.5405	2.5425	2.5385	2.54	88600.0
2017-02-28 19:00:00	NVDA	Stock	2.5413	2.5418	2.539	2.5415	226000.0
2017-02-28 04:00:00	AMZN	Stock	42.4085	42.4085	42.4085	42.4085	5400.0
2017-02-28 06:00:00	AMZN	Stock	42.45	42.6	42.45	42.6	4000.0
2017-02-28 07:00:00	AMZN	Stock	42.55	42.55	42.51	42.5375	23180.0
2017-02-28 08:00:00	AMZN	Stock	42.55	42.654	42.345	42.649	249000.0
2017-02-28 09:00:00	AMZN	Stock	42.613	42.7045	42.465	42.601	9508520.0

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

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