PREVIEW / stock_1hour / 2013-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-06.parquet
  size:    952 KB
  rows:    44,732
  symbols: 3,460

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-02-06 04:00:00	AAPL	Stock	16.3754	16.3754	16.375	16.375	5600.0
2013-02-06 05:00:00	AAPL	Stock	16.3307	16.3311	16.2643	16.2857	115220.0
2013-02-06 06:00:00	AAPL	Stock	16.2964	16.3536	16.2964	16.325	73696.0
2013-02-06 07:00:00	AAPL	Stock	16.3214	16.3461	16.2782	16.3021	483392.0
2013-02-06 08:00:00	AAPL	Stock	16.2871	16.3393	16.2039	16.3057	3179792.0
2013-02-06 09:00:00	AAPL	Stock	16.3054	16.4193	16.2375	16.2636	74711252.0
2013-02-06 10:00:00	AAPL	Stock	16.2627	16.5679	16.1636	16.5057	146703284.0
2013-02-06 11:00:00	AAPL	Stock	16.5111	16.6607	16.48	16.5525	132244420.0
2013-02-06 12:00:00	AAPL	Stock	16.5571	16.5614	16.38	16.4089	60532920.0
2013-02-06 13:00:00	AAPL	Stock	16.4029	16.408	16.3039	16.3375	55132308.0
2013-02-06 14:00:00	AAPL	Stock	16.3361	16.4029	16.3161	16.3725	34933668.0
2013-02-06 15:00:00	AAPL	Stock	16.3746	16.4164	16.3114	16.3316	54230988.0
2013-02-06 16:00:00	AAPL	Stock	16.3299	16.4734	16.3221	16.3389	14693280.0
2013-02-06 17:00:00	AAPL	Stock	16.3339	16.3339	16.2925	16.2964	1306844.0
2013-02-06 18:00:00	AAPL	Stock	16.2946	16.3125	16.275	16.2857	587216.0
2013-02-06 19:00:00	AAPL	Stock	16.2868	16.3339	16.2861	16.3036	574252.0
2013-02-06 07:00:00	MSFT	Stock	27.56	27.56	27.5	27.5	400.0
2013-02-06 08:00:00	MSFT	Stock	27.4	27.59	27.33	27.45	32096.0
2013-02-06 09:00:00	MSFT	Stock	27.42	27.49	27.345	27.46	4531842.0
2013-02-06 10:00:00	MSFT	Stock	27.455	27.48	27.4	27.45	6095822.0
2013-02-06 11:00:00	MSFT	Stock	27.45	27.535	27.44	27.496	4255491.0
2013-02-06 12:00:00	MSFT	Stock	27.5	27.54	27.48	27.49	3857934.0
2013-02-06 13:00:00	MSFT	Stock	27.495	27.5	27.29	27.295	6503903.0
2013-02-06 14:00:00	MSFT	Stock	27.295	27.32	27.26	27.315	4928734.0
2013-02-06 15:00:00	MSFT	Stock	27.31	27.348	27.25	27.34	7246047.0
2013-02-06 16:00:00	MSFT	Stock	27.34	27.532	27.3	27.34	3803955.0
2013-02-06 17:00:00	MSFT	Stock	27.34	27.464	27.3	27.3	25147.0
2013-02-06 18:00:00	MSFT	Stock	27.33	27.33	27.31	27.31	10235.0
2013-02-06 19:00:00	MSFT	Stock	27.32	27.33	27.32	27.33	6203.0
2013-02-06 06:00:00	NVDA	Stock	0.3078	0.3078	0.3075	0.3075	36000.0
2013-02-06 08:00:00	NVDA	Stock	0.3083	0.3083	0.3038	0.3038	2504160.0
2013-02-06 09:00:00	NVDA	Stock	0.3048	0.3088	0.3	0.307	151852720.0
2013-02-06 10:00:00	NVDA	Stock	0.3069	0.311	0.3064	0.308	128772880.0
2013-02-06 11:00:00	NVDA	Stock	0.308	0.31	0.308	0.3085	47910960.0
2013-02-06 12:00:00	NVDA	Stock	0.3085	0.3098	0.3083	0.3098	27869040.0
2013-02-06 13:00:00	NVDA	Stock	0.3098	0.3098	0.3085	0.3091	32012280.0
2013-02-06 14:00:00	NVDA	Stock	0.309	0.3095	0.3075	0.3083	43469880.0
2013-02-06 15:00:00	NVDA	Stock	0.3085	0.3093	0.308	0.3085	79805320.0
2013-02-06 16:00:00	NVDA	Stock	0.3085	0.3093	0.3074	0.3085	3018040.0
2013-02-06 17:00:00	NVDA	Stock	0.3078	0.308	0.3078	0.308	24000.0
2013-02-06 18:00:00	NVDA	Stock	0.3083	0.3085	0.3083	0.3083	76000.0
2013-02-06 19:00:00	NVDA	Stock	0.3083	0.3085	0.3083	0.3083	56000.0
2013-02-06 06:00:00	AMZN	Stock	13.3995	13.4	13.3995	13.4	5980.0
2013-02-06 07:00:00	AMZN	Stock	13.369	13.369	13.3315	13.3315	11960.0
2013-02-06 08:00:00	AMZN	Stock	13.3205	13.321	13.246	13.2475	162240.0
2013-02-06 09:00:00	AMZN	Stock	13.2485	13.3445	13.2485	13.264	7906360.0
2013-02-06 10:00:00	AMZN	Stock	13.2725	13.308	13.117	13.2036	14223880.0
2013-02-06 11:00:00	AMZN	Stock	13.206	13.235	13.161	13.2	5987240.0
2013-02-06 12:00:00	AMZN	Stock	13.201	13.206	13.1105	13.1125	5565160.0
2013-02-06 13:00:00	AMZN	Stock	13.1145	13.131	13.0555	13.0945	5756300.0

> showing 50 of 44,732 rows — these rows as CSV

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