PREVIEW / stock_1hour / 2012-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-06.parquet
  size:    941 KB
  rows:    44,662
  symbols: 3,536

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
2012-06-06 04:00:00	AAPL	Stock	20.2018	20.3214	20.2018	20.2857	83552.0
2012-06-06 05:00:00	AAPL	Stock	20.2857	20.2857	20.2857	20.2857	8400.0
2012-06-06 06:00:00	AAPL	Stock	20.2329	20.3214	20.2329	20.3057	82040.0
2012-06-06 07:00:00	AAPL	Stock	20.3054	20.3546	20.2946	20.3339	1073912.0
2012-06-06 08:00:00	AAPL	Stock	20.3371	20.3532	20.2068	20.2164	3127460.0
2012-06-06 09:00:00	AAPL	Stock	20.2089	20.3482	20.1907	20.3222	65969624.0
2012-06-06 10:00:00	AAPL	Stock	20.3243	20.4946	20.2964	20.4589	90003004.0
2012-06-06 11:00:00	AAPL	Stock	20.4625	20.4821	20.3854	20.4257	55956040.0
2012-06-06 12:00:00	AAPL	Stock	20.4239	20.4589	20.4125	20.4421	26934460.0
2012-06-06 13:00:00	AAPL	Stock	20.4454	20.4532	20.375	20.4054	31370864.0
2012-06-06 14:00:00	AAPL	Stock	20.4039	20.4414	20.3236	20.4196	45523044.0
2012-06-06 15:00:00	AAPL	Stock	20.4232	20.4361	20.3568	20.4189	63959280.0
2012-06-06 16:00:00	AAPL	Stock	20.4189	20.4286	20.3863	20.4286	10397184.0
2012-06-06 17:00:00	AAPL	Stock	20.4307	20.4329	20.4093	20.4214	196644.0
2012-06-06 18:00:00	AAPL	Stock	20.425	20.4375	20.4232	20.4371	133084.0
2012-06-06 19:00:00	AAPL	Stock	20.4375	20.4421	20.4218	20.4393	315336.0
2012-06-06 04:00:00	MSFT	Stock	28.8	28.9	28.8	28.9	1000.0
2012-06-06 05:00:00	MSFT	Stock	28.89	28.9	28.89	28.9	1000.0
2012-06-06 06:00:00	MSFT	Stock	28.95	28.95	28.95	28.95	172.0
2012-06-06 07:00:00	MSFT	Stock	28.9	28.94	28.82	28.86	47611.0
2012-06-06 08:00:00	MSFT	Stock	28.84	28.9	28.75	28.75	41918.0
2012-06-06 09:00:00	MSFT	Stock	28.75	29.045	28.75	28.967	6497816.0
2012-06-06 10:00:00	MSFT	Stock	28.96	29.16	28.95	29.065	7805928.0
2012-06-06 11:00:00	MSFT	Stock	29.065	29.1	29.0	29.02	4632693.0
2012-06-06 12:00:00	MSFT	Stock	29.02	29.07	29.0	29.05	3612485.0
2012-06-06 13:00:00	MSFT	Stock	29.06	29.08	29.01	29.01	2917719.0
2012-06-06 14:00:00	MSFT	Stock	29.01	29.07	29.0	29.049	4882869.0
2012-06-06 15:00:00	MSFT	Stock	29.045	29.37	29.03	29.36	12864321.0
2012-06-06 16:00:00	MSFT	Stock	29.36	29.39	28.505	29.33	2971488.0
2012-06-06 17:00:00	MSFT	Stock	29.3	29.33	29.034	29.034	23045.0
2012-06-06 18:00:00	MSFT	Stock	29.31	29.36	29.31	29.36	22826.0
2012-06-06 19:00:00	MSFT	Stock	29.37	29.37	29.32	29.32	5450.0
2012-06-06 08:00:00	NVDA	Stock	0.3052	0.307	0.3042	0.3042	561200.0
2012-06-06 09:00:00	NVDA	Stock	0.3045	0.3083	0.3018	0.3065	40716120.0
2012-06-06 10:00:00	NVDA	Stock	0.3065	0.3088	0.304	0.3085	52311840.0
2012-06-06 11:00:00	NVDA	Stock	0.3088	0.3105	0.3085	0.3095	53241200.0
2012-06-06 12:00:00	NVDA	Stock	0.3098	0.3103	0.3083	0.3098	48777960.0
2012-06-06 13:00:00	NVDA	Stock	0.3098	0.3103	0.3068	0.3068	26645800.0
2012-06-06 14:00:00	NVDA	Stock	0.3068	0.3095	0.3062	0.3075	57818880.0
2012-06-06 15:00:00	NVDA	Stock	0.3075	0.31	0.307	0.3098	75230600.0
2012-06-06 16:00:00	NVDA	Stock	0.3098	0.3098	0.3016	0.3016	3727080.0
2012-06-06 17:00:00	NVDA	Stock	0.3098	0.3098	0.3098	0.3098	18000.0
2012-06-06 19:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	40000.0
2012-06-06 04:00:00	AMZN	Stock	10.775	10.775	10.775	10.775	2000.0
2012-06-06 06:00:00	AMZN	Stock	10.765	10.7745	10.765	10.7745	6900.0
2012-06-06 07:00:00	AMZN	Stock	10.7745	10.8125	10.7745	10.8	50800.0
2012-06-06 08:00:00	AMZN	Stock	10.7805	10.7975	10.699	10.699	261280.0
2012-06-06 09:00:00	AMZN	Stock	10.6975	10.8655	10.6975	10.815	7518500.0
2012-06-06 10:00:00	AMZN	Stock	10.815	10.895	10.795	10.894	9217200.0
2012-06-06 11:00:00	AMZN	Stock	10.891	10.92	10.8616	10.8775	6864980.0

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

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