PREVIEW / stock_1hour / 2013-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-05.parquet
  size:    977 KB
  rows:    45,516
  symbols: 3,474

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
2013-04-05 04:00:00	AAPL	Stock	15.2643	15.2857	15.2643	15.2857	13328.0
2013-04-05 05:00:00	AAPL	Stock	15.2736	15.2736	15.2482	15.2482	83636.0
2013-04-05 06:00:00	AAPL	Stock	15.2268	15.2268	15.2268	15.2268	2800.0
2013-04-05 07:00:00	AAPL	Stock	15.2007	15.2575	15.1786	15.2189	428400.0
2013-04-05 08:00:00	AAPL	Stock	15.2261	15.2457	15.125	15.135	2899512.0
2013-04-05 09:00:00	AAPL	Stock	15.1361	15.1718	15.0482	15.0718	68546184.0
2013-04-05 10:00:00	AAPL	Stock	15.075	15.1536	15.0546	15.0996	61233620.0
2013-04-05 11:00:00	AAPL	Stock	15.0996	15.1768	15.0932	15.1154	42336448.0
2013-04-05 12:00:00	AAPL	Stock	15.1154	15.1171	15.0768	15.0854	30071048.0
2013-04-05 13:00:00	AAPL	Stock	15.0879	15.1064	15.0679	15.0896	28432068.0
2013-04-05 14:00:00	AAPL	Stock	15.09	15.1304	15.0679	15.0968	27113968.0
2013-04-05 15:00:00	AAPL	Stock	15.0968	15.1193	14.9886	15.1143	97186068.0
2013-04-05 16:00:00	AAPL	Stock	15.1132	15.1461	15.0322	15.1429	15140636.0
2013-04-05 17:00:00	AAPL	Stock	15.1418	15.1446	15.1143	15.1393	311192.0
2013-04-05 18:00:00	AAPL	Stock	15.1411	15.1411	15.1321	15.1339	47600.0
2013-04-05 19:00:00	AAPL	Stock	15.1339	15.1857	15.1271	15.1782	673960.0
2013-04-05 06:00:00	MSFT	Stock	28.51	28.51	28.5	28.5	5114.0
2013-04-05 07:00:00	MSFT	Stock	28.46	28.5	28.45	28.45	3125.0
2013-04-05 08:00:00	MSFT	Stock	28.44	28.45	28.26	28.3	26545.0
2013-04-05 09:00:00	MSFT	Stock	28.31	28.33	28.11	28.2	6704835.0
2013-04-05 10:00:00	MSFT	Stock	28.2	28.46	28.17	28.37	8483311.0
2013-04-05 11:00:00	MSFT	Stock	28.36	28.43	28.245	28.305	4581590.0
2013-04-05 12:00:00	MSFT	Stock	28.302	28.45	28.295	28.355	5688661.0
2013-04-05 13:00:00	MSFT	Stock	28.35	28.42	28.35	28.4	3777481.0
2013-04-05 14:00:00	MSFT	Stock	28.405	28.57	28.39	28.55	4903194.0
2013-04-05 15:00:00	MSFT	Stock	28.55	28.78	28.52	28.7	10437576.0
2013-04-05 16:00:00	MSFT	Stock	28.7	28.743	28.403	28.67	4335007.0
2013-04-05 17:00:00	MSFT	Stock	28.7	28.7	28.404	28.68	274058.0
2013-04-05 19:00:00	MSFT	Stock	28.64	28.67	28.64	28.67	1515.0
2013-04-05 08:00:00	NVDA	Stock	0.3025	0.3025	0.3015	0.3015	100000.0
2013-04-05 09:00:00	NVDA	Stock	0.3018	0.3035	0.301	0.3028	32767080.0
2013-04-05 10:00:00	NVDA	Stock	0.3025	0.3062	0.3018	0.3059	55692720.0
2013-04-05 11:00:00	NVDA	Stock	0.3058	0.307	0.3054	0.3055	84714400.0
2013-04-05 12:00:00	NVDA	Stock	0.3058	0.3061	0.305	0.3055	34699640.0
2013-04-05 13:00:00	NVDA	Stock	0.3052	0.3065	0.305	0.3051	25419920.0
2013-04-05 14:00:00	NVDA	Stock	0.3051	0.3083	0.305	0.3078	48273760.0
2013-04-05 15:00:00	NVDA	Stock	0.3078	0.3115	0.3069	0.3113	169691520.0
2013-04-05 16:00:00	NVDA	Stock	0.3115	0.3115	0.3052	0.3108	68528440.0
2013-04-05 17:00:00	NVDA	Stock	0.3115	0.3115	0.3115	0.3115	195760.0
2013-04-05 18:00:00	NVDA	Stock	0.3113	0.3113	0.3113	0.3113	20000.0
2013-04-05 19:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	4000.0
2013-04-05 08:00:00	AMZN	Stock	12.833	12.833	12.786	12.8	164340.0
2013-04-05 09:00:00	AMZN	Stock	12.788	12.81	12.713	12.76	9067980.0
2013-04-05 10:00:00	AMZN	Stock	12.7625	12.7745	12.6835	12.737	11713020.0
2013-04-05 11:00:00	AMZN	Stock	12.743	12.809	12.7427	12.754	5508500.0
2013-04-05 12:00:00	AMZN	Stock	12.7525	12.768	12.731	12.751	3998780.0
2013-04-05 13:00:00	AMZN	Stock	12.7495	12.77	12.72	12.7202	5434820.0
2013-04-05 14:00:00	AMZN	Stock	12.7255	12.778	12.7155	12.7508	4063920.0
2013-04-05 15:00:00	AMZN	Stock	12.748	12.8	12.713	12.7705	8700660.0
2013-04-05 16:00:00	AMZN	Stock	12.774	12.7805	12.751	12.7737	764100.0

> showing 50 of 45,516 rows — these rows as CSV

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