PREVIEW / stock_1hour / 2013-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-01.parquet
  size:    978 KB
  rows:    46,015
  symbols: 3,461

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-01 04:00:00	AAPL	Stock	16.3886	16.3929	16.3886	16.3907	16800.0
2013-02-01 06:00:00	AAPL	Stock	16.3525	16.3564	16.3214	16.3214	16800.0
2013-02-01 07:00:00	AAPL	Stock	16.3214	16.4018	16.3214	16.3679	379372.0
2013-02-01 08:00:00	AAPL	Stock	16.3661	16.4107	16.325	16.3929	2537612.0
2013-02-01 09:00:00	AAPL	Stock	16.3889	16.41	16.12	16.1332	86762788.0
2013-02-01 10:00:00	AAPL	Stock	16.135	16.2246	16.0125	16.0514	102689020.0
2013-02-01 11:00:00	AAPL	Stock	16.0529	16.1686	16.0268	16.1496	64832516.0
2013-02-01 12:00:00	AAPL	Stock	16.1493	16.2811	16.1379	16.2643	64622040.0
2013-02-01 13:00:00	AAPL	Stock	16.2621	16.3118	16.2193	16.2929	39743956.0
2013-02-01 14:00:00	AAPL	Stock	16.29	16.3014	16.1621	16.2161	45999044.0
2013-02-01 15:00:00	AAPL	Stock	16.215	16.2254	16.1121	16.2057	81177740.0
2013-02-01 16:00:00	AAPL	Stock	16.2046	16.2143	16.1151	16.2107	26836012.0
2013-02-01 17:00:00	AAPL	Stock	16.2075	16.2143	16.2007	16.2143	406224.0
2013-02-01 18:00:00	AAPL	Stock	16.15	16.2143	16.15	16.1929	280924.0
2013-02-01 19:00:00	AAPL	Stock	16.1929	16.2089	16.1839	16.2075	196364.0
2013-02-01 04:00:00	MSFT	Stock	27.59	27.59	27.59	27.59	100.0
2013-02-01 06:00:00	MSFT	Stock	27.58	27.58	27.58	27.58	600.0
2013-02-01 07:00:00	MSFT	Stock	27.58	27.58	27.58	27.58	200.0
2013-02-01 08:00:00	MSFT	Stock	27.55	27.67	27.45	27.67	102400.0
2013-02-01 09:00:00	MSFT	Stock	27.67	27.71	27.55	27.697	4900127.0
2013-02-01 10:00:00	MSFT	Stock	27.695	27.89	27.69	27.825	9078891.0
2013-02-01 11:00:00	MSFT	Stock	27.825	27.94	27.8	27.905	7188777.0
2013-02-01 12:00:00	MSFT	Stock	27.91	28.0	27.89	27.95	4027012.0
2013-02-01 13:00:00	MSFT	Stock	27.945	28.05	27.89	27.91	6893364.0
2013-02-01 14:00:00	MSFT	Stock	27.915	27.99	27.89	27.91	5106620.0
2013-02-01 15:00:00	MSFT	Stock	27.91	27.965	27.81	27.93	12828600.0
2013-02-01 16:00:00	MSFT	Stock	27.92	27.988	27.8	27.87	3520740.0
2013-02-01 17:00:00	MSFT	Stock	27.88	27.93	27.87	27.9	24117.0
2013-02-01 18:00:00	MSFT	Stock	27.9	27.91	27.9	27.9	10705.0
2013-02-01 19:00:00	MSFT	Stock	27.91	27.91	27.89	27.9	528.0
2013-02-01 05:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	4000.0
2013-02-01 08:00:00	NVDA	Stock	0.31	0.31	0.3095	0.3095	44000.0
2013-02-01 09:00:00	NVDA	Stock	0.3075	0.3103	0.3065	0.3073	28747960.0
2013-02-01 10:00:00	NVDA	Stock	0.3073	0.3098	0.307	0.3098	46956000.0
2013-02-01 11:00:00	NVDA	Stock	0.3095	0.3098	0.307	0.3085	46020480.0
2013-02-01 12:00:00	NVDA	Stock	0.3085	0.3088	0.307	0.3085	24767760.0
2013-02-01 13:00:00	NVDA	Stock	0.3085	0.31	0.3084	0.3098	32343200.0
2013-02-01 14:00:00	NVDA	Stock	0.3098	0.3098	0.3083	0.3088	32306920.0
2013-02-01 15:00:00	NVDA	Stock	0.309	0.3093	0.3085	0.3093	63777160.0
2013-02-01 16:00:00	NVDA	Stock	0.3093	0.3093	0.3087	0.3093	11810760.0
2013-02-01 17:00:00	NVDA	Stock	0.3088	0.3088	0.3088	0.3088	12000.0
2013-02-01 18:00:00	NVDA	Stock	0.309	0.309	0.3088	0.3088	20000.0
2013-02-01 19:00:00	NVDA	Stock	0.3078	0.3078	0.3078	0.3078	4000.0
2013-02-01 04:00:00	AMZN	Stock	13.3255	13.3325	13.3255	13.3325	6000.0
2013-02-01 05:00:00	AMZN	Stock	13.3875	13.3875	13.3875	13.3875	2000.0
2013-02-01 06:00:00	AMZN	Stock	13.3675	13.3675	13.35	13.35	4000.0
2013-02-01 07:00:00	AMZN	Stock	13.35	13.364	13.35	13.364	18000.0
2013-02-01 08:00:00	AMZN	Stock	13.375	13.45	13.275	13.444	529100.0
2013-02-01 09:00:00	AMZN	Stock	13.441	13.4465	13.215	13.215	18564200.0
2013-02-01 10:00:00	AMZN	Stock	13.234	13.2845	13.14	13.249	26300160.0

> showing 50 of 46,015 rows — these rows as CSV

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