PREVIEW / stock_1hour / 2012-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-26.parquet
  size:    910 KB
  rows:    43,458
  symbols: 3,497

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-06-26 04:00:00	AAPL	Stock	20.4357	20.4357	20.4286	20.4286	30800.0
2012-06-26 05:00:00	AAPL	Stock	20.4304	20.4411	20.4107	20.4411	86800.0
2012-06-26 06:00:00	AAPL	Stock	20.4639	20.4639	20.4536	20.4604	11200.0
2012-06-26 07:00:00	AAPL	Stock	20.4468	20.4468	20.3661	20.39	150528.0
2012-06-26 08:00:00	AAPL	Stock	20.4014	20.4125	20.3821	20.3932	806316.0
2012-06-26 09:00:00	AAPL	Stock	20.3975	20.4929	20.3146	20.4364	46412996.0
2012-06-26 10:00:00	AAPL	Stock	20.4359	20.5175	20.3461	20.3596	50026340.0
2012-06-26 11:00:00	AAPL	Stock	20.3554	20.4093	20.3214	20.3857	31429076.0
2012-06-26 12:00:00	AAPL	Stock	20.3904	20.3971	20.3368	20.3757	18700500.0
2012-06-26 13:00:00	AAPL	Stock	20.3757	20.3832	20.2618	20.2625	29546552.0
2012-06-26 14:00:00	AAPL	Stock	20.2636	20.4286	20.2625	20.3789	42672392.0
2012-06-26 15:00:00	AAPL	Stock	20.3782	20.4589	20.3746	20.4307	41609120.0
2012-06-26 16:00:00	AAPL	Stock	20.4329	20.4387	20.3752	20.3855	8032248.0
2012-06-26 17:00:00	AAPL	Stock	20.4196	20.425	20.4186	20.4189	13440.0
2012-06-26 18:00:00	AAPL	Stock	20.4268	20.4286	20.4196	20.4225	84028.0
2012-06-26 19:00:00	AAPL	Stock	20.4239	20.425	20.4107	20.4107	163380.0
2012-06-26 07:00:00	MSFT	Stock	29.95	29.95	29.87	29.87	300.0
2012-06-26 08:00:00	MSFT	Stock	29.87	29.93	29.84	29.84	29707.0
2012-06-26 09:00:00	MSFT	Stock	29.93	30.26	29.93	30.14	5523490.0
2012-06-26 10:00:00	MSFT	Stock	30.14	30.27	30.065	30.13	6437959.0
2012-06-26 11:00:00	MSFT	Stock	30.13	30.24	29.95	30.07	5443559.0
2012-06-26 12:00:00	MSFT	Stock	30.065	30.12	29.995	30.015	3871255.0
2012-06-26 13:00:00	MSFT	Stock	30.015	30.05	29.94	30.038	2977709.0
2012-06-26 14:00:00	MSFT	Stock	30.031	30.12	29.99	30.055	4077395.0
2012-06-26 15:00:00	MSFT	Stock	30.05	30.14	30.0	30.0	7476661.0
2012-06-26 16:00:00	MSFT	Stock	30.035	30.083	29.822	30.06	2367329.0
2012-06-26 17:00:00	MSFT	Stock	30.04	30.04	29.99	30.0	4250.0
2012-06-26 18:00:00	MSFT	Stock	30.05	30.05	30.05	30.05	100.0
2012-06-26 19:00:00	MSFT	Stock	30.02	30.02	30.0	30.0	1000.0
2012-06-26 07:00:00	NVDA	Stock	0.3208	0.3208	0.318	0.318	20000.0
2012-06-26 08:00:00	NVDA	Stock	0.321	0.321	0.3163	0.3163	128720.0
2012-06-26 09:00:00	NVDA	Stock	0.3175	0.319	0.3138	0.314	41492680.0
2012-06-26 10:00:00	NVDA	Stock	0.314	0.3183	0.312	0.3153	73582120.0
2012-06-26 11:00:00	NVDA	Stock	0.3151	0.3185	0.3138	0.3181	62807960.0
2012-06-26 12:00:00	NVDA	Stock	0.318	0.3185	0.3169	0.318	41590360.0
2012-06-26 13:00:00	NVDA	Stock	0.3183	0.3185	0.3158	0.318	47460960.0
2012-06-26 14:00:00	NVDA	Stock	0.3178	0.3205	0.3178	0.3191	51529040.0
2012-06-26 15:00:00	NVDA	Stock	0.3193	0.3203	0.3178	0.318	104266480.0
2012-06-26 16:00:00	NVDA	Stock	0.318	0.3193	0.315	0.3193	5061000.0
2012-06-26 17:00:00	NVDA	Stock	0.3193	0.3215	0.318	0.3215	145400.0
2012-06-26 18:00:00	NVDA	Stock	0.32	0.32	0.32	0.32	39600.0
2012-06-26 19:00:00	NVDA	Stock	0.3205	0.321	0.3205	0.3208	38200.0
2012-06-26 07:00:00	AMZN	Stock	11.0635	11.076	11.0635	11.076	13200.0
2012-06-26 08:00:00	AMZN	Stock	11.025	11.072	11.0005	11.072	356940.0
2012-06-26 09:00:00	AMZN	Stock	11.062	11.237	11.056	11.237	13108200.0
2012-06-26 10:00:00	AMZN	Stock	11.2365	11.3195	11.2015	11.236	18593960.0
2012-06-26 11:00:00	AMZN	Stock	11.236	11.283	11.2055	11.2545	7128020.0
2012-06-26 12:00:00	AMZN	Stock	11.255	11.296	11.229	11.2605	4400000.0
2012-06-26 13:00:00	AMZN	Stock	11.263	11.279	11.208	11.2345	5330340.0
2012-06-26 14:00:00	AMZN	Stock	11.236	11.307	11.2345	11.2961	7476780.0

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

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