PREVIEW / stock_1hour / 2018-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-24.parquet
  size:    1.1 MB
  rows:    48,731
  symbols: 2,855

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-04-24 04:00:00	AAPL	Stock	41.4975	41.5425	41.3725	41.5425	36040.0
2018-04-24 05:00:00	AAPL	Stock	41.5425	41.5425	41.525	41.525	2308.0
2018-04-24 06:00:00	AAPL	Stock	41.55	41.575	41.5	41.5625	24020.0
2018-04-24 07:00:00	AAPL	Stock	41.54	41.5725	41.425	41.4575	280280.0
2018-04-24 08:00:00	AAPL	Stock	41.5575	41.575	41.385	41.4375	316012.0
2018-04-24 09:00:00	AAPL	Stock	41.4375	41.5825	41.19	41.325	16293232.0
2018-04-24 10:00:00	AAPL	Stock	41.32	41.3625	40.8575	41.045	21888268.0
2018-04-24 11:00:00	AAPL	Stock	41.0475	41.155	40.91	40.92	13696976.0
2018-04-24 12:00:00	AAPL	Stock	40.9175	41.045	40.59	40.5925	13635488.0
2018-04-24 13:00:00	AAPL	Stock	40.59	40.835	40.52	40.5802	12930460.0
2018-04-24 14:00:00	AAPL	Stock	40.5775	40.725	40.305	40.6655	15593768.0
2018-04-24 15:00:00	AAPL	Stock	40.6675	40.77	40.485	40.735	18180204.0
2018-04-24 16:00:00	AAPL	Stock	40.7	40.7775	40.5095	40.7675	7028536.0
2018-04-24 17:00:00	AAPL	Stock	40.77	40.775	40.705	40.7725	68032.0
2018-04-24 18:00:00	AAPL	Stock	40.74	40.79	40.74	40.7875	16000.0
2018-04-24 19:00:00	AAPL	Stock	40.78	40.79	40.7625	40.77	18244.0
2018-04-24 06:00:00	MSFT	Stock	96.21	96.21	96.2	96.2	600.0
2018-04-24 07:00:00	MSFT	Stock	96.05	96.25	96.01	96.23	15031.0
2018-04-24 08:00:00	MSFT	Stock	96.2	96.24	96.0	96.1	18226.0
2018-04-24 09:00:00	MSFT	Stock	96.07	96.47	95.5	95.78	2648465.0
2018-04-24 10:00:00	MSFT	Stock	95.785	96.18	95.04	95.26	3352162.0
2018-04-24 11:00:00	MSFT	Stock	95.25	95.29	94.37	94.39	3060881.0
2018-04-24 12:00:00	MSFT	Stock	94.38	94.63	93.41	93.41	3469193.0
2018-04-24 13:00:00	MSFT	Stock	93.42	93.66	92.96	93.116	4217936.0
2018-04-24 14:00:00	MSFT	Stock	93.11	93.125	92.41	93.014	4302002.0
2018-04-24 15:00:00	MSFT	Stock	93.01	93.39	92.55	93.08	5592887.0
2018-04-24 16:00:00	MSFT	Stock	93.12	93.48	93.12	93.39	5373951.0
2018-04-24 17:00:00	MSFT	Stock	93.33	93.38	93.24	93.33	7384.0
2018-04-24 18:00:00	MSFT	Stock	93.23	93.37	93.22	93.31	3566.0
2018-04-24 19:00:00	MSFT	Stock	93.3	93.37	93.22	93.37	6343.0
2018-04-24 04:00:00	NVDA	Stock	5.613	5.625	5.6125	5.625	84720.0
2018-04-24 05:00:00	NVDA	Stock	5.6375	5.6382	5.6225	5.6325	167200.0
2018-04-24 06:00:00	NVDA	Stock	5.6325	5.6525	5.6325	5.6525	110920.0
2018-04-24 07:00:00	NVDA	Stock	5.6488	5.6545	5.642	5.6438	382800.0
2018-04-24 08:00:00	NVDA	Stock	5.6472	5.65	5.6212	5.6325	784240.0
2018-04-24 09:00:00	NVDA	Stock	5.6332	5.72	5.6062	5.6983	67209800.0
2018-04-24 10:00:00	NVDA	Stock	5.697	5.7158	5.6203	5.625	71249640.0
2018-04-24 11:00:00	NVDA	Stock	5.6258	5.6469	5.5783	5.5952	44777200.0
2018-04-24 12:00:00	NVDA	Stock	5.597	5.6051	5.4793	5.5043	67564320.0
2018-04-24 13:00:00	NVDA	Stock	5.5028	5.5409	5.483	5.4958	36049280.0
2018-04-24 14:00:00	NVDA	Stock	5.496	5.5153	5.464	5.5015	32651120.0
2018-04-24 15:00:00	NVDA	Stock	5.5052	5.5433	5.497	5.531	42655240.0
2018-04-24 16:00:00	NVDA	Stock	5.53	5.5612	5.53	5.55	14886720.0
2018-04-24 17:00:00	NVDA	Stock	5.55	5.561	5.53	5.561	720280.0
2018-04-24 18:00:00	NVDA	Stock	5.55	5.5562	5.55	5.5562	48080.0
2018-04-24 19:00:00	NVDA	Stock	5.5595	5.56	5.5475	5.5575	200400.0
2018-04-24 04:00:00	AMZN	Stock	76.45	76.6	76.45	76.6	8000.0
2018-04-24 05:00:00	AMZN	Stock	76.797	76.797	76.7945	76.7945	4340.0
2018-04-24 06:00:00	AMZN	Stock	76.875	76.875	76.875	76.875	4000.0
2018-04-24 07:00:00	AMZN	Stock	76.776	76.85	76.6	76.75	381700.0

> showing 50 of 48,731 rows — these rows as CSV

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