PREVIEW / stock_1hour / 2016-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-17.parquet
  size:    1.0 MB
  rows:    48,146
  symbols: 3,238

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-08-17 04:00:00	AAPL	Stock	27.4075	27.4075	27.3725	27.375	5656.0
2016-08-17 06:00:00	AAPL	Stock	27.375	27.375	27.375	27.375	5200.0
2016-08-17 07:00:00	AAPL	Stock	27.36	27.3875	27.3325	27.375	24832.0
2016-08-17 08:00:00	AAPL	Stock	27.3725	27.375	27.275	27.275	459952.0
2016-08-17 09:00:00	AAPL	Stock	27.275	27.3125	27.085	27.1525	18534092.0
2016-08-17 10:00:00	AAPL	Stock	27.1525	27.215	27.115	27.1475	14350776.0
2016-08-17 11:00:00	AAPL	Stock	27.145	27.21	27.13	27.1515	8505728.0
2016-08-17 12:00:00	AAPL	Stock	27.15	27.3075	27.1475	27.2812	10605288.0
2016-08-17 13:00:00	AAPL	Stock	27.2825	27.315	27.255	27.2775	7762432.0
2016-08-17 14:00:00	AAPL	Stock	27.2775	27.3425	27.2	27.2775	11628352.0
2016-08-17 15:00:00	AAPL	Stock	27.2775	27.3288	27.2138	27.3	14253596.0
2016-08-17 16:00:00	AAPL	Stock	27.305	27.32	27.28	27.32	3963292.0
2016-08-17 17:00:00	AAPL	Stock	27.3175	27.325	27.305	27.305	28408.0
2016-08-17 18:00:00	AAPL	Stock	27.305	27.3225	27.305	27.3125	42232.0
2016-08-17 19:00:00	AAPL	Stock	27.3025	27.315	27.25	27.3075	15660.0
2016-08-17 06:00:00	MSFT	Stock	57.44	57.44	57.44	57.44	500.0
2016-08-17 08:00:00	MSFT	Stock	57.45	57.45	57.44	57.44	1851.0
2016-08-17 09:00:00	MSFT	Stock	57.58	57.6	57.24	57.355	1819511.0
2016-08-17 10:00:00	MSFT	Stock	57.355	57.44	57.29	57.37	2076333.0
2016-08-17 11:00:00	MSFT	Stock	57.37	57.415	57.26	57.289	1461795.0
2016-08-17 12:00:00	MSFT	Stock	57.28	57.6	57.23	57.57	1913920.0
2016-08-17 13:00:00	MSFT	Stock	57.57	57.63	57.445	57.464	2387465.0
2016-08-17 14:00:00	MSFT	Stock	57.465	57.68	57.33	57.56	2686292.0
2016-08-17 15:00:00	MSFT	Stock	57.555	57.59	57.43	57.56	3668898.0
2016-08-17 16:00:00	MSFT	Stock	57.56	57.56	57.53	57.53	1297176.0
2016-08-17 17:00:00	MSFT	Stock	57.54	57.54	57.54	57.54	2000.0
2016-08-17 18:00:00	MSFT	Stock	57.57	57.57	57.57	57.57	100.0
2016-08-17 19:00:00	MSFT	Stock	57.57	57.57	57.57	57.57	500.0
2016-08-17 04:00:00	NVDA	Stock	1.5625	1.5625	1.5625	1.5625	7440.0
2016-08-17 05:00:00	NVDA	Stock	1.56	1.56	1.56	1.56	56000.0
2016-08-17 08:00:00	NVDA	Stock	1.5625	1.5628	1.5615	1.5628	79040.0
2016-08-17 09:00:00	NVDA	Stock	1.5628	1.5685	1.5482	1.5518	50442560.0
2016-08-17 10:00:00	NVDA	Stock	1.5518	1.5548	1.5352	1.5432	81604360.0
2016-08-17 11:00:00	NVDA	Stock	1.543	1.5453	1.5244	1.526	97452320.0
2016-08-17 12:00:00	NVDA	Stock	1.5259	1.5298	1.5164	1.529	107850080.0
2016-08-17 13:00:00	NVDA	Stock	1.529	1.5361	1.52	1.5228	82476000.0
2016-08-17 14:00:00	NVDA	Stock	1.5232	1.535	1.5193	1.5268	64505400.0
2016-08-17 15:00:00	NVDA	Stock	1.5268	1.5315	1.5255	1.5283	90526480.0
2016-08-17 16:00:00	NVDA	Stock	1.5288	1.5288	1.525	1.5285	9823800.0
2016-08-17 17:00:00	NVDA	Stock	1.5285	1.5285	1.5258	1.5283	81200.0
2016-08-17 18:00:00	NVDA	Stock	1.5275	1.5278	1.5275	1.5275	50720.0
2016-08-17 19:00:00	NVDA	Stock	1.526	1.5273	1.5258	1.5258	71280.0
2016-08-17 08:00:00	AMZN	Stock	38.1945	38.2	38.1945	38.2	10400.0
2016-08-17 09:00:00	AMZN	Stock	38.201	38.253	37.9695	38.0105	5748820.0
2016-08-17 10:00:00	AMZN	Stock	38.021	38.047	37.96	38.013	5133680.0
2016-08-17 11:00:00	AMZN	Stock	38.0106	38.0415	37.9655	37.973	3896500.0
2016-08-17 12:00:00	AMZN	Stock	37.978	38.178	37.9725	38.1592	3889300.0
2016-08-17 13:00:00	AMZN	Stock	38.1715	38.2374	38.1104	38.135	3292400.0
2016-08-17 14:00:00	AMZN	Stock	38.1405	38.261	38.0815	38.2025	3360100.0
2016-08-17 15:00:00	AMZN	Stock	38.221	38.237	38.1355	38.2285	5001980.0

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

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