PREVIEW / stock_1hour / 2017-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-31.parquet
  size:    1.1 MB
  rows:    48,650
  symbols: 2,945

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-10-31 04:00:00	AAPL	Stock	41.75	41.77	41.75	41.77	3272.0
2017-10-31 05:00:00	AAPL	Stock	41.8125	41.8625	41.8125	41.8625	3584.0
2017-10-31 06:00:00	AAPL	Stock	41.87	41.925	41.775	41.7775	25716.0
2017-10-31 07:00:00	AAPL	Stock	41.775	41.92	41.775	41.9175	286464.0
2017-10-31 08:00:00	AAPL	Stock	41.865	42.0925	41.77	42.0375	1030904.0
2017-10-31 09:00:00	AAPL	Stock	42.0225	42.1725	41.735	41.8	23372980.0
2017-10-31 10:00:00	AAPL	Stock	41.8025	42.1175	41.795	42.0975	17739332.0
2017-10-31 11:00:00	AAPL	Stock	42.095	42.2725	42.09	42.2288	18413352.0
2017-10-31 12:00:00	AAPL	Stock	42.2325	42.3	42.155	42.2125	10848324.0
2017-10-31 13:00:00	AAPL	Stock	42.21	42.2925	42.1275	42.2925	10481448.0
2017-10-31 14:00:00	AAPL	Stock	42.2912	42.4125	42.21	42.264	14796432.0
2017-10-31 15:00:00	AAPL	Stock	42.265	42.325	42.2	42.2625	19385108.0
2017-10-31 16:00:00	AAPL	Stock	42.26	42.2875	42.1995	42.2425	14369028.0
2017-10-31 17:00:00	AAPL	Stock	42.26	42.26	42.0625	42.175	269960.0
2017-10-31 18:00:00	AAPL	Stock	42.175	42.2125	42.15	42.2075	83768.0
2017-10-31 19:00:00	AAPL	Stock	42.2075	42.265	42.195	42.25	56604.0
2017-10-31 04:00:00	MSFT	Stock	84.16	84.16	84.16	84.16	118.0
2017-10-31 07:00:00	MSFT	Stock	83.89	84.1	83.89	84.1	7815.0
2017-10-31 08:00:00	MSFT	Stock	84.0	84.19	83.92	84.15	26397.0
2017-10-31 09:00:00	MSFT	Stock	84.12	84.39	83.56	83.58	2605457.0
2017-10-31 10:00:00	MSFT	Stock	83.58	83.87	83.51	83.75	3324669.0
2017-10-31 11:00:00	MSFT	Stock	83.755	83.805	83.59	83.745	2593079.0
2017-10-31 12:00:00	MSFT	Stock	83.745	83.76	83.31	83.47	2743239.0
2017-10-31 13:00:00	MSFT	Stock	83.475	83.6	83.25	83.43	2103183.0
2017-10-31 14:00:00	MSFT	Stock	83.43	83.565	83.29	83.304	2727171.0
2017-10-31 15:00:00	MSFT	Stock	83.305	83.45	83.11	83.18	5494271.0
2017-10-31 16:00:00	MSFT	Stock	83.18	83.898	83.18	83.3	3725796.0
2017-10-31 17:00:00	MSFT	Stock	83.3	83.3	83.2	83.29	828.0
2017-10-31 18:00:00	MSFT	Stock	83.29	83.29	83.29	83.29	1605.0
2017-10-31 19:00:00	MSFT	Stock	83.29	83.3	83.21	83.21	2274.0
2017-10-31 04:00:00	NVDA	Stock	5.0963	5.0963	5.0963	5.0963	8000.0
2017-10-31 06:00:00	NVDA	Stock	5.1193	5.1193	5.1193	5.1193	4000.0
2017-10-31 07:00:00	NVDA	Stock	5.1012	5.1195	5.1012	5.1125	243880.0
2017-10-31 08:00:00	NVDA	Stock	5.1012	5.1198	5.1012	5.1195	926480.0
2017-10-31 09:00:00	NVDA	Stock	5.1195	5.1702	5.117	5.1539	76459680.0
2017-10-31 10:00:00	NVDA	Stock	5.1541	5.1873	5.1525	5.1713	73526960.0
2017-10-31 11:00:00	NVDA	Stock	5.1707	5.1812	5.1555	5.1802	32420560.0
2017-10-31 12:00:00	NVDA	Stock	5.1808	5.186	5.1615	5.18	27744640.0
2017-10-31 13:00:00	NVDA	Stock	5.18	5.1973	5.1763	5.1858	33195360.0
2017-10-31 14:00:00	NVDA	Stock	5.1862	5.1912	5.1513	5.1684	37608200.0
2017-10-31 15:00:00	NVDA	Stock	5.1684	5.1732	5.1513	5.1688	49266720.0
2017-10-31 16:00:00	NVDA	Stock	5.1702	5.1745	5.1688	5.1725	31268800.0
2017-10-31 17:00:00	NVDA	Stock	5.1715	5.172	5.168	5.169	230560.0
2017-10-31 18:00:00	NVDA	Stock	5.169	5.175	5.169	5.1735	743680.0
2017-10-31 19:00:00	NVDA	Stock	5.175	5.181	5.1738	5.18	460480.0
2017-10-31 07:00:00	AMZN	Stock	55.6775	55.6915	55.6085	55.6495	114600.0
2017-10-31 08:00:00	AMZN	Stock	55.6005	55.675	55.585	55.6095	402920.0
2017-10-31 09:00:00	AMZN	Stock	55.6145	55.625	55.15	55.2834	12412180.0
2017-10-31 10:00:00	AMZN	Stock	55.2705	55.3715	55.056	55.3425	13153380.0
2017-10-31 11:00:00	AMZN	Stock	55.35	55.439	55.2155	55.283	8524660.0

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

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