PREVIEW / stock_1hour / 2016-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-20.parquet
  size:    1.0 MB
  rows:    47,687
  symbols: 3,293

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-20 04:00:00	AAPL	Stock	23.675	23.7225	23.675	23.7	9540.0
2016-05-20 05:00:00	AAPL	Stock	23.655	23.6925	23.65	23.6775	13108.0
2016-05-20 06:00:00	AAPL	Stock	23.6775	23.6775	23.6675	23.67	5568.0
2016-05-20 07:00:00	AAPL	Stock	23.6425	23.66	23.63	23.63	13468.0
2016-05-20 08:00:00	AAPL	Stock	23.65	23.675	23.58	23.6225	311800.0
2016-05-20 09:00:00	AAPL	Stock	23.6275	23.775	23.6	23.75	23070300.0
2016-05-20 10:00:00	AAPL	Stock	23.7475	23.7925	23.685	23.72	20058528.0
2016-05-20 11:00:00	AAPL	Stock	23.7175	23.8	23.715	23.7902	13022420.0
2016-05-20 12:00:00	AAPL	Stock	23.7918	23.8475	23.77	23.8375	10949712.0
2016-05-20 13:00:00	AAPL	Stock	23.8375	23.8575	23.735	23.7725	13594884.0
2016-05-20 14:00:00	AAPL	Stock	23.7725	23.7962	23.7525	23.7775	7293640.0
2016-05-20 15:00:00	AAPL	Stock	23.78	23.8125	23.7325	23.805	18361584.0
2016-05-20 16:00:00	AAPL	Stock	23.805	23.81	23.7775	23.8	10307284.0
2016-05-20 17:00:00	AAPL	Stock	23.7975	23.7975	23.77	23.78	82188.0
2016-05-20 18:00:00	AAPL	Stock	23.7775	23.805	23.77	23.78	689612.0
2016-05-20 19:00:00	AAPL	Stock	23.7775	23.7875	23.7775	23.7825	40924.0
2016-05-20 04:00:00	MSFT	Stock	50.32	50.32	50.32	50.32	100.0
2016-05-20 08:00:00	MSFT	Stock	50.45	50.51	50.4	50.51	4022.0
2016-05-20 09:00:00	MSFT	Stock	50.52	50.975	50.37	50.97	5094184.0
2016-05-20 10:00:00	MSFT	Stock	50.97	51.22	50.83	51.13	4202336.0
2016-05-20 11:00:00	MSFT	Stock	51.12	51.18	50.96	51.125	1952647.0
2016-05-20 12:00:00	MSFT	Stock	51.12	51.13	50.91	50.92	1539832.0
2016-05-20 13:00:00	MSFT	Stock	50.92	50.97	50.74	50.77	1473033.0
2016-05-20 14:00:00	MSFT	Stock	50.769	50.8	50.64	50.67	1913181.0
2016-05-20 15:00:00	MSFT	Stock	50.67	50.68	50.495	50.63	3398591.0
2016-05-20 16:00:00	MSFT	Stock	50.63	50.869	50.58	50.869	2615169.0
2016-05-20 17:00:00	MSFT	Stock	50.65	50.65	50.65	50.65	100.0
2016-05-20 18:00:00	MSFT	Stock	50.69	50.69	50.69	50.69	200.0
2016-05-20 19:00:00	MSFT	Stock	50.62	50.69	50.62	50.69	127000.0
2016-05-20 05:00:00	NVDA	Stock	1.0912	1.0912	1.0912	1.0912	4600.0
2016-05-20 07:00:00	NVDA	Stock	1.0925	1.0925	1.0925	1.0925	8000.0
2016-05-20 08:00:00	NVDA	Stock	1.0925	1.0925	1.09	1.09	360000.0
2016-05-20 09:00:00	NVDA	Stock	1.092	1.1127	1.092	1.1098	64303920.0
2016-05-20 10:00:00	NVDA	Stock	1.1098	1.1112	1.1028	1.1052	63533080.0
2016-05-20 11:00:00	NVDA	Stock	1.105	1.111	1.105	1.1082	43555280.0
2016-05-20 12:00:00	NVDA	Stock	1.1082	1.1086	1.1043	1.107	23200760.0
2016-05-20 13:00:00	NVDA	Stock	1.107	1.1082	1.1002	1.1043	28315080.0
2016-05-20 14:00:00	NVDA	Stock	1.1043	1.111	1.104	1.1062	44353360.0
2016-05-20 15:00:00	NVDA	Stock	1.1062	1.11	1.1049	1.1082	91940560.0
2016-05-20 16:00:00	NVDA	Stock	1.1082	1.11	1.1072	1.1082	13216200.0
2016-05-20 17:00:00	NVDA	Stock	1.1088	1.1088	1.1088	1.1088	81040.0
2016-05-20 18:00:00	NVDA	Stock	1.1085	1.1098	1.1082	1.1088	323240.0
2016-05-20 19:00:00	NVDA	Stock	1.109	1.109	1.109	1.109	8000.0
2016-05-20 07:00:00	AMZN	Stock	34.9605	34.9605	34.9545	34.9545	6020.0
2016-05-20 08:00:00	AMZN	Stock	35.01	35.0775	34.9795	35.0775	209060.0
2016-05-20 09:00:00	AMZN	Stock	35.05	35.3145	34.954	35.2225	16216000.0
2016-05-20 10:00:00	AMZN	Stock	35.203	35.362	35.175	35.3075	9979340.0
2016-05-20 11:00:00	AMZN	Stock	35.2993	35.33	35.235	35.2745	5054140.0
2016-05-20 12:00:00	AMZN	Stock	35.285	35.309	35.2242	35.2718	2789360.0
2016-05-20 13:00:00	AMZN	Stock	35.2816	35.2925	35.1538	35.215	3337260.0

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

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