PREVIEW / stock_1hour / 2012-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-29.parquet
  size:    932 KB
  rows:    44,241
  symbols: 3,528

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-05-29 04:00:00	AAPL	Stock	20.29	20.3304	20.29	20.3304	28280.0
2012-05-29 05:00:00	AAPL	Stock	20.2929	20.2929	20.2321	20.2321	32200.0
2012-05-29 06:00:00	AAPL	Stock	20.1857	20.2004	20.1857	20.2004	10220.0
2012-05-29 07:00:00	AAPL	Stock	20.2071	20.2571	20.2071	20.2489	360640.0
2012-05-29 08:00:00	AAPL	Stock	20.2364	20.3011	20.2179	20.3	2107476.0
2012-05-29 09:00:00	AAPL	Stock	20.3025	20.3929	20.2261	20.2936	63885472.0
2012-05-29 10:00:00	AAPL	Stock	20.2836	20.5	20.2371	20.4361	90879544.0
2012-05-29 11:00:00	AAPL	Stock	20.4361	20.4529	20.2786	20.2854	48509496.0
2012-05-29 12:00:00	AAPL	Stock	20.2814	20.3475	20.1896	20.3071	41858292.0
2012-05-29 13:00:00	AAPL	Stock	20.3079	20.3696	20.2357	20.3496	30476740.0
2012-05-29 14:00:00	AAPL	Stock	20.3504	20.4257	20.3243	20.4019	31440360.0
2012-05-29 15:00:00	AAPL	Stock	20.4043	20.4586	20.3396	20.4379	57612492.0
2012-05-29 16:00:00	AAPL	Stock	20.4382	20.4607	20.3543	20.4589	8166312.0
2012-05-29 17:00:00	AAPL	Stock	20.4579	20.4589	20.3687	20.4464	620872.0
2012-05-29 18:00:00	AAPL	Stock	20.4457	20.4482	20.4343	20.4346	255780.0
2012-05-29 19:00:00	AAPL	Stock	20.4321	20.4321	20.4064	20.4196	302064.0
2012-05-29 07:00:00	MSFT	Stock	29.2	29.2	29.2	29.2	200.0
2012-05-29 08:00:00	MSFT	Stock	29.28	29.35	29.21	29.31	45575.0
2012-05-29 09:00:00	MSFT	Stock	29.3	29.47	29.22	29.41	4103674.0
2012-05-29 10:00:00	MSFT	Stock	29.41	29.72	29.37	29.61	7028135.0
2012-05-29 11:00:00	MSFT	Stock	29.61	29.62	29.33	29.406	4439382.0
2012-05-29 12:00:00	MSFT	Stock	29.4	29.42	29.28	29.37	4254764.0
2012-05-29 13:00:00	MSFT	Stock	29.37	29.42	29.32	29.38	3030037.0
2012-05-29 14:00:00	MSFT	Stock	29.373	29.5	29.35	29.47	3009995.0
2012-05-29 15:00:00	MSFT	Stock	29.475	29.64	29.44	29.55	9280197.0
2012-05-29 16:00:00	MSFT	Stock	29.56	29.67	29.441	29.45	1958636.0
2012-05-29 17:00:00	MSFT	Stock	29.56	29.56	29.495	29.56	107576.0
2012-05-29 18:00:00	MSFT	Stock	29.54	29.56	29.54	29.56	500.0
2012-05-29 19:00:00	MSFT	Stock	29.5	29.55	29.5	29.55	253.0
2012-05-29 08:00:00	NVDA	Stock	0.314	0.3145	0.314	0.314	263840.0
2012-05-29 09:00:00	NVDA	Stock	0.3148	0.3158	0.3138	0.3148	32107760.0
2012-05-29 10:00:00	NVDA	Stock	0.3145	0.32	0.3138	0.3192	63671400.0
2012-05-29 11:00:00	NVDA	Stock	0.319	0.3193	0.3145	0.3158	42267080.0
2012-05-29 12:00:00	NVDA	Stock	0.3158	0.3163	0.3138	0.3158	31307280.0
2012-05-29 13:00:00	NVDA	Stock	0.3155	0.3168	0.315	0.316	16510960.0
2012-05-29 14:00:00	NVDA	Stock	0.3159	0.3183	0.3155	0.3181	26285480.0
2012-05-29 15:00:00	NVDA	Stock	0.3183	0.3193	0.317	0.3181	73359640.0
2012-05-29 16:00:00	NVDA	Stock	0.3183	0.319	0.3157	0.3176	2442200.0
2012-05-29 17:00:00	NVDA	Stock	0.318	0.318	0.318	0.318	418720.0
2012-05-29 18:00:00	NVDA	Stock	0.32	0.3218	0.32	0.32	44000.0
2012-05-29 19:00:00	NVDA	Stock	0.3183	0.3183	0.3183	0.3183	20000.0
2012-05-29 08:00:00	AMZN	Stock	10.62	10.7125	10.62	10.7	84160.0
2012-05-29 09:00:00	AMZN	Stock	10.714	10.7265	10.6145	10.6735	7251200.0
2012-05-29 10:00:00	AMZN	Stock	10.6715	10.8275	10.6375	10.77	13615140.0
2012-05-29 11:00:00	AMZN	Stock	10.7715	10.7946	10.662	10.6917	7145200.0
2012-05-29 12:00:00	AMZN	Stock	10.6865	10.7	10.643	10.659	7080040.0
2012-05-29 13:00:00	AMZN	Stock	10.6575	10.712	10.635	10.7095	4403700.0
2012-05-29 14:00:00	AMZN	Stock	10.7057	10.74	10.678	10.735	3372180.0
2012-05-29 15:00:00	AMZN	Stock	10.7375	10.75	10.694	10.7375	7187640.0
2012-05-29 16:00:00	AMZN	Stock	10.7375	10.748	10.7188	10.7203	2761380.0

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

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