PREVIEW / stock_1hour / 2014-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-17.parquet
  size:    1.1 MB
  rows:    49,388
  symbols: 3,562

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
2014-12-17 04:00:00	AAPL	Stock	26.8	26.82	26.775	26.7975	8400.0
2014-12-17 05:00:00	AAPL	Stock	26.7575	26.84	26.7575	26.8225	65288.0
2014-12-17 06:00:00	AAPL	Stock	26.805	26.945	26.775	26.94	41556.0
2014-12-17 07:00:00	AAPL	Stock	26.925	26.9275	26.85	26.9125	319768.0
2014-12-17 08:00:00	AAPL	Stock	26.9075	26.95	26.6875	26.8225	1203072.0
2014-12-17 09:00:00	AAPL	Stock	26.82	26.95	26.705	26.9225	22538288.0
2014-12-17 10:00:00	AAPL	Stock	26.9225	26.96	26.7225	26.7525	25170128.0
2014-12-17 11:00:00	AAPL	Stock	26.753	27.0075	26.715	27.0052	24891904.0
2014-12-17 12:00:00	AAPL	Stock	27.005	27.0075	26.825	26.8575	15433832.0
2014-12-17 13:00:00	AAPL	Stock	26.855	26.975	26.78	26.975	13113160.0
2014-12-17 14:00:00	AAPL	Stock	26.9725	27.3272	26.94	27.1338	40190580.0
2014-12-17 15:00:00	AAPL	Stock	27.1358	27.46	27.015	27.35	41677512.0
2014-12-17 16:00:00	AAPL	Stock	27.3375	27.375	26.7392	27.3725	2403712.0
2014-12-17 17:00:00	AAPL	Stock	27.3725	27.4	27.3525	27.3875	272076.0
2014-12-17 18:00:00	AAPL	Stock	27.3875	27.4075	27.3525	27.395	295088.0
2014-12-17 19:00:00	AAPL	Stock	27.4	27.4375	27.3875	27.4375	147596.0
2014-12-17 05:00:00	MSFT	Stock	45.34	45.35	45.34	45.35	1000.0
2014-12-17 06:00:00	MSFT	Stock	45.34	45.34	45.22	45.29	2900.0
2014-12-17 07:00:00	MSFT	Stock	45.37	45.38	45.36	45.38	700.0
2014-12-17 08:00:00	MSFT	Stock	45.43	45.43	45.35	45.35	16689.0
2014-12-17 09:00:00	MSFT	Stock	45.35	45.46	44.9	45.18	4172298.0
2014-12-17 10:00:00	MSFT	Stock	45.17	45.27	45.0	45.06	3795825.0
2014-12-17 11:00:00	MSFT	Stock	45.06	45.67	45.05	45.62	3828910.0
2014-12-17 12:00:00	MSFT	Stock	45.62	45.62	45.19	45.36	2467382.0
2014-12-17 13:00:00	MSFT	Stock	45.36	45.44	45.26	45.44	2088266.0
2014-12-17 14:00:00	MSFT	Stock	45.43	45.92	45.38	45.57	5161581.0
2014-12-17 15:00:00	MSFT	Stock	45.57	45.945	45.38	45.74	5830682.0
2014-12-17 16:00:00	MSFT	Stock	45.74	45.78	45.25	45.639	1401954.0
2014-12-17 17:00:00	MSFT	Stock	45.9	45.98	45.78	45.78	1843.0
2014-12-17 18:00:00	MSFT	Stock	45.84	45.84	45.8	45.8	1082.0
2014-12-17 19:00:00	MSFT	Stock	45.76	45.83	45.76	45.83	1077.0
2014-12-17 09:00:00	NVDA	Stock	0.4935	0.4975	0.4775	0.4843	20408880.0
2014-12-17 10:00:00	NVDA	Stock	0.4843	0.4848	0.4815	0.484	25857280.0
2014-12-17 11:00:00	NVDA	Stock	0.4843	0.4923	0.4839	0.492	32595520.0
2014-12-17 12:00:00	NVDA	Stock	0.4923	0.4925	0.4898	0.4905	27029800.0
2014-12-17 13:00:00	NVDA	Stock	0.4908	0.4945	0.4905	0.4945	32320000.0
2014-12-17 14:00:00	NVDA	Stock	0.4942	0.499	0.494	0.4982	63348480.0
2014-12-17 15:00:00	NVDA	Stock	0.4982	0.5043	0.4965	0.5038	122823600.0
2014-12-17 16:00:00	NVDA	Stock	0.5035	0.5035	0.5035	0.5035	15487120.0
2014-12-17 05:00:00	AMZN	Stock	14.825	14.825	14.825	14.825	20000.0
2014-12-17 06:00:00	AMZN	Stock	14.7855	14.7855	14.7855	14.7855	2000.0
2014-12-17 07:00:00	AMZN	Stock	14.825	14.85	14.825	14.85	9820.0
2014-12-17 08:00:00	AMZN	Stock	14.7975	14.8495	14.7905	14.8435	162300.0
2014-12-17 09:00:00	AMZN	Stock	14.8	14.9435	14.765	14.8523	10667660.0
2014-12-17 10:00:00	AMZN	Stock	14.859	14.884	14.6515	14.7745	13364800.0
2014-12-17 11:00:00	AMZN	Stock	14.7865	14.8185	14.7565	14.776	6898240.0
2014-12-17 12:00:00	AMZN	Stock	14.78	14.863	14.7495	14.8245	7686360.0
2014-12-17 13:00:00	AMZN	Stock	14.825	14.8847	14.789	14.8847	6053860.0
2014-12-17 14:00:00	AMZN	Stock	14.8735	14.9835	14.8601	14.8865	20672100.0
2014-12-17 15:00:00	AMZN	Stock	14.8835	14.982	14.8274	14.941	13186280.0

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

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