PREVIEW / stock_1hour / 2017-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-24.parquet
  size:    1.0 MB
  rows:    48,708
  symbols: 3,099

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-02-24 04:00:00	AAPL	Stock	34.0375	34.0375	33.8775	33.88	21724.0
2017-02-24 05:00:00	AAPL	Stock	33.87	33.87	33.655	33.715	39276.0
2017-02-24 06:00:00	AAPL	Stock	33.7175	33.825	33.665	33.665	103016.0
2017-02-24 07:00:00	AAPL	Stock	33.665	33.825	33.655	33.78	162748.0
2017-02-24 08:00:00	AAPL	Stock	33.8225	33.875	33.655	33.83	480800.0
2017-02-24 09:00:00	AAPL	Stock	33.825	34.025	33.7925	33.9575	17633800.0
2017-02-24 10:00:00	AAPL	Stock	33.9562	33.9825	33.82	33.95	13815124.0
2017-02-24 11:00:00	AAPL	Stock	33.95	33.9975	33.9338	33.9625	6892856.0
2017-02-24 12:00:00	AAPL	Stock	33.9612	34.0625	33.9452	34.0375	7465496.0
2017-02-24 13:00:00	AAPL	Stock	34.0375	34.05	34.0075	34.0362	3646068.0
2017-02-24 14:00:00	AAPL	Stock	34.035	34.0388	33.99	33.9988	4971376.0
2017-02-24 15:00:00	AAPL	Stock	34.0	34.1625	33.98	34.16	16588316.0
2017-02-24 16:00:00	AAPL	Stock	34.165	34.1725	34.1425	34.1625	7197568.0
2017-02-24 17:00:00	AAPL	Stock	34.1625	34.165	34.15	34.16	215120.0
2017-02-24 18:00:00	AAPL	Stock	34.15	34.15	34.1475	34.1475	11800.0
2017-02-24 19:00:00	AAPL	Stock	34.15	34.165	34.15	34.1575	22200.0
2017-02-24 05:00:00	MSFT	Stock	64.16	64.16	64.16	64.16	100.0
2017-02-24 06:00:00	MSFT	Stock	64.15	64.16	64.15	64.16	1483.0
2017-02-24 07:00:00	MSFT	Stock	64.21	64.34	64.21	64.24	4000.0
2017-02-24 08:00:00	MSFT	Stock	64.28	64.3	64.17	64.25	47873.0
2017-02-24 09:00:00	MSFT	Stock	64.25	64.77	64.16	64.74	3538518.0
2017-02-24 10:00:00	MSFT	Stock	64.745	64.8	64.41	64.465	3351995.0
2017-02-24 11:00:00	MSFT	Stock	64.47	64.56	64.4	64.41	1354896.0
2017-02-24 12:00:00	MSFT	Stock	64.414	64.48	64.305	64.31	1450893.0
2017-02-24 13:00:00	MSFT	Stock	64.31	64.33	64.135	64.22	1927647.0
2017-02-24 14:00:00	MSFT	Stock	64.215	64.28	64.195	64.235	1105367.0
2017-02-24 15:00:00	MSFT	Stock	64.23	64.62	64.19	64.62	5032973.0
2017-02-24 16:00:00	MSFT	Stock	64.62	64.62	64.47	64.55	2675019.0
2017-02-24 17:00:00	MSFT	Stock	64.62	64.62	64.51	64.51	71551.0
2017-02-24 18:00:00	MSFT	Stock	64.51	64.51	64.51	64.51	300.0
2017-02-24 19:00:00	MSFT	Stock	64.52	64.52	64.51	64.51	700.0
2017-02-24 04:00:00	NVDA	Stock	2.4658	2.4675	2.444	2.4568	416520.0
2017-02-24 05:00:00	NVDA	Stock	2.4538	2.4612	2.4538	2.4612	489120.0
2017-02-24 06:00:00	NVDA	Stock	2.4538	2.455	2.445	2.4525	756640.0
2017-02-24 07:00:00	NVDA	Stock	2.4525	2.4525	2.4243	2.428	1978080.0
2017-02-24 08:00:00	NVDA	Stock	2.4313	2.45	2.405	2.4178	16299600.0
2017-02-24 09:00:00	NVDA	Stock	2.4168	2.4968	2.3925	2.4828	273918560.0
2017-02-24 10:00:00	NVDA	Stock	2.4828	2.535	2.459	2.508	254057880.0
2017-02-24 11:00:00	NVDA	Stock	2.5078	2.5275	2.5	2.5185	99882480.0
2017-02-24 12:00:00	NVDA	Stock	2.5185	2.5453	2.51	2.5312	88249520.0
2017-02-24 13:00:00	NVDA	Stock	2.5314	2.55	2.5208	2.5331	79603920.0
2017-02-24 14:00:00	NVDA	Stock	2.5332	2.5385	2.5225	2.5342	43452960.0
2017-02-24 15:00:00	NVDA	Stock	2.5347	2.54	2.5235	2.5348	79442400.0
2017-02-24 16:00:00	NVDA	Stock	2.5365	2.5408	2.5305	2.539	37357960.0
2017-02-24 17:00:00	NVDA	Stock	2.5405	2.5405	2.5282	2.535	949320.0
2017-02-24 18:00:00	NVDA	Stock	2.5328	2.5363	2.5305	2.5325	62800.0
2017-02-24 19:00:00	NVDA	Stock	2.535	2.5415	2.535	2.5413	319160.0
2017-02-24 04:00:00	AMZN	Stock	42.25	42.35	42.25	42.35	9140.0
2017-02-24 06:00:00	AMZN	Stock	42.3515	42.3515	42.3115	42.3115	22320.0
2017-02-24 07:00:00	AMZN	Stock	42.277	42.3055	42.235	42.235	147020.0

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

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