PREVIEW / stock_1hour / 2016-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-04.parquet
  size:    1.0 MB
  rows:    48,433
  symbols: 3,291

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-05-04 04:00:00	AAPL	Stock	23.8875	23.8875	23.795	23.795	41844.0
2016-05-04 05:00:00	AAPL	Stock	23.795	23.795	23.64	23.64	21616.0
2016-05-04 06:00:00	AAPL	Stock	23.64	23.65	23.6125	23.6275	23424.0
2016-05-04 07:00:00	AAPL	Stock	23.625	23.67	23.6125	23.6675	81340.0
2016-05-04 08:00:00	AAPL	Stock	23.67	23.75	23.6125	23.715	462276.0
2016-05-04 09:00:00	AAPL	Stock	23.6925	23.975	23.6925	23.79	27283732.0
2016-05-04 10:00:00	AAPL	Stock	23.7875	23.82	23.525	23.575	33897176.0
2016-05-04 11:00:00	AAPL	Stock	23.575	23.6375	23.53	23.5625	16767896.0
2016-05-04 12:00:00	AAPL	Stock	23.5628	23.5962	23.5	23.5025	13465896.0
2016-05-04 13:00:00	AAPL	Stock	23.505	23.5475	23.455	23.5075	13093644.0
2016-05-04 14:00:00	AAPL	Stock	23.5075	23.5875	23.4775	23.55	11711244.0
2016-05-04 15:00:00	AAPL	Stock	23.55	23.61	23.5275	23.5475	18558128.0
2016-05-04 16:00:00	AAPL	Stock	23.5475	23.575	23.5093	23.575	12591340.0
2016-05-04 17:00:00	AAPL	Stock	23.575	23.59	23.5725	23.585	45800.0
2016-05-04 18:00:00	AAPL	Stock	23.6	23.61	23.5475	23.5975	58356.0
2016-05-04 19:00:00	AAPL	Stock	23.6	23.62	23.575	23.595	45696.0
2016-05-04 07:00:00	MSFT	Stock	49.54	49.56	49.48	49.55	6478.0
2016-05-04 08:00:00	MSFT	Stock	49.54	49.92	49.48	49.6	21316.0
2016-05-04 09:00:00	MSFT	Stock	49.64	49.94	49.46	49.75	2917125.0
2016-05-04 10:00:00	MSFT	Stock	49.74	49.995	49.62	49.83	3448734.0
2016-05-04 11:00:00	MSFT	Stock	49.835	49.96	49.69	49.95	2344027.0
2016-05-04 12:00:00	MSFT	Stock	49.942	50.06	49.88	49.975	2432789.0
2016-05-04 13:00:00	MSFT	Stock	49.975	50.05	49.87	49.875	2529036.0
2016-05-04 14:00:00	MSFT	Stock	49.88	49.985	49.8	49.849	2238518.0
2016-05-04 15:00:00	MSFT	Stock	49.84	50.01	49.78	49.87	3963983.0
2016-05-04 16:00:00	MSFT	Stock	49.87	49.95	49.85	49.87	3082241.0
2016-05-04 17:00:00	MSFT	Stock	49.87	49.87	49.87	49.87	10243.0
2016-05-04 18:00:00	MSFT	Stock	49.9	49.95	49.87	49.95	660.0
2016-05-04 19:00:00	MSFT	Stock	49.9	49.9	49.9	49.9	228.0
2016-05-04 09:00:00	NVDA	Stock	0.877	0.8795	0.8658	0.874	67626960.0
2016-05-04 10:00:00	NVDA	Stock	0.874	0.8762	0.869	0.873	113017160.0
2016-05-04 11:00:00	NVDA	Stock	0.873	0.8735	0.8662	0.8668	46080360.0
2016-05-04 12:00:00	NVDA	Stock	0.8668	0.8675	0.86	0.8618	63142440.0
2016-05-04 13:00:00	NVDA	Stock	0.8618	0.8652	0.8618	0.8634	44896600.0
2016-05-04 14:00:00	NVDA	Stock	0.8634	0.8675	0.8618	0.8641	47115200.0
2016-05-04 15:00:00	NVDA	Stock	0.8642	0.873	0.864	0.869	83351760.0
2016-05-04 16:00:00	NVDA	Stock	0.869	0.8691	0.8684	0.8691	12244320.0
2016-05-04 17:00:00	NVDA	Stock	0.8745	0.8745	0.8745	0.8745	8000.0
2016-05-04 19:00:00	NVDA	Stock	0.87	0.87	0.87	0.87	4000.0
2016-05-04 05:00:00	AMZN	Stock	33.4225	33.4225	33.4225	33.4225	2000.0
2016-05-04 06:00:00	AMZN	Stock	33.3655	33.3655	33.3655	33.3655	2880.0
2016-05-04 07:00:00	AMZN	Stock	33.3455	33.392	33.249	33.305	33380.0
2016-05-04 08:00:00	AMZN	Stock	33.399	33.399	33.25	33.305	202500.0
2016-05-04 09:00:00	AMZN	Stock	33.345	33.5015	33.107	33.413	12943060.0
2016-05-04 10:00:00	AMZN	Stock	33.4145	33.499	33.28	33.4435	13379580.0
2016-05-04 11:00:00	AMZN	Stock	33.4435	33.6325	33.35	33.48	7903740.0
2016-05-04 12:00:00	AMZN	Stock	33.48	33.61	33.3266	33.329	6022200.0
2016-05-04 13:00:00	AMZN	Stock	33.3209	33.7	33.312	33.6243	12976500.0
2016-05-04 14:00:00	AMZN	Stock	33.621	33.6845	33.4005	33.574	10355160.0
2016-05-04 15:00:00	AMZN	Stock	33.568	33.5945	33.4716	33.549	10062960.0

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

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