PREVIEW / stock_1hour / 2013-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-07.parquet
  size:    947 KB
  rows:    44,314
  symbols: 3,467

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-07 04:00:00	AAPL	Stock	16.2964	16.2964	16.2964	16.2964	13944.0
2013-02-07 05:00:00	AAPL	Stock	16.2957	16.2982	16.2957	16.2982	14560.0
2013-02-07 06:00:00	AAPL	Stock	16.3296	16.33	16.2857	16.3286	45360.0
2013-02-07 07:00:00	AAPL	Stock	16.3036	16.3036	16.2411	16.2411	173124.0
2013-02-07 08:00:00	AAPL	Stock	16.2493	16.645	16.1964	16.5814	21716352.0
2013-02-07 09:00:00	AAPL	Stock	16.5736	16.6071	16.2965	16.3446	94485104.0
2013-02-07 10:00:00	AAPL	Stock	16.345	16.4054	16.2186	16.2843	90058584.0
2013-02-07 11:00:00	AAPL	Stock	16.2843	16.3864	16.2611	16.3144	56483140.0
2013-02-07 12:00:00	AAPL	Stock	16.3146	16.4614	16.3079	16.4157	58099020.0
2013-02-07 13:00:00	AAPL	Stock	16.4136	16.4257	16.3232	16.3571	34241536.0
2013-02-07 14:00:00	AAPL	Stock	16.3571	16.3857	16.2996	16.361	32798836.0
2013-02-07 15:00:00	AAPL	Stock	16.3607	16.7857	16.275	16.7232	273359464.0
2013-02-07 16:00:00	AAPL	Stock	16.7221	16.7464	16.3059	16.6936	21635376.0
2013-02-07 17:00:00	AAPL	Stock	16.6936	16.7339	16.6936	16.7264	1519980.0
2013-02-07 18:00:00	AAPL	Stock	16.7279	16.7321	16.6932	16.7143	932652.0
2013-02-07 19:00:00	AAPL	Stock	16.7136	16.7411	16.7129	16.7411	889252.0
2013-02-07 07:00:00	MSFT	Stock	27.33	27.33	27.26	27.26	739.0
2013-02-07 08:00:00	MSFT	Stock	27.37	27.4	27.37	27.38	44878.0
2013-02-07 09:00:00	MSFT	Stock	27.38	27.39	27.25	27.305	3978590.0
2013-02-07 10:00:00	MSFT	Stock	27.31	27.32	27.1	27.168	8928319.0
2013-02-07 11:00:00	MSFT	Stock	27.17	27.2	27.11	27.145	4597628.0
2013-02-07 12:00:00	MSFT	Stock	27.15	27.22	27.14	27.2	2805102.0
2013-02-07 13:00:00	MSFT	Stock	27.195	27.28	27.16	27.26	3094137.0
2013-02-07 14:00:00	MSFT	Stock	27.265	27.29	27.175	27.225	3200877.0
2013-02-07 15:00:00	MSFT	Stock	27.226	27.29	27.15	27.29	7383355.0
2013-02-07 16:00:00	MSFT	Stock	27.28	27.46	27.168	27.37	3102941.0
2013-02-07 17:00:00	MSFT	Stock	27.39	27.4	27.29	27.33	27859.0
2013-02-07 18:00:00	MSFT	Stock	27.33	27.33	27.33	27.33	2135.0
2013-02-07 19:00:00	MSFT	Stock	27.3	27.35	27.28	27.35	5828.0
2013-02-07 07:00:00	NVDA	Stock	0.3083	0.3083	0.3083	0.3083	12000.0
2013-02-07 08:00:00	NVDA	Stock	0.306	0.306	0.306	0.306	44160.0
2013-02-07 09:00:00	NVDA	Stock	0.3078	0.31	0.306	0.3078	51741280.0
2013-02-07 10:00:00	NVDA	Stock	0.3078	0.308	0.3052	0.3068	70815080.0
2013-02-07 11:00:00	NVDA	Stock	0.3068	0.307	0.3042	0.305	65836720.0
2013-02-07 12:00:00	NVDA	Stock	0.305	0.3073	0.3049	0.3071	34272280.0
2013-02-07 13:00:00	NVDA	Stock	0.307	0.3073	0.3055	0.3062	61068440.0
2013-02-07 14:00:00	NVDA	Stock	0.3062	0.3075	0.3058	0.3068	55209840.0
2013-02-07 15:00:00	NVDA	Stock	0.3068	0.3075	0.306	0.3073	92300200.0
2013-02-07 16:00:00	NVDA	Stock	0.3073	0.308	0.3065	0.3068	3744760.0
2013-02-07 19:00:00	NVDA	Stock	0.308	0.308	0.3075	0.308	164000.0
2013-02-07 04:00:00	AMZN	Stock	13.136	13.1465	13.136	13.1465	4000.0
2013-02-07 05:00:00	AMZN	Stock	13.1415	13.1445	13.1415	13.1445	4000.0
2013-02-07 06:00:00	AMZN	Stock	13.175	13.1845	13.175	13.1795	6000.0
2013-02-07 07:00:00	AMZN	Stock	13.172	13.177	13.155	13.155	8000.0
2013-02-07 08:00:00	AMZN	Stock	13.155	13.155	13.111	13.128	192080.0
2013-02-07 09:00:00	AMZN	Stock	13.139	13.205	12.925	12.9525	11570800.0
2013-02-07 10:00:00	AMZN	Stock	12.9536	12.9615	12.7555	12.8585	19926080.0
2013-02-07 11:00:00	AMZN	Stock	12.858	12.9725	12.85	12.9655	13117440.0
2013-02-07 12:00:00	AMZN	Stock	12.965	13.061	12.9605	13.04	8754480.0
2013-02-07 13:00:00	AMZN	Stock	13.04	13.04	12.938	13.0095	5801960.0

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

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