PREVIEW / stock_1hour / 2016-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-27.parquet
  size:    1.0 MB
  rows:    47,387
  symbols: 3,182

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-10-27 04:00:00	AAPL	Stock	28.925	28.935	28.9125	28.9125	4880.0
2016-10-27 05:00:00	AAPL	Stock	28.925	28.9425	28.925	28.9375	5356.0
2016-10-27 06:00:00	AAPL	Stock	28.9425	28.9875	28.9325	28.9375	25540.0
2016-10-27 07:00:00	AAPL	Stock	28.945	28.9725	28.905	28.9175	56092.0
2016-10-27 08:00:00	AAPL	Stock	28.92	28.95	28.865	28.895	273076.0
2016-10-27 09:00:00	AAPL	Stock	28.885	28.965	28.75	28.855	17021932.0
2016-10-27 10:00:00	AAPL	Stock	28.855	28.865	28.69	28.7525	17453592.0
2016-10-27 11:00:00	AAPL	Stock	28.75	28.8125	28.6925	28.789	11083360.0
2016-10-27 12:00:00	AAPL	Stock	28.79	28.8125	28.725	28.7462	8854132.0
2016-10-27 13:00:00	AAPL	Stock	28.745	28.76	28.7075	28.7425	6559248.0
2016-10-27 14:00:00	AAPL	Stock	28.7425	28.7875	28.7125	28.7175	8111328.0
2016-10-27 15:00:00	AAPL	Stock	28.7175	28.735	28.525	28.625	21905884.0
2016-10-27 16:00:00	AAPL	Stock	28.625	28.7132	28.525	28.57	22630772.0
2016-10-27 17:00:00	AAPL	Stock	28.57	28.5875	28.5275	28.5475	82196.0
2016-10-27 18:00:00	AAPL	Stock	28.54	28.55	28.53	28.545	63740.0
2016-10-27 19:00:00	AAPL	Stock	28.5425	28.5675	28.525	28.5675	72500.0
2016-10-27 04:00:00	MSFT	Stock	60.73	60.73	60.73	60.73	180.0
2016-10-27 07:00:00	MSFT	Stock	60.8	60.8	60.8	60.8	300.0
2016-10-27 08:00:00	MSFT	Stock	60.83	60.85	60.75	60.85	12054.0
2016-10-27 09:00:00	MSFT	Stock	60.8	60.84	60.5	60.675	3736620.0
2016-10-27 10:00:00	MSFT	Stock	60.68	60.76	60.55	60.585	3754182.0
2016-10-27 11:00:00	MSFT	Stock	60.59	60.695	60.5	60.665	2844145.0
2016-10-27 12:00:00	MSFT	Stock	60.67	60.7	60.48	60.515	2091796.0
2016-10-27 13:00:00	MSFT	Stock	60.512	60.575	60.45	60.535	1797906.0
2016-10-27 14:00:00	MSFT	Stock	60.54	60.56	60.435	60.495	2564909.0
2016-10-27 15:00:00	MSFT	Stock	60.5	60.53	60.09	60.11	7794129.0
2016-10-27 16:00:00	MSFT	Stock	60.1	60.22	59.95	60.21	2706110.0
2016-10-27 17:00:00	MSFT	Stock	60.2	60.2	60.12	60.12	19271.0
2016-10-27 18:00:00	MSFT	Stock	60.15	60.15	60.15	60.15	100.0
2016-10-27 19:00:00	MSFT	Stock	60.18	60.19	60.17	60.19	5240.0
2016-10-27 08:00:00	NVDA	Stock	1.8102	1.822	1.8	1.8182	238760.0
2016-10-27 09:00:00	NVDA	Stock	1.8188	1.822	1.8052	1.8155	28829920.0
2016-10-27 10:00:00	NVDA	Stock	1.8135	1.815	1.7862	1.7953	53560360.0
2016-10-27 11:00:00	NVDA	Stock	1.7953	1.796	1.7778	1.7878	40168080.0
2016-10-27 12:00:00	NVDA	Stock	1.7882	1.789	1.7615	1.7633	43955280.0
2016-10-27 13:00:00	NVDA	Stock	1.7635	1.7792	1.763	1.7768	25173200.0
2016-10-27 14:00:00	NVDA	Stock	1.777	1.7862	1.7724	1.773	31618360.0
2016-10-27 15:00:00	NVDA	Stock	1.7733	1.7745	1.7596	1.767	70304840.0
2016-10-27 16:00:00	NVDA	Stock	1.767	1.7678	1.7602	1.7668	9433440.0
2016-10-27 17:00:00	NVDA	Stock	1.7675	1.7675	1.7605	1.7605	354440.0
2016-10-27 18:00:00	NVDA	Stock	1.7688	1.7748	1.7688	1.77	15720.0
2016-10-27 19:00:00	NVDA	Stock	1.77	1.77	1.7615	1.7615	34000.0
2016-10-27 04:00:00	AMZN	Stock	41.455	41.455	41.3115	41.3115	11820.0
2016-10-27 05:00:00	AMZN	Stock	41.2945	41.2945	41.2945	41.2945	4000.0
2016-10-27 06:00:00	AMZN	Stock	41.3235	41.3245	41.25	41.25	11600.0
2016-10-27 07:00:00	AMZN	Stock	41.3045	41.422	41.3045	41.4195	55080.0
2016-10-27 08:00:00	AMZN	Stock	41.425	41.5945	41.3875	41.428	306000.0
2016-10-27 09:00:00	AMZN	Stock	41.461	41.586	41.1105	41.2135	13033420.0
2016-10-27 10:00:00	AMZN	Stock	41.2135	41.283	40.9785	40.9825	11928720.0
2016-10-27 11:00:00	AMZN	Stock	40.979	41.258	40.959	41.205	9626520.0

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

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