PREVIEW / stock_1hour / 2018-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-18.parquet
  size:    1.1 MB
  rows:    49,158
  symbols: 2,837

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
2018-05-18 04:00:00	AAPL	Stock	46.7975	46.8425	46.7975	46.8425	4584.0
2018-05-18 05:00:00	AAPL	Stock	46.845	46.9	46.845	46.875	30668.0
2018-05-18 06:00:00	AAPL	Stock	46.875	46.875	46.8675	46.8675	6400.0
2018-05-18 07:00:00	AAPL	Stock	46.825	46.95	46.7775	46.8375	110128.0
2018-05-18 08:00:00	AAPL	Stock	46.8475	46.875	46.6375	46.64	263180.0
2018-05-18 09:00:00	AAPL	Stock	46.6375	46.8925	46.62	46.68	11648940.0
2018-05-18 10:00:00	AAPL	Stock	46.6825	46.9525	46.615	46.725	13530416.0
2018-05-18 11:00:00	AAPL	Stock	46.725	46.9425	46.7225	46.845	7378948.0
2018-05-18 12:00:00	AAPL	Stock	46.8468	46.875	46.765	46.8338	4810216.0
2018-05-18 13:00:00	AAPL	Stock	46.835	46.87	46.6725	46.7025	5179036.0
2018-05-18 14:00:00	AAPL	Stock	46.7012	46.73	46.6525	46.72	3993108.0
2018-05-18 15:00:00	AAPL	Stock	46.7225	46.7275	46.5325	46.5725	9961212.0
2018-05-18 16:00:00	AAPL	Stock	46.575	46.615	46.575	46.5775	7242020.0
2018-05-18 17:00:00	AAPL	Stock	46.59	46.635	46.59	46.5975	26632.0
2018-05-18 18:00:00	AAPL	Stock	46.595	46.62	46.55	46.5625	17836.0
2018-05-18 19:00:00	AAPL	Stock	46.5775	46.6025	46.55	46.6025	5504.0
2018-05-18 04:00:00	MSFT	Stock	96.35	96.35	96.35	96.35	100.0
2018-05-18 07:00:00	MSFT	Stock	96.45	96.45	96.29	96.29	845.0
2018-05-18 08:00:00	MSFT	Stock	96.34	96.35	95.88	95.9	21920.0
2018-05-18 09:00:00	MSFT	Stock	95.9	96.84	95.82	96.52	3385221.0
2018-05-18 10:00:00	MSFT	Stock	96.53	96.87	96.3	96.62	2116112.0
2018-05-18 11:00:00	MSFT	Stock	96.62	96.93	96.56	96.774	1619354.0
2018-05-18 12:00:00	MSFT	Stock	96.78	96.78	96.51	96.72	1041016.0
2018-05-18 13:00:00	MSFT	Stock	96.725	96.737	96.43	96.54	1001113.0
2018-05-18 14:00:00	MSFT	Stock	96.54	96.6	96.4	96.525	815869.0
2018-05-18 15:00:00	MSFT	Stock	96.525	96.6	96.33	96.36	2670257.0
2018-05-18 16:00:00	MSFT	Stock	96.36	96.4	96.27	96.36	3166862.0
2018-05-18 17:00:00	MSFT	Stock	96.34	96.37	96.34	96.36	1473.0
2018-05-18 18:00:00	MSFT	Stock	96.34	96.34	96.31	96.31	517.0
2018-05-18 19:00:00	MSFT	Stock	96.34	96.35	96.3	96.35	1025.0
2018-05-18 05:00:00	NVDA	Stock	6.2328	6.247	6.2328	6.247	36000.0
2018-05-18 06:00:00	NVDA	Stock	6.247	6.247	6.247	6.247	4000.0
2018-05-18 07:00:00	NVDA	Stock	6.25	6.25	6.236	6.245	755760.0
2018-05-18 08:00:00	NVDA	Stock	6.2462	6.2738	6.2325	6.2438	5788560.0
2018-05-18 09:00:00	NVDA	Stock	6.2432	6.3093	6.2262	6.2639	99144040.0
2018-05-18 10:00:00	NVDA	Stock	6.265	6.303	6.2	6.2355	88287080.0
2018-05-18 11:00:00	NVDA	Stock	6.2358	6.2982	6.2303	6.2506	49763880.0
2018-05-18 12:00:00	NVDA	Stock	6.25	6.2508	6.2232	6.2374	34123760.0
2018-05-18 13:00:00	NVDA	Stock	6.2375	6.2417	6.188	6.1911	41375640.0
2018-05-18 14:00:00	NVDA	Stock	6.1917	6.2008	6.169	6.1743	41185480.0
2018-05-18 15:00:00	NVDA	Stock	6.175	6.1785	6.1435	6.1478	62965840.0
2018-05-18 16:00:00	NVDA	Stock	6.1485	6.1485	6.1388	6.145	13043600.0
2018-05-18 17:00:00	NVDA	Stock	6.1468	6.1468	6.139	6.1435	337200.0
2018-05-18 18:00:00	NVDA	Stock	6.139	6.1458	6.1375	6.145	320040.0
2018-05-18 19:00:00	NVDA	Stock	6.1448	6.1468	6.1375	6.1418	368040.0
2018-05-18 07:00:00	AMZN	Stock	79.3875	79.3875	79.2	79.31	58040.0
2018-05-18 08:00:00	AMZN	Stock	79.308	79.308	78.85	78.85	474020.0
2018-05-18 09:00:00	AMZN	Stock	78.8785	79.148	78.7192	78.7866	7722820.0
2018-05-18 10:00:00	AMZN	Stock	78.825	78.9855	78.6335	78.703	7499660.0
2018-05-18 11:00:00	AMZN	Stock	78.7455	79.1795	78.6695	79.0485	6449480.0

> showing 50 of 49,158 rows — these rows as CSV

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