PREVIEW / stock_1hour / 2017-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-20.parquet
  size:    1.0 MB
  rows:    48,051
  symbols: 3,012

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-06-20 04:00:00	AAPL	Stock	36.75	36.8225	36.75	36.8225	6200.0
2017-06-20 05:00:00	AAPL	Stock	36.82	36.82	36.775	36.775	7760.0
2017-06-20 06:00:00	AAPL	Stock	36.7725	36.7725	36.69	36.75	17704.0
2017-06-20 07:00:00	AAPL	Stock	36.7625	36.7725	36.6875	36.7725	89460.0
2017-06-20 08:00:00	AAPL	Stock	36.79	36.79	36.5925	36.625	565428.0
2017-06-20 09:00:00	AAPL	Stock	36.6475	36.7225	36.34	36.355	14791624.0
2017-06-20 10:00:00	AAPL	Stock	36.355	36.5175	36.3175	36.4825	13543524.0
2017-06-20 11:00:00	AAPL	Stock	36.4825	36.485	36.25	36.3575	10869908.0
2017-06-20 12:00:00	AAPL	Stock	36.36	36.4325	36.2625	36.32	7657204.0
2017-06-20 13:00:00	AAPL	Stock	36.32	36.395	36.2838	36.385	6472316.0
2017-06-20 14:00:00	AAPL	Stock	36.3825	36.4288	36.3025	36.3825	7087976.0
2017-06-20 15:00:00	AAPL	Stock	36.3825	36.4875	36.235	36.2525	18477412.0
2017-06-20 16:00:00	AAPL	Stock	36.2525	36.3675	36.2425	36.255	9054664.0
2017-06-20 17:00:00	AAPL	Stock	36.2525	36.285	36.2525	36.2575	29328.0
2017-06-20 18:00:00	AAPL	Stock	36.2575	36.28	36.2525	36.2525	15700.0
2017-06-20 19:00:00	AAPL	Stock	36.2625	36.28	36.255	36.2725	21680.0
2017-06-20 04:00:00	MSFT	Stock	70.9	70.9	70.9	70.9	199.0
2017-06-20 05:00:00	MSFT	Stock	70.87	70.87	70.87	70.87	134.0
2017-06-20 06:00:00	MSFT	Stock	71.0	71.0	71.0	71.0	100.0
2017-06-20 07:00:00	MSFT	Stock	71.09	71.09	70.9	70.9	10100.0
2017-06-20 08:00:00	MSFT	Stock	70.87	71.04	70.52	70.52	4012.0
2017-06-20 09:00:00	MSFT	Stock	70.53	70.87	70.49	70.595	1715894.0
2017-06-20 10:00:00	MSFT	Stock	70.59	70.76	70.44	70.45	2425081.0
2017-06-20 11:00:00	MSFT	Stock	70.46	70.46	69.95	70.075	2351743.0
2017-06-20 12:00:00	MSFT	Stock	70.08	70.25	69.96	70.21	1908722.0
2017-06-20 13:00:00	MSFT	Stock	70.22	70.24	70.01	70.1	1170357.0
2017-06-20 14:00:00	MSFT	Stock	70.09	70.22	69.975	70.2	1446366.0
2017-06-20 15:00:00	MSFT	Stock	70.2	70.29	69.87	69.9	4339933.0
2017-06-20 16:00:00	MSFT	Stock	69.91	70.26	69.88	69.91	3958930.0
2017-06-20 17:00:00	MSFT	Stock	70.1	70.1	70.09	70.09	4239.0
2017-06-20 18:00:00	MSFT	Stock	70.09	70.09	70.09	70.09	100.0
2017-06-20 19:00:00	MSFT	Stock	70.09	70.1	70.09	70.1	750.0
2017-06-20 04:00:00	NVDA	Stock	3.9725	3.98	3.9675	3.975	240080.0
2017-06-20 05:00:00	NVDA	Stock	3.9722	3.9722	3.9642	3.9712	87120.0
2017-06-20 06:00:00	NVDA	Stock	3.9708	3.9745	3.96	3.9625	429480.0
2017-06-20 07:00:00	NVDA	Stock	3.963	3.9738	3.9585	3.9712	1956120.0
2017-06-20 08:00:00	NVDA	Stock	3.9732	3.9745	3.954	3.9612	4816800.0
2017-06-20 09:00:00	NVDA	Stock	3.9588	4.0435	3.9585	4.0052	262336720.0
2017-06-20 10:00:00	NVDA	Stock	4.0051	4.0112	3.9638	3.9858	224492120.0
2017-06-20 11:00:00	NVDA	Stock	3.9853	3.987	3.923	3.9538	165287040.0
2017-06-20 12:00:00	NVDA	Stock	3.9553	3.9655	3.9333	3.9602	92454480.0
2017-06-20 13:00:00	NVDA	Stock	3.96	3.982	3.9528	3.9802	81139800.0
2017-06-20 14:00:00	NVDA	Stock	3.9805	3.9925	3.9593	3.9665	86315480.0
2017-06-20 15:00:00	NVDA	Stock	3.9665	3.979	3.926	3.9275	125418080.0
2017-06-20 16:00:00	NVDA	Stock	3.925	3.9928	3.9135	3.92	19670200.0
2017-06-20 17:00:00	NVDA	Stock	3.9238	3.931	3.92	3.9252	964840.0
2017-06-20 18:00:00	NVDA	Stock	3.9252	3.9295	3.9252	3.9258	336920.0
2017-06-20 19:00:00	NVDA	Stock	3.9272	3.9343	3.9202	3.9343	511080.0
2017-06-20 04:00:00	AMZN	Stock	49.95	49.975	49.95	49.975	9940.0
2017-06-20 05:00:00	AMZN	Stock	49.967	49.9695	49.967	49.9695	5000.0

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

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