PREVIEW / stock_1hour / 2015-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-08.parquet
  size:    1.0 MB
  rows:    49,075
  symbols: 3,419

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
2015-12-08 04:00:00	AAPL	Stock	29.4875	29.5125	29.4075	29.475	27260.0
2015-12-08 05:00:00	AAPL	Stock	29.4675	29.4875	29.455	29.475	11600.0
2015-12-08 06:00:00	AAPL	Stock	29.475	29.475	29.425	29.425	10200.0
2015-12-08 07:00:00	AAPL	Stock	29.425	29.4275	29.305	29.32	101748.0
2015-12-08 08:00:00	AAPL	Stock	29.31	29.45	29.25	29.275	554168.0
2015-12-08 09:00:00	AAPL	Stock	29.2725	29.525	29.1925	29.2638	19896880.0
2015-12-08 10:00:00	AAPL	Stock	29.265	29.5425	29.215	29.5	26413076.0
2015-12-08 11:00:00	AAPL	Stock	29.4975	29.65	29.4275	29.475	17173556.0
2015-12-08 12:00:00	AAPL	Stock	29.475	29.48	29.34	29.458	10316808.0
2015-12-08 13:00:00	AAPL	Stock	29.4588	29.4975	29.3702	29.435	9181256.0
2015-12-08 14:00:00	AAPL	Stock	29.4325	29.54	29.41	29.4675	12775484.0
2015-12-08 15:00:00	AAPL	Stock	29.468	29.6275	29.4275	29.56	22317044.0
2015-12-08 16:00:00	AAPL	Stock	29.5575	29.575	29.4362	29.5575	10679256.0
2015-12-08 17:00:00	AAPL	Stock	29.55	29.5575	29.5375	29.545	18352.0
2015-12-08 18:00:00	AAPL	Stock	29.535	29.565	29.5275	29.565	23808.0
2015-12-08 19:00:00	AAPL	Stock	29.5875	29.625	29.585	29.6225	60384.0
2015-12-08 07:00:00	MSFT	Stock	55.57	55.6	55.32	55.32	8398.0
2015-12-08 08:00:00	MSFT	Stock	55.4	55.55	55.11	55.18	29538.0
2015-12-08 09:00:00	MSFT	Stock	55.13	55.7	54.99	55.375	5022929.0
2015-12-08 10:00:00	MSFT	Stock	55.38	55.62	55.195	55.54	4138354.0
2015-12-08 11:00:00	MSFT	Stock	55.54	55.82	55.47	55.745	4204844.0
2015-12-08 12:00:00	MSFT	Stock	55.745	55.76	55.5	55.75	2081096.0
2015-12-08 13:00:00	MSFT	Stock	55.76	55.936	55.71	55.935	2997691.0
2015-12-08 14:00:00	MSFT	Stock	55.93	56.1	55.87	55.97	3918361.0
2015-12-08 15:00:00	MSFT	Stock	55.97	56.01	55.69	55.79	6269296.0
2015-12-08 16:00:00	MSFT	Stock	55.79	55.87	55.75	55.79	2369774.0
2015-12-08 17:00:00	MSFT	Stock	55.79	55.86	55.78	55.78	96140.0
2015-12-08 18:00:00	MSFT	Stock	55.77	55.8	55.77	55.77	1650.0
2015-12-08 19:00:00	MSFT	Stock	55.87	55.87	55.87	55.87	2500.0
2015-12-08 07:00:00	NVDA	Stock	0.8288	0.8288	0.8288	0.8288	5760.0
2015-12-08 08:00:00	NVDA	Stock	0.8265	0.8265	0.8175	0.8225	110000.0
2015-12-08 09:00:00	NVDA	Stock	0.8182	0.8255	0.8123	0.825	30976680.0
2015-12-08 10:00:00	NVDA	Stock	0.825	0.8278	0.8178	0.8276	36463520.0
2015-12-08 11:00:00	NVDA	Stock	0.8278	0.8345	0.827	0.834	59437240.0
2015-12-08 12:00:00	NVDA	Stock	0.834	0.8372	0.8311	0.8372	21352200.0
2015-12-08 13:00:00	NVDA	Stock	0.8372	0.842	0.8352	0.8405	35380600.0
2015-12-08 14:00:00	NVDA	Stock	0.8402	0.8425	0.839	0.8402	27847680.0
2015-12-08 15:00:00	NVDA	Stock	0.84	0.8408	0.8377	0.8388	56981200.0
2015-12-08 16:00:00	NVDA	Stock	0.839	0.8392	0.839	0.8392	2055200.0
2015-12-08 17:00:00	NVDA	Stock	0.84	0.84	0.84	0.84	8000.0
2015-12-08 19:00:00	NVDA	Stock	0.837	0.837	0.837	0.837	8000.0
2015-12-08 04:00:00	AMZN	Stock	33.3555	33.3555	33.301	33.301	4000.0
2015-12-08 05:00:00	AMZN	Stock	33.4	33.4	33.4	33.4	2160.0
2015-12-08 06:00:00	AMZN	Stock	33.351	33.351	33.35	33.35	4300.0
2015-12-08 07:00:00	AMZN	Stock	33.35	33.35	33.25	33.25	22000.0
2015-12-08 08:00:00	AMZN	Stock	33.269	33.3	33.1	33.15	381840.0
2015-12-08 09:00:00	AMZN	Stock	33.1555	33.2985	32.9895	33.1413	9954440.0
2015-12-08 10:00:00	AMZN	Stock	33.1345	33.5555	33.1135	33.55	8814100.0
2015-12-08 11:00:00	AMZN	Stock	33.5545	33.725	33.508	33.693	8536600.0
2015-12-08 12:00:00	AMZN	Stock	33.6802	33.76	33.5685	33.7543	5006120.0

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

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