PREVIEW / stock_1hour / 2012-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-11.parquet
  size:    933 KB
  rows:    44,352
  symbols: 3,518

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-11 04:00:00	AAPL	Stock	20.3093	20.3093	20.3	20.3093	16800.0
2012-05-11 05:00:00	AAPL	Stock	20.3093	20.3093	20.3093	20.3093	5600.0
2012-05-11 06:00:00	AAPL	Stock	20.2857	20.3304	20.2407	20.2721	128940.0
2012-05-11 07:00:00	AAPL	Stock	20.2786	20.2954	20.2321	20.2786	1240288.0
2012-05-11 08:00:00	AAPL	Stock	20.2786	20.2864	20.0536	20.1211	8271956.0
2012-05-11 09:00:00	AAPL	Stock	20.1239	20.3186	20.0804	20.2436	72838668.0
2012-05-11 10:00:00	AAPL	Stock	20.2479	20.5168	20.2407	20.4236	96975956.0
2012-05-11 11:00:00	AAPL	Stock	20.4241	20.4425	20.33	20.3675	47841416.0
2012-05-11 12:00:00	AAPL	Stock	20.3607	20.3711	20.2904	20.31	39355064.0
2012-05-11 13:00:00	AAPL	Stock	20.3089	20.3661	20.2682	20.3392	33477024.0
2012-05-11 14:00:00	AAPL	Stock	20.3389	20.365	20.2918	20.3093	26573288.0
2012-05-11 15:00:00	AAPL	Stock	20.3096	20.3243	20.2129	20.2396	59685472.0
2012-05-11 16:00:00	AAPL	Stock	20.2396	20.3649	20.2318	20.2321	8742468.0
2012-05-11 17:00:00	AAPL	Stock	20.2396	20.2429	20.2007	20.2079	602784.0
2012-05-11 18:00:00	AAPL	Stock	20.2121	20.2268	20.2121	20.2182	171108.0
2012-05-11 19:00:00	AAPL	Stock	20.2207	20.2214	20.1925	20.2029	282268.0
2012-05-11 07:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	490.0
2012-05-11 08:00:00	MSFT	Stock	30.67	30.7	30.54	30.56	4100.0
2012-05-11 09:00:00	MSFT	Stock	30.57	31.13	30.57	31.1	5253157.0
2012-05-11 10:00:00	MSFT	Stock	31.11	31.54	31.1	31.38	10440369.0
2012-05-11 11:00:00	MSFT	Stock	31.38	31.41	31.29	31.34	6032835.0
2012-05-11 12:00:00	MSFT	Stock	31.34	31.35	31.29	31.32	2370694.0
2012-05-11 13:00:00	MSFT	Stock	31.328	31.43	31.28	31.37	4578248.0
2012-05-11 14:00:00	MSFT	Stock	31.375	31.4	31.28	31.31	4271897.0
2012-05-11 15:00:00	MSFT	Stock	31.31	31.34	31.16	31.17	7334944.0
2012-05-11 16:00:00	MSFT	Stock	31.17	31.342	31.12	31.16	2406853.0
2012-05-11 17:00:00	MSFT	Stock	31.21	31.27	31.16	31.16	1655.0
2012-05-11 18:00:00	MSFT	Stock	31.17	31.23	31.17	31.18	506.0
2012-05-11 19:00:00	MSFT	Stock	31.18	31.23	31.18	31.22	600.0
2012-05-11 07:00:00	NVDA	Stock	0.3098	0.3408	0.3098	0.3375	15223800.0
2012-05-11 08:00:00	NVDA	Stock	0.3375	0.3442	0.3313	0.3385	67464360.0
2012-05-11 09:00:00	NVDA	Stock	0.3385	0.342	0.3308	0.3385	413327280.0
2012-05-11 10:00:00	NVDA	Stock	0.3384	0.341	0.333	0.337	290206520.0
2012-05-11 11:00:00	NVDA	Stock	0.3373	0.339	0.3353	0.3375	204353600.0
2012-05-11 12:00:00	NVDA	Stock	0.3373	0.3375	0.335	0.3355	56542200.0
2012-05-11 13:00:00	NVDA	Stock	0.3353	0.3358	0.333	0.3333	83396680.0
2012-05-11 14:00:00	NVDA	Stock	0.3335	0.3338	0.3313	0.3325	72974040.0
2012-05-11 15:00:00	NVDA	Stock	0.3325	0.3333	0.329	0.3303	209281880.0
2012-05-11 16:00:00	NVDA	Stock	0.3303	0.3349	0.3302	0.331	4838640.0
2012-05-11 17:00:00	NVDA	Stock	0.331	0.3313	0.328	0.3313	152200.0
2012-05-11 18:00:00	NVDA	Stock	0.3313	0.3313	0.33	0.33	185200.0
2012-05-11 19:00:00	NVDA	Stock	0.3308	0.3325	0.3308	0.3313	77120.0
2012-05-11 08:00:00	AMZN	Stock	11.29	11.32	11.235	11.25	336120.0
2012-05-11 09:00:00	AMZN	Stock	11.24	11.4425	11.233	11.425	12088560.0
2012-05-11 10:00:00	AMZN	Stock	11.4245	11.48	11.375	11.479	15528720.0
2012-05-11 11:00:00	AMZN	Stock	11.48	11.534	11.4505	11.4525	18055620.0
2012-05-11 12:00:00	AMZN	Stock	11.455	11.4965	11.425	11.4515	8432800.0
2012-05-11 13:00:00	AMZN	Stock	11.4585	11.483	11.4435	11.4745	5342740.0
2012-05-11 14:00:00	AMZN	Stock	11.4725	11.482	11.429	11.4498	5834020.0
2012-05-11 15:00:00	AMZN	Stock	11.445	11.475	11.3755	11.3835	14477220.0

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

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