PREVIEW / stock_1hour / 2012-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-27.parquet
  size:    954 KB
  rows:    45,136
  symbols: 3,532

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-02-27 04:00:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	33600.0
2012-02-27 05:00:00	AAPL	Stock	18.5804	18.5804	18.5571	18.5571	16800.0
2012-02-27 06:00:00	AAPL	Stock	18.565	18.5714	18.5571	18.5571	31080.0
2012-02-27 07:00:00	AAPL	Stock	18.5675	18.6032	18.5571	18.5711	316932.0
2012-02-27 08:00:00	AAPL	Stock	18.5714	18.6361	18.5714	18.6268	2665544.0
2012-02-27 09:00:00	AAPL	Stock	18.6318	18.6536	18.4386	18.5204	88622408.0
2012-02-27 10:00:00	AAPL	Stock	18.5179	18.6607	18.5014	18.6221	88615884.0
2012-02-27 11:00:00	AAPL	Stock	18.6204	18.7407	18.6139	18.7175	73134124.0
2012-02-27 12:00:00	AAPL	Stock	18.7182	18.7971	18.6996	18.7864	71825572.0
2012-02-27 13:00:00	AAPL	Stock	18.7864	18.7921	18.7521	18.7729	34997956.0
2012-02-27 14:00:00	AAPL	Stock	18.7721	18.8564	18.7721	18.8519	59269560.0
2012-02-27 15:00:00	AAPL	Stock	18.8546	18.875	18.7339	18.7786	113657012.0
2012-02-27 16:00:00	AAPL	Stock	18.7789	18.8074	18.7006	18.7786	9025128.0
2012-02-27 17:00:00	AAPL	Stock	18.7771	18.7918	18.7714	18.7857	870156.0
2012-02-27 18:00:00	AAPL	Stock	18.7807	18.785	18.7714	18.78	336560.0
2012-02-27 19:00:00	AAPL	Stock	18.78	18.7921	18.7729	18.7921	859404.0
2012-02-27 04:00:00	MSFT	Stock	31.45	31.45	31.45	31.45	200.0
2012-02-27 08:00:00	MSFT	Stock	31.36	31.4	31.35	31.4	4400.0
2012-02-27 09:00:00	MSFT	Stock	31.4	31.4	31.1	31.16	5563888.0
2012-02-27 10:00:00	MSFT	Stock	31.16	31.42	31.15	31.37	4451765.0
2012-02-27 11:00:00	MSFT	Stock	31.37	31.48	31.36	31.41	6146370.0
2012-02-27 12:00:00	MSFT	Stock	31.402	31.5	31.4	31.495	3493295.0
2012-02-27 13:00:00	MSFT	Stock	31.49	31.5	31.37	31.395	2400458.0
2012-02-27 14:00:00	MSFT	Stock	31.393	31.45	31.39	31.429	2349057.0
2012-02-27 15:00:00	MSFT	Stock	31.42	31.49	31.35	31.36	7027689.0
2012-02-27 16:00:00	MSFT	Stock	31.36	31.484	31.33	31.35	2262529.0
2012-02-27 17:00:00	MSFT	Stock	31.32	31.35	31.29	31.29	138078.0
2012-02-27 18:00:00	MSFT	Stock	31.32	31.35	31.31	31.34	7570.0
2012-02-27 19:00:00	MSFT	Stock	31.32	31.32	31.3	31.3	6308.0
2012-02-27 20:00:00	MSFT	Stock	31.29	31.29	31.29	31.29	400.0
2012-02-27 08:00:00	NVDA	Stock	0.3938	0.3938	0.3922	0.3922	169200.0
2012-02-27 09:00:00	NVDA	Stock	0.391	0.3925	0.3838	0.3848	98562640.0
2012-02-27 10:00:00	NVDA	Stock	0.3848	0.3862	0.3811	0.3825	162882560.0
2012-02-27 11:00:00	NVDA	Stock	0.3825	0.3864	0.3825	0.3848	111159200.0
2012-02-27 12:00:00	NVDA	Stock	0.3848	0.388	0.3835	0.3875	73219160.0
2012-02-27 13:00:00	NVDA	Stock	0.3875	0.3879	0.3854	0.3862	58788720.0
2012-02-27 14:00:00	NVDA	Stock	0.3862	0.3886	0.3858	0.3882	78479080.0
2012-02-27 15:00:00	NVDA	Stock	0.3882	0.389	0.3868	0.3868	137199760.0
2012-02-27 16:00:00	NVDA	Stock	0.3868	0.3888	0.3838	0.3868	17822240.0
2012-02-27 17:00:00	NVDA	Stock	0.3859	0.3885	0.3859	0.3868	667600.0
2012-02-27 18:00:00	NVDA	Stock	0.386	0.386	0.386	0.386	12000.0
2012-02-27 19:00:00	NVDA	Stock	0.3888	0.3888	0.3878	0.3878	92000.0
2012-02-27 07:00:00	AMZN	Stock	8.895	8.895	8.885	8.885	12000.0
2012-02-27 08:00:00	AMZN	Stock	8.92	8.92	8.8725	8.895	75780.0
2012-02-27 09:00:00	AMZN	Stock	8.895	8.9305	8.825	8.9092	14851060.0
2012-02-27 10:00:00	AMZN	Stock	8.9055	8.9225	8.8683	8.9035	10346820.0
2012-02-27 11:00:00	AMZN	Stock	8.906	8.95	8.892	8.939	9706300.0
2012-02-27 12:00:00	AMZN	Stock	8.941	8.9545	8.912	8.915	9098980.0
2012-02-27 13:00:00	AMZN	Stock	8.9145	8.925	8.8885	8.9025	6551960.0
2012-02-27 14:00:00	AMZN	Stock	8.906	8.9375	8.9025	8.9375	6569920.0

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

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