PREVIEW / stock_1hour / 2014-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-13.parquet
  size:    1.0 MB
  rows:    48,033
  symbols: 3,541

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-02-13 04:00:00	AAPL	Stock	19.0893	19.0893	18.9546	19.0193	47096.0
2014-02-13 05:00:00	AAPL	Stock	19.0371	19.0371	19.0371	19.0371	11200.0
2014-02-13 06:00:00	AAPL	Stock	19.0357	19.0375	19.0357	19.0371	27272.0
2014-02-13 07:00:00	AAPL	Stock	19.0464	19.0889	19.0357	19.0446	317744.0
2014-02-13 08:00:00	AAPL	Stock	19.0446	19.0679	19.0011	19.0636	1391852.0
2014-02-13 09:00:00	AAPL	Stock	19.0561	19.2554	19.05	19.2082	45156020.0
2014-02-13 10:00:00	AAPL	Stock	19.2082	19.3771	19.1857	19.375	51587704.0
2014-02-13 11:00:00	AAPL	Stock	19.3761	19.3818	19.3193	19.35	28375872.0
2014-02-13 12:00:00	AAPL	Stock	19.3525	19.4018	19.3414	19.3961	21564004.0
2014-02-13 13:00:00	AAPL	Stock	19.3946	19.455	19.3864	19.45	30016504.0
2014-02-13 14:00:00	AAPL	Stock	19.4516	19.4589	19.37	19.4143	29427524.0
2014-02-13 15:00:00	AAPL	Stock	19.4143	19.4436	19.3757	19.4436	35591192.0
2014-02-13 16:00:00	AAPL	Stock	19.4432	19.4478	19.3156	19.4307	11286492.0
2014-02-13 17:00:00	AAPL	Stock	19.4357	19.4518	19.4304	19.4518	317128.0
2014-02-13 18:00:00	AAPL	Stock	19.4339	19.4446	19.4254	19.4439	188664.0
2014-02-13 19:00:00	AAPL	Stock	19.4446	19.4446	19.4286	19.4286	176148.0
2014-02-13 06:00:00	MSFT	Stock	37.38	37.38	37.38	37.38	569.0
2014-02-13 08:00:00	MSFT	Stock	37.42	37.42	37.23	37.24	4958.0
2014-02-13 09:00:00	MSFT	Stock	37.29	37.85	37.24	37.67	4515683.0
2014-02-13 10:00:00	MSFT	Stock	37.673	37.84	37.64	37.79	5223377.0
2014-02-13 11:00:00	MSFT	Stock	37.797	37.86	37.69	37.72	3708992.0
2014-02-13 12:00:00	MSFT	Stock	37.72	37.74	37.69	37.715	2221986.0
2014-02-13 13:00:00	MSFT	Stock	37.715	37.73	37.69	37.72	2854552.0
2014-02-13 14:00:00	MSFT	Stock	37.73	37.76	37.65	37.7	4519107.0
2014-02-13 15:00:00	MSFT	Stock	37.69	37.715	37.55	37.6	9195758.0
2014-02-13 16:00:00	MSFT	Stock	37.61	37.75	37.53	37.58	4338527.0
2014-02-13 17:00:00	MSFT	Stock	37.58	37.58	37.58	37.58	980.0
2014-02-13 18:00:00	MSFT	Stock	37.59	37.61	37.59	37.61	9683.0
2014-02-13 19:00:00	MSFT	Stock	37.59	37.61	37.59	37.61	2460.0
2014-02-13 04:00:00	NVDA	Stock	0.4375	0.4375	0.4375	0.4375	40000.0
2014-02-13 07:00:00	NVDA	Stock	0.4408	0.4412	0.4362	0.4362	386000.0
2014-02-13 08:00:00	NVDA	Stock	0.4425	0.4425	0.4325	0.4352	8512280.0
2014-02-13 09:00:00	NVDA	Stock	0.4362	0.4365	0.4275	0.43	188140240.0
2014-02-13 10:00:00	NVDA	Stock	0.43	0.4316	0.4238	0.4268	176675000.0
2014-02-13 11:00:00	NVDA	Stock	0.4268	0.4305	0.4255	0.4291	103075000.0
2014-02-13 12:00:00	NVDA	Stock	0.4291	0.4312	0.4288	0.43	96477600.0
2014-02-13 13:00:00	NVDA	Stock	0.4298	0.431	0.4274	0.429	64355440.0
2014-02-13 14:00:00	NVDA	Stock	0.429	0.4305	0.4272	0.4288	53000720.0
2014-02-13 15:00:00	NVDA	Stock	0.4288	0.434	0.4282	0.4338	142859400.0
2014-02-13 16:00:00	NVDA	Stock	0.4338	0.435	0.4315	0.434	5622440.0
2014-02-13 18:00:00	NVDA	Stock	0.433	0.433	0.431	0.4328	49880.0
2014-02-13 19:00:00	NVDA	Stock	0.4328	0.4328	0.4328	0.4328	10120.0
2014-02-13 05:00:00	AMZN	Stock	17.425	17.425	17.419	17.419	4000.0
2014-02-13 06:00:00	AMZN	Stock	17.4075	17.4075	17.386	17.386	4000.0
2014-02-13 07:00:00	AMZN	Stock	17.375	17.405	17.375	17.4	32860.0
2014-02-13 08:00:00	AMZN	Stock	17.37	17.4	17.2875	17.3	391500.0
2014-02-13 09:00:00	AMZN	Stock	17.3345	17.635	17.325	17.5665	13905800.0
2014-02-13 10:00:00	AMZN	Stock	17.5665	17.72	17.513	17.706	16347760.0
2014-02-13 11:00:00	AMZN	Stock	17.707	17.7649	17.6955	17.7255	10400760.0
2014-02-13 12:00:00	AMZN	Stock	17.721	17.726	17.6365	17.6915	6533260.0

> showing 50 of 48,033 rows — these rows as CSV

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