PREVIEW / stock_1hour / 2013-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-26.parquet
  size:    960 KB
  rows:    45,091
  symbols: 3,475

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-26 04:00:00	AAPL	Stock	15.8571	15.8714	15.8571	15.8714	27860.0
2013-02-26 05:00:00	AAPL	Stock	15.8393	15.8393	15.8304	15.8321	8400.0
2013-02-26 06:00:00	AAPL	Stock	15.8446	15.8568	15.8446	15.8568	5600.0
2013-02-26 07:00:00	AAPL	Stock	15.875	15.8932	15.8614	15.8661	328356.0
2013-02-26 08:00:00	AAPL	Stock	15.8679	15.8907	15.8071	15.8629	1403304.0
2013-02-26 09:00:00	AAPL	Stock	15.8671	15.8829	15.7054	15.8268	66271772.0
2013-02-26 10:00:00	AAPL	Stock	15.8225	15.8604	15.6732	15.7118	79042992.0
2013-02-26 11:00:00	AAPL	Stock	15.7093	15.7286	15.6307	15.6913	52599568.0
2013-02-26 12:00:00	AAPL	Stock	15.6929	15.7275	15.6571	15.6989	32011084.0
2013-02-26 13:00:00	AAPL	Stock	15.6982	16.0039	15.6779	15.9514	75638920.0
2013-02-26 14:00:00	AAPL	Stock	15.9521	16.1043	15.925	16.0946	89853960.0
2013-02-26 15:00:00	AAPL	Stock	16.0921	16.1264	15.9732	16.0336	85136492.0
2013-02-26 16:00:00	AAPL	Stock	16.0321	16.0357	15.6972	16.0071	13199060.0
2013-02-26 17:00:00	AAPL	Stock	16.0079	16.0346	15.9968	16.0025	482020.0
2013-02-26 18:00:00	AAPL	Stock	16.0	16.0018	15.9832	15.9886	602644.0
2013-02-26 19:00:00	AAPL	Stock	15.9982	16.0107	15.9929	15.9929	507024.0
2013-02-26 07:00:00	MSFT	Stock	27.37	27.37	27.37	27.37	300.0
2013-02-26 08:00:00	MSFT	Stock	27.33	27.49	27.33	27.49	9084.0
2013-02-26 09:00:00	MSFT	Stock	27.49	27.55	27.36	27.54	4142839.0
2013-02-26 10:00:00	MSFT	Stock	27.55	27.6	27.445	27.45	7529073.0
2013-02-26 11:00:00	MSFT	Stock	27.455	27.485	27.38	27.42	5706002.0
2013-02-26 12:00:00	MSFT	Stock	27.422	27.44	27.37	27.39	7953069.0
2013-02-26 13:00:00	MSFT	Stock	27.39	27.41	27.34	27.365	6581536.0
2013-02-26 14:00:00	MSFT	Stock	27.37	27.44	27.35	27.39	5112608.0
2013-02-26 15:00:00	MSFT	Stock	27.39	27.43	27.34	27.37	9009239.0
2013-02-26 16:00:00	MSFT	Stock	27.38	27.411	27.35	27.4	2998089.0
2013-02-26 17:00:00	MSFT	Stock	27.37	27.38	27.37	27.37	14940.0
2013-02-26 18:00:00	MSFT	Stock	27.38	27.41	27.38	27.41	7397.0
2013-02-26 19:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	300.0
2013-02-26 08:00:00	NVDA	Stock	0.3088	0.3088	0.3088	0.3088	28000.0
2013-02-26 09:00:00	NVDA	Stock	0.3088	0.3088	0.3052	0.3073	39120840.0
2013-02-26 10:00:00	NVDA	Stock	0.3073	0.3083	0.3058	0.3065	84469880.0
2013-02-26 11:00:00	NVDA	Stock	0.3065	0.3083	0.3058	0.3078	83889720.0
2013-02-26 12:00:00	NVDA	Stock	0.3078	0.31	0.3073	0.3085	61970160.0
2013-02-26 13:00:00	NVDA	Stock	0.3085	0.31	0.3085	0.3096	48468040.0
2013-02-26 14:00:00	NVDA	Stock	0.3096	0.3109	0.3085	0.3091	61638240.0
2013-02-26 15:00:00	NVDA	Stock	0.309	0.3103	0.3085	0.3095	84047880.0
2013-02-26 16:00:00	NVDA	Stock	0.3093	0.3093	0.3061	0.3061	6788240.0
2013-02-26 17:00:00	NVDA	Stock	0.3093	0.3093	0.3093	0.3093	296920.0
2013-02-26 19:00:00	NVDA	Stock	0.309	0.309	0.309	0.309	4000.0
2013-02-26 08:00:00	AMZN	Stock	13.0475	13.075	12.9935	13.0475	255600.0
2013-02-26 09:00:00	AMZN	Stock	13.04	13.102	12.88	13.0065	11322200.0
2013-02-26 10:00:00	AMZN	Stock	13.005	13.0585	12.885	12.946	16213920.0
2013-02-26 11:00:00	AMZN	Stock	12.9445	12.9465	12.7865	12.844	10767940.0
2013-02-26 12:00:00	AMZN	Stock	12.8465	12.94	12.8325	12.8865	6825960.0
2013-02-26 13:00:00	AMZN	Stock	12.887	13.0134	12.8585	12.943	5937580.0
2013-02-26 14:00:00	AMZN	Stock	12.9425	12.9935	12.9235	12.939	5431900.0
2013-02-26 15:00:00	AMZN	Stock	12.943	13.004	12.9025	12.968	7911780.0
2013-02-26 16:00:00	AMZN	Stock	12.968	12.98	12.9336	12.9539	1695600.0
2013-02-26 17:00:00	AMZN	Stock	12.968	12.9735	12.968	12.9735	12260.0

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

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