PREVIEW / stock_1hour / 2016-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-25.parquet
  size:    709 KB
  rows:    30,165
  symbols: 3,084

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
2016-11-25 04:00:00	AAPL	Stock	27.6775	27.7	27.6125	27.7	2000.0
2016-11-25 06:00:00	AAPL	Stock	27.75	27.75	27.7425	27.7425	3680.0
2016-11-25 07:00:00	AAPL	Stock	27.745	27.7675	27.745	27.76	8368.0
2016-11-25 08:00:00	AAPL	Stock	27.78	27.8	27.775	27.7825	55808.0
2016-11-25 09:00:00	AAPL	Stock	27.7875	27.8975	27.7375	27.88	10598400.0
2016-11-25 10:00:00	AAPL	Stock	27.88	27.8825	27.7675	27.84	8421488.0
2016-11-25 11:00:00	AAPL	Stock	27.84	27.9575	27.835	27.9562	9040464.0
2016-11-25 12:00:00	AAPL	Stock	27.9562	27.9675	27.8775	27.945	10599552.0
2016-11-25 13:00:00	AAPL	Stock	27.945	27.955	27.925	27.937	3827348.0
2016-11-25 14:00:00	AAPL	Stock	27.935	27.945	27.9175	27.945	15976.0
2016-11-25 15:00:00	AAPL	Stock	27.945	28.0	27.9425	27.9475	96052.0
2016-11-25 16:00:00	AAPL	Stock	27.9325	27.95	27.9325	27.9375	11200.0
2016-11-25 06:00:00	MSFT	Stock	60.24	60.25	60.24	60.25	798.0
2016-11-25 08:00:00	MSFT	Stock	60.46	60.46	60.4	60.42	3828.0
2016-11-25 09:00:00	MSFT	Stock	60.42	60.46	60.13	60.4	1588289.0
2016-11-25 10:00:00	MSFT	Stock	60.41	60.425	60.3	60.4	1083014.0
2016-11-25 11:00:00	MSFT	Stock	60.4	60.48	60.32	60.34	1361758.0
2016-11-25 12:00:00	MSFT	Stock	60.345	60.53	60.29	60.53	2327086.0
2016-11-25 13:00:00	MSFT	Stock	60.52	60.541	60.322	60.42	1509281.0
2016-11-25 14:00:00	MSFT	Stock	60.43	60.5	60.43	60.5	1075.0
2016-11-25 15:00:00	MSFT	Stock	60.5	60.53	60.35	60.35	1440.0
2016-11-25 16:00:00	MSFT	Stock	60.25	60.25	60.25	60.25	140.0
2016-11-25 04:00:00	NVDA	Stock	2.3625	2.3625	2.355	2.3612	73840.0
2016-11-25 07:00:00	NVDA	Stock	2.3612	2.3625	2.3612	2.3625	129040.0
2016-11-25 08:00:00	NVDA	Stock	2.3675	2.3675	2.3588	2.3602	350600.0
2016-11-25 09:00:00	NVDA	Stock	2.3602	2.3775	2.3352	2.3418	49543880.0
2016-11-25 10:00:00	NVDA	Stock	2.3415	2.3588	2.3385	2.3458	35506960.0
2016-11-25 11:00:00	NVDA	Stock	2.3458	2.3505	2.3408	2.349	31972920.0
2016-11-25 12:00:00	NVDA	Stock	2.349	2.3568	2.3455	2.3538	52614320.0
2016-11-25 13:00:00	NVDA	Stock	2.354	2.355	2.352	2.354	14255320.0
2016-11-25 14:00:00	NVDA	Stock	2.356	2.3565	2.356	2.3565	147720.0
2016-11-25 15:00:00	NVDA	Stock	2.3562	2.3582	2.3512	2.3512	136880.0
2016-11-25 16:00:00	NVDA	Stock	2.3475	2.3475	2.3475	2.3475	6320.0
2016-11-25 07:00:00	AMZN	Stock	39.1225	39.1885	39.1225	39.167	51840.0
2016-11-25 08:00:00	AMZN	Stock	39.1995	39.3195	39.1225	39.2705	260700.0
2016-11-25 09:00:00	AMZN	Stock	39.26	39.3375	39.1265	39.2123	8463260.0
2016-11-25 10:00:00	AMZN	Stock	39.2215	39.2485	38.978	39.0095	7610420.0
2016-11-25 11:00:00	AMZN	Stock	39.0095	39.0525	38.895	38.9675	5327200.0
2016-11-25 12:00:00	AMZN	Stock	38.979	39.033	38.9553	39.025	7094160.0
2016-11-25 13:00:00	AMZN	Stock	39.005	39.035	38.9785	38.9985	2125700.0
2016-11-25 14:00:00	AMZN	Stock	38.998	39.0236	38.975	39.02	83320.0
2016-11-25 15:00:00	AMZN	Stock	39.0	39.0245	39.0	39.0245	10000.0
2016-11-25 07:00:00	GOOGL	Stock	39.1095	39.1095	39.1095	39.1095	4000.0
2016-11-25 08:00:00	GOOGL	Stock	39.1095	39.1095	39.1	39.1	37380.0
2016-11-25 09:00:00	GOOGL	Stock	39.0205	39.145	38.9095	39.065	1750000.0
2016-11-25 10:00:00	GOOGL	Stock	39.076	39.089	38.9625	39.0437	1391640.0
2016-11-25 11:00:00	GOOGL	Stock	39.0428	39.0905	39.012	39.0225	1516660.0
2016-11-25 12:00:00	GOOGL	Stock	39.017	39.07	38.931	39.0075	2423160.0
2016-11-25 13:00:00	GOOGL	Stock	39.0115	39.0125	38.95	38.95	1225540.0
2016-11-25 15:00:00	GOOGL	Stock	38.9925	38.9925	38.95	38.95	5880.0

> showing 50 of 30,165 rows — these rows as CSV

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