PREVIEW / stock_1hour / 2011-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-10.parquet
  size:    900 KB
  rows:    43,380
  symbols: 3,474

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-10-10 04:00:00	AAPL	Stock	13.3557	13.3557	13.3286	13.3557	55440.0
2011-10-10 05:00:00	AAPL	Stock	13.3571	13.3571	13.3571	13.3571	8400.0
2011-10-10 06:00:00	AAPL	Stock	13.375	13.3925	13.375	13.375	143248.0
2011-10-10 07:00:00	AAPL	Stock	13.3921	13.4286	13.375	13.4086	538804.0
2011-10-10 08:00:00	AAPL	Stock	13.4014	13.5475	13.3571	13.5357	6736156.0
2011-10-10 09:00:00	AAPL	Stock	13.5357	13.6385	13.5075	13.638	80257436.0
2011-10-10 10:00:00	AAPL	Stock	13.6371	13.7411	13.6129	13.6729	90951644.0
2011-10-10 11:00:00	AAPL	Stock	13.6737	13.7354	13.6393	13.735	44921240.0
2011-10-10 12:00:00	AAPL	Stock	13.7345	13.7536	13.6946	13.7125	39474064.0
2011-10-10 13:00:00	AAPL	Stock	13.7125	13.7429	13.6943	13.7329	24355016.0
2011-10-10 14:00:00	AAPL	Stock	13.7363	13.7814	13.7039	13.735	41839308.0
2011-10-10 15:00:00	AAPL	Stock	13.735	13.8861	13.7039	13.8861	95349072.0
2011-10-10 16:00:00	AAPL	Stock	13.885	13.9357	13.6805	13.9289	10388840.0
2011-10-10 17:00:00	AAPL	Stock	13.9325	13.9629	13.8861	13.9536	1450484.0
2011-10-10 18:00:00	AAPL	Stock	13.955	13.9796	13.9446	13.9464	705908.0
2011-10-10 19:00:00	AAPL	Stock	13.95	13.9589	13.9293	13.9375	651252.0
2011-10-10 04:00:00	MSFT	Stock	26.55	26.55	26.55	26.55	100.0
2011-10-10 05:00:00	MSFT	Stock	26.53	26.53	26.53	26.53	200.0
2011-10-10 06:00:00	MSFT	Stock	26.66	26.66	26.66	26.66	200.0
2011-10-10 07:00:00	MSFT	Stock	26.6	26.64	26.59	26.63	4400.0
2011-10-10 08:00:00	MSFT	Stock	26.58	26.69	26.5	26.6	32162.0
2011-10-10 09:00:00	MSFT	Stock	26.6	26.68	26.47	26.61	4489225.0
2011-10-10 10:00:00	MSFT	Stock	26.61	26.8	26.59	26.73	7784798.0
2011-10-10 11:00:00	MSFT	Stock	26.73	26.835	26.71	26.812	3491840.0
2011-10-10 12:00:00	MSFT	Stock	26.82	26.82	26.73	26.78	3122673.0
2011-10-10 13:00:00	MSFT	Stock	26.78	26.85	26.77	26.804	3347801.0
2011-10-10 14:00:00	MSFT	Stock	26.8	26.835	26.732	26.75	3603939.0
2011-10-10 15:00:00	MSFT	Stock	26.751	26.94	26.64	26.94	11438418.0
2011-10-10 16:00:00	MSFT	Stock	26.94	26.97	26.25	26.94	3733577.0
2011-10-10 17:00:00	MSFT	Stock	26.94	26.94	26.76	26.94	33286.0
2011-10-10 18:00:00	MSFT	Stock	26.94	27.04	26.94	26.99	7741.0
2011-10-10 19:00:00	MSFT	Stock	26.94	26.95	26.94	26.95	200.0
2011-10-10 08:00:00	NVDA	Stock	0.3555	0.362	0.3555	0.3612	591200.0
2011-10-10 09:00:00	NVDA	Stock	0.3612	0.3651	0.359	0.365	65439080.0
2011-10-10 10:00:00	NVDA	Stock	0.365	0.3688	0.3645	0.3663	91041800.0
2011-10-10 11:00:00	NVDA	Stock	0.3662	0.3685	0.3642	0.3673	46382120.0
2011-10-10 12:00:00	NVDA	Stock	0.3675	0.3685	0.3642	0.3655	61539200.0
2011-10-10 13:00:00	NVDA	Stock	0.3658	0.3684	0.3654	0.3678	37980280.0
2011-10-10 14:00:00	NVDA	Stock	0.3678	0.3685	0.366	0.3665	43084560.0
2011-10-10 15:00:00	NVDA	Stock	0.3665	0.3695	0.364	0.3692	168297680.0
2011-10-10 16:00:00	NVDA	Stock	0.3695	0.37	0.3538	0.37	8557920.0
2011-10-10 17:00:00	NVDA	Stock	0.3695	0.37	0.3695	0.3695	169560.0
2011-10-10 18:00:00	NVDA	Stock	0.3695	0.3713	0.3695	0.37	46400.0
2011-10-10 19:00:00	NVDA	Stock	0.3698	0.3698	0.3695	0.3695	66000.0
2011-10-10 04:00:00	AMZN	Stock	11.4005	11.4005	11.4005	11.4005	2000.0
2011-10-10 06:00:00	AMZN	Stock	11.4265	11.4265	11.4265	11.4265	2000.0
2011-10-10 07:00:00	AMZN	Stock	11.4275	11.4275	11.397	11.412	14000.0
2011-10-10 08:00:00	AMZN	Stock	11.374	11.3875	11.339	11.35	183140.0
2011-10-10 09:00:00	AMZN	Stock	11.35	11.495	11.205	11.4914	18804840.0
2011-10-10 10:00:00	AMZN	Stock	11.4908	11.64	11.4255	11.595	23178280.0

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

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