PREVIEW / stock_1hour / 2016-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-03.parquet
  size:    1.0 MB
  rows:    48,377
  symbols: 3,371

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-02-03 04:00:00	AAPL	Stock	23.73	23.75	23.7125	23.7125	8360.0
2016-02-03 05:00:00	AAPL	Stock	23.66	23.68	23.6375	23.6575	18800.0
2016-02-03 06:00:00	AAPL	Stock	23.775	23.7925	23.75	23.75	4908.0
2016-02-03 07:00:00	AAPL	Stock	23.785	23.825	23.71	23.71	60036.0
2016-02-03 08:00:00	AAPL	Stock	23.7175	23.825	23.6925	23.77	397524.0
2016-02-03 09:00:00	AAPL	Stock	23.765	23.91	23.715	23.7925	16130532.0
2016-02-03 10:00:00	AAPL	Stock	23.7925	23.7975	23.52	23.6262	29879216.0
2016-02-03 11:00:00	AAPL	Stock	23.6275	23.7925	23.5475	23.675	21753840.0
2016-02-03 12:00:00	AAPL	Stock	23.6775	23.7275	23.575	23.6938	13037096.0
2016-02-03 13:00:00	AAPL	Stock	23.6925	23.75	23.6025	23.61	11554600.0
2016-02-03 14:00:00	AAPL	Stock	23.6088	24.1375	23.6088	24.13	28208292.0
2016-02-03 15:00:00	AAPL	Stock	24.1305	24.21	24.015	24.085	35978528.0
2016-02-03 16:00:00	AAPL	Stock	24.0875	24.11	23.62	24.065	10324228.0
2016-02-03 17:00:00	AAPL	Stock	24.0675	24.075	23.9525	23.9775	162192.0
2016-02-03 18:00:00	AAPL	Stock	23.98	24.025	23.96	24.0025	133076.0
2016-02-03 19:00:00	AAPL	Stock	23.9875	24.035	23.9875	24.0075	105008.0
2016-02-03 05:00:00	MSFT	Stock	53.0	53.0	53.0	53.0	200.0
2016-02-03 06:00:00	MSFT	Stock	52.97	52.98	52.97	52.98	4245.0
2016-02-03 07:00:00	MSFT	Stock	53.15	53.16	53.04	53.05	4200.0
2016-02-03 08:00:00	MSFT	Stock	53.17	53.28	52.95	53.28	28949.0
2016-02-03 09:00:00	MSFT	Stock	53.27	53.39	53.0	53.2	5262736.0
2016-02-03 10:00:00	MSFT	Stock	53.19	53.195	52.07	52.425	8012065.0
2016-02-03 11:00:00	MSFT	Stock	52.43	52.44	51.76	51.94	8165476.0
2016-02-03 12:00:00	MSFT	Stock	51.944	52.085	51.36	51.605	4674852.0
2016-02-03 13:00:00	MSFT	Stock	51.6	51.74	51.26	51.29	4331782.0
2016-02-03 14:00:00	MSFT	Stock	51.28	52.429	51.28	52.28	10309156.0
2016-02-03 15:00:00	MSFT	Stock	52.28	52.53	51.96	52.17	10731824.0
2016-02-03 16:00:00	MSFT	Stock	52.15	52.16	51.93	52.09	2953144.0
2016-02-03 17:00:00	MSFT	Stock	52.09	52.09	52.01	52.03	4488.0
2016-02-03 18:00:00	MSFT	Stock	52.12	52.17	52.11	52.17	22833.0
2016-02-03 19:00:00	MSFT	Stock	52.14	52.16	52.06	52.06	1970.0
2016-02-03 08:00:00	NVDA	Stock	0.7049	0.7049	0.7038	0.7038	44520.0
2016-02-03 09:00:00	NVDA	Stock	0.7088	0.7113	0.7015	0.7075	20087240.0
2016-02-03 10:00:00	NVDA	Stock	0.7075	0.7075	0.6901	0.695	74535680.0
2016-02-03 11:00:00	NVDA	Stock	0.695	0.698	0.6888	0.6951	30096520.0
2016-02-03 12:00:00	NVDA	Stock	0.6952	0.7	0.6946	0.6983	27849240.0
2016-02-03 13:00:00	NVDA	Stock	0.6982	0.7	0.693	0.693	38925920.0
2016-02-03 14:00:00	NVDA	Stock	0.6932	0.7078	0.6932	0.7066	35478160.0
2016-02-03 15:00:00	NVDA	Stock	0.7068	0.7085	0.7014	0.7048	64669480.0
2016-02-03 16:00:00	NVDA	Stock	0.705	0.705	0.6996	0.6996	15831640.0
2016-02-03 06:00:00	AMZN	Stock	27.6	27.6045	27.6	27.6045	18700.0
2016-02-03 07:00:00	AMZN	Stock	27.6865	27.799	27.6865	27.747	53280.0
2016-02-03 08:00:00	AMZN	Stock	27.61	27.9125	27.61	27.826	156200.0
2016-02-03 09:00:00	AMZN	Stock	27.849	27.875	26.6955	26.7819	31577740.0
2016-02-03 10:00:00	AMZN	Stock	26.7815	26.817	26.1557	26.792	54011680.0
2016-02-03 11:00:00	AMZN	Stock	26.7825	26.96	26.4075	26.8175	19250540.0
2016-02-03 12:00:00	AMZN	Stock	26.8405	26.9435	26.4	26.5603	12611820.0
2016-02-03 13:00:00	AMZN	Stock	26.6	26.641	26.095	26.1252	13694780.0
2016-02-03 14:00:00	AMZN	Stock	26.113	26.787	26.113	26.7795	20339540.0
2016-02-03 15:00:00	AMZN	Stock	26.7624	26.848	26.5025	26.5395	21252720.0

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

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