PREVIEW / stock_1hour / 2016-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-20.parquet
  size:    1.1 MB
  rows:    49,230
  symbols: 3,170

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-12-20 04:00:00	AAPL	Stock	29.125	29.125	29.1175	29.1175	800.0
2016-12-20 05:00:00	AAPL	Stock	29.0775	29.11	29.0675	29.11	1652.0
2016-12-20 06:00:00	AAPL	Stock	29.095	29.125	29.09	29.125	16660.0
2016-12-20 07:00:00	AAPL	Stock	29.16	29.1975	29.145	29.155	38220.0
2016-12-20 08:00:00	AAPL	Stock	29.1625	29.2275	29.125	29.225	259528.0
2016-12-20 09:00:00	AAPL	Stock	29.235	29.375	29.17	29.2975	14391144.0
2016-12-20 10:00:00	AAPL	Stock	29.3	29.3012	29.215	29.2812	11220640.0
2016-12-20 11:00:00	AAPL	Stock	29.28	29.295	29.22	29.2405	7537528.0
2016-12-20 12:00:00	AAPL	Stock	29.2412	29.275	29.2275	29.27	5259924.0
2016-12-20 13:00:00	AAPL	Stock	29.27	29.2875	29.2475	29.2775	5989388.0
2016-12-20 14:00:00	AAPL	Stock	29.2775	29.2775	29.18	29.2075	6039872.0
2016-12-20 15:00:00	AAPL	Stock	29.2075	29.26	29.1925	29.2375	9588012.0
2016-12-20 16:00:00	AAPL	Stock	29.2375	29.2525	29.2125	29.225	14462132.0
2016-12-20 17:00:00	AAPL	Stock	29.2175	29.225	29.215	29.225	80536.0
2016-12-20 18:00:00	AAPL	Stock	29.22	29.225	29.2175	29.2175	22360.0
2016-12-20 19:00:00	AAPL	Stock	29.215	29.25	29.215	29.24	27244.0
2016-12-20 06:00:00	MSFT	Stock	63.54	63.6	63.54	63.6	400.0
2016-12-20 07:00:00	MSFT	Stock	63.65	63.75	63.65	63.75	1211.0
2016-12-20 08:00:00	MSFT	Stock	63.68	63.8	63.62	63.8	58428.0
2016-12-20 09:00:00	MSFT	Stock	63.89	63.89	63.52	63.73	2767093.0
2016-12-20 10:00:00	MSFT	Stock	63.73	63.76	63.43	63.494	3333314.0
2016-12-20 11:00:00	MSFT	Stock	63.5	63.51	63.025	63.2	4168654.0
2016-12-20 12:00:00	MSFT	Stock	63.2	63.52	63.15	63.5	2484779.0
2016-12-20 13:00:00	MSFT	Stock	63.496	63.6	63.43	63.51	1384233.0
2016-12-20 14:00:00	MSFT	Stock	63.51	63.52	63.335	63.4	1367672.0
2016-12-20 15:00:00	MSFT	Stock	63.4	63.57	63.38	63.54	2504187.0
2016-12-20 16:00:00	MSFT	Stock	63.54	63.55	63.5	63.5	5650024.0
2016-12-20 17:00:00	MSFT	Stock	63.54	63.68	63.54	63.58	34943.0
2016-12-20 18:00:00	MSFT	Stock	63.62	63.64	63.62	63.64	869.0
2016-12-20 19:00:00	MSFT	Stock	63.64	63.64	63.64	63.64	1621.0
2016-12-20 04:00:00	NVDA	Stock	2.5538	2.5538	2.5538	2.5538	24000.0
2016-12-20 05:00:00	NVDA	Stock	2.5622	2.5622	2.5618	2.5618	16000.0
2016-12-20 06:00:00	NVDA	Stock	2.5615	2.595	2.5615	2.5925	385400.0
2016-12-20 07:00:00	NVDA	Stock	2.5922	2.6075	2.5858	2.6075	659640.0
2016-12-20 08:00:00	NVDA	Stock	2.6075	2.6225	2.5408	2.6145	4929800.0
2016-12-20 09:00:00	NVDA	Stock	2.615	2.6532	2.603	2.638	183332920.0
2016-12-20 10:00:00	NVDA	Stock	2.6378	2.646	2.6248	2.6405	153025760.0
2016-12-20 11:00:00	NVDA	Stock	2.6405	2.644	2.6288	2.6352	95394720.0
2016-12-20 12:00:00	NVDA	Stock	2.6355	2.642	2.6263	2.637	80701680.0
2016-12-20 13:00:00	NVDA	Stock	2.637	2.6512	2.627	2.6473	100667640.0
2016-12-20 14:00:00	NVDA	Stock	2.6472	2.6478	2.6285	2.6303	80454200.0
2016-12-20 15:00:00	NVDA	Stock	2.6303	2.6328	2.6158	2.6288	119356080.0
2016-12-20 16:00:00	NVDA	Stock	2.6272	2.6345	2.625	2.625	18063240.0
2016-12-20 17:00:00	NVDA	Stock	2.6293	2.6338	2.6285	2.63	539600.0
2016-12-20 18:00:00	NVDA	Stock	2.6312	2.6325	2.63	2.6305	305480.0
2016-12-20 19:00:00	NVDA	Stock	2.6312	2.6375	2.6312	2.6375	332640.0
2016-12-20 07:00:00	AMZN	Stock	38.4195	38.4195	38.4195	38.4195	4000.0
2016-12-20 08:00:00	AMZN	Stock	38.4	38.4425	38.3	38.44	285020.0
2016-12-20 09:00:00	AMZN	Stock	38.44	38.7195	38.3855	38.589	9938640.0
2016-12-20 10:00:00	AMZN	Stock	38.59	38.636	38.4747	38.592	6311960.0

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

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