PREVIEW / stock_1hour / 2016-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-19.parquet
  size:    1.0 MB
  rows:    47,405
  symbols: 3,200

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-19 04:00:00	AAPL	Stock	29.27	29.315	29.25	29.315	1600.0
2016-10-19 05:00:00	AAPL	Stock	29.315	29.315	29.315	29.315	2800.0
2016-10-19 06:00:00	AAPL	Stock	29.3575	29.3675	29.3425	29.3675	9052.0
2016-10-19 07:00:00	AAPL	Stock	29.3775	29.4375	29.375	29.4375	35452.0
2016-10-19 08:00:00	AAPL	Stock	29.425	29.4362	29.3	29.355	525252.0
2016-10-19 09:00:00	AAPL	Stock	29.3425	29.44	29.285	29.4112	12022508.0
2016-10-19 10:00:00	AAPL	Stock	29.41	29.4125	29.3145	29.36	12010300.0
2016-10-19 11:00:00	AAPL	Stock	29.36	29.36	28.45	29.26	11511176.0
2016-10-19 12:00:00	AAPL	Stock	29.2588	29.335	29.2275	29.3275	6518120.0
2016-10-19 13:00:00	AAPL	Stock	29.33	29.395	29.33	29.35	6094980.0
2016-10-19 14:00:00	AAPL	Stock	29.3488	29.3775	29.2625	29.305	9547804.0
2016-10-19 15:00:00	AAPL	Stock	29.3075	29.32	29.255	29.28	10959476.0
2016-10-19 16:00:00	AAPL	Stock	29.28	29.325	29.2725	29.2875	4388760.0
2016-10-19 17:00:00	AAPL	Stock	29.2875	29.295	29.185	29.24	239532.0
2016-10-19 18:00:00	AAPL	Stock	29.25	29.26	29.2375	29.26	22684.0
2016-10-19 19:00:00	AAPL	Stock	29.2625	29.2725	29.235	29.2575	56776.0
2016-10-19 05:00:00	MSFT	Stock	57.52	57.52	57.52	57.52	400.0
2016-10-19 06:00:00	MSFT	Stock	57.46	57.46	57.46	57.46	2700.0
2016-10-19 07:00:00	MSFT	Stock	57.46	57.48	57.46	57.47	3200.0
2016-10-19 08:00:00	MSFT	Stock	57.47	57.58	57.45	57.55	13633.0
2016-10-19 09:00:00	MSFT	Stock	57.55	57.58	57.395	57.475	2813067.0
2016-10-19 10:00:00	MSFT	Stock	57.475	57.84	57.47	57.775	3268811.0
2016-10-19 11:00:00	MSFT	Stock	57.775	57.79	57.47	57.52	2287823.0
2016-10-19 12:00:00	MSFT	Stock	57.525	57.58	57.5	57.553	1635261.0
2016-10-19 13:00:00	MSFT	Stock	57.56	57.67	57.53	57.57	1605445.0
2016-10-19 14:00:00	MSFT	Stock	57.57	57.64	57.54	57.625	1760984.0
2016-10-19 15:00:00	MSFT	Stock	57.63	57.68	57.54	57.56	3963869.0
2016-10-19 16:00:00	MSFT	Stock	57.53	57.62	57.52	57.52	2946001.0
2016-10-19 17:00:00	MSFT	Stock	57.57	57.62	57.57	57.6	3955.0
2016-10-19 18:00:00	MSFT	Stock	57.6	57.6	57.55	57.6	1575.0
2016-10-19 19:00:00	MSFT	Stock	57.6	57.6	57.53	57.57	33836.0
2016-10-19 07:00:00	NVDA	Stock	1.6505	1.6505	1.65	1.65	60000.0
2016-10-19 08:00:00	NVDA	Stock	1.6548	1.6575	1.652	1.6562	131440.0
2016-10-19 09:00:00	NVDA	Stock	1.6538	1.6602	1.6455	1.655	29885800.0
2016-10-19 10:00:00	NVDA	Stock	1.6548	1.6684	1.6545	1.6666	25280560.0
2016-10-19 11:00:00	NVDA	Stock	1.667	1.6695	1.6638	1.6638	16268240.0
2016-10-19 12:00:00	NVDA	Stock	1.6635	1.6663	1.6608	1.6635	17514880.0
2016-10-19 13:00:00	NVDA	Stock	1.6635	1.6648	1.66	1.663	14498920.0
2016-10-19 14:00:00	NVDA	Stock	1.6628	1.665	1.6598	1.6615	18542360.0
2016-10-19 15:00:00	NVDA	Stock	1.6618	1.6659	1.6611	1.662	23238080.0
2016-10-19 16:00:00	NVDA	Stock	1.6618	1.6645	1.6592	1.6612	23579040.0
2016-10-19 17:00:00	NVDA	Stock	1.656	1.6618	1.656	1.6618	412000.0
2016-10-19 18:00:00	NVDA	Stock	1.6612	1.665	1.6612	1.6645	104000.0
2016-10-19 19:00:00	NVDA	Stock	1.6648	1.6648	1.6638	1.6638	12000.0
2016-10-19 04:00:00	AMZN	Stock	40.875	40.875	40.875	40.875	2540.0
2016-10-19 06:00:00	AMZN	Stock	40.875	40.875	40.875	40.875	2000.0
2016-10-19 07:00:00	AMZN	Stock	40.95	40.95	40.95	40.95	2000.0
2016-10-19 08:00:00	AMZN	Stock	40.9655	41.1	40.9445	41.01	162340.0
2016-10-19 09:00:00	AMZN	Stock	41.025	41.05	40.806	40.914	6836600.0
2016-10-19 10:00:00	AMZN	Stock	40.8946	40.9438	40.7585	40.8002	9753660.0

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

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