PREVIEW / stock_1hour / 2016-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-15.parquet
  size:    1.0 MB
  rows:    48,393
  symbols: 3,223

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
2016-09-15 04:00:00	AAPL	Stock	27.9225	28.0625	27.8925	28.05	37608.0
2016-09-15 05:00:00	AAPL	Stock	28.0825	28.1725	28.0575	28.165	49032.0
2016-09-15 06:00:00	AAPL	Stock	28.15	28.25	28.1375	28.1975	345120.0
2016-09-15 07:00:00	AAPL	Stock	28.2	28.275	28.1875	28.2675	568056.0
2016-09-15 08:00:00	AAPL	Stock	28.255	28.4975	28.1875	28.48	3599320.0
2016-09-15 09:00:00	AAPL	Stock	28.48	28.7375	28.3725	28.735	81623124.0
2016-09-15 10:00:00	AAPL	Stock	28.7325	28.8775	28.645	28.81	74749120.0
2016-09-15 11:00:00	AAPL	Stock	28.8075	28.85	28.68	28.7462	38451832.0
2016-09-15 12:00:00	AAPL	Stock	28.7462	28.875	28.6925	28.761	29870764.0
2016-09-15 13:00:00	AAPL	Stock	28.7625	28.8078	28.6712	28.7825	25141320.0
2016-09-15 14:00:00	AAPL	Stock	28.7825	28.85	28.7525	28.8422	22531744.0
2016-09-15 15:00:00	AAPL	Stock	28.8425	28.9325	28.7575	28.8925	47693468.0
2016-09-15 16:00:00	AAPL	Stock	28.8875	28.9125	28.751	28.85	16082844.0
2016-09-15 17:00:00	AAPL	Stock	28.855	28.8975	28.8475	28.8675	1132608.0
2016-09-15 18:00:00	AAPL	Stock	28.88	28.9	28.83	28.8675	219812.0
2016-09-15 19:00:00	AAPL	Stock	28.8675	28.875	28.85	28.85	147400.0
2016-09-15 07:00:00	MSFT	Stock	56.26	56.26	56.26	56.26	220.0
2016-09-15 08:00:00	MSFT	Stock	56.35	56.36	56.07	56.17	18679.0
2016-09-15 09:00:00	MSFT	Stock	56.22	56.33	55.98	56.22	2980426.0
2016-09-15 10:00:00	MSFT	Stock	56.22	56.87	56.167	56.86	3580950.0
2016-09-15 11:00:00	MSFT	Stock	56.86	56.99	56.735	56.885	2657061.0
2016-09-15 12:00:00	MSFT	Stock	56.89	57.0	56.835	56.875	2059291.0
2016-09-15 13:00:00	MSFT	Stock	56.88	57.12	56.87	57.12	2058555.0
2016-09-15 14:00:00	MSFT	Stock	57.12	57.35	57.065	57.284	2688085.0
2016-09-15 15:00:00	MSFT	Stock	57.29	57.35	57.18	57.19	4993844.0
2016-09-15 16:00:00	MSFT	Stock	57.19	57.24	57.12	57.24	4335210.0
2016-09-15 17:00:00	MSFT	Stock	57.19	57.19	57.02	57.19	211006.0
2016-09-15 18:00:00	MSFT	Stock	57.13	57.16	57.13	57.16	2100.0
2016-09-15 19:00:00	MSFT	Stock	57.06	57.12	57.06	57.06	2011.0
2016-09-15 07:00:00	NVDA	Stock	1.51	1.51	1.51	1.51	4800.0
2016-09-15 08:00:00	NVDA	Stock	1.5195	1.5208	1.5152	1.5152	270000.0
2016-09-15 09:00:00	NVDA	Stock	1.5152	1.5258	1.509	1.5231	32312400.0
2016-09-15 10:00:00	NVDA	Stock	1.5235	1.55	1.5209	1.5488	61222720.0
2016-09-15 11:00:00	NVDA	Stock	1.549	1.5548	1.5408	1.5498	97990800.0
2016-09-15 12:00:00	NVDA	Stock	1.55	1.5601	1.5478	1.5592	60480520.0
2016-09-15 13:00:00	NVDA	Stock	1.5595	1.5688	1.5575	1.5681	65468600.0
2016-09-15 14:00:00	NVDA	Stock	1.5682	1.569	1.562	1.5658	56263120.0
2016-09-15 15:00:00	NVDA	Stock	1.566	1.5685	1.5602	1.5672	97855320.0
2016-09-15 16:00:00	NVDA	Stock	1.5682	1.5685	1.553	1.5672	4977080.0
2016-09-15 17:00:00	NVDA	Stock	1.5672	1.5672	1.565	1.565	14000.0
2016-09-15 18:00:00	NVDA	Stock	1.5672	1.5672	1.565	1.565	24000.0
2016-09-15 19:00:00	NVDA	Stock	1.5672	1.5672	1.565	1.565	87280.0
2016-09-15 07:00:00	AMZN	Stock	38.1295	38.1375	38.1245	38.133	22680.0
2016-09-15 08:00:00	AMZN	Stock	38.13	38.225	38.1	38.131	254800.0
2016-09-15 09:00:00	AMZN	Stock	38.1625	38.1625	37.879	38.0615	10164520.0
2016-09-15 10:00:00	AMZN	Stock	38.0605	38.3035	37.997	38.3035	9142440.0
2016-09-15 11:00:00	AMZN	Stock	38.2988	38.375	38.2693	38.346	5996400.0
2016-09-15 12:00:00	AMZN	Stock	38.345	38.444	38.3	38.3895	6407560.0
2016-09-15 13:00:00	AMZN	Stock	38.394	38.469	38.3345	38.4615	4926860.0
2016-09-15 14:00:00	AMZN	Stock	38.465	38.5435	38.4282	38.5105	4198780.0

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

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