PREVIEW / stock_1hour / 2011-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-10.parquet
  size:    969 KB
  rows:    46,178
  symbols: 3,519

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-03-10 04:00:00	AAPL	Stock	12.5354	12.5354	12.5118	12.5204	37800.0
2011-03-10 05:00:00	AAPL	Stock	12.4839	12.4839	12.4839	12.4839	8792.0
2011-03-10 06:00:00	AAPL	Stock	12.515	12.5154	12.4907	12.4907	36120.0
2011-03-10 07:00:00	AAPL	Stock	12.49	12.5193	12.4714	12.4964	428820.0
2011-03-10 08:00:00	AAPL	Stock	12.5	12.5311	12.4411	12.4496	3925180.0
2011-03-10 09:00:00	AAPL	Stock	12.4507	12.4957	12.3629	12.3971	86830128.0
2011-03-10 10:00:00	AAPL	Stock	12.3969	12.4018	12.3179	12.3962	108667748.0
2011-03-10 11:00:00	AAPL	Stock	12.3959	12.4004	12.3411	12.3779	55714736.0
2011-03-10 12:00:00	AAPL	Stock	12.3768	12.4146	12.3439	12.4079	44869188.0
2011-03-10 13:00:00	AAPL	Stock	12.4098	12.4364	12.3436	12.3804	74224164.0
2011-03-10 14:00:00	AAPL	Stock	12.3804	12.4286	12.3721	12.4077	45545108.0
2011-03-10 15:00:00	AAPL	Stock	12.4093	12.4193	12.3586	12.3825	69731928.0
2011-03-10 16:00:00	AAPL	Stock	12.3796	12.4018	12.3704	12.3982	11272240.0
2011-03-10 17:00:00	AAPL	Stock	12.3964	12.4196	12.3796	12.4193	1329272.0
2011-03-10 18:00:00	AAPL	Stock	12.4196	12.425	12.3811	12.4196	457660.0
2011-03-10 19:00:00	AAPL	Stock	12.4111	12.4225	12.4036	12.4071	293048.0
2011-03-10 04:00:00	MSFT	Stock	25.67	25.69	25.67	25.69	1700.0
2011-03-10 05:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	2000.0
2011-03-10 06:00:00	MSFT	Stock	25.7	25.7	25.67	25.7	3500.0
2011-03-10 07:00:00	MSFT	Stock	25.7	25.75	25.7	25.71	3700.0
2011-03-10 08:00:00	MSFT	Stock	25.72	25.82	25.7	25.71	51516.0
2011-03-10 09:00:00	MSFT	Stock	25.7	25.72	25.46	25.54	8821527.0
2011-03-10 10:00:00	MSFT	Stock	25.535	25.6	25.42	25.527	11975018.0
2011-03-10 11:00:00	MSFT	Stock	25.525	25.67	25.52	25.637	6334275.0
2011-03-10 12:00:00	MSFT	Stock	25.63	25.67	25.52	25.67	4698446.0
2011-03-10 13:00:00	MSFT	Stock	25.67	25.71	25.455	25.551	9059041.0
2011-03-10 14:00:00	MSFT	Stock	25.559	25.575	25.5	25.539	6398582.0
2011-03-10 15:00:00	MSFT	Stock	25.54	25.55	25.35	25.4	15631654.0
2011-03-10 16:00:00	MSFT	Stock	25.405	25.528	25.37	25.41	3024596.0
2011-03-10 17:00:00	MSFT	Stock	25.4	25.48	25.35	25.44	65005.0
2011-03-10 18:00:00	MSFT	Stock	25.44	25.46	25.41	25.46	9163.0
2011-03-10 19:00:00	MSFT	Stock	25.46	25.46	25.43	25.45	2010.0
2011-03-10 04:00:00	NVDA	Stock	0.4763	0.4763	0.4763	0.4763	4280.0
2011-03-10 07:00:00	NVDA	Stock	0.4738	0.476	0.4713	0.4713	27200.0
2011-03-10 08:00:00	NVDA	Stock	0.4742	0.475	0.47	0.471	1567200.0
2011-03-10 09:00:00	NVDA	Stock	0.4713	0.4713	0.4605	0.4662	228782000.0
2011-03-10 10:00:00	NVDA	Stock	0.466	0.4678	0.4615	0.464	250524040.0
2011-03-10 11:00:00	NVDA	Stock	0.4638	0.469	0.4638	0.467	171971520.0
2011-03-10 12:00:00	NVDA	Stock	0.4668	0.4669	0.458	0.4595	190335520.0
2011-03-10 13:00:00	NVDA	Stock	0.4595	0.4612	0.4505	0.453	328817920.0
2011-03-10 14:00:00	NVDA	Stock	0.453	0.4572	0.452	0.4536	216570000.0
2011-03-10 15:00:00	NVDA	Stock	0.4535	0.4542	0.4475	0.4482	303107840.0
2011-03-10 16:00:00	NVDA	Stock	0.448	0.4785	0.4475	0.4525	20267600.0
2011-03-10 17:00:00	NVDA	Stock	0.4522	0.4538	0.4522	0.453	2941920.0
2011-03-10 18:00:00	NVDA	Stock	0.453	0.4545	0.448	0.4545	1537560.0
2011-03-10 19:00:00	NVDA	Stock	0.4532	0.4555	0.453	0.4548	1160680.0
2011-03-10 04:00:00	AMZN	Stock	8.382	8.382	8.382	8.382	2000.0
2011-03-10 08:00:00	AMZN	Stock	8.39	8.3915	8.338	8.338	228820.0
2011-03-10 09:00:00	AMZN	Stock	8.338	8.379	8.264	8.3292	20957560.0
2011-03-10 10:00:00	AMZN	Stock	8.3275	8.3585	8.241	8.3485	19734480.0

> showing 50 of 46,178 rows — these rows as CSV

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