PREVIEW / stock_1hour / 2011-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-23.parquet
  size:    905 KB
  rows:    43,454
  symbols: 3,534

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-11-23 06:00:00	AAPL	Stock	13.3421	13.375	13.3421	13.375	14000.0
2011-11-23 07:00:00	AAPL	Stock	13.3893	13.3893	13.3357	13.36	349832.0
2011-11-23 08:00:00	AAPL	Stock	13.3554	13.3796	13.3179	13.3393	1710464.0
2011-11-23 09:00:00	AAPL	Stock	13.3393	13.4229	13.2614	13.2644	67476612.0
2011-11-23 10:00:00	AAPL	Stock	13.2636	13.2825	13.1354	13.2121	97726188.0
2011-11-23 11:00:00	AAPL	Stock	13.2096	13.2289	13.1186	13.148	56566104.0
2011-11-23 12:00:00	AAPL	Stock	13.1486	13.1971	13.1435	13.1836	31932012.0
2011-11-23 13:00:00	AAPL	Stock	13.1832	13.2089	13.1396	13.1457	33466580.0
2011-11-23 14:00:00	AAPL	Stock	13.145	13.1714	13.1029	13.1579	41572524.0
2011-11-23 15:00:00	AAPL	Stock	13.1579	13.2157	13.1071	13.1071	72588208.0
2011-11-23 16:00:00	AAPL	Stock	13.1071	13.2045	13.095	13.1143	21578508.0
2011-11-23 17:00:00	AAPL	Stock	13.1139	13.1368	13.1111	13.1286	222012.0
2011-11-23 18:00:00	AAPL	Stock	13.1329	13.1386	13.1068	13.1379	191912.0
2011-11-23 19:00:00	AAPL	Stock	13.1386	13.1496	13.1364	13.1496	319312.0
2011-11-23 04:00:00	MSFT	Stock	24.67	24.67	24.52	24.52	400.0
2011-11-23 05:00:00	MSFT	Stock	24.52	24.53	24.52	24.53	600.0
2011-11-23 06:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	400.0
2011-11-23 07:00:00	MSFT	Stock	24.61	24.7	24.61	24.7	2174.0
2011-11-23 08:00:00	MSFT	Stock	24.7	24.7	24.5	24.6	70865.0
2011-11-23 09:00:00	MSFT	Stock	24.6	24.79	24.56	24.57	3976243.0
2011-11-23 10:00:00	MSFT	Stock	24.56	24.62	24.5	24.615	7294912.0
2011-11-23 11:00:00	MSFT	Stock	24.6	24.62	24.49	24.535	7767429.0
2011-11-23 12:00:00	MSFT	Stock	24.52	24.63	24.49	24.62	5147148.0
2011-11-23 13:00:00	MSFT	Stock	24.615	24.69	24.5	24.53	4400292.0
2011-11-23 14:00:00	MSFT	Stock	24.53	24.56	24.495	24.52	4760196.0
2011-11-23 15:00:00	MSFT	Stock	24.52	24.68	24.47	24.47	11930862.0
2011-11-23 16:00:00	MSFT	Stock	24.47	24.67	24.47	24.54	3165415.0
2011-11-23 17:00:00	MSFT	Stock	24.54	24.54	24.52	24.54	2900.0
2011-11-23 18:00:00	MSFT	Stock	24.56	24.58	24.47	24.52	7470.0
2011-11-23 19:00:00	MSFT	Stock	24.54	24.55	24.54	24.55	5600.0
2011-11-23 04:00:00	NVDA	Stock	0.3773	0.3773	0.3773	0.3773	8000.0
2011-11-23 07:00:00	NVDA	Stock	0.3773	0.3773	0.3773	0.3773	40000.0
2011-11-23 08:00:00	NVDA	Stock	0.373	0.373	0.3695	0.3703	186000.0
2011-11-23 09:00:00	NVDA	Stock	0.3703	0.3758	0.37	0.3705	91185720.0
2011-11-23 10:00:00	NVDA	Stock	0.3706	0.3738	0.367	0.373	184918120.0
2011-11-23 11:00:00	NVDA	Stock	0.373	0.3741	0.369	0.3705	114732280.0
2011-11-23 12:00:00	NVDA	Stock	0.3706	0.371	0.3665	0.3689	78986960.0
2011-11-23 13:00:00	NVDA	Stock	0.3689	0.3695	0.363	0.3638	86893760.0
2011-11-23 14:00:00	NVDA	Stock	0.3638	0.373	0.3612	0.362	90714640.0
2011-11-23 15:00:00	NVDA	Stock	0.3618	0.3652	0.3608	0.361	158146440.0
2011-11-23 16:00:00	NVDA	Stock	0.361	0.3732	0.3608	0.3612	17819680.0
2011-11-23 17:00:00	NVDA	Stock	0.3632	0.3632	0.3618	0.3618	48000.0
2011-11-23 19:00:00	NVDA	Stock	0.363	0.3645	0.363	0.3645	25520.0
2011-11-23 07:00:00	AMZN	Stock	9.5705	9.5705	9.541	9.57	28000.0
2011-11-23 08:00:00	AMZN	Stock	9.562	9.65	9.5085	9.619	723760.0
2011-11-23 09:00:00	AMZN	Stock	9.62	9.73	9.511	9.5114	35171340.0
2011-11-23 10:00:00	AMZN	Stock	9.5141	9.5725	9.3945	9.504	40177040.0
2011-11-23 11:00:00	AMZN	Stock	9.505	9.5275	9.424	9.4805	18758920.0
2011-11-23 12:00:00	AMZN	Stock	9.4795	9.5245	9.4515	9.5085	12970880.0
2011-11-23 13:00:00	AMZN	Stock	9.509	9.55	9.475	9.493	10305480.0

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

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