PREVIEW / stock_1hour / 2012-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-02.parquet
  size:    932 KB
  rows:    43,791
  symbols: 3,453

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-11-02 04:00:00	AAPL	Stock	21.3214	21.3214	21.2525	21.2857	14000.0
2012-11-02 05:00:00	AAPL	Stock	21.2857	21.3468	21.2857	21.3468	5600.0
2012-11-02 06:00:00	AAPL	Stock	21.3468	21.3468	21.3143	21.3357	11816.0
2012-11-02 07:00:00	AAPL	Stock	21.3214	21.3214	21.2679	21.2732	277844.0
2012-11-02 08:00:00	AAPL	Stock	21.2821	21.3457	21.2054	21.2864	2600276.0
2012-11-02 09:00:00	AAPL	Stock	21.285	21.3196	21.1139	21.1734	50280664.0
2012-11-02 10:00:00	AAPL	Stock	21.1768	21.1786	21.0596	21.1325	65762060.0
2012-11-02 11:00:00	AAPL	Stock	21.1268	21.2107	21.0464	21.0961	46018000.0
2012-11-02 12:00:00	AAPL	Stock	21.0896	21.1093	21.04	21.0718	35210196.0
2012-11-02 13:00:00	AAPL	Stock	21.0702	21.0857	20.9029	20.9293	73168816.0
2012-11-02 14:00:00	AAPL	Stock	20.9293	20.9321	20.7193	20.7861	121688644.0
2012-11-02 15:00:00	AAPL	Stock	20.7843	20.8268	20.5268	20.605	180646228.0
2012-11-02 16:00:00	AAPL	Stock	20.6064	21.287	20.558	20.6071	14761432.0
2012-11-02 17:00:00	AAPL	Stock	20.6071	20.6175	20.6	20.6036	199948.0
2012-11-02 18:00:00	AAPL	Stock	20.6036	20.6179	20.5961	20.6164	181524.0
2012-11-02 19:00:00	AAPL	Stock	20.6161	20.6164	20.5893	20.6071	239680.0
2012-11-02 06:00:00	MSFT	Stock	29.57	29.57	29.57	29.57	713.0
2012-11-02 07:00:00	MSFT	Stock	29.57	29.57	29.51	29.56	6640.0
2012-11-02 08:00:00	MSFT	Stock	29.56	29.73	29.54	29.57	69392.0
2012-11-02 09:00:00	MSFT	Stock	29.57	29.67	29.49	29.577	6779261.0
2012-11-02 10:00:00	MSFT	Stock	29.58	29.6	29.33	29.485	8381492.0
2012-11-02 11:00:00	MSFT	Stock	29.485	29.62	29.44	29.62	6823222.0
2012-11-02 12:00:00	MSFT	Stock	29.61	29.63	29.56	29.59	4981982.0
2012-11-02 13:00:00	MSFT	Stock	29.59	29.77	29.53	29.63	6741839.0
2012-11-02 14:00:00	MSFT	Stock	29.63	29.74	29.52	29.615	7394958.0
2012-11-02 15:00:00	MSFT	Stock	29.615	29.69	29.49	29.49	12723798.0
2012-11-02 16:00:00	MSFT	Stock	29.49	29.65	29.44	29.49	2680648.0
2012-11-02 17:00:00	MSFT	Stock	29.48	29.48	29.46	29.46	1201.0
2012-11-02 18:00:00	MSFT	Stock	29.48	29.48	29.45	29.48	1797.0
2012-11-02 19:00:00	MSFT	Stock	29.49	29.49	29.48	29.48	6000.0
2012-11-02 08:00:00	NVDA	Stock	0.3125	0.317	0.3125	0.3153	101000.0
2012-11-02 09:00:00	NVDA	Stock	0.3153	0.3175	0.3125	0.315	34043000.0
2012-11-02 10:00:00	NVDA	Stock	0.3148	0.315	0.3118	0.3133	45363080.0
2012-11-02 11:00:00	NVDA	Stock	0.3133	0.3135	0.3118	0.3135	26161280.0
2012-11-02 12:00:00	NVDA	Stock	0.3135	0.3143	0.3128	0.3141	17175200.0
2012-11-02 13:00:00	NVDA	Stock	0.314	0.3153	0.313	0.313	20997040.0
2012-11-02 14:00:00	NVDA	Stock	0.3131	0.3133	0.3103	0.3108	19165480.0
2012-11-02 15:00:00	NVDA	Stock	0.3108	0.3135	0.3108	0.312	76308320.0
2012-11-02 16:00:00	NVDA	Stock	0.3123	0.313	0.3103	0.3103	3334880.0
2012-11-02 08:00:00	AMZN	Stock	11.65	11.6875	11.606	11.675	39000.0
2012-11-02 09:00:00	AMZN	Stock	11.69	11.8475	11.675	11.7889	14334500.0
2012-11-02 10:00:00	AMZN	Stock	11.789	11.87	11.7678	11.8108	11657840.0
2012-11-02 11:00:00	AMZN	Stock	11.81	11.811	11.7175	11.7413	5780360.0
2012-11-02 12:00:00	AMZN	Stock	11.7385	11.769	11.7125	11.7525	3747420.0
2012-11-02 13:00:00	AMZN	Stock	11.7555	11.7605	11.704	11.731	4849160.0
2012-11-02 14:00:00	AMZN	Stock	11.7285	11.7395	11.675	11.6925	7005020.0
2012-11-02 15:00:00	AMZN	Stock	11.6915	11.705	11.6055	11.6055	15812740.0
2012-11-02 16:00:00	AMZN	Stock	11.605	11.7598	11.545	11.55	1271920.0
2012-11-02 17:00:00	AMZN	Stock	11.5575	11.5575	11.5575	11.5575	2000.0
2012-11-02 18:00:00	AMZN	Stock	11.5745	11.5745	11.5745	11.5745	2000.0

> showing 50 of 43,791 rows — these rows as CSV

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