PREVIEW / stock_1hour / 2017-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-01.parquet
  size:    1.0 MB
  rows:    47,868
  symbols: 3,052

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-05-01 04:00:00	AAPL	Stock	36.0025	36.0025	36.0025	36.0025	400.0
2017-05-01 06:00:00	AAPL	Stock	36.035	36.04	36.0325	36.035	12480.0
2017-05-01 07:00:00	AAPL	Stock	36.0575	36.12	36.0475	36.0875	87748.0
2017-05-01 08:00:00	AAPL	Stock	36.075	36.1925	35.9125	36.155	402184.0
2017-05-01 09:00:00	AAPL	Stock	36.1675	36.4675	36.165	36.4475	20122980.0
2017-05-01 10:00:00	AAPL	Stock	36.4475	36.5325	36.3925	36.52	16744240.0
2017-05-01 11:00:00	AAPL	Stock	36.519	36.575	36.4875	36.5625	11067828.0
2017-05-01 12:00:00	AAPL	Stock	36.5625	36.67	36.51	36.6402	10322624.0
2017-05-01 13:00:00	AAPL	Stock	36.6425	36.74	36.6075	36.74	10131516.0
2017-05-01 14:00:00	AAPL	Stock	36.74	36.7475	36.6375	36.679	11094832.0
2017-05-01 15:00:00	AAPL	Stock	36.6775	36.8	36.63	36.64	23824096.0
2017-05-01 16:00:00	AAPL	Stock	36.6525	36.705	36.6425	36.7	11115364.0
2017-05-01 17:00:00	AAPL	Stock	36.675	36.705	36.675	36.6925	130004.0
2017-05-01 18:00:00	AAPL	Stock	36.7	36.7125	36.6875	36.7075	89908.0
2017-05-01 19:00:00	AAPL	Stock	36.6925	36.7175	36.675	36.7	113728.0
2017-05-01 07:00:00	MSFT	Stock	68.74	68.74	68.6	68.6	350.0
2017-05-01 08:00:00	MSFT	Stock	68.5	68.6	68.45	68.46	23504.0
2017-05-01 09:00:00	MSFT	Stock	68.56	68.735	68.5	68.699	2807731.0
2017-05-01 10:00:00	MSFT	Stock	68.69	68.82	68.61	68.785	4205582.0
2017-05-01 11:00:00	MSFT	Stock	68.78	69.08	68.74	69.02	3186924.0
2017-05-01 12:00:00	MSFT	Stock	69.014	69.42	69.0	69.305	3721786.0
2017-05-01 13:00:00	MSFT	Stock	69.305	69.46	69.29	69.35	2456419.0
2017-05-01 14:00:00	MSFT	Stock	69.35	69.405	69.295	69.36	2422641.0
2017-05-01 15:00:00	MSFT	Stock	69.355	69.55	69.24	69.43	8330662.0
2017-05-01 16:00:00	MSFT	Stock	69.42	69.6	69.41	69.55	2682503.0
2017-05-01 17:00:00	MSFT	Stock	69.53	69.58	69.53	69.58	4400.0
2017-05-01 18:00:00	MSFT	Stock	69.55	69.64	69.53	69.53	16017.0
2017-05-01 19:00:00	MSFT	Stock	69.59	69.59	69.53	69.56	3240.0
2017-05-01 05:00:00	NVDA	Stock	2.6112	2.6112	2.6112	2.6112	6000.0
2017-05-01 07:00:00	NVDA	Stock	2.6125	2.6125	2.6125	2.6125	13200.0
2017-05-01 08:00:00	NVDA	Stock	2.6138	2.6138	2.6075	2.6125	679280.0
2017-05-01 09:00:00	NVDA	Stock	2.6138	2.6425	2.6112	2.6378	47421440.0
2017-05-01 10:00:00	NVDA	Stock	2.6375	2.6414	2.6178	2.626	46662240.0
2017-05-01 11:00:00	NVDA	Stock	2.626	2.6478	2.6238	2.6445	41224280.0
2017-05-01 12:00:00	NVDA	Stock	2.6445	2.6463	2.6355	2.6395	21576840.0
2017-05-01 13:00:00	NVDA	Stock	2.6398	2.6608	2.6388	2.6599	39929040.0
2017-05-01 14:00:00	NVDA	Stock	2.6602	2.6625	2.6528	2.6616	31141680.0
2017-05-01 15:00:00	NVDA	Stock	2.6619	2.6712	2.6573	2.6663	58850040.0
2017-05-01 16:00:00	NVDA	Stock	2.666	2.6748	2.629	2.635	11386160.0
2017-05-01 17:00:00	NVDA	Stock	2.6355	2.6435	2.635	2.6352	955080.0
2017-05-01 18:00:00	NVDA	Stock	2.636	2.6413	2.636	2.6372	120200.0
2017-05-01 19:00:00	NVDA	Stock	2.6378	2.6413	2.6365	2.6413	233240.0
2017-05-01 04:00:00	AMZN	Stock	46.3	46.4845	46.3	46.4845	12600.0
2017-05-01 07:00:00	AMZN	Stock	46.4165	46.4165	46.34	46.34	23320.0
2017-05-01 08:00:00	AMZN	Stock	46.3975	46.5915	46.3615	46.548	566360.0
2017-05-01 09:00:00	AMZN	Stock	46.5165	47.094	46.39	46.995	17216200.0
2017-05-01 10:00:00	AMZN	Stock	46.9785	47.299	46.91	47.283	16385820.0
2017-05-01 11:00:00	AMZN	Stock	47.2825	47.4795	47.2335	47.394	12954640.0
2017-05-01 12:00:00	AMZN	Stock	47.4005	47.4775	47.3265	47.3598	7276040.0
2017-05-01 13:00:00	AMZN	Stock	47.36	47.606	47.326	47.6048	9962840.0

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

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