PREVIEW / stock_30min / 2011-12-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-07.parquet
  size:    1.4 MB
  rows:    75,809
  symbols: 3,515

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-12-07 04:30:00	AAPL	Stock	14.0536	14.0536	14.0536	14.0536	2800.0
2011-12-07 05:00:00	AAPL	Stock	14.0361	14.0393	14.0357	14.0357	37800.0
2011-12-07 05:30:00	AAPL	Stock	14.0	14.0	14.0	14.0	30800.0
2011-12-07 07:00:00	AAPL	Stock	14.0	14.0	13.9796	13.9911	93800.0
2011-12-07 07:30:00	AAPL	Stock	13.9914	13.9914	13.9625	13.9796	146636.0
2011-12-07 08:00:00	AAPL	Stock	13.9714	13.9939	13.9254	13.9282	1192688.0
2011-12-07 08:30:00	AAPL	Stock	13.9286	13.9536	13.9036	13.9225	1830472.0
2011-12-07 09:00:00	AAPL	Stock	13.9168	13.9339	13.9018	13.9296	1164352.0
2011-12-07 09:30:00	AAPL	Stock	13.9254	13.9554	13.8186	13.8429	55275192.0
2011-12-07 10:00:00	AAPL	Stock	13.8429	13.8696	13.8193	13.8314	25279688.0
2011-12-07 10:30:00	AAPL	Stock	13.8292	13.8704	13.8129	13.8704	23964780.0
2011-12-07 11:00:00	AAPL	Stock	13.8704	13.8789	13.8454	13.8691	15875580.0
2011-12-07 11:30:00	AAPL	Stock	13.8693	13.921	13.8664	13.9179	20358212.0
2011-12-07 12:00:00	AAPL	Stock	13.9211	13.9343	13.8793	13.9182	16179660.0
2011-12-07 12:30:00	AAPL	Stock	13.9157	13.9239	13.8903	13.9143	9676996.0
2011-12-07 13:00:00	AAPL	Stock	13.9143	13.9232	13.8761	13.9021	8901396.0
2011-12-07 13:30:00	AAPL	Stock	13.9025	13.9064	13.8657	13.8732	7384272.0
2011-12-07 14:00:00	AAPL	Stock	13.8742	13.8832	13.8375	13.8532	15167824.0
2011-12-07 14:30:00	AAPL	Stock	13.8525	13.8782	13.825	13.8376	19762204.0
2011-12-07 15:00:00	AAPL	Stock	13.8396	13.8961	13.8214	13.8888	22286124.0
2011-12-07 15:30:00	AAPL	Stock	13.8918	13.9621	13.8682	13.8979	43668240.0
2011-12-07 16:00:00	AAPL	Stock	13.8975	13.9143	13.8731	13.9139	6376300.0
2011-12-07 16:30:00	AAPL	Stock	13.8521	13.9357	13.8521	13.9196	4129692.0
2011-12-07 17:00:00	AAPL	Stock	13.9625	13.9625	13.9179	13.9357	201320.0
2011-12-07 17:30:00	AAPL	Stock	13.935	13.9357	13.9293	13.9321	98364.0
2011-12-07 18:00:00	AAPL	Stock	13.9346	13.9361	13.8961	13.9357	88620.0
2011-12-07 18:30:00	AAPL	Stock	13.9371	13.9371	13.9304	13.9304	23100.0
2011-12-07 19:00:00	AAPL	Stock	13.9318	13.9339	13.9318	13.9336	17248.0
2011-12-07 19:30:00	AAPL	Stock	13.9289	13.9311	13.9268	13.9286	182280.0
2011-12-07 06:30:00	MSFT	Stock	25.77	25.77	25.77	25.77	200.0
2011-12-07 08:00:00	MSFT	Stock	25.7	25.7	25.62	25.62	13720.0
2011-12-07 08:30:00	MSFT	Stock	25.62	25.69	25.62	25.66	7970.0
2011-12-07 09:00:00	MSFT	Stock	25.63	25.67	25.61	25.67	48661.0
2011-12-07 09:30:00	MSFT	Stock	25.64	25.72	25.39	25.471	7000952.0
2011-12-07 10:00:00	MSFT	Stock	25.479	25.48	25.335	25.41	6025872.0
2011-12-07 10:30:00	MSFT	Stock	25.41	25.43	25.36	25.405	4808027.0
2011-12-07 11:00:00	MSFT	Stock	25.405	25.47	25.37	25.459	4651428.0
2011-12-07 11:30:00	MSFT	Stock	25.46	25.495	25.4	25.449	4647621.0
2011-12-07 12:00:00	MSFT	Stock	25.45	25.52	25.42	25.49	3227487.0
2011-12-07 12:30:00	MSFT	Stock	25.5	25.6	25.46	25.589	3734579.0
2011-12-07 13:00:00	MSFT	Stock	25.585	25.59	25.52	25.535	2827046.0
2011-12-07 13:30:00	MSFT	Stock	25.538	25.6	25.495	25.53	2899354.0
2011-12-07 14:00:00	MSFT	Stock	25.525	25.55	25.41	25.544	2811836.0
2011-12-07 14:30:00	MSFT	Stock	25.55	25.56	25.434	25.49	4152807.0
2011-12-07 15:00:00	MSFT	Stock	25.49	25.63	25.48	25.59	3795708.0
2011-12-07 15:30:00	MSFT	Stock	25.6	25.76	25.58	25.6	9439776.0
2011-12-07 16:00:00	MSFT	Stock	25.6	25.69	25.51	25.548	1824973.0
2011-12-07 16:30:00	MSFT	Stock	25.409	25.68	25.409	25.62	32311.0
2011-12-07 17:00:00	MSFT	Stock	25.66	25.69	25.65	25.69	4350.0
2011-12-07 18:00:00	MSFT	Stock	25.63	25.63	25.6	25.6	9586.0

> showing 50 of 75,809 rows — these rows as CSV

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