PREVIEW / stock_1hour / 2016-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-16.parquet
  size:    1.0 MB
  rows:    48,926
  symbols: 3,231

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-16 04:00:00	AAPL	Stock	28.8325	28.8375	28.7575	28.8125	16892.0
2016-09-16 05:00:00	AAPL	Stock	28.7675	28.8025	28.7675	28.8	51856.0
2016-09-16 06:00:00	AAPL	Stock	28.8125	28.945	28.8025	28.8425	127496.0
2016-09-16 07:00:00	AAPL	Stock	28.8925	28.99	28.6875	28.7375	498128.0
2016-09-16 08:00:00	AAPL	Stock	28.8875	28.9875	28.6875	28.7625	1307316.0
2016-09-16 09:00:00	AAPL	Stock	28.77	29.0325	28.7	28.7562	86931712.0
2016-09-16 10:00:00	AAPL	Stock	28.755	28.8475	28.6925	28.745	39531360.0
2016-09-16 11:00:00	AAPL	Stock	28.75	28.7775	28.6662	28.7025	22225416.0
2016-09-16 12:00:00	AAPL	Stock	28.7025	28.7325	28.5125	28.5765	23040352.0
2016-09-16 13:00:00	AAPL	Stock	28.5755	28.6575	28.51	28.585	19166724.0
2016-09-16 14:00:00	AAPL	Stock	28.5825	28.7612	28.5525	28.69	21757576.0
2016-09-16 15:00:00	AAPL	Stock	28.688	28.78	28.6875	28.7275	29589296.0
2016-09-16 16:00:00	AAPL	Stock	28.7275	28.768	28.579	28.755	52628708.0
2016-09-16 17:00:00	AAPL	Stock	28.755	28.755	28.725	28.73	161700.0
2016-09-16 18:00:00	AAPL	Stock	28.73	28.7375	28.72	28.735	252552.0
2016-09-16 19:00:00	AAPL	Stock	28.73	28.7375	28.7275	28.735	105004.0
2016-09-16 06:00:00	MSFT	Stock	57.19	57.19	57.19	57.19	100.0
2016-09-16 07:00:00	MSFT	Stock	56.78	56.78	56.78	56.78	100.0
2016-09-16 08:00:00	MSFT	Stock	57.02	57.03	57.02	57.02	2860.0
2016-09-16 09:00:00	MSFT	Stock	57.09	57.8	56.75	57.29	16850949.0
2016-09-16 10:00:00	MSFT	Stock	57.29	57.33	57.035	57.195	3700919.0
2016-09-16 11:00:00	MSFT	Stock	57.19	57.22	57.04	57.12	2083888.0
2016-09-16 12:00:00	MSFT	Stock	57.12	57.23	57.05	57.05	1334052.0
2016-09-16 13:00:00	MSFT	Stock	57.05	57.136	57.01	57.095	1704750.0
2016-09-16 14:00:00	MSFT	Stock	57.09	57.185	57.04	57.055	1499623.0
2016-09-16 15:00:00	MSFT	Stock	57.06	57.31	57.045	57.24	5005826.0
2016-09-16 16:00:00	MSFT	Stock	57.26	57.33	57.25	57.25	9448708.0
2016-09-16 17:00:00	MSFT	Stock	57.29	57.29	57.29	57.29	450.0
2016-09-16 18:00:00	MSFT	Stock	57.32	57.32	57.32	57.32	700.0
2016-09-16 19:00:00	MSFT	Stock	57.29	57.31	57.29	57.31	2300.0
2016-09-16 05:00:00	NVDA	Stock	1.5605	1.5605	1.5605	1.5605	7520.0
2016-09-16 06:00:00	NVDA	Stock	1.555	1.555	1.555	1.555	16000.0
2016-09-16 07:00:00	NVDA	Stock	1.555	1.5592	1.555	1.5592	12000.0
2016-09-16 08:00:00	NVDA	Stock	1.5675	1.5675	1.5568	1.5625	88400.0
2016-09-16 09:00:00	NVDA	Stock	1.5625	1.5875	1.5583	1.5602	100097640.0
2016-09-16 10:00:00	NVDA	Stock	1.5602	1.5732	1.553	1.5678	74065400.0
2016-09-16 11:00:00	NVDA	Stock	1.568	1.5691	1.564	1.5645	33345400.0
2016-09-16 12:00:00	NVDA	Stock	1.5646	1.5731	1.5625	1.565	44874880.0
2016-09-16 13:00:00	NVDA	Stock	1.5648	1.5668	1.5594	1.5665	26296080.0
2016-09-16 14:00:00	NVDA	Stock	1.5663	1.5755	1.5634	1.5711	49213880.0
2016-09-16 15:00:00	NVDA	Stock	1.5712	1.5812	1.565	1.5712	170115880.0
2016-09-16 16:00:00	NVDA	Stock	1.5728	1.5738	1.5708	1.5738	47236360.0
2016-09-16 17:00:00	NVDA	Stock	1.5718	1.5738	1.5708	1.5738	48000.0
2016-09-16 18:00:00	NVDA	Stock	1.5798	1.5798	1.5738	1.5738	48000.0
2016-09-16 04:00:00	AMZN	Stock	38.484	38.4955	38.4735	38.4955	57000.0
2016-09-16 05:00:00	AMZN	Stock	38.4795	38.4795	38.4795	38.4795	4000.0
2016-09-16 06:00:00	AMZN	Stock	38.4845	38.5275	38.4715	38.525	39400.0
2016-09-16 07:00:00	AMZN	Stock	38.51	38.55	38.504	38.517	48600.0
2016-09-16 08:00:00	AMZN	Stock	38.55	38.689	38.4925	38.6715	381200.0
2016-09-16 09:00:00	AMZN	Stock	38.682	38.95	38.583	38.918	24987860.0

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

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