PREVIEW / stock_1hour / 2013-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-19.parquet
  size:    983 KB
  rows:    45,816
  symbols: 3,487

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-19 04:00:00	AAPL	Stock	16.4589	16.5089	16.4589	16.5089	16800.0
2013-02-19 05:00:00	AAPL	Stock	16.5071	16.5179	16.5	16.5	42420.0
2013-02-19 06:00:00	AAPL	Stock	16.5071	16.5354	16.5071	16.5089	39340.0
2013-02-19 07:00:00	AAPL	Stock	16.5089	16.5625	16.5029	16.5532	597548.0
2013-02-19 08:00:00	AAPL	Stock	16.5493	16.5625	16.4832	16.5339	1798440.0
2013-02-19 09:00:00	AAPL	Stock	16.5186	16.5261	16.3482	16.3707	69980820.0
2013-02-19 10:00:00	AAPL	Stock	16.3696	16.3768	16.2089	16.239	89069092.0
2013-02-19 11:00:00	AAPL	Stock	16.2364	16.3486	16.2089	16.3366	49739452.0
2013-02-19 12:00:00	AAPL	Stock	16.3412	16.3821	16.2896	16.3768	53690000.0
2013-02-19 13:00:00	AAPL	Stock	16.3789	16.4496	16.3151	16.3229	46755996.0
2013-02-19 14:00:00	AAPL	Stock	16.3271	16.4764	16.3179	16.4157	46663736.0
2013-02-19 15:00:00	AAPL	Stock	16.4161	16.4368	16.3482	16.4271	43959832.0
2013-02-19 16:00:00	AAPL	Stock	16.427	16.4536	16.2373	16.4282	24633196.0
2013-02-19 17:00:00	AAPL	Stock	16.3117	16.4464	16.3117	16.4454	287000.0
2013-02-19 18:00:00	AAPL	Stock	16.4375	16.4464	16.4339	16.4446	146692.0
2013-02-19 19:00:00	AAPL	Stock	16.4361	16.4518	16.4361	16.4411	213976.0
2013-02-19 07:00:00	MSFT	Stock	27.92	27.92	27.85	27.85	950.0
2013-02-19 08:00:00	MSFT	Stock	27.92	27.93	27.86	27.86	24000.0
2013-02-19 09:00:00	MSFT	Stock	27.86	27.99	27.8	27.95	5612029.0
2013-02-19 10:00:00	MSFT	Stock	27.95	28.09	27.95	27.99	6563261.0
2013-02-19 11:00:00	MSFT	Stock	27.99	28.02	27.96	28.0	3203146.0
2013-02-19 12:00:00	MSFT	Stock	28.0	28.0	27.965	27.98	2583175.0
2013-02-19 13:00:00	MSFT	Stock	27.987	28.02	27.92	27.95	2811413.0
2013-02-19 14:00:00	MSFT	Stock	27.95	27.98	27.93	27.97	2805873.0
2013-02-19 15:00:00	MSFT	Stock	27.965	28.055	27.95	28.05	7077882.0
2013-02-19 16:00:00	MSFT	Stock	28.05	28.06	27.95	28.05	6940046.0
2013-02-19 17:00:00	MSFT	Stock	28.018	28.05	28.018	28.05	1300.0
2013-02-19 18:00:00	MSFT	Stock	28.01	28.05	28.01	28.02	565.0
2013-02-19 19:00:00	MSFT	Stock	28.03	28.05	28.03	28.05	1689.0
2013-02-19 07:00:00	NVDA	Stock	0.318	0.318	0.318	0.318	24000.0
2013-02-19 08:00:00	NVDA	Stock	0.3185	0.3188	0.3175	0.3188	228000.0
2013-02-19 09:00:00	NVDA	Stock	0.3195	0.32	0.3158	0.3161	71929280.0
2013-02-19 10:00:00	NVDA	Stock	0.3161	0.3173	0.3146	0.3153	75151680.0
2013-02-19 11:00:00	NVDA	Stock	0.315	0.3163	0.315	0.3155	43050560.0
2013-02-19 12:00:00	NVDA	Stock	0.3155	0.3158	0.314	0.3146	31116400.0
2013-02-19 13:00:00	NVDA	Stock	0.3146	0.3148	0.3125	0.3128	33649080.0
2013-02-19 14:00:00	NVDA	Stock	0.3126	0.3138	0.312	0.3133	58377160.0
2013-02-19 15:00:00	NVDA	Stock	0.3131	0.3143	0.3125	0.3138	93987760.0
2013-02-19 16:00:00	NVDA	Stock	0.314	0.3185	0.313	0.314	23934120.0
2013-02-19 17:00:00	NVDA	Stock	0.3135	0.3135	0.3135	0.3135	40000.0
2013-02-19 18:00:00	NVDA	Stock	0.314	0.314	0.314	0.314	4000.0
2013-02-19 19:00:00	NVDA	Stock	0.3135	0.3135	0.3135	0.3135	4000.0
2013-02-19 05:00:00	AMZN	Stock	13.2445	13.2495	13.235	13.2495	6000.0
2013-02-19 06:00:00	AMZN	Stock	13.255	13.255	13.235	13.235	8000.0
2013-02-19 07:00:00	AMZN	Stock	13.2375	13.2375	13.2295	13.235	12000.0
2013-02-19 08:00:00	AMZN	Stock	13.25	13.274	13.239	13.26	59660.0
2013-02-19 09:00:00	AMZN	Stock	13.26	13.3985	13.225	13.362	8516880.0
2013-02-19 10:00:00	AMZN	Stock	13.351	13.4185	13.303	13.3558	10516860.0
2013-02-19 11:00:00	AMZN	Stock	13.3575	13.3875	13.339	13.3605	7541660.0
2013-02-19 12:00:00	AMZN	Stock	13.365	13.3675	13.3275	13.3675	6363820.0

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

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