PREVIEW / stock_1hour / 2011-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-03.parquet
  size:    951 KB
  rows:    44,867
  symbols: 3,530

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-08-03 04:00:00	AAPL	Stock	13.9254	13.9464	13.9054	13.9286	61600.0
2011-08-03 05:00:00	AAPL	Stock	13.9446	13.9571	13.9	13.9293	85400.0
2011-08-03 06:00:00	AAPL	Stock	13.9304	14.0093	13.9229	13.975	243180.0
2011-08-03 07:00:00	AAPL	Stock	13.975	13.98	13.9279	13.9464	625240.0
2011-08-03 08:00:00	AAPL	Stock	13.9532	14.0236	13.9207	14.0068	3210788.0
2011-08-03 09:00:00	AAPL	Stock	14.0104	14.0129	13.8961	14.0039	80490340.0
2011-08-03 10:00:00	AAPL	Stock	14.0039	14.0314	13.6514	13.8654	211380008.0
2011-08-03 11:00:00	AAPL	Stock	13.8678	13.9525	13.8225	13.9043	113709064.0
2011-08-03 12:00:00	AAPL	Stock	13.9071	13.9443	13.8357	13.9225	56207144.0
2011-08-03 13:00:00	AAPL	Stock	13.9207	14.0554	13.8932	14.0114	80723580.0
2011-08-03 14:00:00	AAPL	Stock	14.0114	14.0407	13.9329	13.9771	81130252.0
2011-08-03 15:00:00	AAPL	Stock	13.9761	14.0357	13.9393	14.0204	87119116.0
2011-08-03 16:00:00	AAPL	Stock	14.0179	14.0454	13.736	14.0068	14840000.0
2011-08-03 17:00:00	AAPL	Stock	14.0029	14.0207	14.0025	14.0175	265888.0
2011-08-03 18:00:00	AAPL	Stock	14.015	14.0357	14.0111	14.0354	382060.0
2011-08-03 19:00:00	AAPL	Stock	14.0354	14.0536	14.0329	14.0536	435092.0
2011-08-03 04:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	400.0
2011-08-03 05:00:00	MSFT	Stock	26.87	26.87	26.77	26.77	1200.0
2011-08-03 06:00:00	MSFT	Stock	26.81	26.81	26.81	26.81	500.0
2011-08-03 07:00:00	MSFT	Stock	26.8	26.82	26.79	26.82	800.0
2011-08-03 08:00:00	MSFT	Stock	26.8	27.04	26.8	26.9	19695.0
2011-08-03 09:00:00	MSFT	Stock	26.9	27.0	26.63	26.898	5568171.0
2011-08-03 10:00:00	MSFT	Stock	26.89	26.95	26.48	26.59	12534170.0
2011-08-03 11:00:00	MSFT	Stock	26.59	26.78	26.53	26.692	9748726.0
2011-08-03 12:00:00	MSFT	Stock	26.69	26.705	26.5	26.61	5756465.0
2011-08-03 13:00:00	MSFT	Stock	26.61	26.89	26.52	26.748	7442680.0
2011-08-03 14:00:00	MSFT	Stock	26.75	26.81	26.67	26.778	6312308.0
2011-08-03 15:00:00	MSFT	Stock	26.78	27.0	26.76	26.9	14114007.0
2011-08-03 16:00:00	MSFT	Stock	26.9	26.95	26.69	26.92	2422486.0
2011-08-03 17:00:00	MSFT	Stock	26.92	26.92	26.9	26.9	7593.0
2011-08-03 18:00:00	MSFT	Stock	26.92	26.96	26.92	26.96	10552.0
2011-08-03 19:00:00	MSFT	Stock	26.92	26.98	26.92	26.98	1621.0
2011-08-03 07:00:00	NVDA	Stock	0.3612	0.3612	0.3612	0.3612	40000.0
2011-08-03 08:00:00	NVDA	Stock	0.3612	0.3692	0.3605	0.367	416000.0
2011-08-03 09:00:00	NVDA	Stock	0.366	0.3698	0.3602	0.3696	106542200.0
2011-08-03 10:00:00	NVDA	Stock	0.3698	0.371	0.3578	0.3612	197919600.0
2011-08-03 11:00:00	NVDA	Stock	0.3615	0.3685	0.3595	0.3662	103438960.0
2011-08-03 12:00:00	NVDA	Stock	0.3662	0.367	0.3625	0.3654	63919800.0
2011-08-03 13:00:00	NVDA	Stock	0.3655	0.371	0.3628	0.3685	64463200.0
2011-08-03 14:00:00	NVDA	Stock	0.3685	0.37	0.3668	0.3695	82765480.0
2011-08-03 15:00:00	NVDA	Stock	0.3692	0.3715	0.3682	0.3703	133465720.0
2011-08-03 16:00:00	NVDA	Stock	0.37	0.3708	0.3662	0.3705	11865400.0
2011-08-03 17:00:00	NVDA	Stock	0.3705	0.3708	0.3705	0.3708	92000.0
2011-08-03 18:00:00	NVDA	Stock	0.37	0.3705	0.37	0.3705	109200.0
2011-08-03 19:00:00	NVDA	Stock	0.3703	0.3708	0.3703	0.3705	94800.0
2011-08-03 04:00:00	AMZN	Stock	10.6325	10.6335	10.6325	10.6335	6000.0
2011-08-03 06:00:00	AMZN	Stock	10.6565	10.6565	10.656	10.656	4000.0
2011-08-03 07:00:00	AMZN	Stock	10.668	10.682	10.59	10.608	79280.0
2011-08-03 08:00:00	AMZN	Stock	10.592	10.674	10.585	10.662	292480.0
2011-08-03 09:00:00	AMZN	Stock	10.6495	10.7415	10.5945	10.6752	17888460.0

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

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