PREVIEW / stock_1hour / 2012-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-04.parquet
  size:    938 KB
  rows:    44,192
  symbols: 3,463

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-12-04 04:00:00	AAPL	Stock	20.8975	20.8975	20.8975	20.8975	2800.0
2012-12-04 05:00:00	AAPL	Stock	20.8929	20.9282	20.8929	20.9282	11844.0
2012-12-04 06:00:00	AAPL	Stock	20.9282	20.9336	20.9282	20.9286	32732.0
2012-12-04 07:00:00	AAPL	Stock	20.9214	20.925	20.8857	20.9	330064.0
2012-12-04 08:00:00	AAPL	Stock	20.9079	20.9314	20.7661	20.7982	3166968.0
2012-12-04 09:00:00	AAPL	Stock	20.8007	20.8079	20.625	20.6321	67213860.0
2012-12-04 10:00:00	AAPL	Stock	20.6314	20.7315	20.5118	20.5518	93715888.0
2012-12-04 11:00:00	AAPL	Stock	20.5482	20.675	20.4564	20.6354	69954388.0
2012-12-04 12:00:00	AAPL	Stock	20.6371	20.6389	20.5004	20.5018	41968136.0
2012-12-04 13:00:00	AAPL	Stock	20.505	20.5622	20.4332	20.543	54432364.0
2012-12-04 14:00:00	AAPL	Stock	20.5461	20.6011	20.4464	20.5479	43371356.0
2012-12-04 15:00:00	AAPL	Stock	20.5514	20.6554	20.5107	20.5636	71903384.0
2012-12-04 16:00:00	AAPL	Stock	20.5637	20.5893	20.5232	20.5286	22455384.0
2012-12-04 17:00:00	AAPL	Stock	20.5357	20.5661	20.3571	20.375	5202960.0
2012-12-04 18:00:00	AAPL	Stock	20.3811	20.4107	20.3661	20.4018	814632.0
2012-12-04 19:00:00	AAPL	Stock	20.4107	20.4139	20.3893	20.3929	530320.0
2012-12-04 20:00:00	AAPL	Stock	20.3889	20.3889	20.3889	20.3889	2800.0
2012-12-04 07:00:00	MSFT	Stock	26.5	26.55	26.48	26.48	3775.0
2012-12-04 08:00:00	MSFT	Stock	26.5	26.55	26.5	26.53	37706.0
2012-12-04 09:00:00	MSFT	Stock	26.5	26.63	26.4	26.55	6082469.0
2012-12-04 10:00:00	MSFT	Stock	26.545	26.58	26.34	26.38	8866076.0
2012-12-04 11:00:00	MSFT	Stock	26.381	26.49	26.35	26.445	6330263.0
2012-12-04 12:00:00	MSFT	Stock	26.44	26.46	26.38	26.405	4348162.0
2012-12-04 13:00:00	MSFT	Stock	26.402	26.505	26.39	26.49	4867012.0
2012-12-04 14:00:00	MSFT	Stock	26.5	26.5	26.4	26.415	4486784.0
2012-12-04 15:00:00	MSFT	Stock	26.42	26.49	26.34	26.34	10142929.0
2012-12-04 16:00:00	MSFT	Stock	26.375	26.437	26.34	26.37	1697171.0
2012-12-04 17:00:00	MSFT	Stock	26.37	26.37	26.3	26.32	64935.0
2012-12-04 18:00:00	MSFT	Stock	26.34	26.34	26.29	26.32	6103.0
2012-12-04 19:00:00	MSFT	Stock	26.32	26.34	26.31	26.33	15926.0
2012-12-04 08:00:00	NVDA	Stock	0.2945	0.2945	0.2945	0.2945	8000.0
2012-12-04 09:00:00	NVDA	Stock	0.2945	0.2968	0.2925	0.2955	61158600.0
2012-12-04 10:00:00	NVDA	Stock	0.2954	0.298	0.2942	0.298	64712440.0
2012-12-04 11:00:00	NVDA	Stock	0.298	0.299	0.296	0.2989	69239960.0
2012-12-04 12:00:00	NVDA	Stock	0.2989	0.2992	0.2972	0.2982	89068360.0
2012-12-04 13:00:00	NVDA	Stock	0.298	0.3015	0.2972	0.3014	57423440.0
2012-12-04 14:00:00	NVDA	Stock	0.3015	0.3018	0.2998	0.3015	48584480.0
2012-12-04 15:00:00	NVDA	Stock	0.3015	0.303	0.3012	0.3025	128192080.0
2012-12-04 16:00:00	NVDA	Stock	0.3024	0.3032	0.2938	0.3015	8838240.0
2012-12-04 18:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	60000.0
2012-12-04 19:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	40000.0
2012-12-04 07:00:00	AMZN	Stock	12.557	12.557	12.557	12.557	2000.0
2012-12-04 08:00:00	AMZN	Stock	12.5365	12.541	12.5185	12.5185	78120.0
2012-12-04 09:00:00	AMZN	Stock	12.5	12.585	12.4925	12.542	12758000.0
2012-12-04 10:00:00	AMZN	Stock	12.5366	12.5845	12.438	12.4555	13248140.0
2012-12-04 11:00:00	AMZN	Stock	12.455	12.55	12.433	12.5243	8637580.0
2012-12-04 12:00:00	AMZN	Stock	12.531	12.5365	12.493	12.5315	4442560.0
2012-12-04 13:00:00	AMZN	Stock	12.525	12.6225	12.5217	12.6225	5746200.0
2012-12-04 14:00:00	AMZN	Stock	12.6215	12.6365	12.5645	12.6258	5285780.0
2012-12-04 15:00:00	AMZN	Stock	12.625	12.65	12.6015	12.6265	9647020.0

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

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