PREVIEW / stock_1hour / 2013-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-24.parquet
  size:    1.0 MB
  rows:    48,376
  symbols: 3,534

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
2013-10-24 04:00:00	AAPL	Stock	18.7857	18.8179	18.7857	18.8179	18200.0
2013-10-24 05:00:00	AAPL	Stock	18.8036	18.8532	18.8036	18.8125	34356.0
2013-10-24 06:00:00	AAPL	Stock	18.8393	18.8557	18.8175	18.8557	114604.0
2013-10-24 07:00:00	AAPL	Stock	18.8721	18.8829	18.7839	18.7839	595336.0
2013-10-24 08:00:00	AAPL	Stock	18.7686	18.8571	18.7321	18.7643	2142952.0
2013-10-24 09:00:00	AAPL	Stock	18.75	18.8282	18.6589	18.7089	45647252.0
2013-10-24 10:00:00	AAPL	Stock	18.7157	18.8354	18.7	18.8086	52176936.0
2013-10-24 11:00:00	AAPL	Stock	18.8077	18.9811	18.8011	18.9679	69319572.0
2013-10-24 12:00:00	AAPL	Stock	18.967	18.9893	18.8786	18.9443	55426784.0
2013-10-24 13:00:00	AAPL	Stock	18.9446	18.9707	18.9211	18.9395	22952216.0
2013-10-24 14:00:00	AAPL	Stock	18.9417	19.0157	18.9358	19.0118	37307900.0
2013-10-24 15:00:00	AAPL	Stock	19.0111	19.0168	18.9479	18.9955	47945296.0
2013-10-24 16:00:00	AAPL	Stock	18.9979	19.0982	18.7225	19.0875	13837852.0
2013-10-24 17:00:00	AAPL	Stock	19.0946	19.095	18.9968	19.0718	32672136.0
2013-10-24 18:00:00	AAPL	Stock	19.0679	19.075	18.9979	19.0696	134848.0
2013-10-24 19:00:00	AAPL	Stock	19.0643	19.0718	19.0536	19.0679	421988.0
2013-10-24 07:00:00	MSFT	Stock	33.89	33.89	33.89	33.89	200.0
2013-10-24 08:00:00	MSFT	Stock	34.0	34.02	33.75	33.75	78627.0
2013-10-24 09:00:00	MSFT	Stock	33.71	33.87	33.57	33.72	6082066.0
2013-10-24 10:00:00	MSFT	Stock	33.713	34.1	33.71	34.015	7198071.0
2013-10-24 11:00:00	MSFT	Stock	34.02	34.08	33.94	33.955	4238597.0
2013-10-24 12:00:00	MSFT	Stock	33.95	34.08	33.91	34.05	4146318.0
2013-10-24 13:00:00	MSFT	Stock	34.055	34.08	33.99	34.009	4458944.0
2013-10-24 14:00:00	MSFT	Stock	34.0	34.01	33.92	33.937	3808122.0
2013-10-24 15:00:00	MSFT	Stock	33.94	33.94	33.72	33.72	12220123.0
2013-10-24 16:00:00	MSFT	Stock	33.73	36.21	33.716	35.65	8283507.0
2013-10-24 17:00:00	MSFT	Stock	35.65	36.0	35.5	35.99	889829.0
2013-10-24 18:00:00	MSFT	Stock	35.96	35.99	35.1	35.5	517361.0
2013-10-24 19:00:00	MSFT	Stock	35.58	35.68	35.5	35.51	93258.0
2013-10-24 09:00:00	NVDA	Stock	0.3885	0.391	0.3862	0.3865	12933280.0
2013-10-24 10:00:00	NVDA	Stock	0.3865	0.3876	0.3842	0.3846	31212280.0
2013-10-24 11:00:00	NVDA	Stock	0.3845	0.386	0.3841	0.3858	25135120.0
2013-10-24 12:00:00	NVDA	Stock	0.3859	0.3878	0.3853	0.3876	23314400.0
2013-10-24 13:00:00	NVDA	Stock	0.3878	0.388	0.3862	0.3865	15612640.0
2013-10-24 14:00:00	NVDA	Stock	0.3862	0.3865	0.3856	0.386	10431320.0
2013-10-24 15:00:00	NVDA	Stock	0.3858	0.3862	0.3845	0.3845	88721120.0
2013-10-24 16:00:00	NVDA	Stock	0.3848	0.3883	0.379	0.3883	16360160.0
2013-10-24 04:00:00	AMZN	Stock	16.3875	16.3975	16.3875	16.3975	4000.0
2013-10-24 07:00:00	AMZN	Stock	16.46	16.46	16.4305	16.4395	57100.0
2013-10-24 08:00:00	AMZN	Stock	16.4375	16.4625	16.3485	16.4125	351020.0
2013-10-24 09:00:00	AMZN	Stock	16.4125	16.586	16.4	16.426	9648000.0
2013-10-24 10:00:00	AMZN	Stock	16.4325	16.5065	16.3375	16.5065	8669780.0
2013-10-24 11:00:00	AMZN	Stock	16.5055	16.5795	16.476	16.5435	6995060.0
2013-10-24 12:00:00	AMZN	Stock	16.547	16.5985	16.536	16.5565	5558300.0
2013-10-24 13:00:00	AMZN	Stock	16.5568	16.562	16.45	16.465	5920440.0
2013-10-24 14:00:00	AMZN	Stock	16.4745	16.6325	16.4575	16.6215	8502300.0
2013-10-24 15:00:00	AMZN	Stock	16.6178	16.625	16.503	16.59	20935580.0
2013-10-24 16:00:00	AMZN	Stock	16.6105	18.2	16.5	17.9	38352320.0
2013-10-24 17:00:00	AMZN	Stock	17.905	18.0725	17.77	17.98	6430820.0
2013-10-24 18:00:00	AMZN	Stock	17.9845	18.035	17.925	17.975	1314300.0

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

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