PREVIEW / stock_1hour / 2018-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-12.parquet
  size:    1.1 MB
  rows:    50,295
  symbols: 2,894

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-02-12 04:00:00	AAPL	Stock	39.4125	39.85	39.4125	39.705	21448.0
2018-02-12 05:00:00	AAPL	Stock	39.6225	39.625	39.555	39.6175	28660.0
2018-02-12 06:00:00	AAPL	Stock	39.55	39.7	39.465	39.4975	39288.0
2018-02-12 07:00:00	AAPL	Stock	39.525	39.7125	39.4675	39.68	326428.0
2018-02-12 08:00:00	AAPL	Stock	39.7	39.7375	39.1025	39.6	700972.0
2018-02-12 09:00:00	AAPL	Stock	39.5975	40.075	39.25	39.895	32516040.0
2018-02-12 10:00:00	AAPL	Stock	39.895	40.2075	39.6925	40.1925	34539788.0
2018-02-12 11:00:00	AAPL	Stock	40.1925	40.53	40.1375	40.5225	28121088.0
2018-02-12 12:00:00	AAPL	Stock	40.5222	40.7175	40.4575	40.625	21714516.0
2018-02-12 13:00:00	AAPL	Stock	40.6325	40.7475	40.4625	40.7168	13876928.0
2018-02-12 14:00:00	AAPL	Stock	40.7175	40.8188	40.625	40.7762	17814528.0
2018-02-12 15:00:00	AAPL	Stock	40.7775	40.9725	40.59	40.6875	35788932.0
2018-02-12 16:00:00	AAPL	Stock	40.6775	40.73	40.67	40.715	17992740.0
2018-02-12 17:00:00	AAPL	Stock	40.7175	40.725	40.7	40.7125	70320.0
2018-02-12 18:00:00	AAPL	Stock	40.7125	40.7425	40.685	40.685	55884.0
2018-02-12 19:00:00	AAPL	Stock	40.7	40.7	40.6375	40.6625	63328.0
2018-02-12 04:00:00	MSFT	Stock	87.8	89.13	87.8	89.13	7782.0
2018-02-12 05:00:00	MSFT	Stock	89.32	89.34	89.32	89.34	1100.0
2018-02-12 06:00:00	MSFT	Stock	89.34	89.66	89.01	89.01	4317.0
2018-02-12 07:00:00	MSFT	Stock	89.19	89.44	88.98	89.1	23765.0
2018-02-12 08:00:00	MSFT	Stock	89.3	89.34	88.18	88.79	102270.0
2018-02-12 09:00:00	MSFT	Stock	88.5	89.3	88.18	88.72	4561491.0
2018-02-12 10:00:00	MSFT	Stock	88.72	89.22	87.93	88.355	4418978.0
2018-02-12 11:00:00	MSFT	Stock	88.36	89.26	88.205	89.15	4300060.0
2018-02-12 12:00:00	MSFT	Stock	89.15	89.31	88.79	88.95	2743480.0
2018-02-12 13:00:00	MSFT	Stock	88.96	89.43	88.71	89.37	2235507.0
2018-02-12 14:00:00	MSFT	Stock	89.37	89.5	88.96	89.29	2818384.0
2018-02-12 15:00:00	MSFT	Stock	89.29	89.78	88.87	89.15	6391913.0
2018-02-12 16:00:00	MSFT	Stock	89.13	89.35	89.1	89.25	6023397.0
2018-02-12 17:00:00	MSFT	Stock	89.3	89.45	89.15	89.15	7776.0
2018-02-12 18:00:00	MSFT	Stock	89.16	89.22	89.16	89.2	700.0
2018-02-12 19:00:00	MSFT	Stock	89.24	89.35	89.08	89.15	3068.0
2018-02-12 04:00:00	NVDA	Stock	5.8125	5.8125	5.8125	5.8125	116320.0
2018-02-12 05:00:00	NVDA	Stock	5.889	5.9108	5.8835	5.8998	464400.0
2018-02-12 06:00:00	NVDA	Stock	5.911	5.927	5.8802	5.8802	750720.0
2018-02-12 07:00:00	NVDA	Stock	5.8865	5.9198	5.8828	5.9025	1614400.0
2018-02-12 08:00:00	NVDA	Stock	5.9062	5.925	5.8788	5.8863	6559600.0
2018-02-12 09:00:00	NVDA	Stock	5.8863	5.8938	5.7388	5.7618	155212040.0
2018-02-12 10:00:00	NVDA	Stock	5.7623	5.7952	5.6305	5.6901	269611720.0
2018-02-12 11:00:00	NVDA	Stock	5.69	5.7472	5.6568	5.7174	123210920.0
2018-02-12 12:00:00	NVDA	Stock	5.7175	5.7198	5.65	5.674	86150680.0
2018-02-12 13:00:00	NVDA	Stock	5.679	5.6848	5.6258	5.6655	87325440.0
2018-02-12 14:00:00	NVDA	Stock	5.6658	5.765	5.645	5.7396	132548160.0
2018-02-12 15:00:00	NVDA	Stock	5.7422	5.7748	5.6695	5.7005	116054720.0
2018-02-12 16:00:00	NVDA	Stock	5.7008	5.7118	5.6878	5.703	17461440.0
2018-02-12 17:00:00	NVDA	Stock	5.705	5.7075	5.702	5.7053	306240.0
2018-02-12 18:00:00	NVDA	Stock	5.7053	5.7085	5.6978	5.6978	673720.0
2018-02-12 19:00:00	NVDA	Stock	5.6975	5.7013	5.69	5.6962	345160.0
2018-02-12 04:00:00	AMZN	Stock	67.55	68.35	67.55	68.3	69300.0
2018-02-12 05:00:00	AMZN	Stock	68.25	68.45	68.2495	68.45	63380.0

> showing 50 of 50,295 rows — these rows as CSV

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