PREVIEW / stock_1hour / 2017-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-23.parquet
  size:    1.0 MB
  rows:    48,237
  symbols: 3,086

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
2017-02-23 05:00:00	AAPL	Stock	34.29	34.3175	34.29	34.3175	4204.0
2017-02-23 06:00:00	AAPL	Stock	34.29	34.3	34.2875	34.2875	2644.0
2017-02-23 07:00:00	AAPL	Stock	34.3375	34.3425	34.32	34.32	35184.0
2017-02-23 08:00:00	AAPL	Stock	34.3175	34.3425	34.3	34.3075	184328.0
2017-02-23 09:00:00	AAPL	Stock	34.3075	34.375	34.1725	34.2675	13883008.0
2017-02-23 10:00:00	AAPL	Stock	34.2688	34.2975	34.0925	34.0975	15259184.0
2017-02-23 11:00:00	AAPL	Stock	34.0982	34.1925	34.075	34.15	11940020.0
2017-02-23 12:00:00	AAPL	Stock	34.15	34.1875	34.115	34.1725	6051864.0
2017-02-23 13:00:00	AAPL	Stock	34.1725	34.2125	34.14	34.1925	3893016.0
2017-02-23 14:00:00	AAPL	Stock	34.19	34.2325	34.15	34.2062	5133080.0
2017-02-23 15:00:00	AAPL	Stock	34.205	34.2225	34.095	34.1325	11860388.0
2017-02-23 16:00:00	AAPL	Stock	34.125	34.15	34.115	34.1325	6084336.0
2017-02-23 17:00:00	AAPL	Stock	34.1425	34.1425	34.1175	34.12	84244.0
2017-02-23 18:00:00	AAPL	Stock	34.12	34.12	34.095	34.1125	16404.0
2017-02-23 19:00:00	AAPL	Stock	34.095	34.115	34.0925	34.1125	27696.0
2017-02-23 05:00:00	MSFT	Stock	64.35	64.35	64.35	64.35	517.0
2017-02-23 06:00:00	MSFT	Stock	64.35	64.35	64.35	64.35	1983.0
2017-02-23 08:00:00	MSFT	Stock	64.4	64.4	64.3	64.3	2143.0
2017-02-23 09:00:00	MSFT	Stock	64.33	64.52	64.25	64.34	1951127.0
2017-02-23 10:00:00	MSFT	Stock	64.34	64.38	64.21	64.31	3036938.0
2017-02-23 11:00:00	MSFT	Stock	64.31	64.53	64.195	64.44	2066605.0
2017-02-23 12:00:00	MSFT	Stock	64.435	64.62	64.42	64.53	1590085.0
2017-02-23 13:00:00	MSFT	Stock	64.53	64.58	64.43	64.55	1223602.0
2017-02-23 14:00:00	MSFT	Stock	64.545	64.69	64.48	64.65	1590281.0
2017-02-23 15:00:00	MSFT	Stock	64.65	64.728	64.49	64.62	5238985.0
2017-02-23 16:00:00	MSFT	Stock	64.62	64.62	64.46	64.49	1911989.0
2017-02-23 17:00:00	MSFT	Stock	64.49	64.49	64.43	64.45	3132.0
2017-02-23 18:00:00	MSFT	Stock	64.48	64.5	64.47	64.5	3325.0
2017-02-23 19:00:00	MSFT	Stock	64.42	64.48	64.41	64.41	2656.0
2017-02-23 04:00:00	NVDA	Stock	2.6998	2.6998	2.6885	2.695	143400.0
2017-02-23 05:00:00	NVDA	Stock	2.6885	2.6885	2.6438	2.65	374840.0
2017-02-23 06:00:00	NVDA	Stock	2.65	2.6625	2.645	2.66	355480.0
2017-02-23 07:00:00	NVDA	Stock	2.6625	2.6798	2.66	2.664	2271560.0
2017-02-23 08:00:00	NVDA	Stock	2.6663	2.675	2.6408	2.6512	8309560.0
2017-02-23 09:00:00	NVDA	Stock	2.6505	2.6598	2.5868	2.6035	253782040.0
2017-02-23 10:00:00	NVDA	Stock	2.6032	2.6065	2.5255	2.5285	335501360.0
2017-02-23 11:00:00	NVDA	Stock	2.5282	2.5328	2.4998	2.512	273250960.0
2017-02-23 12:00:00	NVDA	Stock	2.5113	2.5488	2.5095	2.5342	163403840.0
2017-02-23 13:00:00	NVDA	Stock	2.5348	2.5435	2.4998	2.5031	136808240.0
2017-02-23 14:00:00	NVDA	Stock	2.5035	2.5285	2.5015	2.5088	113660200.0
2017-02-23 15:00:00	NVDA	Stock	2.5085	2.514	2.492	2.512	223306520.0
2017-02-23 16:00:00	NVDA	Stock	2.5122	2.5233	2.5122	2.5195	3592840.0
2017-02-23 17:00:00	NVDA	Stock	2.5195	2.5195	2.4878	2.491	4276800.0
2017-02-23 18:00:00	NVDA	Stock	2.4888	2.4913	2.4652	2.47	5217960.0
2017-02-23 19:00:00	NVDA	Stock	2.4688	2.472	2.4628	2.464	1991680.0
2017-02-23 07:00:00	AMZN	Stock	42.85	42.85	42.85	42.85	4000.0
2017-02-23 08:00:00	AMZN	Stock	42.69	42.9495	42.69	42.931	210300.0
2017-02-23 09:00:00	AMZN	Stock	42.9325	43.043	42.7195	42.8068	9057480.0
2017-02-23 10:00:00	AMZN	Stock	42.8095	42.889	42.55	42.5755	10829700.0
2017-02-23 11:00:00	AMZN	Stock	42.5845	42.6375	42.4	42.5961	10517780.0

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

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