PREVIEW / stock_1hour / 2012-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-15.parquet
  size:    952 KB
  rows:    44,896
  symbols: 3,489

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-15 04:00:00	AAPL	Stock	19.1896	19.25	19.1875	19.25	110320.0
2012-11-15 05:00:00	AAPL	Stock	19.2321	19.25	19.2321	19.25	47012.0
2012-11-15 06:00:00	AAPL	Stock	19.22	19.25	19.1957	19.25	155764.0
2012-11-15 07:00:00	AAPL	Stock	19.2543	19.2636	19.1829	19.2143	679084.0
2012-11-15 08:00:00	AAPL	Stock	19.2086	19.2571	19.1761	19.2232	3144288.0
2012-11-15 09:00:00	AAPL	Stock	19.2282	19.2814	18.9482	18.9807	104325396.0
2012-11-15 10:00:00	AAPL	Stock	18.9775	19.1568	18.8489	18.8729	160325284.0
2012-11-15 11:00:00	AAPL	Stock	18.8714	18.9275	18.7589	18.7875	107296084.0
2012-11-15 12:00:00	AAPL	Stock	18.7864	18.9643	18.7679	18.8579	94198076.0
2012-11-15 13:00:00	AAPL	Stock	18.8579	19.0429	18.8551	18.9572	72779728.0
2012-11-15 14:00:00	AAPL	Stock	18.9561	18.9732	18.8071	18.8196	65841524.0
2012-11-15 15:00:00	AAPL	Stock	18.8218	18.8657	18.665	18.7804	158455444.0
2012-11-15 16:00:00	AAPL	Stock	18.7864	18.9207	18.683	18.7646	14191688.0
2012-11-15 17:00:00	AAPL	Stock	18.7668	18.7707	18.6429	18.7589	565124.0
2012-11-15 18:00:00	AAPL	Stock	18.7625	18.7625	18.7143	18.725	631288.0
2012-11-15 19:00:00	AAPL	Stock	18.73	18.7357	18.7196	18.735	470400.0
2012-11-15 07:00:00	MSFT	Stock	26.92	26.93	26.86	26.93	11734.0
2012-11-15 08:00:00	MSFT	Stock	26.87	26.92	26.83	26.87	168235.0
2012-11-15 09:00:00	MSFT	Stock	26.85	26.97	26.69	26.805	6540922.0
2012-11-15 10:00:00	MSFT	Stock	26.8	26.9	26.75	26.78	8202344.0
2012-11-15 11:00:00	MSFT	Stock	26.78	26.8	26.7	26.79	7114988.0
2012-11-15 12:00:00	MSFT	Stock	26.79	26.81	26.73	26.76	4601026.0
2012-11-15 13:00:00	MSFT	Stock	26.75	26.81	26.7	26.76	5335478.0
2012-11-15 14:00:00	MSFT	Stock	26.76	26.83	26.73	26.76	4368355.0
2012-11-15 15:00:00	MSFT	Stock	26.76	26.765	26.63	26.67	10320869.0
2012-11-15 16:00:00	MSFT	Stock	26.66	26.867	26.66	26.66	2355458.0
2012-11-15 17:00:00	MSFT	Stock	26.67	26.7	26.56	26.62	12836.0
2012-11-15 18:00:00	MSFT	Stock	26.65	26.65	26.56	26.63	8123.0
2012-11-15 19:00:00	MSFT	Stock	26.62	26.65	26.6	26.65	7900.0
2012-11-15 05:00:00	NVDA	Stock	0.295	0.295	0.286	0.286	36000.0
2012-11-15 06:00:00	NVDA	Stock	0.2912	0.2912	0.2912	0.2912	20000.0
2012-11-15 07:00:00	NVDA	Stock	0.29	0.29	0.29	0.29	8000.0
2012-11-15 08:00:00	NVDA	Stock	0.291	0.291	0.2895	0.2902	78280.0
2012-11-15 09:00:00	NVDA	Stock	0.289	0.2978	0.289	0.2938	109255400.0
2012-11-15 10:00:00	NVDA	Stock	0.2938	0.295	0.2905	0.291	61927000.0
2012-11-15 11:00:00	NVDA	Stock	0.2908	0.2925	0.2902	0.292	38005760.0
2012-11-15 12:00:00	NVDA	Stock	0.2919	0.2921	0.2885	0.289	44080800.0
2012-11-15 13:00:00	NVDA	Stock	0.2892	0.2898	0.288	0.289	52970440.0
2012-11-15 14:00:00	NVDA	Stock	0.289	0.2908	0.2888	0.29	46407320.0
2012-11-15 15:00:00	NVDA	Stock	0.2898	0.2902	0.2878	0.2898	98230840.0
2012-11-15 16:00:00	NVDA	Stock	0.2902	0.2909	0.2888	0.2898	2839320.0
2012-11-15 18:00:00	NVDA	Stock	0.29	0.29	0.29	0.29	80000.0
2012-11-15 19:00:00	NVDA	Stock	0.2898	0.2898	0.2898	0.2898	20000.0
2012-11-15 08:00:00	AMZN	Stock	11.165	11.19	11.13	11.1305	20700.0
2012-11-15 09:00:00	AMZN	Stock	11.13	11.16	11.0625	11.099	6501180.0
2012-11-15 10:00:00	AMZN	Stock	11.09	11.258	11.0685	11.133	10826680.0
2012-11-15 11:00:00	AMZN	Stock	11.125	11.1346	11.068	11.084	5029640.0
2012-11-15 12:00:00	AMZN	Stock	11.083	11.0854	11.005	11.0105	11231940.0
2012-11-15 13:00:00	AMZN	Stock	11.0125	11.05	10.981	11.0275	10188040.0
2012-11-15 14:00:00	AMZN	Stock	11.024	11.047	10.9915	11.0048	5533180.0

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

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