PREVIEW / stock_1hour / 2011-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-26.parquet
  size:    956 KB
  rows:    45,785
  symbols: 3,521

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-07-26 04:00:00	AAPL	Stock	14.2754	14.2754	14.2179	14.2411	53200.0
2011-07-26 05:00:00	AAPL	Stock	14.2382	14.2393	14.2289	14.2321	42336.0
2011-07-26 06:00:00	AAPL	Stock	14.2464	14.2625	14.2446	14.2464	57652.0
2011-07-26 07:00:00	AAPL	Stock	14.2496	14.3036	14.2496	14.2846	1106392.0
2011-07-26 08:00:00	AAPL	Stock	14.2886	14.3321	14.2675	14.2932	4724356.0
2011-07-26 09:00:00	AAPL	Stock	14.2925	14.4089	14.2682	14.3225	112595000.0
2011-07-26 10:00:00	AAPL	Stock	14.3179	14.3968	14.2896	14.3859	75761588.0
2011-07-26 11:00:00	AAPL	Stock	14.3882	14.4368	14.3832	14.4054	67201204.0
2011-07-26 12:00:00	AAPL	Stock	14.4054	14.4346	14.3971	14.4254	38886484.0
2011-07-26 13:00:00	AAPL	Stock	14.4246	14.4464	14.3918	14.415	39522756.0
2011-07-26 14:00:00	AAPL	Stock	14.4146	14.4282	14.3979	14.4075	37505300.0
2011-07-26 15:00:00	AAPL	Stock	14.4075	14.4339	14.3929	14.4021	73655904.0
2011-07-26 16:00:00	AAPL	Stock	14.4047	14.427	14.3393	14.3929	15351420.0
2011-07-26 17:00:00	AAPL	Stock	14.39	14.4029	14.3696	14.3718	251748.0
2011-07-26 18:00:00	AAPL	Stock	14.3714	14.4075	14.37	14.3789	266784.0
2011-07-26 19:00:00	AAPL	Stock	14.3857	14.3857	14.375	14.375	264460.0
2011-07-26 07:00:00	MSFT	Stock	27.9	27.95	27.9	27.92	4103.0
2011-07-26 08:00:00	MSFT	Stock	27.88	27.92	27.86	27.87	8417.0
2011-07-26 09:00:00	MSFT	Stock	27.87	27.99	27.78	27.9	7151100.0
2011-07-26 10:00:00	MSFT	Stock	27.9	27.99	27.845	27.99	11257259.0
2011-07-26 11:00:00	MSFT	Stock	27.99	28.045	27.95	28.008	7799440.0
2011-07-26 12:00:00	MSFT	Stock	28.01	28.08	28.0	28.08	11117241.0
2011-07-26 13:00:00	MSFT	Stock	28.08	28.09	28.04	28.08	6507093.0
2011-07-26 14:00:00	MSFT	Stock	28.08	28.145	28.02	28.03	8673617.0
2011-07-26 15:00:00	MSFT	Stock	28.03	28.1	28.01	28.07	14260569.0
2011-07-26 16:00:00	MSFT	Stock	28.07	28.09	27.97	28.0	5470531.0
2011-07-26 17:00:00	MSFT	Stock	28.05	28.07	28.0	28.0	2884.0
2011-07-26 18:00:00	MSFT	Stock	28.01	28.08	27.91	27.95	39115.0
2011-07-26 19:00:00	MSFT	Stock	27.95	28.0	27.94	27.95	4323.0
2011-07-26 20:00:00	MSFT	Stock	27.91	27.91	27.91	27.91	500.0
2011-07-26 07:00:00	NVDA	Stock	0.3675	0.3713	0.3575	0.3578	483280.0
2011-07-26 08:00:00	NVDA	Stock	0.3592	0.3595	0.355	0.3562	3943200.0
2011-07-26 09:00:00	NVDA	Stock	0.3562	0.3675	0.355	0.3598	132297400.0
2011-07-26 10:00:00	NVDA	Stock	0.3598	0.3621	0.3548	0.3615	180105440.0
2011-07-26 11:00:00	NVDA	Stock	0.3615	0.3648	0.3612	0.3625	113089520.0
2011-07-26 12:00:00	NVDA	Stock	0.3625	0.3643	0.362	0.3628	42526680.0
2011-07-26 13:00:00	NVDA	Stock	0.3628	0.363	0.3602	0.3615	34814200.0
2011-07-26 14:00:00	NVDA	Stock	0.3612	0.3638	0.3612	0.362	52412680.0
2011-07-26 15:00:00	NVDA	Stock	0.362	0.3625	0.359	0.36	115481640.0
2011-07-26 16:00:00	NVDA	Stock	0.3598	0.3613	0.3598	0.36	14798560.0
2011-07-26 17:00:00	NVDA	Stock	0.3598	0.36	0.3588	0.3588	669920.0
2011-07-26 18:00:00	NVDA	Stock	0.3592	0.3592	0.3588	0.3588	32000.0
2011-07-26 19:00:00	NVDA	Stock	0.3588	0.3588	0.3588	0.3588	64000.0
2011-07-26 05:00:00	AMZN	Stock	10.6395	10.6395	10.638	10.638	4000.0
2011-07-26 06:00:00	AMZN	Stock	10.7125	10.7125	10.7	10.7	4000.0
2011-07-26 07:00:00	AMZN	Stock	10.77	10.77	10.77	10.77	2000.0
2011-07-26 08:00:00	AMZN	Stock	10.75	10.8005	10.7125	10.78	332200.0
2011-07-26 09:00:00	AMZN	Stock	10.7675	10.78	10.6505	10.697	15341720.0
2011-07-26 10:00:00	AMZN	Stock	10.697	10.7125	10.56	10.641	22605620.0
2011-07-26 11:00:00	AMZN	Stock	10.6455	10.651	10.553	10.553	14004720.0

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

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