PREVIEW / stock_1hour / 2011-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-09.parquet
  size:    939 KB
  rows:    44,659
  symbols: 3,540

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-02-09 04:00:00	AAPL	Stock	12.6786	12.6786	12.6786	12.6786	9800.0
2011-02-09 05:00:00	AAPL	Stock	12.6786	12.6786	12.6786	12.6786	5600.0
2011-02-09 06:00:00	AAPL	Stock	12.6771	12.6793	12.6771	12.6786	64120.0
2011-02-09 07:00:00	AAPL	Stock	12.6782	12.6964	12.6561	12.6679	348124.0
2011-02-09 08:00:00	AAPL	Stock	12.6718	12.6932	12.6679	12.685	2126236.0
2011-02-09 09:00:00	AAPL	Stock	12.6875	12.7396	12.6739	12.7364	64239112.0
2011-02-09 10:00:00	AAPL	Stock	12.7364	12.8214	12.7307	12.8107	97791792.0
2011-02-09 11:00:00	AAPL	Stock	12.8107	12.8164	12.7468	12.7764	83717004.0
2011-02-09 12:00:00	AAPL	Stock	12.7764	12.8207	12.7571	12.7986	48921712.0
2011-02-09 13:00:00	AAPL	Stock	12.8	12.8161	12.7768	12.7768	36029028.0
2011-02-09 14:00:00	AAPL	Stock	12.7782	12.7782	12.7279	12.7529	69731256.0
2011-02-09 15:00:00	AAPL	Stock	12.7543	12.7929	12.7518	12.79	61424748.0
2011-02-09 16:00:00	AAPL	Stock	12.7914	12.8071	12.7674	12.7839	8731576.0
2011-02-09 17:00:00	AAPL	Stock	12.7832	12.7843	12.6752	12.7639	776244.0
2011-02-09 18:00:00	AAPL	Stock	12.7629	12.7914	12.76	12.7696	157024.0
2011-02-09 19:00:00	AAPL	Stock	12.7739	12.7857	12.7714	12.7732	396788.0
2011-02-09 08:00:00	MSFT	Stock	28.2	28.26	28.2	28.25	2315.0
2011-02-09 09:00:00	MSFT	Stock	28.24	28.44	28.11	28.222	2476516.0
2011-02-09 10:00:00	MSFT	Stock	28.23	28.26	28.11	28.13	7026497.0
2011-02-09 11:00:00	MSFT	Stock	28.13	28.16	28.04	28.09	5954414.0
2011-02-09 12:00:00	MSFT	Stock	28.09	28.16	28.08	28.115	5278435.0
2011-02-09 13:00:00	MSFT	Stock	28.115	28.15	28.1	28.11	4465031.0
2011-02-09 14:00:00	MSFT	Stock	28.11	28.13	28.03	28.035	10190106.0
2011-02-09 15:00:00	MSFT	Stock	28.03	28.05	27.91	27.952	13355689.0
2011-02-09 16:00:00	MSFT	Stock	27.95	28.083	27.92	27.95	2093285.0
2011-02-09 17:00:00	MSFT	Stock	27.93	27.96	27.78	27.9	25490.0
2011-02-09 18:00:00	MSFT	Stock	27.91	27.97	27.91	27.92	20781.0
2011-02-09 19:00:00	MSFT	Stock	27.93	27.99	27.91	27.91	23747.0
2011-02-09 06:00:00	NVDA	Stock	0.5955	0.5955	0.5955	0.5955	4000.0
2011-02-09 07:00:00	NVDA	Stock	0.5928	0.5928	0.5888	0.5888	77800.0
2011-02-09 08:00:00	NVDA	Stock	0.5912	0.5995	0.5912	0.5975	4350600.0
2011-02-09 09:00:00	NVDA	Stock	0.5983	0.605	0.5955	0.602	132834440.0
2011-02-09 10:00:00	NVDA	Stock	0.602	0.604	0.5863	0.5878	227337640.0
2011-02-09 11:00:00	NVDA	Stock	0.5878	0.5882	0.5715	0.576	365168960.0
2011-02-09 12:00:00	NVDA	Stock	0.576	0.5863	0.5738	0.583	152817840.0
2011-02-09 13:00:00	NVDA	Stock	0.583	0.5872	0.5815	0.5818	87209160.0
2011-02-09 14:00:00	NVDA	Stock	0.5818	0.5828	0.5765	0.5782	133720160.0
2011-02-09 15:00:00	NVDA	Stock	0.5781	0.5838	0.578	0.5822	156713880.0
2011-02-09 16:00:00	NVDA	Stock	0.5822	0.5848	0.58	0.583	7586080.0
2011-02-09 17:00:00	NVDA	Stock	0.5973	0.5973	0.5772	0.578	1577200.0
2011-02-09 18:00:00	NVDA	Stock	0.578	0.582	0.577	0.5772	382600.0
2011-02-09 19:00:00	NVDA	Stock	0.5772	0.5782	0.577	0.577	98280.0
2011-02-09 05:00:00	AMZN	Stock	9.135	9.135	9.094	9.094	6000.0
2011-02-09 07:00:00	AMZN	Stock	9.1135	9.13	9.1135	9.13	8000.0
2011-02-09 08:00:00	AMZN	Stock	9.135	9.135	9.1125	9.13	75660.0
2011-02-09 09:00:00	AMZN	Stock	9.134	9.2	9.1215	9.133	19153760.0
2011-02-09 10:00:00	AMZN	Stock	9.1325	9.2475	9.113	9.235	32235080.0
2011-02-09 11:00:00	AMZN	Stock	9.233	9.2395	9.1825	9.2135	21637960.0
2011-02-09 12:00:00	AMZN	Stock	9.213	9.292	9.1915	9.2655	19442100.0
2011-02-09 13:00:00	AMZN	Stock	9.266	9.3235	9.2605	9.3165	17754480.0

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

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