PREVIEW / stock_1hour / 2016-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-12.parquet
  size:    1.1 MB
  rows:    49,448
  symbols: 3,239

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-12 04:00:00	AAPL	Stock	25.5025	25.5625	25.4775	25.51	72832.0
2016-09-12 05:00:00	AAPL	Stock	25.55	25.575	25.5	25.5	17668.0
2016-09-12 06:00:00	AAPL	Stock	25.5025	25.5025	25.455	25.49	54364.0
2016-09-12 07:00:00	AAPL	Stock	25.4925	25.645	25.4925	25.6375	203156.0
2016-09-12 08:00:00	AAPL	Stock	25.6375	25.7375	25.45	25.6925	594704.0
2016-09-12 09:00:00	AAPL	Stock	25.6925	26.075	25.6325	26.0588	33110296.0
2016-09-12 10:00:00	AAPL	Stock	26.058	26.1812	26.0478	26.15	25658712.0
2016-09-12 11:00:00	AAPL	Stock	26.15	26.25	26.125	26.1338	16554824.0
2016-09-12 12:00:00	AAPL	Stock	26.1338	26.225	26.085	26.19	12629732.0
2016-09-12 13:00:00	AAPL	Stock	26.19	26.2525	26.0575	26.24	18632576.0
2016-09-12 14:00:00	AAPL	Stock	26.2375	26.375	26.2278	26.365	16467148.0
2016-09-12 15:00:00	AAPL	Stock	26.3675	26.43	26.325	26.36	28619376.0
2016-09-12 16:00:00	AAPL	Stock	26.3625	26.4025	26.1635	26.365	14390900.0
2016-09-12 17:00:00	AAPL	Stock	26.3625	26.405	26.3625	26.4	174496.0
2016-09-12 18:00:00	AAPL	Stock	26.4	26.4375	26.36	26.4325	343956.0
2016-09-12 19:00:00	AAPL	Stock	26.425	26.45	26.42	26.4275	132264.0
2016-09-12 04:00:00	MSFT	Stock	55.8	55.86	55.42	55.86	400.0
2016-09-12 07:00:00	MSFT	Stock	55.72	55.9	55.72	55.9	5911.0
2016-09-12 08:00:00	MSFT	Stock	55.85	56.09	55.7	56.09	17756.0
2016-09-12 09:00:00	MSFT	Stock	56.0	56.24	55.61	56.17	3558161.0
2016-09-12 10:00:00	MSFT	Stock	56.17	56.5	56.11	56.395	3004720.0
2016-09-12 11:00:00	MSFT	Stock	56.395	56.52	56.27	56.435	2567366.0
2016-09-12 12:00:00	MSFT	Stock	56.435	56.7	56.35	56.655	2408842.0
2016-09-12 13:00:00	MSFT	Stock	56.66	57.0	56.535	56.97	3492205.0
2016-09-12 14:00:00	MSFT	Stock	56.96	57.165	56.94	57.057	2709694.0
2016-09-12 15:00:00	MSFT	Stock	57.05	57.205	56.94	57.05	5640585.0
2016-09-12 16:00:00	MSFT	Stock	57.05	57.1	57.05	57.05	3857811.0
2016-09-12 17:00:00	MSFT	Stock	56.649	57.08	56.649	57.05	1482.0
2016-09-12 18:00:00	MSFT	Stock	57.05	57.05	57.05	57.05	26404.0
2016-09-12 04:00:00	NVDA	Stock	1.48	1.48	1.475	1.4775	140000.0
2016-09-12 07:00:00	NVDA	Stock	1.4682	1.47	1.4638	1.4658	230240.0
2016-09-12 08:00:00	NVDA	Stock	1.47	1.4762	1.4655	1.4725	1345360.0
2016-09-12 09:00:00	NVDA	Stock	1.47	1.485	1.4329	1.482	137179520.0
2016-09-12 10:00:00	NVDA	Stock	1.4821	1.497	1.481	1.4938	90951480.0
2016-09-12 11:00:00	NVDA	Stock	1.4935	1.5018	1.4916	1.4942	60349440.0
2016-09-12 12:00:00	NVDA	Stock	1.4945	1.5055	1.4888	1.5055	47141760.0
2016-09-12 13:00:00	NVDA	Stock	1.5053	1.514	1.5	1.51	46310640.0
2016-09-12 14:00:00	NVDA	Stock	1.5098	1.5216	1.5089	1.5193	50979320.0
2016-09-12 15:00:00	NVDA	Stock	1.5195	1.5215	1.5152	1.5188	116237880.0
2016-09-12 16:00:00	NVDA	Stock	1.5188	1.5213	1.5188	1.5208	2423920.0
2016-09-12 17:00:00	NVDA	Stock	1.5218	1.5218	1.5188	1.5188	420000.0
2016-09-12 18:00:00	NVDA	Stock	1.5188	1.525	1.5175	1.525	147880.0
2016-09-12 19:00:00	NVDA	Stock	1.5218	1.5218	1.5218	1.5218	144720.0
2016-09-12 04:00:00	AMZN	Stock	37.65	37.674	37.65	37.674	21960.0
2016-09-12 06:00:00	AMZN	Stock	37.65	37.65	37.65	37.65	2000.0
2016-09-12 07:00:00	AMZN	Stock	37.7	37.7625	37.6915	37.7625	53840.0
2016-09-12 08:00:00	AMZN	Stock	37.752	37.9	37.5925	37.85	274520.0
2016-09-12 09:00:00	AMZN	Stock	37.8745	38.3285	37.8	38.16	13454300.0
2016-09-12 10:00:00	AMZN	Stock	38.1745	38.3585	38.005	38.3405	11018020.0
2016-09-12 11:00:00	AMZN	Stock	38.3445	38.495	38.296	38.395	6979400.0

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

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