PREVIEW / stock_1hour / 2013-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-13.parquet
  size:    960 KB
  rows:    44,912
  symbols: 3,476

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-13 04:00:00	AAPL	Stock	16.7071	16.7071	16.7071	16.7071	5600.0
2013-02-13 06:00:00	AAPL	Stock	16.6793	16.6793	16.6686	16.6786	83020.0
2013-02-13 07:00:00	AAPL	Stock	16.6961	16.7496	16.6786	16.6954	325472.0
2013-02-13 08:00:00	AAPL	Stock	16.6957	16.7482	16.6486	16.6736	3467660.0
2013-02-13 09:00:00	AAPL	Stock	16.6754	16.8529	16.5436	16.8379	96223204.0
2013-02-13 10:00:00	AAPL	Stock	16.8443	16.9139	16.7214	16.9096	95678268.0
2013-02-13 11:00:00	AAPL	Stock	16.9118	16.9157	16.7029	16.7357	56545104.0
2013-02-13 12:00:00	AAPL	Stock	16.7379	16.8005	16.6214	16.6279	55293812.0
2013-02-13 13:00:00	AAPL	Stock	16.6246	16.7618	16.6218	16.7469	33919676.0
2013-02-13 14:00:00	AAPL	Stock	16.7507	16.7696	16.625	16.6486	39603844.0
2013-02-13 15:00:00	AAPL	Stock	16.6482	16.6889	16.6025	16.6786	55799464.0
2013-02-13 16:00:00	AAPL	Stock	16.6789	16.8288	16.6656	16.6732	19600168.0
2013-02-13 17:00:00	AAPL	Stock	16.6721	16.6911	16.6629	16.6796	239400.0
2013-02-13 18:00:00	AAPL	Stock	16.6818	16.6821	16.6739	16.6764	59584.0
2013-02-13 19:00:00	AAPL	Stock	16.6714	16.675	16.6436	16.6611	257320.0
2013-02-13 08:00:00	MSFT	Stock	27.91	27.93	27.82	27.93	93729.0
2013-02-13 09:00:00	MSFT	Stock	27.92	28.0	27.88	27.962	4388074.0
2013-02-13 10:00:00	MSFT	Stock	27.97	28.11	27.97	28.04	11307534.0
2013-02-13 11:00:00	MSFT	Stock	28.04	28.07	27.905	27.94	7037484.0
2013-02-13 12:00:00	MSFT	Stock	27.95	28.02	27.92	27.98	3233704.0
2013-02-13 13:00:00	MSFT	Stock	27.98	28.07	27.96	28.025	4123142.0
2013-02-13 14:00:00	MSFT	Stock	28.035	28.08	27.995	28.01	4662556.0
2013-02-13 15:00:00	MSFT	Stock	28.01	28.04	27.96	28.02	4960328.0
2013-02-13 16:00:00	MSFT	Stock	28.03	28.06	27.969	28.04	1102414.0
2013-02-13 17:00:00	MSFT	Stock	28.04	28.04	27.98	28.0	3500.0
2013-02-13 18:00:00	MSFT	Stock	27.98	27.98	27.98	27.98	280.0
2013-02-13 19:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	250.0
2013-02-13 08:00:00	NVDA	Stock	0.3143	0.3143	0.3143	0.3143	4000.0
2013-02-13 09:00:00	NVDA	Stock	0.3125	0.3143	0.311	0.314	30544880.0
2013-02-13 10:00:00	NVDA	Stock	0.314	0.3161	0.3138	0.3155	68801640.0
2013-02-13 11:00:00	NVDA	Stock	0.3156	0.3163	0.3115	0.3128	51795920.0
2013-02-13 12:00:00	NVDA	Stock	0.3128	0.3153	0.3127	0.3145	74147800.0
2013-02-13 13:00:00	NVDA	Stock	0.3148	0.3166	0.3145	0.3155	91254640.0
2013-02-13 14:00:00	NVDA	Stock	0.3154	0.3155	0.3088	0.309	151976200.0
2013-02-13 15:00:00	NVDA	Stock	0.309	0.3103	0.3083	0.3093	323579680.0
2013-02-13 16:00:00	NVDA	Stock	0.3093	0.3118	0.3	0.3093	55683840.0
2013-02-13 17:00:00	NVDA	Stock	0.3098	0.3098	0.3048	0.3055	3024280.0
2013-02-13 18:00:00	NVDA	Stock	0.3052	0.3052	0.3038	0.3045	2352760.0
2013-02-13 19:00:00	NVDA	Stock	0.3045	0.305	0.3042	0.305	1137080.0
2013-02-13 06:00:00	AMZN	Stock	13.0045	13.03	13.0045	13.03	37200.0
2013-02-13 07:00:00	AMZN	Stock	13.025	13.0845	13.025	13.0845	129080.0
2013-02-13 08:00:00	AMZN	Stock	13.08	13.093	13.06	13.087	543220.0
2013-02-13 09:00:00	AMZN	Stock	13.0855	13.338	13.015	13.3244	19933500.0
2013-02-13 10:00:00	AMZN	Stock	13.3245	13.4635	13.259	13.3285	23545060.0
2013-02-13 11:00:00	AMZN	Stock	13.3215	13.333	13.21	13.313	14106820.0
2013-02-13 12:00:00	AMZN	Stock	13.313	13.3825	13.2595	13.341	9540200.0
2013-02-13 13:00:00	AMZN	Stock	13.3355	13.435	13.329	13.398	8356060.0
2013-02-13 14:00:00	AMZN	Stock	13.3945	13.4122	13.309	13.372	6425040.0
2013-02-13 15:00:00	AMZN	Stock	13.371	13.498	13.364	13.4765	20607440.0
2013-02-13 16:00:00	AMZN	Stock	13.4705	13.4795	13.3081	13.46	533280.0

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

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