PREVIEW / stock_1hour / 2013-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-12.parquet
  size:    960 KB
  rows:    44,690
  symbols: 3,491

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-04-12 04:00:00	AAPL	Stock	15.4821	15.4821	15.4821	15.4821	2800.0
2013-04-12 06:00:00	AAPL	Stock	15.4579	15.4579	15.4579	15.4579	11200.0
2013-04-12 07:00:00	AAPL	Stock	15.4568	15.4607	15.4107	15.4464	58604.0
2013-04-12 08:00:00	AAPL	Stock	15.4421	15.5143	15.3793	15.4143	1945748.0
2013-04-12 09:00:00	AAPL	Stock	15.4082	15.5054	15.3968	15.4173	39967368.0
2013-04-12 10:00:00	AAPL	Stock	15.4143	15.4786	15.3411	15.3661	52608164.0
2013-04-12 11:00:00	AAPL	Stock	15.3646	15.3871	15.3304	15.3836	31962308.0
2013-04-12 12:00:00	AAPL	Stock	15.3814	15.3854	15.34	15.3686	16590140.0
2013-04-12 13:00:00	AAPL	Stock	15.3696	15.3807	15.3409	15.3591	19057220.0
2013-04-12 14:00:00	AAPL	Stock	15.3596	15.37	15.3246	15.3469	16083760.0
2013-04-12 15:00:00	AAPL	Stock	15.3457	15.3707	15.3354	15.3489	36169112.0
2013-04-12 16:00:00	AAPL	Stock	15.35	15.4919	15.3371	15.35	15582504.0
2013-04-12 17:00:00	AAPL	Stock	15.3414	15.4341	15.3393	15.3443	468860.0
2013-04-12 18:00:00	AAPL	Stock	15.3446	15.3464	15.3429	15.3429	14000.0
2013-04-12 19:00:00	AAPL	Stock	15.3414	15.3439	15.3393	15.3393	107072.0
2013-04-12 04:00:00	MSFT	Stock	28.9	28.9	28.77	28.77	750.0
2013-04-12 05:00:00	MSFT	Stock	28.76	28.76	28.76	28.76	100.0
2013-04-12 06:00:00	MSFT	Stock	28.71	28.71	28.5	28.59	6712.0
2013-04-12 07:00:00	MSFT	Stock	28.62	28.83	28.62	28.79	77150.0
2013-04-12 08:00:00	MSFT	Stock	28.79	28.8	28.67	28.71	236243.0
2013-04-12 09:00:00	MSFT	Stock	28.69	29.02	28.69	28.94	10255139.0
2013-04-12 10:00:00	MSFT	Stock	28.95	29.0	28.66	28.785	18242034.0
2013-04-12 11:00:00	MSFT	Stock	28.785	28.85	28.76	28.83	5550434.0
2013-04-12 12:00:00	MSFT	Stock	28.835	28.89	28.78	28.81	3413031.0
2013-04-12 13:00:00	MSFT	Stock	28.82	28.86	28.76	28.78	2877275.0
2013-04-12 14:00:00	MSFT	Stock	28.78	28.81	28.74	28.77	4087138.0
2013-04-12 15:00:00	MSFT	Stock	28.765	28.84	28.74	28.82	13875766.0
2013-04-12 16:00:00	MSFT	Stock	28.83	28.845	28.73	28.79	3587558.0
2013-04-12 17:00:00	MSFT	Stock	28.936	28.936	28.76	28.78	52764.0
2013-04-12 18:00:00	MSFT	Stock	28.77	28.79	28.75	28.76	3872.0
2013-04-12 19:00:00	MSFT	Stock	28.79	28.82	28.79	28.82	1500.0
2013-04-12 09:00:00	NVDA	Stock	0.319	0.321	0.3178	0.32	41786120.0
2013-04-12 10:00:00	NVDA	Stock	0.32	0.3235	0.3195	0.3215	119577000.0
2013-04-12 11:00:00	NVDA	Stock	0.3215	0.3266	0.32	0.3255	157817160.0
2013-04-12 12:00:00	NVDA	Stock	0.3255	0.33	0.325	0.3298	90451360.0
2013-04-12 13:00:00	NVDA	Stock	0.3298	0.3308	0.3283	0.3283	113341320.0
2013-04-12 14:00:00	NVDA	Stock	0.3283	0.329	0.3263	0.3266	60435840.0
2013-04-12 15:00:00	NVDA	Stock	0.3266	0.3288	0.3265	0.3273	164756560.0
2013-04-12 16:00:00	NVDA	Stock	0.3273	0.3275	0.3186	0.3273	7632600.0
2013-04-12 17:00:00	NVDA	Stock	0.3255	0.3255	0.325	0.325	112440.0
2013-04-12 18:00:00	NVDA	Stock	0.325	0.3273	0.325	0.3273	48680.0
2013-04-12 19:00:00	NVDA	Stock	0.3273	0.3273	0.3273	0.3273	4000.0
2013-04-12 07:00:00	AMZN	Stock	13.41	13.41	13.41	13.41	4000.0
2013-04-12 08:00:00	AMZN	Stock	13.495	13.495	13.4005	13.444	227160.0
2013-04-12 09:00:00	AMZN	Stock	13.45	13.6195	13.4395	13.5105	12233120.0
2013-04-12 10:00:00	AMZN	Stock	13.518	13.5205	13.351	13.4025	8299800.0
2013-04-12 11:00:00	AMZN	Stock	13.402	13.545	13.3555	13.514	8265800.0
2013-04-12 12:00:00	AMZN	Stock	13.514	13.5945	13.5076	13.571	5034780.0
2013-04-12 13:00:00	AMZN	Stock	13.574	13.6	13.5535	13.571	4824120.0
2013-04-12 14:00:00	AMZN	Stock	13.565	13.6125	13.559	13.5988	4964000.0

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

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