PREVIEW / stock_1hour / 2017-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-05.parquet
  size:    1.1 MB
  rows:    49,511
  symbols: 3,073

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-04-05 05:00:00	AAPL	Stock	36.175	36.175	36.1625	36.1625	1744.0
2017-04-05 06:00:00	AAPL	Stock	36.15	36.15	36.15	36.15	6800.0
2017-04-05 07:00:00	AAPL	Stock	36.1375	36.165	36.125	36.1625	57020.0
2017-04-05 08:00:00	AAPL	Stock	36.1675	36.1825	35.8175	35.9675	1269504.0
2017-04-05 09:00:00	AAPL	Stock	35.965	36.2975	35.9375	36.193	21236964.0
2017-04-05 10:00:00	AAPL	Stock	36.1925	36.3475	36.135	36.32	16107996.0
2017-04-05 11:00:00	AAPL	Stock	36.315	36.3475	36.205	36.3	10163832.0
2017-04-05 12:00:00	AAPL	Stock	36.3	36.3638	36.2825	36.3362	6917060.0
2017-04-05 13:00:00	AAPL	Stock	36.3365	36.365	36.2975	36.3575	6196140.0
2017-04-05 14:00:00	AAPL	Stock	36.355	36.3575	36.2025	36.21	10070148.0
2017-04-05 15:00:00	AAPL	Stock	36.2122	36.2338	35.9525	36.005	23067440.0
2017-04-05 16:00:00	AAPL	Stock	36.005	36.191	35.87	35.8975	4325584.0
2017-04-05 17:00:00	AAPL	Stock	35.8925	36.005	35.8125	35.8625	227764.0
2017-04-05 18:00:00	AAPL	Stock	35.8675	35.8975	35.8375	35.8925	76672.0
2017-04-05 19:00:00	AAPL	Stock	35.8775	35.8925	35.8775	35.88	28764.0
2017-04-05 07:00:00	MSFT	Stock	65.82	65.82	65.82	65.82	100.0
2017-04-05 08:00:00	MSFT	Stock	65.73	65.87	65.73	65.87	2367.0
2017-04-05 09:00:00	MSFT	Stock	65.81	66.3	65.76	66.01	1712166.0
2017-04-05 10:00:00	MSFT	Stock	66.02	66.28	65.96	66.25	2538428.0
2017-04-05 11:00:00	MSFT	Stock	66.255	66.35	66.13	66.13	2269789.0
2017-04-05 12:00:00	MSFT	Stock	66.132	66.22	66.11	66.14	1350456.0
2017-04-05 13:00:00	MSFT	Stock	66.14	66.22	66.07	66.19	2061857.0
2017-04-05 14:00:00	MSFT	Stock	66.19	66.35	65.97	65.98	3204870.0
2017-04-05 15:00:00	MSFT	Stock	65.974	66.07	65.444	65.56	5027918.0
2017-04-05 16:00:00	MSFT	Stock	65.57	65.57	65.43	65.43	1478452.0
2017-04-05 17:00:00	MSFT	Stock	65.53	65.56	65.43	65.56	6631.0
2017-04-05 18:00:00	MSFT	Stock	65.5	65.5	65.45	65.48	1200.0
2017-04-05 19:00:00	MSFT	Stock	65.51	65.51	65.48	65.5	1816.0
2017-04-05 04:00:00	NVDA	Stock	2.5025	2.5053	2.5015	2.5053	32000.0
2017-04-05 05:00:00	NVDA	Stock	2.5075	2.509	2.5075	2.509	16000.0
2017-04-05 06:00:00	NVDA	Stock	2.5095	2.5128	2.5095	2.5128	24720.0
2017-04-05 07:00:00	NVDA	Stock	2.515	2.515	2.5015	2.5038	561160.0
2017-04-05 08:00:00	NVDA	Stock	2.5015	2.52	2.5005	2.517	1678080.0
2017-04-05 09:00:00	NVDA	Stock	2.5173	2.549	2.4875	2.5362	159338520.0
2017-04-05 10:00:00	NVDA	Stock	2.535	2.5373	2.5038	2.5305	142464920.0
2017-04-05 11:00:00	NVDA	Stock	2.5308	2.5442	2.529	2.534	70297560.0
2017-04-05 12:00:00	NVDA	Stock	2.5342	2.5568	2.5338	2.5568	66961360.0
2017-04-05 13:00:00	NVDA	Stock	2.557	2.5593	2.5417	2.5485	57048160.0
2017-04-05 14:00:00	NVDA	Stock	2.5485	2.5533	2.5275	2.5278	51472880.0
2017-04-05 15:00:00	NVDA	Stock	2.5276	2.5358	2.497	2.5003	125984840.0
2017-04-05 16:00:00	NVDA	Stock	2.5003	2.5272	2.4975	2.5008	11140440.0
2017-04-05 17:00:00	NVDA	Stock	2.501	2.501	2.4988	2.5	345000.0
2017-04-05 18:00:00	NVDA	Stock	2.5	2.5025	2.499	2.5	443560.0
2017-04-05 19:00:00	NVDA	Stock	2.5005	2.5025	2.5005	2.5025	40000.0
2017-04-05 04:00:00	AMZN	Stock	45.426	45.426	45.426	45.426	2000.0
2017-04-05 05:00:00	AMZN	Stock	45.505	45.505	45.505	45.505	2480.0
2017-04-05 06:00:00	AMZN	Stock	45.5435	45.5895	45.5435	45.5465	10100.0
2017-04-05 07:00:00	AMZN	Stock	45.4885	45.587	45.4415	45.4415	214340.0
2017-04-05 08:00:00	AMZN	Stock	45.501	45.57	45.455	45.539	527000.0
2017-04-05 09:00:00	AMZN	Stock	45.53	46.0	45.4045	45.9118	25845200.0

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

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