PREVIEW / stock_1hour / 2016-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-18.parquet
  size:    1.0 MB
  rows:    47,985
  symbols: 3,253

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-08-18 04:00:00	AAPL	Stock	27.33	27.345	27.33	27.345	1164.0
2016-08-18 06:00:00	AAPL	Stock	27.3475	27.3475	27.325	27.3275	8204.0
2016-08-18 07:00:00	AAPL	Stock	27.325	27.325	27.265	27.265	18316.0
2016-08-18 08:00:00	AAPL	Stock	27.2875	27.2975	27.26	27.26	84212.0
2016-08-18 09:00:00	AAPL	Stock	27.275	27.4	27.2625	27.331	12101908.0
2016-08-18 10:00:00	AAPL	Stock	27.335	27.3725	27.285	27.3625	11394948.0
2016-08-18 11:00:00	AAPL	Stock	27.3625	27.3775	27.3175	27.3612	7698872.0
2016-08-18 12:00:00	AAPL	Stock	27.36	27.3675	27.2575	27.2875	7412992.0
2016-08-18 13:00:00	AAPL	Stock	27.2875	27.325	27.2775	27.295	6464704.0
2016-08-18 14:00:00	AAPL	Stock	27.2975	27.35	27.2875	27.3462	7487644.0
2016-08-18 15:00:00	AAPL	Stock	27.3465	27.375	27.255	27.2702	15348228.0
2016-08-18 16:00:00	AAPL	Stock	27.27	27.339	27.265	27.2725	11262520.0
2016-08-18 17:00:00	AAPL	Stock	27.2725	27.3	27.2675	27.3	99476.0
2016-08-18 18:00:00	AAPL	Stock	27.28	27.3025	27.28	27.295	21680.0
2016-08-18 19:00:00	AAPL	Stock	27.2825	27.2975	27.27	27.2975	35300.0
2016-08-18 07:00:00	MSFT	Stock	57.49	57.49	57.49	57.49	359.0
2016-08-18 08:00:00	MSFT	Stock	57.56	57.56	57.56	57.56	100.0
2016-08-18 09:00:00	MSFT	Stock	57.42	57.53	57.27	57.31	1366413.0
2016-08-18 10:00:00	MSFT	Stock	57.315	57.57	57.3	57.47	1775039.0
2016-08-18 11:00:00	MSFT	Stock	57.47	57.5	57.385	57.44	1606510.0
2016-08-18 12:00:00	MSFT	Stock	57.443	57.45	57.28	57.403	1294273.0
2016-08-18 13:00:00	MSFT	Stock	57.41	57.57	57.39	57.529	951293.0
2016-08-18 14:00:00	MSFT	Stock	57.53	57.63	57.52	57.63	1206425.0
2016-08-18 15:00:00	MSFT	Stock	57.62	57.7	57.58	57.6	2412749.0
2016-08-18 16:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	2631281.0
2016-08-18 18:00:00	MSFT	Stock	57.56	57.56	57.56	57.56	300.0
2016-08-18 19:00:00	MSFT	Stock	57.63	57.63	57.63	57.63	1800.0
2016-08-18 07:00:00	NVDA	Stock	1.536	1.536	1.536	1.536	4000.0
2016-08-18 08:00:00	NVDA	Stock	1.5373	1.5373	1.5168	1.5225	164280.0
2016-08-18 09:00:00	NVDA	Stock	1.52	1.5428	1.52	1.5398	50614840.0
2016-08-18 10:00:00	NVDA	Stock	1.54	1.548	1.538	1.5444	48232240.0
2016-08-18 11:00:00	NVDA	Stock	1.5444	1.553	1.543	1.5525	43843560.0
2016-08-18 12:00:00	NVDA	Stock	1.5523	1.553	1.5425	1.5449	36801680.0
2016-08-18 13:00:00	NVDA	Stock	1.545	1.5549	1.5449	1.5535	28853520.0
2016-08-18 14:00:00	NVDA	Stock	1.5535	1.5538	1.5503	1.5524	31258200.0
2016-08-18 15:00:00	NVDA	Stock	1.5525	1.555	1.5478	1.5525	58303040.0
2016-08-18 16:00:00	NVDA	Stock	1.5525	1.5538	1.5525	1.5528	20747240.0
2016-08-18 17:00:00	NVDA	Stock	1.5538	1.5548	1.5538	1.5538	60000.0
2016-08-18 18:00:00	NVDA	Stock	1.5535	1.5548	1.5535	1.5535	131400.0
2016-08-18 19:00:00	NVDA	Stock	1.5558	1.5575	1.5558	1.5575	90000.0
2016-08-18 07:00:00	AMZN	Stock	38.2065	38.214	38.2065	38.212	18520.0
2016-08-18 09:00:00	AMZN	Stock	38.2185	38.22	38.03	38.193	4559020.0
2016-08-18 10:00:00	AMZN	Stock	38.1925	38.2585	38.0865	38.1665	3685940.0
2016-08-18 11:00:00	AMZN	Stock	38.166	38.21	38.119	38.2025	2825960.0
2016-08-18 12:00:00	AMZN	Stock	38.2045	38.2585	38.078	38.12	2399160.0
2016-08-18 13:00:00	AMZN	Stock	38.123	38.216	38.1175	38.216	1702840.0
2016-08-18 14:00:00	AMZN	Stock	38.2195	38.22	38.1616	38.1935	1689400.0
2016-08-18 15:00:00	AMZN	Stock	38.1885	38.225	38.1585	38.214	2933240.0
2016-08-18 16:00:00	AMZN	Stock	38.223	38.223	38.175	38.175	5563180.0
2016-08-18 18:00:00	AMZN	Stock	38.2175	38.2175	38.205	38.205	4000.0

> showing 50 of 47,985 rows — these rows as CSV

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