PREVIEW / stock_1hour / 2012-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-31.parquet
  size:    976 KB
  rows:    45,691
  symbols: 3,548

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-31 04:00:00	AAPL	Stock	20.7321	20.7321	20.6786	20.7036	30800.0
2012-05-31 05:00:00	AAPL	Stock	20.7321	20.7732	20.7143	20.7679	105700.0
2012-05-31 06:00:00	AAPL	Stock	20.7679	20.7679	20.7268	20.7268	33880.0
2012-05-31 07:00:00	AAPL	Stock	20.7268	20.775	20.7232	20.74	705768.0
2012-05-31 08:00:00	AAPL	Stock	20.7407	20.8125	20.6846	20.7893	6678420.0
2012-05-31 09:00:00	AAPL	Stock	20.795	20.8	20.5621	20.6068	71522808.0
2012-05-31 10:00:00	AAPL	Stock	20.6011	20.6161	20.4093	20.5546	99413524.0
2012-05-31 11:00:00	AAPL	Stock	20.5494	20.6325	20.4982	20.5841	51848440.0
2012-05-31 12:00:00	AAPL	Stock	20.5821	20.7304	20.5643	20.6715	54328932.0
2012-05-31 13:00:00	AAPL	Stock	20.6714	20.7329	20.56	20.5875	54045936.0
2012-05-31 14:00:00	AAPL	Stock	20.5875	20.6843	20.5764	20.6529	37958732.0
2012-05-31 15:00:00	AAPL	Stock	20.6575	20.7396	20.625	20.6268	83372884.0
2012-05-31 16:00:00	AAPL	Stock	20.6254	20.7098	20.5989	20.6114	23846144.0
2012-05-31 17:00:00	AAPL	Stock	20.6118	20.6332	20.5554	20.5711	892696.0
2012-05-31 18:00:00	AAPL	Stock	20.5775	20.6332	20.5714	20.5821	168532.0
2012-05-31 19:00:00	AAPL	Stock	20.5871	20.5907	20.5764	20.5793	172004.0
2012-05-31 08:00:00	MSFT	Stock	29.34	29.39	29.3	29.31	17424.0
2012-05-31 09:00:00	MSFT	Stock	29.35	29.35	29.01	29.04	3988148.0
2012-05-31 10:00:00	MSFT	Stock	29.04	29.13	28.95	29.04	6218682.0
2012-05-31 11:00:00	MSFT	Stock	29.036	29.208	28.94	29.16	3454084.0
2012-05-31 12:00:00	MSFT	Stock	29.16	29.33	29.11	29.305	3029447.0
2012-05-31 13:00:00	MSFT	Stock	29.3	29.42	29.14	29.18	3167185.0
2012-05-31 14:00:00	MSFT	Stock	29.18	29.3	29.16	29.27	3365586.0
2012-05-31 15:00:00	MSFT	Stock	29.26	29.4	29.19	29.2	9049832.0
2012-05-31 16:00:00	MSFT	Stock	29.2	29.264	29.12	29.15	6328940.0
2012-05-31 17:00:00	MSFT	Stock	29.11	29.3	29.11	29.208	28665.0
2012-05-31 18:00:00	MSFT	Stock	29.13	29.19	29.13	29.13	6250.0
2012-05-31 19:00:00	MSFT	Stock	29.14	29.15	29.11	29.12	2086.0
2012-05-31 08:00:00	NVDA	Stock	0.3143	0.3155	0.3143	0.3155	70000.0
2012-05-31 09:00:00	NVDA	Stock	0.3143	0.3155	0.3068	0.3085	36387960.0
2012-05-31 10:00:00	NVDA	Stock	0.3083	0.311	0.3069	0.3087	56345080.0
2012-05-31 11:00:00	NVDA	Stock	0.3088	0.309	0.307	0.3073	36083240.0
2012-05-31 12:00:00	NVDA	Stock	0.3075	0.3098	0.307	0.3085	42807840.0
2012-05-31 13:00:00	NVDA	Stock	0.3085	0.312	0.3083	0.309	43132320.0
2012-05-31 14:00:00	NVDA	Stock	0.309	0.3109	0.309	0.3099	22647800.0
2012-05-31 15:00:00	NVDA	Stock	0.31	0.3133	0.3095	0.311	87112640.0
2012-05-31 16:00:00	NVDA	Stock	0.3108	0.312	0.3098	0.3107	8579920.0
2012-05-31 17:00:00	NVDA	Stock	0.3125	0.3125	0.3109	0.3109	170240.0
2012-05-31 19:00:00	NVDA	Stock	0.313	0.313	0.313	0.313	4000.0
2012-05-31 04:00:00	AMZN	Stock	10.2525	10.2525	10.2525	10.2525	2000.0
2012-05-31 08:00:00	AMZN	Stock	10.4555	10.49	10.408	10.4265	63600.0
2012-05-31 09:00:00	AMZN	Stock	10.4435	10.4995	10.36	10.4155	7841700.0
2012-05-31 10:00:00	AMZN	Stock	10.4055	10.461	10.3555	10.439	11745140.0
2012-05-31 11:00:00	AMZN	Stock	10.4385	10.581	10.429	10.5055	18509220.0
2012-05-31 12:00:00	AMZN	Stock	10.5095	10.637	10.495	10.5865	11798680.0
2012-05-31 13:00:00	AMZN	Stock	10.5865	10.685	10.568	10.587	12622800.0
2012-05-31 14:00:00	AMZN	Stock	10.589	10.649	10.5835	10.6232	7543320.0
2012-05-31 15:00:00	AMZN	Stock	10.6195	10.6894	10.5825	10.639	19598000.0
2012-05-31 16:00:00	AMZN	Stock	10.6455	10.683	10.4892	10.6474	7092380.0
2012-05-31 17:00:00	AMZN	Stock	10.6455	10.6519	10.625	10.6355	69640.0

> showing 50 of 45,691 rows — these rows as CSV

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