PREVIEW / stock_1hour / 2016-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-26.parquet
  size:    1023 KB
  rows:    47,710
  symbols: 3,297

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-05-26 04:00:00	AAPL	Stock	24.9625	24.9625	24.9025	24.9025	4136.0
2016-05-26 05:00:00	AAPL	Stock	24.8725	24.875	24.8625	24.875	8912.0
2016-05-26 06:00:00	AAPL	Stock	24.875	24.89	24.8725	24.885	35072.0
2016-05-26 07:00:00	AAPL	Stock	24.8875	24.93	24.8525	24.9125	92392.0
2016-05-26 08:00:00	AAPL	Stock	24.8775	24.9375	24.8375	24.9125	694248.0
2016-05-26 09:00:00	AAPL	Stock	24.905	24.9925	24.66	24.765	31707428.0
2016-05-26 10:00:00	AAPL	Stock	24.765	24.87	24.7388	24.7425	19316088.0
2016-05-26 11:00:00	AAPL	Stock	24.74	24.855	24.7275	24.8185	14921304.0
2016-05-26 12:00:00	AAPL	Stock	24.82	24.9138	24.8	24.9025	11524868.0
2016-05-26 13:00:00	AAPL	Stock	24.9025	25.064	24.8975	25.0425	20201184.0
2016-05-26 14:00:00	AAPL	Stock	25.0425	25.1225	25.0305	25.0775	15357392.0
2016-05-26 15:00:00	AAPL	Stock	25.0763	25.1825	25.07	25.105	23256864.0
2016-05-26 16:00:00	AAPL	Stock	25.1025	25.135	24.997	25.1125	11296996.0
2016-05-26 17:00:00	AAPL	Stock	25.1125	25.1275	25.1025	25.1175	87812.0
2016-05-26 18:00:00	AAPL	Stock	25.115	25.125	25.11	25.1175	27696.0
2016-05-26 19:00:00	AAPL	Stock	25.1175	25.135	25.11	25.135	47892.0
2016-05-26 04:00:00	MSFT	Stock	52.11	52.11	52.11	52.11	100.0
2016-05-26 07:00:00	MSFT	Stock	52.12	52.12	52.12	52.12	325.0
2016-05-26 08:00:00	MSFT	Stock	52.23	52.23	52.2	52.22	3530.0
2016-05-26 09:00:00	MSFT	Stock	52.19	52.19	51.38	51.395	3903556.0
2016-05-26 10:00:00	MSFT	Stock	51.4	51.77	51.36	51.55	3556296.0
2016-05-26 11:00:00	MSFT	Stock	51.54	51.878	51.53	51.73	2279926.0
2016-05-26 12:00:00	MSFT	Stock	51.723	51.77	51.67	51.69	1494689.0
2016-05-26 13:00:00	MSFT	Stock	51.695	51.735	51.62	51.69	2253293.0
2016-05-26 14:00:00	MSFT	Stock	51.68	51.84	51.67	51.83	2513900.0
2016-05-26 15:00:00	MSFT	Stock	51.84	51.979	51.82	51.89	4691841.0
2016-05-26 16:00:00	MSFT	Stock	51.89	51.89	51.67	51.85	2035074.0
2016-05-26 17:00:00	MSFT	Stock	51.8	51.8	51.8	51.8	200.0
2016-05-26 18:00:00	MSFT	Stock	51.82	51.82	51.82	51.82	400.0
2016-05-26 19:00:00	MSFT	Stock	51.82	51.9	51.81	51.9	6280.0
2016-05-26 07:00:00	NVDA	Stock	1.1228	1.1228	1.1225	1.1225	25240.0
2016-05-26 08:00:00	NVDA	Stock	1.125	1.1292	1.125	1.1292	40080.0
2016-05-26 09:00:00	NVDA	Stock	1.1288	1.1388	1.1255	1.1328	33684440.0
2016-05-26 10:00:00	NVDA	Stock	1.1328	1.1455	1.132	1.1399	59133400.0
2016-05-26 11:00:00	NVDA	Stock	1.1398	1.1488	1.1382	1.1474	44265120.0
2016-05-26 12:00:00	NVDA	Stock	1.1475	1.1495	1.1429	1.1438	27590200.0
2016-05-26 13:00:00	NVDA	Stock	1.1438	1.1443	1.1404	1.1441	30960720.0
2016-05-26 14:00:00	NVDA	Stock	1.144	1.1462	1.141	1.145	24866440.0
2016-05-26 15:00:00	NVDA	Stock	1.145	1.145	1.1398	1.1413	67441160.0
2016-05-26 16:00:00	NVDA	Stock	1.1413	1.1418	1.1402	1.1413	1590240.0
2016-05-26 17:00:00	NVDA	Stock	1.1413	1.145	1.1413	1.1445	464000.0
2016-05-26 18:00:00	NVDA	Stock	1.1425	1.1438	1.1425	1.1425	93440.0
2016-05-26 19:00:00	NVDA	Stock	1.1425	1.1425	1.1415	1.1415	60000.0
2016-05-26 07:00:00	AMZN	Stock	35.449	35.5	35.4225	35.5	42460.0
2016-05-26 08:00:00	AMZN	Stock	35.475	35.4985	35.398	35.45	219680.0
2016-05-26 09:00:00	AMZN	Stock	35.445	35.6165	35.3647	35.5133	7838560.0
2016-05-26 10:00:00	AMZN	Stock	35.5235	35.7255	35.4855	35.634	9875780.0
2016-05-26 11:00:00	AMZN	Stock	35.6285	35.74	35.601	35.636	6006020.0
2016-05-26 12:00:00	AMZN	Stock	35.626	35.6715	35.5775	35.6515	3726260.0
2016-05-26 13:00:00	AMZN	Stock	35.6465	35.699	35.63	35.659	3609020.0

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

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