PREVIEW / stock_1hour / 2017-07-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-10.parquet
  size:    1.0 MB
  rows:    47,787
  symbols: 2,990

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-07-10 04:00:00	AAPL	Stock	36.2075	36.2075	36.1375	36.1375	800.0
2017-07-10 05:00:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	432.0
2017-07-10 06:00:00	AAPL	Stock	36.155	36.21	36.15	36.21	4104.0
2017-07-10 07:00:00	AAPL	Stock	36.21	36.2475	36.15	36.175	34560.0
2017-07-10 08:00:00	AAPL	Stock	36.1625	36.215	36.0	36.075	217808.0
2017-07-10 09:00:00	AAPL	Stock	36.0775	36.1325	35.8425	35.87	10532296.0
2017-07-10 10:00:00	AAPL	Stock	35.8675	36.225	35.8575	36.21	11419052.0
2017-07-10 11:00:00	AAPL	Stock	36.2075	36.2475	36.17	36.2112	7121020.0
2017-07-10 12:00:00	AAPL	Stock	36.21	36.38	36.2	36.375	8826672.0
2017-07-10 13:00:00	AAPL	Stock	36.3775	36.4688	36.3675	36.4662	6985976.0
2017-07-10 14:00:00	AAPL	Stock	36.4665	36.4875	36.39	36.4125	5627820.0
2017-07-10 15:00:00	AAPL	Stock	36.4125	36.4275	36.2575	36.2725	15565000.0
2017-07-10 16:00:00	AAPL	Stock	36.265	36.31	36.25	36.25	10500024.0
2017-07-10 17:00:00	AAPL	Stock	36.24	36.25	36.2375	36.25	5544.0
2017-07-10 18:00:00	AAPL	Stock	36.2425	36.25	36.24	36.24	12404.0
2017-07-10 19:00:00	AAPL	Stock	36.24	36.25	36.2375	36.2375	16988.0
2017-07-10 07:00:00	MSFT	Stock	69.65	69.66	69.61	69.61	1609.0
2017-07-10 08:00:00	MSFT	Stock	69.6	69.78	69.6	69.6	15904.0
2017-07-10 09:00:00	MSFT	Stock	69.59	69.96	69.2	69.58	2330234.0
2017-07-10 10:00:00	MSFT	Stock	69.57	70.0	69.55	69.98	2366565.0
2017-07-10 11:00:00	MSFT	Stock	69.98	70.02	69.86	69.97	1776236.0
2017-07-10 12:00:00	MSFT	Stock	69.969	70.05	69.835	69.85	1075392.0
2017-07-10 13:00:00	MSFT	Stock	69.85	70.03	69.82	69.995	937968.0
2017-07-10 14:00:00	MSFT	Stock	69.997	70.1	69.983	70.055	1243667.0
2017-07-10 15:00:00	MSFT	Stock	70.06	70.25	69.98	69.98	2776065.0
2017-07-10 16:00:00	MSFT	Stock	69.98	70.01	69.94	69.94	1627387.0
2017-07-10 17:00:00	MSFT	Stock	69.94	69.94	69.93	69.93	1114.0
2017-07-10 18:00:00	MSFT	Stock	69.95	69.95	69.93	69.93	501.0
2017-07-10 19:00:00	MSFT	Stock	69.95	69.96	69.95	69.95	1175.0
2017-07-10 04:00:00	NVDA	Stock	3.6925	3.73	3.6925	3.7225	393360.0
2017-07-10 05:00:00	NVDA	Stock	3.7225	3.73	3.7225	3.7275	308000.0
2017-07-10 06:00:00	NVDA	Stock	3.7292	3.745	3.7225	3.726	1572240.0
2017-07-10 07:00:00	NVDA	Stock	3.7298	3.74	3.7175	3.7328	2271320.0
2017-07-10 08:00:00	NVDA	Stock	3.7312	3.7468	3.72	3.7328	7399320.0
2017-07-10 09:00:00	NVDA	Stock	3.7338	3.7808	3.7171	3.7278	190818760.0
2017-07-10 10:00:00	NVDA	Stock	3.729	3.7725	3.7212	3.7706	163089080.0
2017-07-10 11:00:00	NVDA	Stock	3.7707	3.7922	3.769	3.7892	119517720.0
2017-07-10 12:00:00	NVDA	Stock	3.7888	3.8062	3.7818	3.8035	91457760.0
2017-07-10 13:00:00	NVDA	Stock	3.8038	3.8198	3.7925	3.8167	95615480.0
2017-07-10 14:00:00	NVDA	Stock	3.816	3.821	3.806	3.8194	61423760.0
2017-07-10 15:00:00	NVDA	Stock	3.8193	3.85	3.8162	3.8428	161918200.0
2017-07-10 16:00:00	NVDA	Stock	3.8425	3.8452	3.788	3.8392	27590520.0
2017-07-10 17:00:00	NVDA	Stock	3.8383	3.8438	3.8375	3.8438	797880.0
2017-07-10 18:00:00	NVDA	Stock	3.8438	3.85	3.8425	3.8425	1237600.0
2017-07-10 19:00:00	NVDA	Stock	3.8425	3.85	3.8425	3.845	737560.0
2017-07-10 04:00:00	AMZN	Stock	49.2115	49.2115	49.2115	49.2115	2000.0
2017-07-10 05:00:00	AMZN	Stock	49.21	49.21	49.21	49.21	2400.0
2017-07-10 06:00:00	AMZN	Stock	49.23	49.23	49.23	49.23	6040.0
2017-07-10 07:00:00	AMZN	Stock	49.2225	49.2225	49.135	49.155	66440.0
2017-07-10 08:00:00	AMZN	Stock	49.167	49.29	49.119	49.242	433060.0

> showing 50 of 47,787 rows — these rows as CSV

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