PREVIEW / stock_1hour / 2017-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-17.parquet
  size:    1.0 MB
  rows:    48,157
  symbols: 3,101

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-17 04:00:00	AAPL	Stock	33.8725	33.8725	33.725	33.725	1468.0
2017-02-17 05:00:00	AAPL	Stock	33.745	33.7725	33.7	33.7725	5376.0
2017-02-17 06:00:00	AAPL	Stock	33.7425	33.7675	33.7125	33.725	10680.0
2017-02-17 07:00:00	AAPL	Stock	33.755	33.7775	33.7375	33.77	49096.0
2017-02-17 08:00:00	AAPL	Stock	33.7525	33.78	33.7125	33.755	169956.0
2017-02-17 09:00:00	AAPL	Stock	33.765	33.9	33.725	33.9	22010912.0
2017-02-17 10:00:00	AAPL	Stock	33.8995	33.9475	33.8125	33.8175	11266352.0
2017-02-17 11:00:00	AAPL	Stock	33.8188	33.8625	33.7825	33.8475	6434152.0
2017-02-17 12:00:00	AAPL	Stock	33.8475	33.875	33.82	33.8475	3984436.0
2017-02-17 13:00:00	AAPL	Stock	33.846	33.885	33.83	33.8805	5356532.0
2017-02-17 14:00:00	AAPL	Stock	33.881	33.9025	33.865	33.8775	5084420.0
2017-02-17 15:00:00	AAPL	Stock	33.876	33.9375	33.8425	33.9275	14326500.0
2017-02-17 16:00:00	AAPL	Stock	33.9575	33.9575	33.865	33.9125	14155784.0
2017-02-17 17:00:00	AAPL	Stock	33.9125	33.925	33.9	33.9225	66580.0
2017-02-17 18:00:00	AAPL	Stock	33.925	33.9275	33.9125	33.9225	17568.0
2017-02-17 19:00:00	AAPL	Stock	33.915	33.925	33.9075	33.9175	41660.0
2017-02-17 04:00:00	MSFT	Stock	64.44	64.44	64.44	64.44	840.0
2017-02-17 07:00:00	MSFT	Stock	64.45	64.45	64.4	64.4	554.0
2017-02-17 08:00:00	MSFT	Stock	64.42	64.44	64.31	64.31	6159.0
2017-02-17 09:00:00	MSFT	Stock	64.38	64.6	64.3	64.54	4163860.0
2017-02-17 10:00:00	MSFT	Stock	64.55	64.69	64.47	64.49	1740071.0
2017-02-17 11:00:00	MSFT	Stock	64.49	64.54	64.37	64.42	1430770.0
2017-02-17 12:00:00	MSFT	Stock	64.42	64.53	64.4	64.525	1022341.0
2017-02-17 13:00:00	MSFT	Stock	64.525	64.54	64.4	64.4	1055274.0
2017-02-17 14:00:00	MSFT	Stock	64.4	64.45	64.39	64.39	1037828.0
2017-02-17 15:00:00	MSFT	Stock	64.39	64.63	64.37	64.61	4444889.0
2017-02-17 16:00:00	MSFT	Stock	64.62	64.62	64.41	64.54	5154840.0
2017-02-17 17:00:00	MSFT	Stock	64.54	64.54	64.53	64.53	818.0
2017-02-17 18:00:00	MSFT	Stock	64.5	64.5	64.5	64.5	1200.0
2017-02-17 19:00:00	MSFT	Stock	64.51	64.55	64.51	64.55	590.0
2017-02-17 04:00:00	NVDA	Stock	2.681	2.681	2.6788	2.6788	44000.0
2017-02-17 06:00:00	NVDA	Stock	2.677	2.677	2.6748	2.675	43800.0
2017-02-17 07:00:00	NVDA	Stock	2.667	2.667	2.66	2.6605	24000.0
2017-02-17 08:00:00	NVDA	Stock	2.6605	2.6745	2.6562	2.6605	1572600.0
2017-02-17 09:00:00	NVDA	Stock	2.6613	2.668	2.6198	2.6355	131844840.0
2017-02-17 10:00:00	NVDA	Stock	2.636	2.66	2.6235	2.6541	110725560.0
2017-02-17 11:00:00	NVDA	Stock	2.654	2.6808	2.6538	2.6654	83307280.0
2017-02-17 12:00:00	NVDA	Stock	2.6653	2.6733	2.6555	2.663	49717680.0
2017-02-17 13:00:00	NVDA	Stock	2.6628	2.6786	2.6602	2.67	38661560.0
2017-02-17 14:00:00	NVDA	Stock	2.6699	2.6852	2.669	2.6773	42321920.0
2017-02-17 15:00:00	NVDA	Stock	2.677	2.6816	2.6718	2.6808	67614240.0
2017-02-17 16:00:00	NVDA	Stock	2.68	2.6808	2.6775	2.68	4941920.0
2017-02-17 17:00:00	NVDA	Stock	2.68	2.68	2.6775	2.6775	231560.0
2017-02-17 18:00:00	NVDA	Stock	2.6775	2.6798	2.6765	2.6765	265680.0
2017-02-17 19:00:00	NVDA	Stock	2.6765	2.68	2.6762	2.6798	346800.0
2017-02-17 06:00:00	AMZN	Stock	42.0655	42.0655	42.0655	42.0655	2000.0
2017-02-17 07:00:00	AMZN	Stock	42.0655	42.125	42.0655	42.125	60640.0
2017-02-17 08:00:00	AMZN	Stock	42.0685	42.125	42.052	42.12	222120.0
2017-02-17 09:00:00	AMZN	Stock	42.1035	42.2975	42.0365	42.2502	11161560.0
2017-02-17 10:00:00	AMZN	Stock	42.2543	42.3635	42.2395	42.305	9991320.0

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

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