PREVIEW / stock_30min / 2012-12-04

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-04.parquet
  size:    1.4 MB
  rows:    74,183
  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:30:00	AAPL	Stock	20.8975	20.8975	20.8975	20.8975	2800.0
2012-12-04 05:00:00	AAPL	Stock	20.8929	20.9107	20.8929	20.9107	5600.0
2012-12-04 05:30:00	AAPL	Stock	20.9282	20.9282	20.9282	20.9282	6244.0
2012-12-04 06:00:00	AAPL	Stock	20.9282	20.9336	20.9282	20.9336	24332.0
2012-12-04 06:30:00	AAPL	Stock	20.9296	20.9296	20.9286	20.9286	8400.0
2012-12-04 07:00:00	AAPL	Stock	20.9214	20.925	20.8857	20.8857	183624.0
2012-12-04 07:30:00	AAPL	Stock	20.8857	20.9236	20.8857	20.9	146440.0
2012-12-04 08:00:00	AAPL	Stock	20.9079	20.9314	20.8871	20.8911	824404.0
2012-12-04 08:30:00	AAPL	Stock	20.8861	20.8929	20.7661	20.7982	2342564.0
2012-12-04 09:00:00	AAPL	Stock	20.8007	20.8079	20.7357	20.7696	2270660.0
2012-12-04 09:30:00	AAPL	Stock	20.7682	20.78	20.625	20.6321	64943200.0
2012-12-04 10:00:00	AAPL	Stock	20.6314	20.7315	20.5682	20.5793	51193772.0
2012-12-04 10:30:00	AAPL	Stock	20.5761	20.6	20.5118	20.5518	42522116.0
2012-12-04 11:00:00	AAPL	Stock	20.5482	20.5664	20.4564	20.5486	32586764.0
2012-12-04 11:30:00	AAPL	Stock	20.5475	20.675	20.5357	20.6354	37367624.0
2012-12-04 12:00:00	AAPL	Stock	20.6371	20.6389	20.5179	20.5843	22754900.0
2012-12-04 12:30:00	AAPL	Stock	20.5796	20.6232	20.5004	20.5018	19213236.0
2012-12-04 13:00:00	AAPL	Stock	20.505	20.5243	20.4332	20.4816	29918196.0
2012-12-04 13:30:00	AAPL	Stock	20.4779	20.5622	20.4554	20.543	24514168.0
2012-12-04 14:00:00	AAPL	Stock	20.5461	20.5711	20.4507	20.4539	18990692.0
2012-12-04 14:30:00	AAPL	Stock	20.4539	20.6011	20.4464	20.5479	24380664.0
2012-12-04 15:00:00	AAPL	Stock	20.5514	20.6554	20.5429	20.5829	29670172.0
2012-12-04 15:30:00	AAPL	Stock	20.5825	20.5843	20.5107	20.5636	42233212.0
2012-12-04 16:00:00	AAPL	Stock	20.5637	20.5893	20.5411	20.5536	22140440.0
2012-12-04 16:30:00	AAPL	Stock	20.55	20.5625	20.5232	20.5286	314944.0
2012-12-04 17:00:00	AAPL	Stock	20.5357	20.5661	20.4161	20.4264	3651984.0
2012-12-04 17:30:00	AAPL	Stock	20.4218	20.4246	20.3571	20.375	1550976.0
2012-12-04 18:00:00	AAPL	Stock	20.3811	20.4039	20.3661	20.3982	496244.0
2012-12-04 18:30:00	AAPL	Stock	20.3961	20.4107	20.3961	20.4018	318388.0
2012-12-04 19:00:00	AAPL	Stock	20.4107	20.4139	20.3961	20.4021	165760.0
2012-12-04 19:30:00	AAPL	Stock	20.3982	20.4036	20.3893	20.3929	364560.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.5	26.55	2775.0
2012-12-04 07:30:00	MSFT	Stock	26.48	26.48	26.48	26.48	1000.0
2012-12-04 08:00:00	MSFT	Stock	26.5	26.55	26.5	26.52	21019.0
2012-12-04 08:30:00	MSFT	Stock	26.52	26.53	26.5	26.53	16687.0
2012-12-04 09:00:00	MSFT	Stock	26.5	26.52	26.47	26.48	19833.0
2012-12-04 09:30:00	MSFT	Stock	26.48	26.63	26.4	26.55	6062636.0
2012-12-04 10:00:00	MSFT	Stock	26.545	26.58	26.4	26.405	4875189.0
2012-12-04 10:30:00	MSFT	Stock	26.411	26.45	26.34	26.38	3990887.0
2012-12-04 11:00:00	MSFT	Stock	26.381	26.47	26.35	26.43	2778849.0
2012-12-04 11:30:00	MSFT	Stock	26.425	26.49	26.375	26.445	3551414.0
2012-12-04 12:00:00	MSFT	Stock	26.44	26.46	26.38	26.43	2149221.0
2012-12-04 12:30:00	MSFT	Stock	26.435	26.45	26.38	26.405	2198941.0
2012-12-04 13:00:00	MSFT	Stock	26.402	26.435	26.39	26.43	2182268.0
2012-12-04 13:30:00	MSFT	Stock	26.42	26.505	26.41	26.49	2684744.0
2012-12-04 14:00:00	MSFT	Stock	26.5	26.5	26.42	26.43	2285518.0
2012-12-04 14:30:00	MSFT	Stock	26.42	26.46	26.4	26.415	2201266.0
2012-12-04 15:00:00	MSFT	Stock	26.42	26.49	26.41	26.44	2795311.0
2012-12-04 15:30:00	MSFT	Stock	26.435	26.45	26.34	26.34	7347618.0

> showing 50 of 74,183 rows — these rows as CSV

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