PREVIEW / stock_1hour / 2011-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-01.parquet
  size:    928 KB
  rows:    44,832
  symbols: 3,490

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
2011-09-01 04:00:00	AAPL	Stock	13.7511	13.7511	13.7511	13.7511	2800.0
2011-09-01 07:00:00	AAPL	Stock	13.7454	13.7664	13.7343	13.7471	182028.0
2011-09-01 08:00:00	AAPL	Stock	13.7532	13.8443	13.7229	13.8304	2649752.0
2011-09-01 09:00:00	AAPL	Stock	13.83	13.8321	13.7089	13.7507	48505828.0
2011-09-01 10:00:00	AAPL	Stock	13.7511	13.8336	13.7364	13.7421	73712660.0
2011-09-01 11:00:00	AAPL	Stock	13.7439	13.7618	13.7182	13.7577	38515036.0
2011-09-01 12:00:00	AAPL	Stock	13.7575	13.7582	13.7029	13.7071	26885656.0
2011-09-01 13:00:00	AAPL	Stock	13.7036	13.7064	13.6304	13.6429	40905676.0
2011-09-01 14:00:00	AAPL	Stock	13.6404	13.66	13.5971	13.6443	38174304.0
2011-09-01 15:00:00	AAPL	Stock	13.6436	13.6507	13.6068	13.6125	57029252.0
2011-09-01 16:00:00	AAPL	Stock	13.6082	13.7439	13.5975	13.6054	10837960.0
2011-09-01 17:00:00	AAPL	Stock	13.7455	13.7455	13.6036	13.6107	2826712.0
2011-09-01 18:00:00	AAPL	Stock	13.6143	13.6143	13.5918	13.6018	386148.0
2011-09-01 19:00:00	AAPL	Stock	13.6046	13.6046	13.5886	13.5964	146720.0
2011-09-01 07:00:00	MSFT	Stock	26.45	26.45	26.45	26.45	300.0
2011-09-01 08:00:00	MSFT	Stock	26.5	26.6	26.46	26.54	25916.0
2011-09-01 09:00:00	MSFT	Stock	26.55	26.8	26.4	26.61	5981271.0
2011-09-01 10:00:00	MSFT	Stock	26.6	26.86	26.45	26.45	11500816.0
2011-09-01 11:00:00	MSFT	Stock	26.45	26.54	26.39	26.505	6547410.0
2011-09-01 12:00:00	MSFT	Stock	26.5	26.505	26.36	26.36	4988117.0
2011-09-01 13:00:00	MSFT	Stock	26.36	26.41	26.24	26.313	6365542.0
2011-09-01 14:00:00	MSFT	Stock	26.31	26.39	26.22	26.265	8712990.0
2011-09-01 15:00:00	MSFT	Stock	26.27	26.35	26.21	26.23	10154352.0
2011-09-01 16:00:00	MSFT	Stock	26.24	26.6	26.14	26.14	5105978.0
2011-09-01 17:00:00	MSFT	Stock	26.645	26.645	26.11	26.2	797036.0
2011-09-01 18:00:00	MSFT	Stock	26.15	26.21	26.15	26.21	10803.0
2011-09-01 19:00:00	MSFT	Stock	26.2	26.2	26.15	26.15	760.0
2011-09-01 07:00:00	NVDA	Stock	0.3325	0.3325	0.3325	0.3325	20000.0
2011-09-01 08:00:00	NVDA	Stock	0.335	0.34	0.335	0.3388	1803320.0
2011-09-01 09:00:00	NVDA	Stock	0.3375	0.3408	0.3355	0.3404	92456520.0
2011-09-01 10:00:00	NVDA	Stock	0.3402	0.3445	0.3385	0.341	192501160.0
2011-09-01 11:00:00	NVDA	Stock	0.341	0.3445	0.3398	0.3438	91170680.0
2011-09-01 12:00:00	NVDA	Stock	0.3437	0.3442	0.3413	0.3418	47399560.0
2011-09-01 13:00:00	NVDA	Stock	0.3415	0.3422	0.3382	0.3385	73853560.0
2011-09-01 14:00:00	NVDA	Stock	0.3385	0.339	0.335	0.3353	107731640.0
2011-09-01 15:00:00	NVDA	Stock	0.335	0.3353	0.3318	0.3322	137970640.0
2011-09-01 16:00:00	NVDA	Stock	0.3322	0.339	0.3319	0.334	10062960.0
2011-09-01 17:00:00	NVDA	Stock	0.3339	0.3339	0.332	0.332	5597120.0
2011-09-01 18:00:00	NVDA	Stock	0.3322	0.3342	0.3322	0.3342	211320.0
2011-09-01 19:00:00	NVDA	Stock	0.3325	0.3325	0.3325	0.3325	23080.0
2011-09-01 07:00:00	AMZN	Stock	10.75	10.75	10.75	10.75	4000.0
2011-09-01 08:00:00	AMZN	Stock	10.7335	10.785	10.705	10.7695	234700.0
2011-09-01 09:00:00	AMZN	Stock	10.77	10.8075	10.71	10.785	15728400.0
2011-09-01 10:00:00	AMZN	Stock	10.7835	10.882	10.7625	10.821	24867380.0
2011-09-01 11:00:00	AMZN	Stock	10.821	10.859	10.7625	10.831	12605060.0
2011-09-01 12:00:00	AMZN	Stock	10.8325	10.8335	10.7335	10.7365	8304180.0
2011-09-01 13:00:00	AMZN	Stock	10.7355	10.757	10.617	10.6345	12830000.0
2011-09-01 14:00:00	AMZN	Stock	10.6325	10.667	10.581	10.611	12794560.0
2011-09-01 15:00:00	AMZN	Stock	10.613	10.6594	10.5875	10.627	13158440.0
2011-09-01 16:00:00	AMZN	Stock	10.628	10.7645	10.6125	10.6125	2501740.0

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

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