PREVIEW / stock_1hour / 2017-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-06.parquet
  size:    1.1 MB
  rows:    49,220
  symbols: 2,941

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-12-06 04:00:00	AAPL	Stock	42.24	42.25	42.24	42.25	1896.0
2017-12-06 05:00:00	AAPL	Stock	42.235	42.235	42.1825	42.1825	9180.0
2017-12-06 06:00:00	AAPL	Stock	42.1875	42.235	42.14	42.1675	15664.0
2017-12-06 07:00:00	AAPL	Stock	42.225	42.25	42.1625	42.1675	217276.0
2017-12-06 08:00:00	AAPL	Stock	42.19	42.25	41.9775	42.0875	660304.0
2017-12-06 09:00:00	AAPL	Stock	42.09	42.305	41.615	42.2825	25894116.0
2017-12-06 10:00:00	AAPL	Stock	42.2812	42.375	42.14	42.37	14351628.0
2017-12-06 11:00:00	AAPL	Stock	42.37	42.5513	42.295	42.3925	10898856.0
2017-12-06 12:00:00	AAPL	Stock	42.3925	42.4625	42.225	42.3175	8594416.0
2017-12-06 13:00:00	AAPL	Stock	42.3198	42.4175	42.27	42.39	5387276.0
2017-12-06 14:00:00	AAPL	Stock	42.39	42.5075	42.305	42.33	7780112.0
2017-12-06 15:00:00	AAPL	Stock	42.3288	42.3625	42.2075	42.2625	14123748.0
2017-12-06 16:00:00	AAPL	Stock	42.2525	42.3	42.2	42.2075	9308808.0
2017-12-06 17:00:00	AAPL	Stock	42.225	42.2875	42.2125	42.2875	84716.0
2017-12-06 18:00:00	AAPL	Stock	42.285	42.2875	42.2525	42.28	41144.0
2017-12-06 19:00:00	AAPL	Stock	42.2825	42.355	42.2825	42.355	73912.0
2017-12-06 06:00:00	MSFT	Stock	81.22	81.22	81.22	81.22	200.0
2017-12-06 07:00:00	MSFT	Stock	81.25	81.25	81.1	81.1	7584.0
2017-12-06 08:00:00	MSFT	Stock	81.1	81.4	81.06	81.36	20869.0
2017-12-06 09:00:00	MSFT	Stock	81.3	82.53	81.25	82.37	2263127.0
2017-12-06 10:00:00	MSFT	Stock	82.37	82.955	82.33	82.935	2796210.0
2017-12-06 11:00:00	MSFT	Stock	82.94	83.14	82.61	82.92	2547137.0
2017-12-06 12:00:00	MSFT	Stock	82.92	82.98	82.47	82.83	1831329.0
2017-12-06 13:00:00	MSFT	Stock	82.83	82.85	82.65	82.775	2038832.0
2017-12-06 14:00:00	MSFT	Stock	82.77	82.99	82.68	82.81	1838761.0
2017-12-06 15:00:00	MSFT	Stock	82.81	82.92	82.63	82.79	2820740.0
2017-12-06 16:00:00	MSFT	Stock	82.78	82.8	82.72	82.8	5533292.0
2017-12-06 17:00:00	MSFT	Stock	82.8	82.8	82.78	82.78	2751.0
2017-12-06 18:00:00	MSFT	Stock	82.8	83.0	82.8	83.0	22203.0
2017-12-06 19:00:00	MSFT	Stock	83.0	83.02	82.8	83.0	5093.0
2017-12-06 04:00:00	NVDA	Stock	4.6865	4.6865	4.672	4.672	48680.0
2017-12-06 06:00:00	NVDA	Stock	4.6538	4.6625	4.6375	4.645	248080.0
2017-12-06 07:00:00	NVDA	Stock	4.645	4.6688	4.6375	4.6622	1030680.0
2017-12-06 08:00:00	NVDA	Stock	4.6375	4.6625	4.6375	4.6562	2101720.0
2017-12-06 09:00:00	NVDA	Stock	4.66	4.7535	4.621	4.7133	107997440.0
2017-12-06 10:00:00	NVDA	Stock	4.7112	4.7375	4.677	4.7268	83224240.0
2017-12-06 11:00:00	NVDA	Stock	4.7264	4.727	4.6885	4.7042	37689640.0
2017-12-06 12:00:00	NVDA	Stock	4.7028	4.7243	4.68	4.697	32228040.0
2017-12-06 13:00:00	NVDA	Stock	4.6982	4.7222	4.6892	4.7105	27286360.0
2017-12-06 14:00:00	NVDA	Stock	4.7115	4.7412	4.7075	4.7225	38210920.0
2017-12-06 15:00:00	NVDA	Stock	4.7219	4.7425	4.7215	4.7312	59973400.0
2017-12-06 16:00:00	NVDA	Stock	4.7315	4.7488	4.7193	4.7488	18937360.0
2017-12-06 17:00:00	NVDA	Stock	4.7438	4.7438	4.732	4.733	868520.0
2017-12-06 18:00:00	NVDA	Stock	4.7405	4.7568	4.7405	4.7548	578560.0
2017-12-06 19:00:00	NVDA	Stock	4.7545	4.796	4.7525	4.7925	1255200.0
2017-12-06 04:00:00	AMZN	Stock	56.964	56.964	56.964	56.964	7040.0
2017-12-06 05:00:00	AMZN	Stock	56.885	56.885	56.885	56.885	2000.0
2017-12-06 07:00:00	AMZN	Stock	56.8885	56.8885	56.803	56.8795	25980.0
2017-12-06 08:00:00	AMZN	Stock	56.8	56.925	56.75	56.875	57720.0
2017-12-06 09:00:00	AMZN	Stock	56.9635	57.5585	56.804	57.3105	9222100.0

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

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