PREVIEW / stock_1hour / 2012-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-08.parquet
  size:    948 KB
  rows:    44,710
  symbols: 3,549

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-08 04:00:00	AAPL	Stock	20.2882	20.2882	20.2496	20.2496	44800.0
2012-05-08 05:00:00	AAPL	Stock	20.2393	20.2393	20.2021	20.2021	32928.0
2012-05-08 06:00:00	AAPL	Stock	20.2311	20.2354	20.2311	20.2354	34160.0
2012-05-08 07:00:00	AAPL	Stock	20.2325	20.3571	20.2325	20.3571	250600.0
2012-05-08 08:00:00	AAPL	Stock	20.3571	20.4407	20.3007	20.3696	2286508.0
2012-05-08 09:00:00	AAPL	Stock	20.3679	20.4107	20.1579	20.1743	66579800.0
2012-05-08 10:00:00	AAPL	Stock	20.1764	20.2321	20.0125	20.0911	88051656.0
2012-05-08 11:00:00	AAPL	Stock	20.0961	20.1511	19.9546	20.1068	82895260.0
2012-05-08 12:00:00	AAPL	Stock	20.1046	20.1193	19.9821	20.0036	39863796.0
2012-05-08 13:00:00	AAPL	Stock	20.0021	20.1425	19.9861	20.1064	40815096.0
2012-05-08 14:00:00	AAPL	Stock	20.1018	20.3268	20.0961	20.2751	62959204.0
2012-05-08 15:00:00	AAPL	Stock	20.275	20.3875	20.2036	20.2882	90963992.0
2012-05-08 16:00:00	AAPL	Stock	20.2914	20.2993	20.0856	20.2921	14250012.0
2012-05-08 17:00:00	AAPL	Stock	20.275	20.2939	20.275	20.2829	254940.0
2012-05-08 18:00:00	AAPL	Stock	20.2829	20.2871	20.2793	20.2857	259196.0
2012-05-08 19:00:00	AAPL	Stock	20.2811	20.2811	20.2482	20.25	440468.0
2012-05-08 07:00:00	MSFT	Stock	30.5	30.5	30.5	30.5	549.0
2012-05-08 08:00:00	MSFT	Stock	30.6	30.65	30.41	30.49	15598.0
2012-05-08 09:00:00	MSFT	Stock	30.48	30.78	30.46	30.56	5575827.0
2012-05-08 10:00:00	MSFT	Stock	30.57	30.58	30.23	30.33	8635188.0
2012-05-08 11:00:00	MSFT	Stock	30.325	30.39	30.17	30.33	7535884.0
2012-05-08 12:00:00	MSFT	Stock	30.33	30.34	30.2	30.26	5307071.0
2012-05-08 13:00:00	MSFT	Stock	30.25	30.49	30.25	30.451	3575208.0
2012-05-08 14:00:00	MSFT	Stock	30.45	30.53	30.38	30.455	3698200.0
2012-05-08 15:00:00	MSFT	Stock	30.455	30.58	30.4	30.49	8891639.0
2012-05-08 16:00:00	MSFT	Stock	30.49	30.737	30.413	30.737	2910660.0
2012-05-08 17:00:00	MSFT	Stock	30.53	30.57	30.5	30.57	2700.0
2012-05-08 18:00:00	MSFT	Stock	30.52	30.54	30.52	30.52	1495.0
2012-05-08 19:00:00	MSFT	Stock	30.52	30.52	30.4	30.42	7690.0
2012-05-08 08:00:00	NVDA	Stock	0.3113	0.312	0.307	0.312	432400.0
2012-05-08 09:00:00	NVDA	Stock	0.3108	0.3125	0.3088	0.3103	48928320.0
2012-05-08 10:00:00	NVDA	Stock	0.31	0.31	0.3052	0.3062	65248640.0
2012-05-08 11:00:00	NVDA	Stock	0.3062	0.3088	0.3052	0.307	56914480.0
2012-05-08 12:00:00	NVDA	Stock	0.307	0.3073	0.3035	0.304	42559440.0
2012-05-08 13:00:00	NVDA	Stock	0.3041	0.3092	0.304	0.3088	36207280.0
2012-05-08 14:00:00	NVDA	Stock	0.3088	0.3118	0.3078	0.3101	38673640.0
2012-05-08 15:00:00	NVDA	Stock	0.3103	0.3135	0.3095	0.3115	113242280.0
2012-05-08 16:00:00	NVDA	Stock	0.3118	0.3118	0.3086	0.31	50546880.0
2012-05-08 17:00:00	NVDA	Stock	0.3108	0.3115	0.3108	0.3115	13200.0
2012-05-08 18:00:00	NVDA	Stock	0.3113	0.3113	0.3113	0.3113	10400.0
2012-05-08 04:00:00	AMZN	Stock	11.239	11.239	11.239	11.239	2000.0
2012-05-08 07:00:00	AMZN	Stock	11.238	11.238	11.238	11.238	2000.0
2012-05-08 08:00:00	AMZN	Stock	11.24	11.2725	11.21	11.225	168380.0
2012-05-08 09:00:00	AMZN	Stock	11.218	11.225	11.1065	11.1513	10207500.0
2012-05-08 10:00:00	AMZN	Stock	11.1615	11.1635	10.911	10.967	21143020.0
2012-05-08 11:00:00	AMZN	Stock	10.9645	11.141	10.91	11.0805	15525540.0
2012-05-08 12:00:00	AMZN	Stock	11.0805	11.1035	11.0345	11.046	7981660.0
2012-05-08 13:00:00	AMZN	Stock	11.0495	11.16	11.0425	11.1295	7636860.0
2012-05-08 14:00:00	AMZN	Stock	11.1295	11.1955	11.1045	11.189	9017740.0
2012-05-08 15:00:00	AMZN	Stock	11.188	11.2695	11.1605	11.195	16385880.0

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

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