PREVIEW / stock_1hour / 2016-10-31

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-31.parquet
  size:    1.0 MB
  rows:    47,600
  symbols: 3,205

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-31 04:00:00	AAPL	Stock	28.4725	28.475	28.35	28.35	5128.0
2016-10-31 05:00:00	AAPL	Stock	28.44	28.4875	28.44	28.4875	1576.0
2016-10-31 06:00:00	AAPL	Stock	28.4375	28.47	28.4375	28.4375	6580.0
2016-10-31 07:00:00	AAPL	Stock	28.44	28.45	28.43	28.43	34400.0
2016-10-31 08:00:00	AAPL	Stock	28.445	28.45	28.405	28.45	154504.0
2016-10-31 09:00:00	AAPL	Stock	28.445	28.485	28.3	28.3225	16523972.0
2016-10-31 10:00:00	AAPL	Stock	28.3225	28.4675	28.315	28.42	17307856.0
2016-10-31 11:00:00	AAPL	Stock	28.4225	28.44	28.36	28.431	9453944.0
2016-10-31 12:00:00	AAPL	Stock	28.4312	28.5	28.4225	28.4925	6739556.0
2016-10-31 13:00:00	AAPL	Stock	28.4945	28.5575	28.48	28.5125	8035244.0
2016-10-31 14:00:00	AAPL	Stock	28.5125	28.52	28.425	28.435	6839332.0
2016-10-31 15:00:00	AAPL	Stock	28.4375	28.4825	28.385	28.39	15780492.0
2016-10-31 16:00:00	AAPL	Stock	28.385	28.4678	28.3825	28.395	14448500.0
2016-10-31 17:00:00	AAPL	Stock	28.3925	28.395	28.38	28.3825	7956.0
2016-10-31 18:00:00	AAPL	Stock	28.395	28.395	28.3775	28.38	31188.0
2016-10-31 19:00:00	AAPL	Stock	28.3875	28.39	28.3775	28.385	44460.0
2016-10-31 05:00:00	MSFT	Stock	60.12	60.12	60.12	60.12	500.0
2016-10-31 06:00:00	MSFT	Stock	60.11	60.12	60.1	60.1	14960.0
2016-10-31 07:00:00	MSFT	Stock	60.07	60.07	60.07	60.07	8500.0
2016-10-31 08:00:00	MSFT	Stock	60.06	60.16	60.06	60.15	36057.0
2016-10-31 09:00:00	MSFT	Stock	60.14	60.38	60.08	60.225	2520076.0
2016-10-31 10:00:00	MSFT	Stock	60.23	60.35	60.15	60.295	3187138.0
2016-10-31 11:00:00	MSFT	Stock	60.295	60.42	60.21	60.38	2269079.0
2016-10-31 12:00:00	MSFT	Stock	60.39	60.41	60.26	60.26	1942949.0
2016-10-31 13:00:00	MSFT	Stock	60.26	60.28	60.11	60.148	1503749.0
2016-10-31 14:00:00	MSFT	Stock	60.15	60.18	60.05	60.08	1681970.0
2016-10-31 15:00:00	MSFT	Stock	60.08	60.205	59.93	59.93	6405274.0
2016-10-31 16:00:00	MSFT	Stock	59.93	60.06	59.92	60.0	5184992.0
2016-10-31 17:00:00	MSFT	Stock	60.0	60.03	60.0	60.0	1320.0
2016-10-31 19:00:00	MSFT	Stock	60.0	60.0	59.98	59.98	1390.0
2016-10-31 04:00:00	NVDA	Stock	1.765	1.765	1.765	1.765	40000.0
2016-10-31 05:00:00	NVDA	Stock	1.765	1.765	1.765	1.765	5600.0
2016-10-31 06:00:00	NVDA	Stock	1.757	1.7725	1.757	1.7725	8000.0
2016-10-31 08:00:00	NVDA	Stock	1.775	1.775	1.7675	1.768	192480.0
2016-10-31 09:00:00	NVDA	Stock	1.772	1.7898	1.7672	1.7832	27609560.0
2016-10-31 10:00:00	NVDA	Stock	1.783	1.7848	1.7689	1.7725	37103320.0
2016-10-31 11:00:00	NVDA	Stock	1.7725	1.7825	1.7692	1.7802	25864400.0
2016-10-31 12:00:00	NVDA	Stock	1.7805	1.7838	1.7788	1.78	18190240.0
2016-10-31 13:00:00	NVDA	Stock	1.78	1.7865	1.779	1.7864	25305200.0
2016-10-31 14:00:00	NVDA	Stock	1.7862	1.7906	1.783	1.7858	25284440.0
2016-10-31 15:00:00	NVDA	Stock	1.7858	1.7859	1.7785	1.779	47334720.0
2016-10-31 16:00:00	NVDA	Stock	1.779	1.779	1.779	1.779	20422120.0
2016-10-31 17:00:00	NVDA	Stock	1.7838	1.7838	1.7825	1.7825	48000.0
2016-10-31 18:00:00	NVDA	Stock	1.7832	1.7842	1.7825	1.7842	121040.0
2016-10-31 04:00:00	AMZN	Stock	39.1	39.1	39.05	39.05	12400.0
2016-10-31 05:00:00	AMZN	Stock	39.049	39.074	39.0055	39.074	47100.0
2016-10-31 06:00:00	AMZN	Stock	39.06	39.06	39.015	39.0455	21400.0
2016-10-31 07:00:00	AMZN	Stock	39.0055	39.024	38.9755	39.004	72620.0
2016-10-31 08:00:00	AMZN	Stock	39.015	39.069	39.0	39.067	411400.0
2016-10-31 09:00:00	AMZN	Stock	39.0745	39.2834	39.0055	39.1478	16761900.0

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

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