PREVIEW / stock_1hour / 2011-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-03-03.parquet
  size:    963 KB
  rows:    46,383
  symbols: 3,525

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-03 04:00:00	AAPL	Stock	12.6721	12.6764	12.6696	12.6696	44800.0
2011-03-03 05:00:00	AAPL	Stock	12.6743	12.6764	12.6714	12.6732	187320.0
2011-03-03 06:00:00	AAPL	Stock	12.6732	12.6764	12.6643	12.675	324268.0
2011-03-03 07:00:00	AAPL	Stock	12.675	12.7036	12.6561	12.6964	1054900.0
2011-03-03 08:00:00	AAPL	Stock	12.6946	12.725	12.6718	12.7175	5307400.0
2011-03-03 09:00:00	AAPL	Stock	12.7146	12.7921	12.7114	12.74	104842668.0
2011-03-03 10:00:00	AAPL	Stock	12.7393	12.8136	12.7357	12.8107	99828176.0
2011-03-03 11:00:00	AAPL	Stock	12.8105	12.8225	12.7814	12.8087	65862524.0
2011-03-03 12:00:00	AAPL	Stock	12.8096	12.8164	12.7986	12.8043	28503468.0
2011-03-03 13:00:00	AAPL	Stock	12.805	12.8157	12.7939	12.8136	32933012.0
2011-03-03 14:00:00	AAPL	Stock	12.8129	12.8468	12.8089	12.845	61350044.0
2011-03-03 15:00:00	AAPL	Stock	12.8454	12.8496	12.8154	12.8414	79254476.0
2011-03-03 16:00:00	AAPL	Stock	12.8386	12.843	12.7927	12.8393	15932252.0
2011-03-03 17:00:00	AAPL	Stock	12.8375	12.8482	12.744	12.8482	1602720.0
2011-03-03 18:00:00	AAPL	Stock	12.8479	12.8511	12.8414	12.8507	332948.0
2011-03-03 19:00:00	AAPL	Stock	12.8514	12.8564	12.8507	12.8554	460740.0
2011-03-03 07:00:00	MSFT	Stock	26.27	26.27	26.2	26.21	8200.0
2011-03-03 08:00:00	MSFT	Stock	26.21	26.29	26.16	26.25	88595.0
2011-03-03 09:00:00	MSFT	Stock	26.26	26.4	26.19	26.35	6069041.0
2011-03-03 10:00:00	MSFT	Stock	26.35	26.39	26.29	26.333	7743691.0
2011-03-03 11:00:00	MSFT	Stock	26.33	26.35	26.27	26.305	9308463.0
2011-03-03 12:00:00	MSFT	Stock	26.31	26.35	26.26	26.3	6383047.0
2011-03-03 13:00:00	MSFT	Stock	26.31	26.32	26.23	26.24	8518303.0
2011-03-03 14:00:00	MSFT	Stock	26.232	26.29	26.2	26.24	8918437.0
2011-03-03 15:00:00	MSFT	Stock	26.25	26.27	26.18	26.19	18233079.0
2011-03-03 16:00:00	MSFT	Stock	26.202	26.289	26.18	26.21	2181655.0
2011-03-03 17:00:00	MSFT	Stock	26.21	26.22	26.21	26.22	4375.0
2011-03-03 18:00:00	MSFT	Stock	26.24	26.24	26.2	26.22	2800.0
2011-03-03 19:00:00	MSFT	Stock	26.22	26.24	26.2	26.2	22574.0
2011-03-03 07:00:00	NVDA	Stock	0.5287	0.53	0.5282	0.53	564000.0
2011-03-03 08:00:00	NVDA	Stock	0.525	0.531	0.525	0.5275	3217080.0
2011-03-03 09:00:00	NVDA	Stock	0.5295	0.5338	0.5112	0.5153	298533960.0
2011-03-03 10:00:00	NVDA	Stock	0.5152	0.5175	0.506	0.5102	246100200.0
2011-03-03 11:00:00	NVDA	Stock	0.5104	0.5245	0.5098	0.52	236940760.0
2011-03-03 12:00:00	NVDA	Stock	0.52	0.529	0.5188	0.5234	206577120.0
2011-03-03 13:00:00	NVDA	Stock	0.5232	0.5242	0.517	0.5185	117510720.0
2011-03-03 14:00:00	NVDA	Stock	0.5187	0.5238	0.517	0.5195	130282600.0
2011-03-03 15:00:00	NVDA	Stock	0.5198	0.523	0.5188	0.5218	275534840.0
2011-03-03 16:00:00	NVDA	Stock	0.5207	0.522	0.5106	0.522	45340560.0
2011-03-03 17:00:00	NVDA	Stock	0.5228	0.5228	0.52	0.5215	747720.0
2011-03-03 18:00:00	NVDA	Stock	0.5213	0.5228	0.5207	0.522	785560.0
2011-03-03 19:00:00	NVDA	Stock	0.5205	0.522	0.5205	0.522	141120.0
2011-03-03 07:00:00	AMZN	Stock	8.6775	8.6775	8.65	8.65	10000.0
2011-03-03 08:00:00	AMZN	Stock	8.66	8.72	8.66	8.7	329380.0
2011-03-03 09:00:00	AMZN	Stock	8.6875	8.701	8.6025	8.665	11219920.0
2011-03-03 10:00:00	AMZN	Stock	8.661	8.6975	8.6305	8.653	11255720.0
2011-03-03 11:00:00	AMZN	Stock	8.6535	8.713	8.641	8.707	10141260.0
2011-03-03 12:00:00	AMZN	Stock	8.708	8.71	8.6825	8.6985	4533460.0
2011-03-03 13:00:00	AMZN	Stock	8.6985	8.715	8.675	8.6815	7268020.0
2011-03-03 14:00:00	AMZN	Stock	8.6825	8.723	8.6665	8.6665	14557280.0

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

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