PREVIEW / stock_1hour / 2014-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-12.parquet
  size:    1.0 MB
  rows:    47,997
  symbols: 3,525

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-06-12 04:00:00	AAPL	Stock	23.475	23.475	23.47	23.47	4000.0
2014-06-12 05:00:00	AAPL	Stock	23.4625	23.485	23.4625	23.4625	4516.0
2014-06-12 06:00:00	AAPL	Stock	23.4625	23.5	23.4625	23.485	25944.0
2014-06-12 07:00:00	AAPL	Stock	23.475	23.5375	23.475	23.5175	103624.0
2014-06-12 08:00:00	AAPL	Stock	23.52	23.5325	23.4775	23.505	541020.0
2014-06-12 09:00:00	AAPL	Stock	23.5	23.53	23.3275	23.4425	24226228.0
2014-06-12 10:00:00	AAPL	Stock	23.4375	23.46	23.265	23.345	25706912.0
2014-06-12 11:00:00	AAPL	Stock	23.345	23.3675	23.27	23.271	15546184.0
2014-06-12 12:00:00	AAPL	Stock	23.27	23.2875	23.07	23.13	33149088.0
2014-06-12 13:00:00	AAPL	Stock	23.13	23.1375	23.0175	23.0625	26508404.0
2014-06-12 14:00:00	AAPL	Stock	23.06	23.0875	22.975	23.0825	27351596.0
2014-06-12 15:00:00	AAPL	Stock	23.0825	23.085	23.0	23.065	34322932.0
2014-06-12 16:00:00	AAPL	Stock	23.0675	23.0725	23.025	23.04	6609080.0
2014-06-12 17:00:00	AAPL	Stock	23.045	23.065	23.04	23.0475	190016.0
2014-06-12 18:00:00	AAPL	Stock	23.0425	23.055	23.035	23.0425	159324.0
2014-06-12 19:00:00	AAPL	Stock	23.0325	23.0375	23.0	23.0125	207660.0
2014-06-12 08:00:00	MSFT	Stock	40.86	40.9	40.86	40.9	1500.0
2014-06-12 09:00:00	MSFT	Stock	40.87	40.88	40.5	40.58	2692864.0
2014-06-12 10:00:00	MSFT	Stock	40.574	40.71	40.457	40.525	3020607.0
2014-06-12 11:00:00	MSFT	Stock	40.526	40.71	40.51	40.592	1896263.0
2014-06-12 12:00:00	MSFT	Stock	40.59	40.69	40.5	40.555	1533749.0
2014-06-12 13:00:00	MSFT	Stock	40.55	40.562	40.4	40.46	3256677.0
2014-06-12 14:00:00	MSFT	Stock	40.45	40.49	40.37	40.38	2369792.0
2014-06-12 15:00:00	MSFT	Stock	40.385	40.6	40.29	40.58	9088906.0
2014-06-12 16:00:00	MSFT	Stock	40.58	41.14	40.322	40.9	4799541.0
2014-06-12 17:00:00	MSFT	Stock	40.82	40.92	40.58	40.82	40145.0
2014-06-12 18:00:00	MSFT	Stock	40.9	40.9	40.84	40.84	2660.0
2014-06-12 19:00:00	MSFT	Stock	40.89	40.89	40.86	40.86	2910.0
2014-06-12 08:00:00	NVDA	Stock	0.485	0.485	0.485	0.485	1460000.0
2014-06-12 09:00:00	NVDA	Stock	0.485	0.485	0.4808	0.4828	25910720.0
2014-06-12 10:00:00	NVDA	Stock	0.4828	0.4871	0.4828	0.4855	52456080.0
2014-06-12 11:00:00	NVDA	Stock	0.4855	0.4875	0.485	0.4875	30322400.0
2014-06-12 12:00:00	NVDA	Stock	0.4874	0.4902	0.4872	0.4886	35598040.0
2014-06-12 13:00:00	NVDA	Stock	0.4885	0.489	0.4855	0.486	28029120.0
2014-06-12 14:00:00	NVDA	Stock	0.486	0.4875	0.4855	0.4864	24497040.0
2014-06-12 15:00:00	NVDA	Stock	0.4864	0.4883	0.485	0.488	68819360.0
2014-06-12 16:00:00	NVDA	Stock	0.4878	0.4935	0.4872	0.4935	3682760.0
2014-06-12 17:00:00	NVDA	Stock	0.4928	0.4932	0.4925	0.4932	120000.0
2014-06-12 18:00:00	NVDA	Stock	0.4932	0.4938	0.4932	0.4938	28000.0
2014-06-12 19:00:00	NVDA	Stock	0.4932	0.4932	0.4932	0.4932	12000.0
2014-06-12 04:00:00	AMZN	Stock	16.7995	16.7995	16.7995	16.7995	2000.0
2014-06-12 06:00:00	AMZN	Stock	16.812	16.842	16.8	16.8	14000.0
2014-06-12 07:00:00	AMZN	Stock	16.8	16.8	16.8	16.8	2000.0
2014-06-12 08:00:00	AMZN	Stock	16.849	16.849	16.715	16.78	253220.0
2014-06-12 09:00:00	AMZN	Stock	16.78	16.8	16.475	16.514	14259720.0
2014-06-12 10:00:00	AMZN	Stock	16.514	16.58	16.402	16.493	15923200.0
2014-06-12 11:00:00	AMZN	Stock	16.4945	16.5275	16.4535	16.4635	7132940.0
2014-06-12 12:00:00	AMZN	Stock	16.463	16.4815	16.4	16.413	6214560.0
2014-06-12 13:00:00	AMZN	Stock	16.422	16.422	16.3348	16.3585	8547960.0
2014-06-12 14:00:00	AMZN	Stock	16.3535	16.41	16.3155	16.327	7807160.0

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

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