PREVIEW / stock_1hour / 2011-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-26.parquet
  size:    919 KB
  rows:    44,526
  symbols: 3,528

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-26 04:00:00	AAPL	Stock	14.4321	14.4964	14.3811	14.4964	127400.0
2011-09-26 05:00:00	AAPL	Stock	14.5	14.5357	14.4964	14.5054	158144.0
2011-09-26 06:00:00	AAPL	Stock	14.4782	14.4868	14.4286	14.4464	262360.0
2011-09-26 07:00:00	AAPL	Stock	14.4464	14.4857	14.1071	14.2679	5342596.0
2011-09-26 08:00:00	AAPL	Stock	14.2836	14.4393	14.2646	14.4068	14491064.0
2011-09-26 09:00:00	AAPL	Stock	14.4036	14.4193	14.0714	14.0857	142125172.0
2011-09-26 10:00:00	AAPL	Stock	14.0887	14.242	13.975	14.2164	177880612.0
2011-09-26 11:00:00	AAPL	Stock	14.2232	14.3521	14.1786	14.3018	114492672.0
2011-09-26 12:00:00	AAPL	Stock	14.3032	14.3211	14.1429	14.1714	64684648.0
2011-09-26 13:00:00	AAPL	Stock	14.1711	14.1814	14.0796	14.1293	56582624.0
2011-09-26 14:00:00	AAPL	Stock	14.1321	14.2587	14.1164	14.2454	68355028.0
2011-09-26 15:00:00	AAPL	Stock	14.2532	14.4279	14.2343	14.4	109935364.0
2011-09-26 16:00:00	AAPL	Stock	14.3943	14.4059	14.181	14.3875	41240052.0
2011-09-26 17:00:00	AAPL	Stock	14.3946	14.3946	14.3821	14.3864	335860.0
2011-09-26 18:00:00	AAPL	Stock	14.3864	14.3989	14.3779	14.3857	143136.0
2011-09-26 19:00:00	AAPL	Stock	14.3857	14.3889	14.3643	14.3714	416416.0
2011-09-26 05:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	100.0
2011-09-26 06:00:00	MSFT	Stock	25.25	25.25	25.25	25.25	200.0
2011-09-26 07:00:00	MSFT	Stock	25.38	25.47	25.25	25.4	38359.0
2011-09-26 08:00:00	MSFT	Stock	25.4	25.44	25.06	25.31	24397.0
2011-09-26 09:00:00	MSFT	Stock	25.35	25.37	24.96	25.0	4967404.0
2011-09-26 10:00:00	MSFT	Stock	25.0	25.09	24.73	25.052	9315644.0
2011-09-26 11:00:00	MSFT	Stock	25.05	25.35	25.01	25.26	6171370.0
2011-09-26 12:00:00	MSFT	Stock	25.26	25.28	24.95	25.01	4333132.0
2011-09-26 13:00:00	MSFT	Stock	25.01	25.036	24.88	24.978	4784395.0
2011-09-26 14:00:00	MSFT	Stock	24.976	25.24	24.95	25.135	5044109.0
2011-09-26 15:00:00	MSFT	Stock	25.135	25.52	25.1	25.45	12182669.0
2011-09-26 16:00:00	MSFT	Stock	25.46	25.53	25.147	25.44	2745566.0
2011-09-26 17:00:00	MSFT	Stock	25.06	25.45	25.06	25.45	46367.0
2011-09-26 18:00:00	MSFT	Stock	25.44	25.44	25.43	25.43	24200.0
2011-09-26 19:00:00	MSFT	Stock	25.43	25.43	25.43	25.43	4078.0
2011-09-26 07:00:00	NVDA	Stock	0.3545	0.3545	0.3538	0.3538	40000.0
2011-09-26 08:00:00	NVDA	Stock	0.3548	0.3548	0.349	0.351	795400.0
2011-09-26 09:00:00	NVDA	Stock	0.3508	0.351	0.3385	0.3388	95930280.0
2011-09-26 10:00:00	NVDA	Stock	0.3388	0.3418	0.3342	0.3362	181328040.0
2011-09-26 11:00:00	NVDA	Stock	0.336	0.3368	0.3342	0.336	147776560.0
2011-09-26 12:00:00	NVDA	Stock	0.336	0.3368	0.3333	0.3346	102383960.0
2011-09-26 13:00:00	NVDA	Stock	0.3346	0.3368	0.33	0.3342	139026320.0
2011-09-26 14:00:00	NVDA	Stock	0.3344	0.339	0.334	0.3385	124132160.0
2011-09-26 15:00:00	NVDA	Stock	0.3385	0.346	0.338	0.3453	158713240.0
2011-09-26 16:00:00	NVDA	Stock	0.3453	0.3465	0.3377	0.3455	18332480.0
2011-09-26 17:00:00	NVDA	Stock	0.3448	0.345	0.3435	0.3448	188000.0
2011-09-26 18:00:00	NVDA	Stock	0.3445	0.3475	0.3445	0.346	167760.0
2011-09-26 19:00:00	NVDA	Stock	0.345	0.345	0.3438	0.3438	486000.0
2011-09-26 04:00:00	AMZN	Stock	11.153	11.2	11.153	11.2	6000.0
2011-09-26 07:00:00	AMZN	Stock	11.338	11.402	11.338	11.3615	124000.0
2011-09-26 08:00:00	AMZN	Stock	11.3515	11.414	11.3185	11.38	399380.0
2011-09-26 09:00:00	AMZN	Stock	11.394	11.4895	11.3195	11.3408	17872740.0
2011-09-26 10:00:00	AMZN	Stock	11.3405	11.3585	11.07	11.2235	26763200.0
2011-09-26 11:00:00	AMZN	Stock	11.2322	11.3975	11.1865	11.3435	14427900.0

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

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