PREVIEW / stock_1hour / 2016-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-08.parquet
  size:    1.0 MB
  rows:    49,199
  symbols: 3,367

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-08 04:00:00	AAPL	Stock	23.4525	23.4525	23.1625	23.1625	23220.0
2016-02-08 05:00:00	AAPL	Stock	23.0825	23.1575	23.0825	23.105	44828.0
2016-02-08 06:00:00	AAPL	Stock	23.08	23.1375	23.0325	23.0975	51188.0
2016-02-08 07:00:00	AAPL	Stock	23.08	23.1	23.0125	23.07	275836.0
2016-02-08 08:00:00	AAPL	Stock	23.0775	23.2375	23.0325	23.2225	638476.0
2016-02-08 09:00:00	AAPL	Stock	23.2225	23.67	23.15	23.645	31264260.0
2016-02-08 10:00:00	AAPL	Stock	23.64	23.6875	23.3625	23.495	32808564.0
2016-02-08 11:00:00	AAPL	Stock	23.4975	23.621	23.37	23.621	23181932.0
2016-02-08 12:00:00	AAPL	Stock	23.62	23.6975	23.52	23.56	18296708.0
2016-02-08 13:00:00	AAPL	Stock	23.5588	23.572	23.4325	23.45	16451436.0
2016-02-08 14:00:00	AAPL	Stock	23.4475	23.4975	23.3425	23.4025	22614600.0
2016-02-08 15:00:00	AAPL	Stock	23.4025	23.925	23.3925	23.7525	43368884.0
2016-02-08 16:00:00	AAPL	Stock	23.7525	23.835	23.463	23.7925	11365736.0
2016-02-08 17:00:00	AAPL	Stock	23.795	23.795	23.68	23.7375	367160.0
2016-02-08 18:00:00	AAPL	Stock	23.69	23.73	23.6675	23.68	62124.0
2016-02-08 19:00:00	AAPL	Stock	23.68	23.7	23.6625	23.6625	40012.0
2016-02-08 04:00:00	MSFT	Stock	50.11	50.11	49.5	49.5	4258.0
2016-02-08 05:00:00	MSFT	Stock	49.56	49.56	49.5	49.5	1000.0
2016-02-08 06:00:00	MSFT	Stock	49.25	49.51	49.25	49.41	6308.0
2016-02-08 07:00:00	MSFT	Stock	49.4	49.4	49.09	49.25	75421.0
2016-02-08 08:00:00	MSFT	Stock	49.25	49.44	49.1	49.44	57671.0
2016-02-08 09:00:00	MSFT	Stock	49.44	50.16	48.19	48.63	9384507.0
2016-02-08 10:00:00	MSFT	Stock	48.625	49.19	48.45	48.8	10539488.0
2016-02-08 11:00:00	MSFT	Stock	48.81	49.0	48.5	48.99	4501762.0
2016-02-08 12:00:00	MSFT	Stock	48.99	49.26	48.82	49.12	5436715.0
2016-02-08 13:00:00	MSFT	Stock	49.11	49.195	48.54	48.61	4042575.0
2016-02-08 14:00:00	MSFT	Stock	48.6	48.71	48.26	48.43	5841195.0
2016-02-08 15:00:00	MSFT	Stock	48.43	49.47	48.315	49.39	12744901.0
2016-02-08 16:00:00	MSFT	Stock	49.41	49.54	49.41	49.5	3178446.0
2016-02-08 17:00:00	MSFT	Stock	49.5	49.5	49.27	49.5	904686.0
2016-02-08 18:00:00	MSFT	Stock	49.42	49.42	49.26	49.35	995.0
2016-02-08 19:00:00	MSFT	Stock	49.35	49.43	49.24	49.31	6850.0
2016-02-08 05:00:00	NVDA	Stock	0.653	0.653	0.653	0.653	20000.0
2016-02-08 08:00:00	NVDA	Stock	0.6555	0.6555	0.6388	0.6488	151360.0
2016-02-08 09:00:00	NVDA	Stock	0.6505	0.6548	0.639	0.6435	58896960.0
2016-02-08 10:00:00	NVDA	Stock	0.6433	0.645	0.6348	0.635	104593320.0
2016-02-08 11:00:00	NVDA	Stock	0.6349	0.6365	0.6293	0.6348	70698000.0
2016-02-08 12:00:00	NVDA	Stock	0.6348	0.637	0.6315	0.6359	41302520.0
2016-02-08 13:00:00	NVDA	Stock	0.6359	0.6365	0.6263	0.6268	51981600.0
2016-02-08 14:00:00	NVDA	Stock	0.6268	0.631	0.6213	0.623	79050240.0
2016-02-08 15:00:00	NVDA	Stock	0.623	0.6345	0.6214	0.6303	154779800.0
2016-02-08 16:00:00	NVDA	Stock	0.63	0.6385	0.6288	0.6288	20697120.0
2016-02-08 18:00:00	NVDA	Stock	0.6305	0.6305	0.6305	0.6305	12800.0
2016-02-08 19:00:00	NVDA	Stock	0.6313	0.6313	0.6313	0.6313	12000.0
2016-02-08 04:00:00	AMZN	Stock	24.751	24.8	24.675	24.675	16180.0
2016-02-08 05:00:00	AMZN	Stock	24.5255	24.5355	24.4675	24.5005	21540.0
2016-02-08 06:00:00	AMZN	Stock	24.55	24.55	24.4075	24.4075	49600.0
2016-02-08 07:00:00	AMZN	Stock	24.4	24.4	24.1	24.225	296540.0
2016-02-08 08:00:00	AMZN	Stock	24.2055	24.3975	24.0625	24.35	919860.0
2016-02-08 09:00:00	AMZN	Stock	24.34	24.675	23.842	24.453	46859600.0

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

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