PREVIEW / stock_1hour / 2016-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-21.parquet
  size:    1.0 MB
  rows:    47,216
  symbols: 3,190

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-21 04:00:00	AAPL	Stock	29.2925	29.2925	29.215	29.22	4856.0
2016-10-21 05:00:00	AAPL	Stock	29.2325	29.235	29.2325	29.235	1680.0
2016-10-21 06:00:00	AAPL	Stock	29.2275	29.24	29.18	29.2325	12592.0
2016-10-21 07:00:00	AAPL	Stock	29.225	29.2375	29.215	29.2225	25976.0
2016-10-21 08:00:00	AAPL	Stock	29.235	29.3	29.2	29.2425	130988.0
2016-10-21 09:00:00	AAPL	Stock	29.26	29.315	29.0775	29.2088	19401776.0
2016-10-21 10:00:00	AAPL	Stock	29.2075	29.2075	29.1025	29.165	12198148.0
2016-10-21 11:00:00	AAPL	Stock	29.1625	29.2175	29.13	29.1825	8528736.0
2016-10-21 12:00:00	AAPL	Stock	29.185	29.1975	29.12	29.1335	6489640.0
2016-10-21 13:00:00	AAPL	Stock	29.134	29.185	29.1175	29.15	6130792.0
2016-10-21 14:00:00	AAPL	Stock	29.1525	29.1825	29.1425	29.155	6130720.0
2016-10-21 15:00:00	AAPL	Stock	29.155	29.1625	29.07	29.1325	17476516.0
2016-10-21 16:00:00	AAPL	Stock	29.15	29.1772	29.105	29.1225	7550888.0
2016-10-21 17:00:00	AAPL	Stock	29.1225	29.15	29.1	29.115	2682996.0
2016-10-21 18:00:00	AAPL	Stock	29.125	29.145	29.125	29.13	47540.0
2016-10-21 19:00:00	AAPL	Stock	29.125	29.14	29.1175	29.135	47232.0
2016-10-21 04:00:00	MSFT	Stock	60.35	60.35	60.11	60.26	6175.0
2016-10-21 05:00:00	MSFT	Stock	60.26	60.38	60.2	60.35	5487.0
2016-10-21 06:00:00	MSFT	Stock	60.35	60.47	60.15	60.3	42151.0
2016-10-21 07:00:00	MSFT	Stock	60.22	60.74	60.13	60.7	309983.0
2016-10-21 08:00:00	MSFT	Stock	60.7	60.9	57.25	60.6	1678335.0
2016-10-21 09:00:00	MSFT	Stock	60.62	60.62	59.74	59.775	23782075.0
2016-10-21 10:00:00	MSFT	Stock	59.77	59.87	59.485	59.63	12993791.0
2016-10-21 11:00:00	MSFT	Stock	59.63	60.0	59.61	59.925	8078242.0
2016-10-21 12:00:00	MSFT	Stock	59.915	60.31	59.8	59.88	7700048.0
2016-10-21 13:00:00	MSFT	Stock	59.89	60.12	59.88	60.06	3933801.0
2016-10-21 14:00:00	MSFT	Stock	60.06	60.09	59.78	59.875	4135866.0
2016-10-21 15:00:00	MSFT	Stock	59.875	59.88	59.65	59.68	9169888.0
2016-10-21 16:00:00	MSFT	Stock	59.67	59.77	59.66	59.73	4659985.0
2016-10-21 17:00:00	MSFT	Stock	59.7	59.77	59.66	59.66	4627.0
2016-10-21 18:00:00	MSFT	Stock	59.68	59.7	59.68	59.69	2065.0
2016-10-21 19:00:00	MSFT	Stock	59.75	59.76	59.6	59.65	14840.0
2016-10-21 05:00:00	NVDA	Stock	1.6925	1.6925	1.6925	1.6925	32000.0
2016-10-21 07:00:00	NVDA	Stock	1.6925	1.7075	1.6898	1.6898	70000.0
2016-10-21 08:00:00	NVDA	Stock	1.689	1.6975	1.689	1.6948	40840.0
2016-10-21 09:00:00	NVDA	Stock	1.6895	1.6902	1.6725	1.6855	28804400.0
2016-10-21 10:00:00	NVDA	Stock	1.6855	1.6912	1.6805	1.6823	23285120.0
2016-10-21 11:00:00	NVDA	Stock	1.682	1.6872	1.6758	1.6814	18533720.0
2016-10-21 12:00:00	NVDA	Stock	1.6814	1.6848	1.678	1.6842	14752360.0
2016-10-21 13:00:00	NVDA	Stock	1.6841	1.6865	1.6798	1.6826	16189960.0
2016-10-21 14:00:00	NVDA	Stock	1.6828	1.6892	1.6803	1.6858	19752360.0
2016-10-21 15:00:00	NVDA	Stock	1.6859	1.6915	1.6846	1.6885	42791120.0
2016-10-21 16:00:00	NVDA	Stock	1.6885	1.6888	1.686	1.686	38424880.0
2016-10-21 17:00:00	NVDA	Stock	1.6915	1.6915	1.6915	1.6915	4000.0
2016-10-21 18:00:00	NVDA	Stock	1.6918	1.6918	1.6875	1.6875	8000.0
2016-10-21 19:00:00	NVDA	Stock	1.6872	1.6872	1.6872	1.6872	14000.0
2016-10-21 04:00:00	AMZN	Stock	40.5	40.5	40.5	40.5	2000.0
2016-10-21 07:00:00	AMZN	Stock	40.55	40.5985	40.55	40.5935	46800.0
2016-10-21 08:00:00	AMZN	Stock	40.5875	40.5875	40.4565	40.4565	152340.0
2016-10-21 09:00:00	AMZN	Stock	40.496	40.7725	40.4315	40.627	10603720.0

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

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