PREVIEW / stock_1hour / 2016-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-24.parquet
  size:    1.0 MB
  rows:    48,042
  symbols: 3,267

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-24 04:00:00	AAPL	Stock	27.235	27.235	27.235	27.235	824.0
2016-08-24 06:00:00	AAPL	Stock	27.23	27.2425	27.2125	27.2125	1600.0
2016-08-24 07:00:00	AAPL	Stock	27.215	27.245	27.205	27.2225	8060.0
2016-08-24 08:00:00	AAPL	Stock	27.215	27.2425	27.215	27.2325	30168.0
2016-08-24 09:00:00	AAPL	Stock	27.23	27.24	27.03	27.066	13133116.0
2016-08-24 10:00:00	AAPL	Stock	27.0675	27.0975	27.0	27.0325	12988044.0
2016-08-24 11:00:00	AAPL	Stock	27.035	27.065	26.9812	27.0062	10412196.0
2016-08-24 12:00:00	AAPL	Stock	27.0075	27.075	26.9825	27.0725	8563604.0
2016-08-24 13:00:00	AAPL	Stock	27.072	27.1	27.0525	27.0725	5348108.0
2016-08-24 14:00:00	AAPL	Stock	27.0725	27.0725	26.9975	27.06	8268064.0
2016-08-24 15:00:00	AAPL	Stock	27.06	27.08	26.92	27.01	19544904.0
2016-08-24 16:00:00	AAPL	Stock	27.01	27.015	26.975	26.98	6588348.0
2016-08-24 17:00:00	AAPL	Stock	26.98	26.985	26.965	26.9775	33892.0
2016-08-24 18:00:00	AAPL	Stock	26.975	27.0075	26.9625	26.965	117176.0
2016-08-24 19:00:00	AAPL	Stock	26.965	26.975	26.9625	26.975	18628.0
2016-08-24 06:00:00	MSFT	Stock	57.91	57.91	57.91	57.91	309.0
2016-08-24 07:00:00	MSFT	Stock	57.95	58.0	57.95	58.0	211.0
2016-08-24 08:00:00	MSFT	Stock	57.95	58.0	57.9	58.0	5100.0
2016-08-24 09:00:00	MSFT	Stock	58.0	58.03	57.715	57.8	1935006.0
2016-08-24 10:00:00	MSFT	Stock	57.809	57.95	57.76	57.825	2046993.0
2016-08-24 11:00:00	MSFT	Stock	57.83	57.96	57.81	57.88	1500593.0
2016-08-24 12:00:00	MSFT	Stock	57.88	58.04	57.88	58.02	1453964.0
2016-08-24 13:00:00	MSFT	Stock	58.02	58.02	57.93	57.94	1328669.0
2016-08-24 14:00:00	MSFT	Stock	57.946	57.97	57.82	57.97	1725239.0
2016-08-24 15:00:00	MSFT	Stock	57.97	57.97	57.75	57.97	3709191.0
2016-08-24 16:00:00	MSFT	Stock	57.95	57.95	57.9	57.95	2199272.0
2016-08-24 06:00:00	NVDA	Stock	1.5792	1.5792	1.5792	1.5792	4000.0
2016-08-24 07:00:00	NVDA	Stock	1.5783	1.5785	1.5755	1.5755	79520.0
2016-08-24 08:00:00	NVDA	Stock	1.5775	1.5775	1.5732	1.5732	342080.0
2016-08-24 09:00:00	NVDA	Stock	1.577	1.5805	1.5688	1.571	36146560.0
2016-08-24 10:00:00	NVDA	Stock	1.571	1.5715	1.5572	1.5596	54622480.0
2016-08-24 11:00:00	NVDA	Stock	1.5598	1.57	1.5596	1.5645	35240960.0
2016-08-24 12:00:00	NVDA	Stock	1.5645	1.5685	1.5632	1.5668	19004040.0
2016-08-24 13:00:00	NVDA	Stock	1.5666	1.5682	1.5625	1.5629	18495120.0
2016-08-24 14:00:00	NVDA	Stock	1.5628	1.563	1.555	1.5569	39912240.0
2016-08-24 15:00:00	NVDA	Stock	1.5568	1.5572	1.5412	1.5485	79563320.0
2016-08-24 16:00:00	NVDA	Stock	1.5485	1.5518	1.5485	1.5488	6456520.0
2016-08-24 17:00:00	NVDA	Stock	1.5475	1.5475	1.5465	1.5465	24000.0
2016-08-24 18:00:00	NVDA	Stock	1.5495	1.5495	1.5463	1.5463	60000.0
2016-08-24 19:00:00	NVDA	Stock	1.55	1.5525	1.55	1.5515	101880.0
2016-08-24 08:00:00	AMZN	Stock	38.1705	38.184	38.149	38.1745	61340.0
2016-08-24 09:00:00	AMZN	Stock	38.192	38.192	38.041	38.055	2919560.0
2016-08-24 10:00:00	AMZN	Stock	38.0587	38.087	37.962	37.9788	3627840.0
2016-08-24 11:00:00	AMZN	Stock	37.983	38.05	37.9545	37.979	2796920.0
2016-08-24 12:00:00	AMZN	Stock	37.9845	38.033	37.9346	38.0	2463280.0
2016-08-24 13:00:00	AMZN	Stock	38.009	38.0095	37.945	37.9885	1843240.0
2016-08-24 14:00:00	AMZN	Stock	37.9875	38.0	37.888	37.9685	3777160.0
2016-08-24 15:00:00	AMZN	Stock	37.9555	37.9695	37.768	37.8775	8742320.0
2016-08-24 16:00:00	AMZN	Stock	37.8625	38.0054	37.818	37.8625	198480.0
2016-08-24 17:00:00	AMZN	Stock	37.8425	37.8535	37.8425	37.8535	26740.0

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

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