PREVIEW / stock_1hour / 2016-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-29.parquet
  size:    1.0 MB
  rows:    47,778
  symbols: 3,212

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-29 04:00:00	AAPL	Stock	28.4625	28.4625	28.4	28.4	5260.0
2016-09-29 05:00:00	AAPL	Stock	28.3875	28.3875	28.3625	28.375	3304.0
2016-09-29 06:00:00	AAPL	Stock	28.4125	28.4125	28.275	28.2875	73552.0
2016-09-29 07:00:00	AAPL	Stock	28.2775	28.33	28.2525	28.32	184116.0
2016-09-29 08:00:00	AAPL	Stock	28.335	28.425	28.28	28.315	511212.0
2016-09-29 09:00:00	AAPL	Stock	28.3275	28.45	28.255	28.285	13746188.0
2016-09-29 10:00:00	AAPL	Stock	28.2825	28.3	28.11	28.1135	29103440.0
2016-09-29 11:00:00	AAPL	Stock	28.115	28.1725	28.05	28.1548	15521728.0
2016-09-29 12:00:00	AAPL	Stock	28.155	28.26	28.0375	28.0925	15669268.0
2016-09-29 13:00:00	AAPL	Stock	28.09	28.09	27.95	28.0	18039804.0
2016-09-29 14:00:00	AAPL	Stock	28.0	28.1	27.9775	28.045	14604648.0
2016-09-29 15:00:00	AAPL	Stock	28.0425	28.1525	28.025	28.045	21619428.0
2016-09-29 16:00:00	AAPL	Stock	28.045	28.195	28.04	28.0575	6072672.0
2016-09-29 17:00:00	AAPL	Stock	28.065	28.065	28.05	28.05	62632.0
2016-09-29 18:00:00	AAPL	Stock	28.0525	28.0525	28.035	28.0375	49344.0
2016-09-29 19:00:00	AAPL	Stock	28.045	28.0525	28.035	28.0475	30380.0
2016-09-29 07:00:00	MSFT	Stock	58.0	58.0	57.97	57.97	200.0
2016-09-29 08:00:00	MSFT	Stock	57.98	57.98	57.96	57.96	700.0
2016-09-29 09:00:00	MSFT	Stock	57.94	58.12	57.81	58.07	2031383.0
2016-09-29 10:00:00	MSFT	Stock	58.08	58.168	57.81	57.965	3188442.0
2016-09-29 11:00:00	MSFT	Stock	57.965	58.07	57.92	58.0	2339653.0
2016-09-29 12:00:00	MSFT	Stock	57.995	58.09	57.42	57.48	3075371.0
2016-09-29 13:00:00	MSFT	Stock	57.47	57.52	57.21	57.32	4227140.0
2016-09-29 14:00:00	MSFT	Stock	57.32	57.73	57.22	57.62	2467104.0
2016-09-29 15:00:00	MSFT	Stock	57.62	57.69	57.39	57.4	4495264.0
2016-09-29 16:00:00	MSFT	Stock	57.4	57.8	57.39	57.4	2257131.0
2016-09-29 17:00:00	MSFT	Stock	57.46	57.5	57.46	57.46	3899.0
2016-09-29 18:00:00	MSFT	Stock	57.46	57.46	57.4	57.46	57426.0
2016-09-29 19:00:00	MSFT	Stock	57.46	57.46	57.46	57.46	1100.0
2016-09-29 06:00:00	NVDA	Stock	1.675	1.675	1.6665	1.6665	10000.0
2016-09-29 08:00:00	NVDA	Stock	1.665	1.675	1.665	1.67	183040.0
2016-09-29 09:00:00	NVDA	Stock	1.674	1.678	1.6575	1.6735	36769400.0
2016-09-29 10:00:00	NVDA	Stock	1.673	1.6765	1.664	1.6692	39402320.0
2016-09-29 11:00:00	NVDA	Stock	1.669	1.6709	1.6625	1.666	27986440.0
2016-09-29 12:00:00	NVDA	Stock	1.6663	1.668	1.654	1.6567	38926280.0
2016-09-29 13:00:00	NVDA	Stock	1.6562	1.6868	1.6513	1.6725	67475000.0
2016-09-29 14:00:00	NVDA	Stock	1.6728	1.6902	1.6718	1.6858	35627560.0
2016-09-29 15:00:00	NVDA	Stock	1.6855	1.689	1.6802	1.6852	50371360.0
2016-09-29 16:00:00	NVDA	Stock	1.6858	1.688	1.685	1.688	745440.0
2016-09-29 17:00:00	NVDA	Stock	1.688	1.688	1.6863	1.688	86680.0
2016-09-29 18:00:00	NVDA	Stock	1.685	1.6858	1.685	1.6858	82800.0
2016-09-29 19:00:00	NVDA	Stock	1.685	1.6858	1.685	1.6858	16000.0
2016-09-29 04:00:00	AMZN	Stock	41.45	41.5975	41.45	41.5975	6000.0
2016-09-29 06:00:00	AMZN	Stock	41.57	41.57	41.5	41.5	14140.0
2016-09-29 07:00:00	AMZN	Stock	41.544	41.5445	41.5	41.5	23460.0
2016-09-29 08:00:00	AMZN	Stock	41.5062	41.5062	41.35	41.425	144300.0
2016-09-29 09:00:00	AMZN	Stock	41.426	41.8362	41.4115	41.791	17823640.0
2016-09-29 10:00:00	AMZN	Stock	41.776	41.875	41.562	41.596	16260460.0
2016-09-29 11:00:00	AMZN	Stock	41.5935	41.6469	41.4003	41.5462	11929180.0
2016-09-29 12:00:00	AMZN	Stock	41.5425	41.6695	41.3	41.3785	12289880.0

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

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