PREVIEW / stock_1hour / 2016-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-14.parquet
  size:    1.0 MB
  rows:    48,244
  symbols: 3,232

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-14 04:00:00	AAPL	Stock	27.05	27.1975	27.05	27.0525	31316.0
2016-09-14 05:00:00	AAPL	Stock	27.0725	27.0725	27.0	27.0	43084.0
2016-09-14 06:00:00	AAPL	Stock	27.0375	27.1975	26.9825	27.1625	174324.0
2016-09-14 07:00:00	AAPL	Stock	27.125	27.275	27.115	27.2375	288384.0
2016-09-14 08:00:00	AAPL	Stock	27.215	27.25	27.065	27.17	1247360.0
2016-09-14 09:00:00	AAPL	Stock	27.1625	27.7425	27.12	27.7375	69215196.0
2016-09-14 10:00:00	AAPL	Stock	27.7388	27.8925	27.6625	27.7962	64675912.0
2016-09-14 11:00:00	AAPL	Stock	27.7988	28.1925	27.7938	28.1592	65845120.0
2016-09-14 12:00:00	AAPL	Stock	28.1585	28.2575	28.0775	28.1302	42584032.0
2016-09-14 13:00:00	AAPL	Stock	28.135	28.1875	27.7375	27.89	61762644.0
2016-09-14 14:00:00	AAPL	Stock	27.895	28.1875	27.7875	28.0522	58489668.0
2016-09-14 15:00:00	AAPL	Stock	28.0525	28.085	27.8475	27.9425	45750480.0
2016-09-14 16:00:00	AAPL	Stock	27.94	28.1542	27.9	27.935	11947404.0
2016-09-14 17:00:00	AAPL	Stock	27.93	27.9475	27.9275	27.945	491312.0
2016-09-14 18:00:00	AAPL	Stock	27.945	27.9775	27.9375	27.97	115100.0
2016-09-14 19:00:00	AAPL	Stock	27.96	27.985	27.9375	27.9775	109496.0
2016-09-14 05:00:00	MSFT	Stock	56.8	56.8	56.8	56.8	175.0
2016-09-14 07:00:00	MSFT	Stock	56.81	56.81	56.81	56.81	200.0
2016-09-14 08:00:00	MSFT	Stock	56.65	56.69	56.65	56.69	6600.0
2016-09-14 09:00:00	MSFT	Stock	56.69	56.69	56.03	56.14	3047845.0
2016-09-14 10:00:00	MSFT	Stock	56.15	56.625	56.12	56.49	3757279.0
2016-09-14 11:00:00	MSFT	Stock	56.49	56.545	56.22	56.52	2341045.0
2016-09-14 12:00:00	MSFT	Stock	56.52	56.63	56.4	56.485	1629777.0
2016-09-14 13:00:00	MSFT	Stock	56.48	56.52	56.28	56.28	1537971.0
2016-09-14 14:00:00	MSFT	Stock	56.28	56.39	56.141	56.34	2150414.0
2016-09-14 15:00:00	MSFT	Stock	56.34	56.37	56.04	56.26	5283267.0
2016-09-14 16:00:00	MSFT	Stock	56.26	56.29	56.07	56.26	2973486.0
2016-09-14 18:00:00	MSFT	Stock	56.24	56.24	56.23	56.23	284.0
2016-09-14 19:00:00	MSFT	Stock	56.1	56.1	56.1	56.1	1740.0
2016-09-14 07:00:00	NVDA	Stock	1.5095	1.51	1.5095	1.51	8000.0
2016-09-14 08:00:00	NVDA	Stock	1.5015	1.513	1.5012	1.513	156560.0
2016-09-14 09:00:00	NVDA	Stock	1.5125	1.5128	1.494	1.5012	32555640.0
2016-09-14 10:00:00	NVDA	Stock	1.5015	1.5075	1.4918	1.4942	49666160.0
2016-09-14 11:00:00	NVDA	Stock	1.4942	1.5062	1.4878	1.506	37425480.0
2016-09-14 12:00:00	NVDA	Stock	1.5061	1.515	1.505	1.5098	36028600.0
2016-09-14 13:00:00	NVDA	Stock	1.5098	1.514	1.503	1.5054	17650480.0
2016-09-14 14:00:00	NVDA	Stock	1.5053	1.5072	1.4991	1.5051	25983080.0
2016-09-14 15:00:00	NVDA	Stock	1.5053	1.51	1.499	1.51	53444160.0
2016-09-14 16:00:00	NVDA	Stock	1.51	1.51	1.5098	1.51	15999720.0
2016-09-14 17:00:00	NVDA	Stock	1.5098	1.5098	1.5098	1.5098	12000.0
2016-09-14 18:00:00	NVDA	Stock	1.5095	1.5135	1.5075	1.5135	138360.0
2016-09-14 07:00:00	AMZN	Stock	38.172	38.172	38.158	38.158	18340.0
2016-09-14 08:00:00	AMZN	Stock	38.172	38.203	38.15	38.203	102180.0
2016-09-14 09:00:00	AMZN	Stock	38.2	38.324	38.0875	38.2615	8681540.0
2016-09-14 10:00:00	AMZN	Stock	38.2518	38.375	38.2	38.2341	8433080.0
2016-09-14 11:00:00	AMZN	Stock	38.231	38.2625	38.1002	38.2035	5915080.0
2016-09-14 12:00:00	AMZN	Stock	38.211	38.3075	38.1687	38.2615	5521860.0
2016-09-14 13:00:00	AMZN	Stock	38.2435	38.2995	38.183	38.1875	3393460.0
2016-09-14 14:00:00	AMZN	Stock	38.1825	38.2185	38.076	38.1361	4173140.0
2016-09-14 15:00:00	AMZN	Stock	38.12	38.1295	37.9425	38.05	9049400.0

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

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