PREVIEW / stock_1hour / 2012-02-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-10.parquet
  size:    957 KB
  rows:    45,441
  symbols: 3,532

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
2012-02-10 04:00:00	AAPL	Stock	17.6607	17.6661	17.6607	17.6661	42000.0
2012-02-10 05:00:00	AAPL	Stock	17.6518	17.6518	17.6	17.6	111720.0
2012-02-10 06:00:00	AAPL	Stock	17.6096	17.625	17.6093	17.6093	30380.0
2012-02-10 07:00:00	AAPL	Stock	17.6179	17.6246	17.4561	17.5179	1761452.0
2012-02-10 08:00:00	AAPL	Stock	17.5321	17.6346	17.5	17.5807	5902372.0
2012-02-10 09:00:00	AAPL	Stock	17.5821	17.7721	17.4482	17.6436	155936816.0
2012-02-10 10:00:00	AAPL	Stock	17.6414	17.7143	17.5643	17.6968	122652740.0
2012-02-10 11:00:00	AAPL	Stock	17.6982	17.7536	17.6943	17.7136	66314584.0
2012-02-10 12:00:00	AAPL	Stock	17.7136	17.7325	17.7	17.7182	36466472.0
2012-02-10 13:00:00	AAPL	Stock	17.7182	17.7204	17.5989	17.6054	67371752.0
2012-02-10 14:00:00	AAPL	Stock	17.6039	17.6696	17.5893	17.6461	59309460.0
2012-02-10 15:00:00	AAPL	Stock	17.6461	17.6461	17.5732	17.6318	96036948.0
2012-02-10 16:00:00	AAPL	Stock	17.6304	17.6921	17.6085	17.6593	10586520.0
2012-02-10 17:00:00	AAPL	Stock	17.6568	17.6795	17.6518	17.6607	1385636.0
2012-02-10 18:00:00	AAPL	Stock	17.6607	17.6654	17.6536	17.6643	274652.0
2012-02-10 19:00:00	AAPL	Stock	17.6643	17.6668	17.6589	17.665	410508.0
2012-02-10 07:00:00	MSFT	Stock	30.67	30.67	30.54	30.55	20500.0
2012-02-10 08:00:00	MSFT	Stock	30.6	30.65	30.55	30.6	47350.0
2012-02-10 09:00:00	MSFT	Stock	30.59	30.8	30.55	30.627	5421926.0
2012-02-10 10:00:00	MSFT	Stock	30.62	30.67	30.51	30.61	7114364.0
2012-02-10 11:00:00	MSFT	Stock	30.615	30.69	30.57	30.63	4822102.0
2012-02-10 12:00:00	MSFT	Stock	30.63	30.65	30.58	30.6	3806659.0
2012-02-10 13:00:00	MSFT	Stock	30.59	30.66	30.46	30.5	3902518.0
2012-02-10 14:00:00	MSFT	Stock	30.5	30.58	30.49	30.54	2987103.0
2012-02-10 15:00:00	MSFT	Stock	30.55	30.55	30.36	30.475	9669892.0
2012-02-10 16:00:00	MSFT	Stock	30.5	30.602	30.38	30.5	4694245.0
2012-02-10 17:00:00	MSFT	Stock	30.56	30.568	30.53	30.56	71550.0
2012-02-10 18:00:00	MSFT	Stock	30.53	30.57	30.53	30.57	1262.0
2012-02-10 19:00:00	MSFT	Stock	30.57	30.57	30.57	30.57	572.0
2012-02-10 08:00:00	NVDA	Stock	0.405	0.405	0.4	0.4013	573200.0
2012-02-10 09:00:00	NVDA	Stock	0.401	0.405	0.4	0.4015	53090320.0
2012-02-10 10:00:00	NVDA	Stock	0.4015	0.402	0.3978	0.4015	97798880.0
2012-02-10 11:00:00	NVDA	Stock	0.4015	0.4028	0.4003	0.4008	28984760.0
2012-02-10 12:00:00	NVDA	Stock	0.4008	0.401	0.3988	0.4003	23946520.0
2012-02-10 13:00:00	NVDA	Stock	0.4003	0.4015	0.3975	0.3975	52272240.0
2012-02-10 14:00:00	NVDA	Stock	0.3975	0.3985	0.3962	0.3976	35648960.0
2012-02-10 15:00:00	NVDA	Stock	0.3976	0.398	0.3953	0.3973	122417600.0
2012-02-10 16:00:00	NVDA	Stock	0.3973	0.4075	0.3965	0.3973	19336720.0
2012-02-10 17:00:00	NVDA	Stock	0.3988	0.3988	0.3988	0.3988	17600.0
2012-02-10 18:00:00	NVDA	Stock	0.3962	0.4	0.3955	0.4	23200.0
2012-02-10 19:00:00	NVDA	Stock	0.3965	0.3965	0.3965	0.3965	16800.0
2012-02-10 07:00:00	AMZN	Stock	9.2	9.2	9.1625	9.1625	129500.0
2012-02-10 08:00:00	AMZN	Stock	9.172	9.185	9.139	9.1495	308160.0
2012-02-10 09:00:00	AMZN	Stock	9.1575	9.28	9.126	9.2525	18834600.0
2012-02-10 10:00:00	AMZN	Stock	9.2512	9.3815	9.2435	9.338	33100620.0
2012-02-10 11:00:00	AMZN	Stock	9.3345	9.362	9.297	9.322	15463720.0
2012-02-10 12:00:00	AMZN	Stock	9.325	9.355	9.315	9.3375	10482900.0
2012-02-10 13:00:00	AMZN	Stock	9.3375	9.3385	9.278	9.28	9231900.0
2012-02-10 14:00:00	AMZN	Stock	9.2815	9.305	9.245	9.2565	9294060.0
2012-02-10 15:00:00	AMZN	Stock	9.258	9.282	9.233	9.2815	15489640.0

> showing 50 of 45,441 rows — these rows as CSV

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