PREVIEW / stock_1hour / 2017-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-20.parquet
  size:    1.0 MB
  rows:    47,947
  symbols: 3,089

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-01-20 04:00:00	AAPL	Stock	29.9475	29.9475	29.945	29.945	1600.0
2017-01-20 05:00:00	AAPL	Stock	29.995	30.0	29.995	30.0	1924.0
2017-01-20 06:00:00	AAPL	Stock	30.035	30.0425	30.0225	30.0375	5004.0
2017-01-20 07:00:00	AAPL	Stock	30.0425	30.05	30.02	30.05	78560.0
2017-01-20 08:00:00	AAPL	Stock	30.05	30.06	29.875	30.0375	174124.0
2017-01-20 09:00:00	AAPL	Stock	30.0375	30.1125	29.985	30.03	22176912.0
2017-01-20 10:00:00	AAPL	Stock	30.032	30.0375	29.9575	30.0225	11936904.0
2017-01-20 11:00:00	AAPL	Stock	30.0235	30.04	29.995	30.025	7518132.0
2017-01-20 12:00:00	AAPL	Stock	30.025	30.0425	29.941	29.953	13710592.0
2017-01-20 13:00:00	AAPL	Stock	29.955	30.0025	29.9475	29.9538	7229408.0
2017-01-20 14:00:00	AAPL	Stock	29.954	29.985	29.9338	29.975	8370332.0
2017-01-20 15:00:00	AAPL	Stock	29.975	30.005	29.96	29.9975	18843540.0
2017-01-20 16:00:00	AAPL	Stock	30.0025	30.015	29.995	30.0025	12982560.0
2017-01-20 17:00:00	AAPL	Stock	30.0025	30.0075	30.0	30.0075	48872.0
2017-01-20 18:00:00	AAPL	Stock	30.0075	30.01	30.0025	30.005	17900.0
2017-01-20 19:00:00	AAPL	Stock	30.005	30.01	30.0	30.01	8390432.0
2017-01-20 06:00:00	MSFT	Stock	62.57	62.57	62.57	62.57	850.0
2017-01-20 07:00:00	MSFT	Stock	62.66	62.66	62.66	62.66	189.0
2017-01-20 08:00:00	MSFT	Stock	62.5	62.69	62.5	62.69	4155.0
2017-01-20 09:00:00	MSFT	Stock	62.62	62.8	62.37	62.739	5918309.0
2017-01-20 10:00:00	MSFT	Stock	62.735	62.82	62.5	62.506	2462768.0
2017-01-20 11:00:00	MSFT	Stock	62.51	62.59	62.44	62.58	1809799.0
2017-01-20 12:00:00	MSFT	Stock	62.58	62.625	62.37	62.54	3455094.0
2017-01-20 13:00:00	MSFT	Stock	62.54	62.625	62.47	62.485	1515626.0
2017-01-20 14:00:00	MSFT	Stock	62.488	62.61	62.48	62.585	1667022.0
2017-01-20 15:00:00	MSFT	Stock	62.585	62.75	62.535	62.73	6275237.0
2017-01-20 16:00:00	MSFT	Stock	62.74	62.99	62.6	62.93	3866443.0
2017-01-20 17:00:00	MSFT	Stock	62.8	62.92	62.8	62.82	2522.0
2017-01-20 18:00:00	MSFT	Stock	62.82	62.88	62.82	62.88	740.0
2017-01-20 19:00:00	MSFT	Stock	62.88	62.88	62.85	62.85	555.0
2017-01-20 06:00:00	NVDA	Stock	2.6438	2.6438	2.6438	2.6438	12080.0
2017-01-20 07:00:00	NVDA	Stock	2.6375	2.6375	2.6375	2.6375	7120.0
2017-01-20 08:00:00	NVDA	Stock	2.6372	2.651	2.63	2.6458	654960.0
2017-01-20 09:00:00	NVDA	Stock	2.646	2.67	2.6282	2.6398	92685080.0
2017-01-20 10:00:00	NVDA	Stock	2.6388	2.6405	2.6075	2.612	92333040.0
2017-01-20 11:00:00	NVDA	Stock	2.612	2.6215	2.5985	2.6043	53248160.0
2017-01-20 12:00:00	NVDA	Stock	2.6043	2.6093	2.5818	2.5885	72454880.0
2017-01-20 13:00:00	NVDA	Stock	2.5885	2.605	2.5875	2.59	41628040.0
2017-01-20 14:00:00	NVDA	Stock	2.5908	2.5962	2.578	2.5921	38668080.0
2017-01-20 15:00:00	NVDA	Stock	2.5921	2.6013	2.5839	2.6003	61281280.0
2017-01-20 16:00:00	NVDA	Stock	2.6003	2.6032	2.5988	2.602	20894440.0
2017-01-20 17:00:00	NVDA	Stock	2.6018	2.6062	2.6013	2.6062	310040.0
2017-01-20 18:00:00	NVDA	Stock	2.6062	2.6088	2.605	2.6075	510480.0
2017-01-20 19:00:00	NVDA	Stock	2.6085	2.61	2.607	2.6082	564200.0
2017-01-20 06:00:00	AMZN	Stock	40.6	40.6	40.6	40.6	10500.0
2017-01-20 07:00:00	AMZN	Stock	40.647	40.647	40.617	40.617	4000.0
2017-01-20 08:00:00	AMZN	Stock	40.5655	40.6475	40.55	40.63	130580.0
2017-01-20 09:00:00	AMZN	Stock	40.63	40.801	40.563	40.5655	12162900.0
2017-01-20 10:00:00	AMZN	Stock	40.572	40.5995	40.441	40.5625	8644000.0
2017-01-20 11:00:00	AMZN	Stock	40.5695	40.6546	40.5175	40.606	6014480.0

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

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