PREVIEW / stock_1hour / 2016-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-13.parquet
  size:    1.0 MB
  rows:    49,055
  symbols: 3,340

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-04-13 04:00:00	AAPL	Stock	27.6275	27.735	27.6275	27.7225	22384.0
2016-04-13 05:00:00	AAPL	Stock	27.735	27.8	27.735	27.785	23064.0
2016-04-13 06:00:00	AAPL	Stock	27.7575	27.8	27.7575	27.765	15176.0
2016-04-13 07:00:00	AAPL	Stock	27.775	27.8125	27.765	27.795	84888.0
2016-04-13 08:00:00	AAPL	Stock	27.78	27.8	27.7	27.7425	339324.0
2016-04-13 09:00:00	AAPL	Stock	27.745	27.9625	27.69	27.8725	19712780.0
2016-04-13 10:00:00	AAPL	Stock	27.877	27.995	27.8625	27.905	20768248.0
2016-04-13 11:00:00	AAPL	Stock	27.9	28.05	27.8625	28.015	20766932.0
2016-04-13 12:00:00	AAPL	Stock	28.0175	28.0225	27.93	27.955	7206924.0
2016-04-13 13:00:00	AAPL	Stock	27.955	28.025	27.9025	28.02	10902444.0
2016-04-13 14:00:00	AAPL	Stock	28.02	28.085	27.985	28.015	14008364.0
2016-04-13 15:00:00	AAPL	Stock	28.015	28.08	27.9775	28.01	21060944.0
2016-04-13 16:00:00	AAPL	Stock	28.01	28.0175	27.9925	28.0025	5349908.0
2016-04-13 17:00:00	AAPL	Stock	27.9925	28.025	27.985	28.025	181580.0
2016-04-13 18:00:00	AAPL	Stock	28.0125	28.025	28.0125	28.0125	13440.0
2016-04-13 19:00:00	AAPL	Stock	28.015	28.0425	28.0125	28.0325	51472.0
2016-04-13 05:00:00	MSFT	Stock	54.89	54.89	54.89	54.89	100.0
2016-04-13 07:00:00	MSFT	Stock	54.97	54.97	54.97	54.97	200.0
2016-04-13 08:00:00	MSFT	Stock	54.98	55.02	54.9	54.96	9671.0
2016-04-13 09:00:00	MSFT	Stock	54.99	55.32	54.93	55.21	2621403.0
2016-04-13 10:00:00	MSFT	Stock	55.22	55.29	54.975	54.99	2584331.0
2016-04-13 11:00:00	MSFT	Stock	54.99	55.21	54.95	55.105	2229774.0
2016-04-13 12:00:00	MSFT	Stock	55.105	55.145	54.995	55.0	1512987.0
2016-04-13 13:00:00	MSFT	Stock	55.0	55.09	54.89	55.06	2143121.0
2016-04-13 14:00:00	MSFT	Stock	55.06	55.24	55.02	55.195	1662354.0
2016-04-13 15:00:00	MSFT	Stock	55.19	55.438	55.18	55.35	4021576.0
2016-04-13 16:00:00	MSFT	Stock	55.35	55.37	55.3	55.36	1875969.0
2016-04-13 17:00:00	MSFT	Stock	55.35	55.35	55.35	55.35	146030.0
2016-04-13 18:00:00	MSFT	Stock	55.3	55.3	55.3	55.3	360.0
2016-04-13 19:00:00	MSFT	Stock	55.32	55.34	55.28	55.32	3506.0
2016-04-13 08:00:00	NVDA	Stock	0.9033	0.9033	0.9033	0.9033	16000.0
2016-04-13 09:00:00	NVDA	Stock	0.9	0.9141	0.899	0.9118	37322560.0
2016-04-13 10:00:00	NVDA	Stock	0.9118	0.9125	0.9055	0.9072	47276680.0
2016-04-13 11:00:00	NVDA	Stock	0.907	0.9125	0.9065	0.9095	30076720.0
2016-04-13 12:00:00	NVDA	Stock	0.9098	0.9113	0.908	0.9088	38102800.0
2016-04-13 13:00:00	NVDA	Stock	0.9088	0.911	0.9072	0.9102	36805240.0
2016-04-13 14:00:00	NVDA	Stock	0.91	0.911	0.9076	0.9108	33738360.0
2016-04-13 15:00:00	NVDA	Stock	0.911	0.9188	0.9108	0.9185	102302400.0
2016-04-13 16:00:00	NVDA	Stock	0.9185	0.9222	0.9182	0.9213	1073200.0
2016-04-13 17:00:00	NVDA	Stock	0.9182	0.9182	0.9182	0.9182	4000.0
2016-04-13 18:00:00	NVDA	Stock	0.9185	0.9185	0.916	0.916	8000.0
2016-04-13 19:00:00	NVDA	Stock	0.9235	0.9235	0.9235	0.9235	5000.0
2016-04-13 04:00:00	AMZN	Stock	30.225	30.225	30.201	30.225	22000.0
2016-04-13 07:00:00	AMZN	Stock	30.2855	30.36	30.2855	30.36	64520.0
2016-04-13 08:00:00	AMZN	Stock	30.343	30.377	30.2945	30.35	317020.0
2016-04-13 09:00:00	AMZN	Stock	30.35	30.7845	30.2645	30.7595	16189280.0
2016-04-13 10:00:00	AMZN	Stock	30.7648	30.8405	30.581	30.6455	14453240.0
2016-04-13 11:00:00	AMZN	Stock	30.631	30.7405	30.5625	30.5875	6433840.0
2016-04-13 12:00:00	AMZN	Stock	30.589	30.7085	30.5005	30.6615	6406200.0
2016-04-13 13:00:00	AMZN	Stock	30.6665	30.7195	30.546	30.6715	6316740.0

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

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