PREVIEW / stock_30min / 2011-04-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-21.parquet
  size:    1.4 MB
  rows:    74,689
  symbols: 3,533

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-04-21 04:00:00	AAPL	Stock	12.6964	12.7561	12.6964	12.7296	74200.0
2011-04-21 04:30:00	AAPL	Stock	12.7143	12.7293	12.7143	12.7282	43120.0
2011-04-21 05:00:00	AAPL	Stock	12.7268	12.7321	12.715	12.7321	70000.0
2011-04-21 05:30:00	AAPL	Stock	12.7321	12.74	12.7236	12.7329	60200.0
2011-04-21 06:00:00	AAPL	Stock	12.7236	12.7329	12.715	12.7268	203700.0
2011-04-21 06:30:00	AAPL	Stock	12.7268	12.7268	12.7	12.7	145600.0
2011-04-21 07:00:00	AAPL	Stock	12.7139	12.8154	12.6904	12.7854	2000908.0
2011-04-21 07:30:00	AAPL	Stock	12.7854	12.8893	12.7629	12.8846	3916892.0
2011-04-21 08:00:00	AAPL	Stock	12.8768	12.8875	12.7554	12.7857	8654856.0
2011-04-21 08:30:00	AAPL	Stock	12.7825	12.7846	12.725	12.75	4728808.0
2011-04-21 09:00:00	AAPL	Stock	12.75	12.7821	12.6786	12.6786	8909488.0
2011-04-21 09:30:00	AAPL	Stock	12.6796	12.6832	12.5561	12.583	209922076.0
2011-04-21 10:00:00	AAPL	Stock	12.5829	12.5836	12.4654	12.4789	104457528.0
2011-04-21 10:30:00	AAPL	Stock	12.4786	12.5496	12.4471	12.5459	80814692.0
2011-04-21 11:00:00	AAPL	Stock	12.5486	12.5679	12.5275	12.5661	39726876.0
2011-04-21 11:30:00	AAPL	Stock	12.5668	12.625	12.5653	12.6125	47680416.0
2011-04-21 12:00:00	AAPL	Stock	12.6141	12.6179	12.5643	12.5643	26440316.0
2011-04-21 12:30:00	AAPL	Stock	12.5643	12.5911	12.5539	12.5743	21971236.0
2011-04-21 13:00:00	AAPL	Stock	12.5736	12.5804	12.5557	12.56	17367112.0
2011-04-21 13:30:00	AAPL	Stock	12.56	12.5636	12.5232	12.5582	21484512.0
2011-04-21 14:00:00	AAPL	Stock	12.5582	12.5821	12.5496	12.582	22528268.0
2011-04-21 14:30:00	AAPL	Stock	12.5815	12.6021	12.5643	12.5663	24467128.0
2011-04-21 15:00:00	AAPL	Stock	12.5675	12.5807	12.5421	12.5554	21541828.0
2011-04-21 15:30:00	AAPL	Stock	12.5546	12.5786	12.5	12.5254	66465280.0
2011-04-21 16:00:00	AAPL	Stock	12.5257	12.6481	12.4589	12.5339	13461084.0
2011-04-21 16:30:00	AAPL	Stock	12.5318	12.5651	12.5257	12.5321	1520540.0
2011-04-21 17:00:00	AAPL	Stock	12.5318	12.5321	12.5286	12.5321	251916.0
2011-04-21 17:30:00	AAPL	Stock	12.5321	12.5357	12.5304	12.535	95900.0
2011-04-21 18:00:00	AAPL	Stock	12.5321	12.535	12.525	12.5286	345408.0
2011-04-21 18:30:00	AAPL	Stock	12.5293	12.5354	12.5286	12.5286	129892.0
2011-04-21 19:00:00	AAPL	Stock	12.5318	12.5357	12.5286	12.5304	126560.0
2011-04-21 19:30:00	AAPL	Stock	12.5325	12.54	12.5325	12.5339	61712.0
2011-04-21 07:00:00	MSFT	Stock	25.96	25.96	25.95	25.96	3260.0
2011-04-21 07:30:00	MSFT	Stock	25.96	25.96	25.96	25.96	6500.0
2011-04-21 08:00:00	MSFT	Stock	25.95	25.95	25.87	25.95	10925.0
2011-04-21 08:30:00	MSFT	Stock	25.93	25.96	25.87	25.91	19761.0
2011-04-21 09:00:00	MSFT	Stock	25.91	25.94	25.74	25.76	60275.0
2011-04-21 09:30:00	MSFT	Stock	25.78	25.89	25.58	25.63	5247288.0
2011-04-21 10:00:00	MSFT	Stock	25.62	25.72	25.57	25.606	4697603.0
2011-04-21 10:30:00	MSFT	Stock	25.6	25.61	25.48	25.52	4975839.0
2011-04-21 11:00:00	MSFT	Stock	25.529	25.57	25.5	25.56	2582750.0
2011-04-21 11:30:00	MSFT	Stock	25.565	25.57	25.52	25.54	1778539.0
2011-04-21 12:00:00	MSFT	Stock	25.531	25.56	25.5	25.55	1890212.0
2011-04-21 12:30:00	MSFT	Stock	25.55	25.56	25.5	25.53	1845002.0
2011-04-21 13:00:00	MSFT	Stock	25.54	25.54	25.4	25.412	4344984.0
2011-04-21 13:30:00	MSFT	Stock	25.415	25.42	25.4	25.42	1402609.0
2011-04-21 14:00:00	MSFT	Stock	25.42	25.48	25.41	25.471	1926814.0
2011-04-21 14:30:00	MSFT	Stock	25.475	25.48	25.36	25.375	3166392.0
2011-04-21 15:00:00	MSFT	Stock	25.375	25.45	25.37	25.41	2661464.0
2011-04-21 15:30:00	MSFT	Stock	25.41	25.54	25.41	25.53	6807017.0

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

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