PREVIEW / stock_1hour / 2012-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-26.parquet
  size:    924 KB
  rows:    43,700
  symbols: 3,481

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-12-26 07:00:00	AAPL	Stock	18.6468	18.6468	18.6071	18.6136	158340.0
2012-12-26 08:00:00	AAPL	Stock	18.6111	18.6429	18.56	18.57	953904.0
2012-12-26 09:00:00	AAPL	Stock	18.5696	18.5821	18.4439	18.5118	33393612.0
2012-12-26 10:00:00	AAPL	Stock	18.5064	18.5232	18.3239	18.3375	56131208.0
2012-12-26 11:00:00	AAPL	Stock	18.3375	18.3607	18.2543	18.35	55159160.0
2012-12-26 12:00:00	AAPL	Stock	18.3496	18.3571	18.2836	18.355	25837644.0
2012-12-26 13:00:00	AAPL	Stock	18.3511	18.4232	18.3393	18.3832	32597824.0
2012-12-26 14:00:00	AAPL	Stock	18.3825	18.4239	18.3182	18.3811	32505060.0
2012-12-26 15:00:00	AAPL	Stock	18.3746	18.3921	18.2889	18.3179	49421344.0
2012-12-26 16:00:00	AAPL	Stock	18.325	18.3839	18.2896	18.295	7455896.0
2012-12-26 17:00:00	AAPL	Stock	18.295	18.295	18.2793	18.2857	421008.0
2012-12-26 18:00:00	AAPL	Stock	18.2854	18.2857	18.2786	18.2786	130956.0
2012-12-26 19:00:00	AAPL	Stock	18.2768	18.2889	18.2679	18.2707	334516.0
2012-12-26 08:00:00	MSFT	Stock	27.1	27.12	27.08	27.08	5184.0
2012-12-26 09:00:00	MSFT	Stock	27.08	27.2	27.01	27.12	3603207.0
2012-12-26 10:00:00	MSFT	Stock	27.13	27.15	26.82	26.82	5028198.0
2012-12-26 11:00:00	MSFT	Stock	26.825	26.975	26.7	26.945	6016363.0
2012-12-26 12:00:00	MSFT	Stock	26.945	26.95	26.8	26.862	3037472.0
2012-12-26 13:00:00	MSFT	Stock	26.87	26.92	26.8	26.82	3394296.0
2012-12-26 14:00:00	MSFT	Stock	26.83	26.95	26.82	26.92	2919975.0
2012-12-26 15:00:00	MSFT	Stock	26.92	26.93	26.81	26.885	6150073.0
2012-12-26 16:00:00	MSFT	Stock	26.86	26.899	26.86	26.86	1235317.0
2012-12-26 17:00:00	MSFT	Stock	26.86	26.88	26.85	26.85	1329.0
2012-12-26 18:00:00	MSFT	Stock	26.87	26.87	26.86	26.86	5020.0
2012-12-26 19:00:00	MSFT	Stock	26.86	26.86	26.85	26.85	5268.0
2012-12-26 09:00:00	NVDA	Stock	0.3055	0.3105	0.3055	0.3093	28758320.0
2012-12-26 10:00:00	NVDA	Stock	0.3095	0.31	0.3073	0.3078	34309000.0
2012-12-26 11:00:00	NVDA	Stock	0.308	0.308	0.3048	0.307	30827200.0
2012-12-26 12:00:00	NVDA	Stock	0.3073	0.3073	0.3058	0.306	15312080.0
2012-12-26 13:00:00	NVDA	Stock	0.3061	0.3065	0.3058	0.3062	10016280.0
2012-12-26 14:00:00	NVDA	Stock	0.306	0.3073	0.3058	0.3065	22651920.0
2012-12-26 15:00:00	NVDA	Stock	0.3065	0.3068	0.3052	0.306	49199960.0
2012-12-26 16:00:00	NVDA	Stock	0.306	0.306	0.305	0.3052	5361360.0
2012-12-26 17:00:00	NVDA	Stock	0.305	0.305	0.305	0.305	20000.0
2012-12-26 18:00:00	NVDA	Stock	0.3062	0.3062	0.3062	0.3062	4000.0
2012-12-26 19:00:00	NVDA	Stock	0.3058	0.3058	0.3058	0.3058	60000.0
2012-12-26 08:00:00	AMZN	Stock	12.92	12.9255	12.92	12.9225	74040.0
2012-12-26 09:00:00	AMZN	Stock	12.919	12.919	12.7505	12.8072	7801340.0
2012-12-26 10:00:00	AMZN	Stock	12.8064	12.8265	12.6555	12.666	11428280.0
2012-12-26 11:00:00	AMZN	Stock	12.6585	12.67	12.446	12.5345	19865100.0
2012-12-26 12:00:00	AMZN	Stock	12.532	12.539	12.425	12.4593	7977320.0
2012-12-26 13:00:00	AMZN	Stock	12.461	12.474	12.411	12.4125	4457600.0
2012-12-26 14:00:00	AMZN	Stock	12.413	12.485	12.4125	12.484	5627140.0
2012-12-26 15:00:00	AMZN	Stock	12.482	12.514	12.402	12.4395	15730680.0
2012-12-26 16:00:00	AMZN	Stock	12.437	12.6818	12.3815	12.3835	697920.0
2012-12-26 17:00:00	AMZN	Stock	12.386	12.389	12.38	12.389	26700.0
2012-12-26 18:00:00	AMZN	Stock	12.376	12.3815	12.376	12.3815	14000.0
2012-12-26 19:00:00	AMZN	Stock	12.3985	12.3985	12.38	12.397	18740.0
2012-12-26 07:00:00	META	Stock	27.03	27.13	27.0	27.03	27944.0
2012-12-26 08:00:00	META	Stock	27.03	27.31	27.01	27.25	313817.0

> showing 50 of 43,700 rows — these rows as CSV

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