PREVIEW / stock_1hour / 2017-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-20.parquet
  size:    1.0 MB
  rows:    47,649
  symbols: 2,978

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-07-20 04:00:00	AAPL	Stock	37.7625	37.7625	37.7275	37.7275	2160.0
2017-07-20 05:00:00	AAPL	Stock	37.755	37.755	37.65	37.65	2728.0
2017-07-20 06:00:00	AAPL	Stock	37.675	37.745	37.675	37.7375	2000.0
2017-07-20 07:00:00	AAPL	Stock	37.7375	37.8475	37.7275	37.8225	26976.0
2017-07-20 08:00:00	AAPL	Stock	37.795	37.875	37.795	37.805	157852.0
2017-07-20 09:00:00	AAPL	Stock	37.82	37.935	37.725	37.7775	10272412.0
2017-07-20 10:00:00	AAPL	Stock	37.7775	37.785	37.5475	37.635	12389888.0
2017-07-20 11:00:00	AAPL	Stock	37.6305	37.71	37.6075	37.675	5818484.0
2017-07-20 12:00:00	AAPL	Stock	37.6735	37.7642	37.67	37.6925	3428308.0
2017-07-20 13:00:00	AAPL	Stock	37.6938	37.73	37.625	37.729	3424268.0
2017-07-20 14:00:00	AAPL	Stock	37.7275	37.7275	37.6075	37.64	5125652.0
2017-07-20 15:00:00	AAPL	Stock	37.6425	37.745	37.585	37.5875	13252264.0
2017-07-20 16:00:00	AAPL	Stock	37.585	37.63	37.5525	37.605	5690836.0
2017-07-20 17:00:00	AAPL	Stock	37.6025	37.6625	37.6	37.6375	60868.0
2017-07-20 18:00:00	AAPL	Stock	37.6275	37.6275	37.5925	37.5925	50716.0
2017-07-20 19:00:00	AAPL	Stock	37.5925	37.61	37.5925	37.5925	32380.0
2017-07-20 04:00:00	MSFT	Stock	74.05	74.05	74.05	74.05	200.0
2017-07-20 05:00:00	MSFT	Stock	74.05	74.05	74.0	74.0	702.0
2017-07-20 06:00:00	MSFT	Stock	74.11	74.11	74.08	74.08	1392.0
2017-07-20 07:00:00	MSFT	Stock	74.08	74.12	74.01	74.12	6771.0
2017-07-20 08:00:00	MSFT	Stock	74.1	74.25	74.08	74.11	70283.0
2017-07-20 09:00:00	MSFT	Stock	74.11	74.34	73.28	73.63	4703534.0
2017-07-20 10:00:00	MSFT	Stock	73.62	73.92	73.41	73.835	4803244.0
2017-07-20 11:00:00	MSFT	Stock	73.836	74.13	73.82	73.925	2712368.0
2017-07-20 12:00:00	MSFT	Stock	73.92	73.975	73.84	73.88	2112943.0
2017-07-20 13:00:00	MSFT	Stock	73.88	74.07	73.79	73.966	2465518.0
2017-07-20 14:00:00	MSFT	Stock	73.96	74.01	73.62	73.8	3483945.0
2017-07-20 15:00:00	MSFT	Stock	73.799	74.3	73.799	74.25	8512538.0
2017-07-20 16:00:00	MSFT	Stock	74.22	76.24	73.37	75.8	6218226.0
2017-07-20 17:00:00	MSFT	Stock	75.8	77.24	74.22	76.37	1713055.0
2017-07-20 18:00:00	MSFT	Stock	76.44	76.47	72.6	73.71	1800258.0
2017-07-20 19:00:00	MSFT	Stock	73.7	74.3	73.63	74.0	315114.0
2017-07-20 04:00:00	NVDA	Stock	4.1078	4.1078	4.1078	4.1078	8000.0
2017-07-20 05:00:00	NVDA	Stock	4.1125	4.1263	4.1125	4.1263	94920.0
2017-07-20 06:00:00	NVDA	Stock	4.1225	4.125	4.1225	4.125	35360.0
2017-07-20 07:00:00	NVDA	Stock	4.125	4.14	4.125	4.14	72200.0
2017-07-20 08:00:00	NVDA	Stock	4.145	4.1558	4.1275	4.1425	736760.0
2017-07-20 09:00:00	NVDA	Stock	4.1405	4.1525	4.0978	4.1313	103332760.0
2017-07-20 10:00:00	NVDA	Stock	4.1308	4.1492	4.106	4.1428	133245760.0
2017-07-20 11:00:00	NVDA	Stock	4.1428	4.177	4.1422	4.1688	125224400.0
2017-07-20 12:00:00	NVDA	Stock	4.168	4.1798	4.159	4.1608	65627400.0
2017-07-20 13:00:00	NVDA	Stock	4.1601	4.1672	4.1475	4.1554	46144800.0
2017-07-20 14:00:00	NVDA	Stock	4.1548	4.17	4.1382	4.1667	47639640.0
2017-07-20 15:00:00	NVDA	Stock	4.1665	4.1878	4.1658	4.1878	117731080.0
2017-07-20 16:00:00	NVDA	Stock	4.1865	4.1945	4.1705	4.1838	19017440.0
2017-07-20 17:00:00	NVDA	Stock	4.1838	4.184	4.1785	4.18	544160.0
2017-07-20 18:00:00	NVDA	Stock	4.1812	4.183	4.1735	4.1735	1076040.0
2017-07-20 19:00:00	NVDA	Stock	4.1735	4.1772	4.1705	4.1772	453080.0
2017-07-20 05:00:00	AMZN	Stock	51.432	51.432	51.431	51.431	4500.0
2017-07-20 07:00:00	AMZN	Stock	51.4645	51.53	51.4645	51.53	14000.0

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

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