PREVIEW / stock_1hour / 2016-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-06.parquet
  size:    1.0 MB
  rows:    47,119
  symbols: 3,179

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-10-06 05:00:00	AAPL	Stock	28.255	28.255	28.255	28.255	400.0
2016-10-06 06:00:00	AAPL	Stock	28.2525	28.375	28.2525	28.375	5816.0
2016-10-06 07:00:00	AAPL	Stock	28.365	28.4575	28.365	28.435	70440.0
2016-10-06 08:00:00	AAPL	Stock	28.415	28.435	28.2	28.415	345936.0
2016-10-06 09:00:00	AAPL	Stock	28.405	28.5125	28.335	28.385	21072808.0
2016-10-06 10:00:00	AAPL	Stock	28.385	28.4425	28.2825	28.3798	16690868.0
2016-10-06 11:00:00	AAPL	Stock	28.3775	28.495	28.2825	28.4758	12992772.0
2016-10-06 12:00:00	AAPL	Stock	28.4775	28.569	28.4575	28.535	15974476.0
2016-10-06 13:00:00	AAPL	Stock	28.5325	28.5825	28.53	28.57	9747028.0
2016-10-06 14:00:00	AAPL	Stock	28.5675	28.585	28.5075	28.5338	9029604.0
2016-10-06 15:00:00	AAPL	Stock	28.5325	28.57	28.4675	28.4775	13836324.0
2016-10-06 16:00:00	AAPL	Stock	28.4725	28.5075	28.4175	28.4825	6254340.0
2016-10-06 17:00:00	AAPL	Stock	28.4825	28.4925	28.4725	28.4875	913504.0
2016-10-06 18:00:00	AAPL	Stock	28.4875	28.4875	28.475	28.4875	34520.0
2016-10-06 19:00:00	AAPL	Stock	28.475	28.485	28.4525	28.485	60072.0
2016-10-06 07:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	300.0
2016-10-06 08:00:00	MSFT	Stock	57.54	57.54	57.54	57.54	371.0
2016-10-06 09:00:00	MSFT	Stock	57.55	57.74	57.28	57.44	2275554.0
2016-10-06 10:00:00	MSFT	Stock	57.43	57.68	57.37	57.66	2298007.0
2016-10-06 11:00:00	MSFT	Stock	57.66	57.82	57.365	57.74	2365970.0
2016-10-06 12:00:00	MSFT	Stock	57.74	57.86	57.73	57.76	1170090.0
2016-10-06 13:00:00	MSFT	Stock	57.76	57.786	57.66	57.7	1285789.0
2016-10-06 14:00:00	MSFT	Stock	57.7	57.8	57.7	57.8	1194141.0
2016-10-06 15:00:00	MSFT	Stock	57.8	57.84	57.7	57.74	2787791.0
2016-10-06 16:00:00	MSFT	Stock	57.74	57.75	57.604	57.74	1952986.0
2016-10-06 19:00:00	MSFT	Stock	57.74	57.74	57.74	57.74	5300.0
2016-10-06 05:00:00	NVDA	Stock	1.6748	1.6748	1.6748	1.6748	10000.0
2016-10-06 06:00:00	NVDA	Stock	1.678	1.678	1.636	1.636	246640.0
2016-10-06 07:00:00	NVDA	Stock	1.6435	1.6745	1.6428	1.6588	181920.0
2016-10-06 08:00:00	NVDA	Stock	1.6628	1.6812	1.62	1.6812	1056160.0
2016-10-06 09:00:00	NVDA	Stock	1.6812	1.6958	1.6565	1.68	71890640.0
2016-10-06 10:00:00	NVDA	Stock	1.6802	1.6845	1.6678	1.6823	62048280.0
2016-10-06 11:00:00	NVDA	Stock	1.6823	1.6895	1.6738	1.6863	41930680.0
2016-10-06 12:00:00	NVDA	Stock	1.6863	1.6892	1.6802	1.6812	19245280.0
2016-10-06 13:00:00	NVDA	Stock	1.681	1.682	1.6648	1.672	33843800.0
2016-10-06 14:00:00	NVDA	Stock	1.6716	1.6838	1.671	1.682	31215600.0
2016-10-06 15:00:00	NVDA	Stock	1.6818	1.6855	1.6775	1.6835	52781480.0
2016-10-06 16:00:00	NVDA	Stock	1.6835	1.6848	1.682	1.6835	12062880.0
2016-10-06 17:00:00	NVDA	Stock	1.6825	1.6835	1.6825	1.6835	22000.0
2016-10-06 18:00:00	NVDA	Stock	1.6838	1.6872	1.6838	1.6852	151000.0
2016-10-06 19:00:00	NVDA	Stock	1.687	1.687	1.6863	1.6863	387800.0
2016-10-06 04:00:00	AMZN	Stock	42.273	42.273	42.267	42.267	5760.0
2016-10-06 05:00:00	AMZN	Stock	42.264	42.2645	42.264	42.2645	13900.0
2016-10-06 06:00:00	AMZN	Stock	42.2385	42.2385	42.175	42.175	10180.0
2016-10-06 07:00:00	AMZN	Stock	42.141	42.1675	42.0615	42.123	46000.0
2016-10-06 08:00:00	AMZN	Stock	42.175	42.175	42.069	42.137	150180.0
2016-10-06 09:00:00	AMZN	Stock	42.135	42.3	42.03	42.2945	9843920.0
2016-10-06 10:00:00	AMZN	Stock	42.2815	42.3605	42.1335	42.2162	9396100.0
2016-10-06 11:00:00	AMZN	Stock	42.2165	42.3145	42.061	42.267	6891600.0
2016-10-06 12:00:00	AMZN	Stock	42.27	42.315	42.1835	42.245	3193140.0

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

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