PREVIEW / stock_1hour / 2017-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-17.parquet
  size:    1.0 MB
  rows:    47,743
  symbols: 3,063

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-04-17 06:00:00	AAPL	Stock	35.2775	35.3575	35.2775	35.3575	1600.0
2017-04-17 07:00:00	AAPL	Stock	35.325	35.41	35.325	35.41	9428.0
2017-04-17 08:00:00	AAPL	Stock	35.405	35.4825	35.325	35.4825	169448.0
2017-04-17 09:00:00	AAPL	Stock	35.475	35.4825	35.2768	35.3075	11872104.0
2017-04-17 10:00:00	AAPL	Stock	35.305	35.3875	35.2175	35.28	11070000.0
2017-04-17 11:00:00	AAPL	Stock	35.28	35.3388	35.235	35.275	5370684.0
2017-04-17 12:00:00	AAPL	Stock	35.275	35.3525	35.2725	35.344	4601752.0
2017-04-17 13:00:00	AAPL	Stock	35.345	35.3812	35.3275	35.3535	4385512.0
2017-04-17 14:00:00	AAPL	Stock	35.3525	35.3875	35.3315	35.3425	4664116.0
2017-04-17 15:00:00	AAPL	Stock	35.3425	35.4675	35.3275	35.4575	11552600.0
2017-04-17 16:00:00	AAPL	Stock	35.47	35.47	35.445	35.4625	4326376.0
2017-04-17 17:00:00	AAPL	Stock	35.4525	35.475	35.4525	35.475	80040.0
2017-04-17 18:00:00	AAPL	Stock	35.4625	35.4725	35.4625	35.4675	15928.0
2017-04-17 19:00:00	AAPL	Stock	35.4675	35.475	35.45	35.45	42708.0
2017-04-17 07:00:00	MSFT	Stock	64.81	65.12	64.8	65.12	300.0
2017-04-17 08:00:00	MSFT	Stock	65.17	65.17	65.09	65.1	2800.0
2017-04-17 09:00:00	MSFT	Stock	65.1	65.4	65.01	65.27	1549043.0
2017-04-17 10:00:00	MSFT	Stock	65.265	65.45	65.2	65.325	1485148.0
2017-04-17 11:00:00	MSFT	Stock	65.325	65.47	65.32	65.36	1765411.0
2017-04-17 12:00:00	MSFT	Stock	65.36	65.46	65.32	65.345	913342.0
2017-04-17 13:00:00	MSFT	Stock	65.34	65.44	65.31	65.39	824078.0
2017-04-17 14:00:00	MSFT	Stock	65.4	65.43	65.31	65.335	1378927.0
2017-04-17 15:00:00	MSFT	Stock	65.33	65.49	65.3	65.47	4072980.0
2017-04-17 16:00:00	MSFT	Stock	65.48	65.5	65.4	65.5	2137923.0
2017-04-17 17:00:00	MSFT	Stock	65.5	65.5	65.45	65.45	660.0
2017-04-17 18:00:00	MSFT	Stock	65.49	65.49	65.49	65.49	100.0
2017-04-17 19:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	2981.0
2017-04-17 05:00:00	NVDA	Stock	2.3872	2.3872	2.3872	2.3872	4000.0
2017-04-17 07:00:00	NVDA	Stock	2.3875	2.3895	2.3875	2.3888	34080.0
2017-04-17 08:00:00	NVDA	Stock	2.3888	2.4025	2.3888	2.4012	838520.0
2017-04-17 09:00:00	NVDA	Stock	2.4012	2.443	2.395	2.442	89444320.0
2017-04-17 10:00:00	NVDA	Stock	2.4422	2.459	2.4365	2.4452	81346960.0
2017-04-17 11:00:00	NVDA	Stock	2.4455	2.4565	2.4412	2.4535	48033640.0
2017-04-17 12:00:00	NVDA	Stock	2.4532	2.472	2.453	2.4648	56854120.0
2017-04-17 13:00:00	NVDA	Stock	2.4646	2.4748	2.4645	2.4719	35005200.0
2017-04-17 14:00:00	NVDA	Stock	2.472	2.4775	2.4675	2.4708	42983760.0
2017-04-17 15:00:00	NVDA	Stock	2.4708	2.481	2.4685	2.4808	69837120.0
2017-04-17 16:00:00	NVDA	Stock	2.4808	2.482	2.48	2.4802	34162760.0
2017-04-17 17:00:00	NVDA	Stock	2.4815	2.486	2.4802	2.486	712240.0
2017-04-17 18:00:00	NVDA	Stock	2.4838	2.4905	2.4838	2.4875	238640.0
2017-04-17 19:00:00	NVDA	Stock	2.4875	2.4875	2.4843	2.4872	100000.0
2017-04-17 06:00:00	AMZN	Stock	44.3155	44.344	44.3155	44.344	10160.0
2017-04-17 07:00:00	AMZN	Stock	44.2525	44.435	44.2505	44.3925	29240.0
2017-04-17 08:00:00	AMZN	Stock	44.363	44.44	44.281	44.4375	314500.0
2017-04-17 09:00:00	AMZN	Stock	44.4375	44.733	44.367	44.635	11254340.0
2017-04-17 10:00:00	AMZN	Stock	44.6375	44.745	44.6065	44.7005	7182600.0
2017-04-17 11:00:00	AMZN	Stock	44.6978	44.849	44.675	44.7615	5153140.0
2017-04-17 12:00:00	AMZN	Stock	44.7571	44.8625	44.749	44.8605	2786320.0
2017-04-17 13:00:00	AMZN	Stock	44.8592	44.95	44.852	44.9433	3662480.0
2017-04-17 14:00:00	AMZN	Stock	44.939	45.0041	44.8955	44.9645	5513080.0

> showing 50 of 47,743 rows — these rows as CSV

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