PREVIEW / stock_1hour / 2016-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-21.parquet
  size:    1.0 MB
  rows:    48,133
  symbols: 3,217

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-21 04:00:00	AAPL	Stock	28.505	28.5725	28.505	28.5725	8228.0
2016-09-21 05:00:00	AAPL	Stock	28.53	28.65	28.53	28.65	33568.0
2016-09-21 06:00:00	AAPL	Stock	28.665	28.735	28.3075	28.565	57688.0
2016-09-21 07:00:00	AAPL	Stock	28.555	28.63	28.53	28.55	79232.0
2016-09-21 08:00:00	AAPL	Stock	28.545	28.575	28.48	28.5275	312388.0
2016-09-21 09:00:00	AAPL	Stock	28.52	28.52	28.2625	28.2868	17390008.0
2016-09-21 10:00:00	AAPL	Stock	28.285	28.445	28.2575	28.315	19366396.0
2016-09-21 11:00:00	AAPL	Stock	28.315	28.3212	28.225	28.2335	13836904.0
2016-09-21 12:00:00	AAPL	Stock	28.2325	28.2425	28.1102	28.1725	16079236.0
2016-09-21 13:00:00	AAPL	Stock	28.175	28.2175	28.135	28.17	9129972.0
2016-09-21 14:00:00	AAPL	Stock	28.1625	28.355	28.125	28.34	22347264.0
2016-09-21 15:00:00	AAPL	Stock	28.34	28.415	28.31	28.3825	20143780.0
2016-09-21 16:00:00	AAPL	Stock	28.3875	28.4325	28.375	28.4125	11991908.0
2016-09-21 17:00:00	AAPL	Stock	28.4125	28.415	28.395	28.4	61788.0
2016-09-21 18:00:00	AAPL	Stock	28.4	28.4075	28.3925	28.4	35180.0
2016-09-21 19:00:00	AAPL	Stock	28.405	28.415	28.4025	28.415	35640.0
2016-09-21 04:00:00	MSFT	Stock	57.53	57.75	57.53	57.6	1448.0
2016-09-21 05:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	1100.0
2016-09-21 06:00:00	MSFT	Stock	57.6	57.6	57.5	57.53	1972.0
2016-09-21 07:00:00	MSFT	Stock	57.5	57.55	57.44	57.5	34974.0
2016-09-21 08:00:00	MSFT	Stock	57.55	57.59	57.42	57.56	106374.0
2016-09-21 09:00:00	MSFT	Stock	57.57	57.59	57.08	57.43	5194646.0
2016-09-21 10:00:00	MSFT	Stock	57.44	57.6	57.39	57.455	4022950.0
2016-09-21 11:00:00	MSFT	Stock	57.46	57.52	57.34	57.38	3310778.0
2016-09-21 12:00:00	MSFT	Stock	57.375	57.45	57.11	57.18	2881447.0
2016-09-21 13:00:00	MSFT	Stock	57.17	57.37	57.13	57.3	2057615.0
2016-09-21 14:00:00	MSFT	Stock	57.3	57.54	57.12	57.51	4696099.0
2016-09-21 15:00:00	MSFT	Stock	57.52	57.85	57.465	57.75	6151953.0
2016-09-21 16:00:00	MSFT	Stock	57.76	57.8	57.74	57.76	2873706.0
2016-09-21 17:00:00	MSFT	Stock	57.8	57.83	57.73	57.78	19219.0
2016-09-21 18:00:00	MSFT	Stock	57.78	57.8	57.78	57.8	700.0
2016-09-21 19:00:00	MSFT	Stock	57.76	57.82	57.76	57.82	2336.0
2016-09-21 08:00:00	NVDA	Stock	1.5805	1.5842	1.5805	1.5832	96000.0
2016-09-21 09:00:00	NVDA	Stock	1.5848	1.6028	1.5818	1.6024	36734680.0
2016-09-21 10:00:00	NVDA	Stock	1.6023	1.605	1.5928	1.5935	54328560.0
2016-09-21 11:00:00	NVDA	Stock	1.5938	1.601	1.5925	1.593	27194840.0
2016-09-21 12:00:00	NVDA	Stock	1.593	1.5964	1.5865	1.5964	23083560.0
2016-09-21 13:00:00	NVDA	Stock	1.5963	1.5992	1.5938	1.5983	19283640.0
2016-09-21 14:00:00	NVDA	Stock	1.5978	1.612	1.5948	1.6112	50001440.0
2016-09-21 15:00:00	NVDA	Stock	1.6112	1.6245	1.609	1.6212	94724080.0
2016-09-21 16:00:00	NVDA	Stock	1.6215	1.6248	1.6205	1.6215	15605800.0
2016-09-21 17:00:00	NVDA	Stock	1.6215	1.6245	1.6215	1.6245	101000.0
2016-09-21 18:00:00	NVDA	Stock	1.6242	1.6245	1.6225	1.6245	14000.0
2016-09-21 19:00:00	NVDA	Stock	1.6245	1.6245	1.6242	1.6242	25600.0
2016-09-21 04:00:00	AMZN	Stock	39.17	39.25	39.17	39.25	7940.0
2016-09-21 05:00:00	AMZN	Stock	39.2715	39.273	39.25	39.273	10000.0
2016-09-21 06:00:00	AMZN	Stock	39.2935	39.2935	39.25	39.25	15240.0
2016-09-21 07:00:00	AMZN	Stock	39.195	39.2	39.1725	39.1725	28000.0
2016-09-21 08:00:00	AMZN	Stock	39.15	39.1625	39.125	39.134	106120.0
2016-09-21 09:00:00	AMZN	Stock	39.1495	39.17	39.0125	39.0775	4706080.0

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

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