PREVIEW / stock_1hour / 2013-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-10.parquet
  size:    949 KB
  rows:    44,756
  symbols: 3,467

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-01-10 04:00:00	AAPL	Stock	18.4854	18.5293	18.4854	18.515	98756.0
2013-01-10 05:00:00	AAPL	Stock	18.5154	18.5357	18.5154	18.5321	146104.0
2013-01-10 06:00:00	AAPL	Stock	18.5357	18.6071	18.5321	18.5893	491876.0
2013-01-10 07:00:00	AAPL	Stock	18.5779	18.7429	18.5625	18.7357	3124744.0
2013-01-10 08:00:00	AAPL	Stock	18.7346	18.9929	18.6786	18.8875	13889708.0
2013-01-10 09:00:00	AAPL	Stock	18.89	18.9464	18.5982	18.6764	110148976.0
2013-01-10 10:00:00	AAPL	Stock	18.6721	18.6854	18.4761	18.5245	105582764.0
2013-01-10 11:00:00	AAPL	Stock	18.5229	18.5604	18.4414	18.5035	61591152.0
2013-01-10 12:00:00	AAPL	Stock	18.5029	18.5082	18.4114	18.4336	51558416.0
2013-01-10 13:00:00	AAPL	Stock	18.4339	18.5179	18.42	18.4787	36350272.0
2013-01-10 14:00:00	AAPL	Stock	18.4787	18.6786	18.4225	18.6211	71210972.0
2013-01-10 15:00:00	AAPL	Stock	18.6207	18.7707	18.5993	18.6957	119421344.0
2013-01-10 16:00:00	AAPL	Stock	18.7029	18.7286	18.4652	18.7229	13625052.0
2013-01-10 17:00:00	AAPL	Stock	18.7229	18.7286	18.7161	18.7232	344512.0
2013-01-10 18:00:00	AAPL	Stock	18.7236	18.7414	18.7214	18.7264	526344.0
2013-01-10 19:00:00	AAPL	Stock	18.7318	18.7318	18.7161	18.7214	517748.0
2013-01-10 04:00:00	MSFT	Stock	26.61	26.61	26.45	26.5	1790.0
2013-01-10 05:00:00	MSFT	Stock	26.5	26.5	26.5	26.5	1000.0
2013-01-10 06:00:00	MSFT	Stock	26.5	26.58	26.49	26.52	32224.0
2013-01-10 07:00:00	MSFT	Stock	26.55	26.55	26.39	26.45	63556.0
2013-01-10 08:00:00	MSFT	Stock	26.45	26.7	26.39	26.52	456049.0
2013-01-10 09:00:00	MSFT	Stock	26.55	26.98	26.54	26.87	8920841.0
2013-01-10 10:00:00	MSFT	Stock	26.875	26.88	26.45	26.495	10146819.0
2013-01-10 11:00:00	MSFT	Stock	26.49	26.5	26.38	26.42	8786337.0
2013-01-10 12:00:00	MSFT	Stock	26.43	26.45	26.3	26.32	9872594.0
2013-01-10 13:00:00	MSFT	Stock	26.32	26.4	26.29	26.352	7985109.0
2013-01-10 14:00:00	MSFT	Stock	26.35	26.48	26.29	26.451	8375610.0
2013-01-10 15:00:00	MSFT	Stock	26.451	26.5	26.42	26.48	12663816.0
2013-01-10 16:00:00	MSFT	Stock	26.47	26.773	26.339	26.58	2949040.0
2013-01-10 17:00:00	MSFT	Stock	26.54	26.57	26.46	26.53	188614.0
2013-01-10 18:00:00	MSFT	Stock	26.52	26.54	26.52	26.53	9425.0
2013-01-10 19:00:00	MSFT	Stock	26.51	26.52	26.47	26.48	16836.0
2013-01-10 08:00:00	NVDA	Stock	0.309	0.309	0.3068	0.3088	352000.0
2013-01-10 09:00:00	NVDA	Stock	0.3085	0.3095	0.3062	0.3068	75884440.0
2013-01-10 10:00:00	NVDA	Stock	0.3065	0.3075	0.3042	0.3073	78081360.0
2013-01-10 11:00:00	NVDA	Stock	0.307	0.308	0.3055	0.3065	70205200.0
2013-01-10 12:00:00	NVDA	Stock	0.3068	0.307	0.305	0.3055	50126240.0
2013-01-10 13:00:00	NVDA	Stock	0.3055	0.3068	0.3045	0.305	41927880.0
2013-01-10 14:00:00	NVDA	Stock	0.305	0.3058	0.304	0.3054	68848680.0
2013-01-10 15:00:00	NVDA	Stock	0.3054	0.3058	0.3048	0.3058	99701520.0
2013-01-10 16:00:00	NVDA	Stock	0.3058	0.3065	0.305	0.306	4460360.0
2013-01-10 17:00:00	NVDA	Stock	0.3068	0.3068	0.3068	0.3068	40000.0
2013-01-10 18:00:00	NVDA	Stock	0.3068	0.3068	0.3068	0.3068	4000.0
2013-01-10 19:00:00	NVDA	Stock	0.3065	0.3068	0.3065	0.3068	20000.0
2013-01-10 07:00:00	AMZN	Stock	13.4	13.4	13.3555	13.3555	10000.0
2013-01-10 08:00:00	AMZN	Stock	13.3565	13.405	13.305	13.4	242300.0
2013-01-10 09:00:00	AMZN	Stock	13.4	13.437	13.31	13.361	5893560.0
2013-01-10 10:00:00	AMZN	Stock	13.365	13.3705	13.211	13.232	10277620.0
2013-01-10 11:00:00	AMZN	Stock	13.2295	13.2345	13.1658	13.17	7898500.0
2013-01-10 12:00:00	AMZN	Stock	13.1705	13.2495	13.1495	13.183	7142940.0

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

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