PREVIEW / stock_1hour / 2011-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-27.parquet
  size:    961 KB
  rows:    46,062
  symbols: 3,553

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-04-27 04:00:00	AAPL	Stock	12.5039	12.5039	12.45	12.5	12460.0
2011-04-27 05:00:00	AAPL	Stock	12.5	12.5143	12.4964	12.4964	25200.0
2011-04-27 06:00:00	AAPL	Stock	12.5139	12.5154	12.5139	12.5154	36400.0
2011-04-27 07:00:00	AAPL	Stock	12.5114	12.5429	12.5107	12.5389	54432.0
2011-04-27 08:00:00	AAPL	Stock	12.535	12.5786	12.5179	12.5689	2311960.0
2011-04-27 09:00:00	AAPL	Stock	12.5668	12.5839	12.5021	12.5111	43573208.0
2011-04-27 10:00:00	AAPL	Stock	12.5104	12.5118	12.3964	12.4018	75806612.0
2011-04-27 11:00:00	AAPL	Stock	12.4007	12.4714	12.4007	12.455	41029324.0
2011-04-27 12:00:00	AAPL	Stock	12.4554	12.5211	12.4489	12.5171	35706300.0
2011-04-27 13:00:00	AAPL	Stock	12.5161	12.5179	12.4875	12.499	33426036.0
2011-04-27 14:00:00	AAPL	Stock	12.4992	12.5264	12.4821	12.5254	30371656.0
2011-04-27 15:00:00	AAPL	Stock	12.5257	12.5461	12.4904	12.5086	70064148.0
2011-04-27 16:00:00	AAPL	Stock	12.5089	12.5326	12.4864	12.5057	14201264.0
2011-04-27 17:00:00	AAPL	Stock	12.5079	12.5129	12.5071	12.5071	849884.0
2011-04-27 18:00:00	AAPL	Stock	12.5036	12.5054	12.4682	12.4718	804888.0
2011-04-27 19:00:00	AAPL	Stock	12.4714	12.4768	12.4482	12.4664	402472.0
2011-04-27 04:00:00	MSFT	Stock	26.27	26.27	26.27	26.27	200.0
2011-04-27 07:00:00	MSFT	Stock	26.19	26.32	26.19	26.32	3997.0
2011-04-27 08:00:00	MSFT	Stock	26.32	26.36	26.28	26.3	42776.0
2011-04-27 09:00:00	MSFT	Stock	26.3	26.34	26.1	26.225	5075396.0
2011-04-27 10:00:00	MSFT	Stock	26.22	26.24	26.13	26.18	7888832.0
2011-04-27 11:00:00	MSFT	Stock	26.18	26.29	26.17	26.253	6806439.0
2011-04-27 12:00:00	MSFT	Stock	26.25	26.335	26.21	26.305	5224263.0
2011-04-27 13:00:00	MSFT	Stock	26.3	26.315	26.26	26.29	7449980.0
2011-04-27 14:00:00	MSFT	Stock	26.292	26.31	26.225	26.298	6814184.0
2011-04-27 15:00:00	MSFT	Stock	26.292	26.39	26.25	26.39	10277665.0
2011-04-27 16:00:00	MSFT	Stock	26.38	26.4	26.19	26.36	1597092.0
2011-04-27 17:00:00	MSFT	Stock	26.37	26.42	26.36	26.42	168791.0
2011-04-27 18:00:00	MSFT	Stock	26.42	26.43	26.38	26.4	43045.0
2011-04-27 19:00:00	MSFT	Stock	26.4	26.45	26.4	26.43	35602.0
2011-04-27 08:00:00	NVDA	Stock	0.4862	0.4865	0.4848	0.4848	44000.0
2011-04-27 09:00:00	NVDA	Stock	0.4848	0.485	0.4763	0.4763	76850880.0
2011-04-27 10:00:00	NVDA	Stock	0.4763	0.4793	0.4725	0.4785	93418800.0
2011-04-27 11:00:00	NVDA	Stock	0.4785	0.483	0.4785	0.4823	46033120.0
2011-04-27 12:00:00	NVDA	Stock	0.4822	0.4845	0.4811	0.484	61023560.0
2011-04-27 13:00:00	NVDA	Stock	0.4838	0.484	0.4812	0.4815	38769920.0
2011-04-27 14:00:00	NVDA	Stock	0.4815	0.4825	0.4798	0.4822	46532680.0
2011-04-27 15:00:00	NVDA	Stock	0.4822	0.4832	0.4812	0.4825	79884160.0
2011-04-27 16:00:00	NVDA	Stock	0.4828	0.4828	0.4798	0.482	508680.0
2011-04-27 17:00:00	NVDA	Stock	0.482	0.4825	0.482	0.4825	462600.0
2011-04-27 19:00:00	NVDA	Stock	0.4812	0.4812	0.4812	0.4812	204000.0
2011-04-27 04:00:00	AMZN	Stock	9.0105	9.0105	9.0105	9.0105	2000.0
2011-04-27 05:00:00	AMZN	Stock	9.0105	9.025	9.0105	9.025	4000.0
2011-04-27 06:00:00	AMZN	Stock	9.01	9.01	8.903	8.95	56000.0
2011-04-27 07:00:00	AMZN	Stock	8.9625	9.1125	8.9625	9.0165	670960.0
2011-04-27 08:00:00	AMZN	Stock	9.0175	9.115	9.0	9.0615	6091500.0
2011-04-27 09:00:00	AMZN	Stock	9.06	9.3875	9.0575	9.3765	102703140.0
2011-04-27 10:00:00	AMZN	Stock	9.3765	9.5435	9.345	9.5328	95692180.0
2011-04-27 11:00:00	AMZN	Stock	9.5325	9.6345	9.471	9.6025	55186400.0
2011-04-27 12:00:00	AMZN	Stock	9.6025	9.696	9.5885	9.6942	40473880.0

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

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