PREVIEW / stock_30min / 2014-02-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-18.parquet
  size:    1.6 MB
  rows:    82,730
  symbols: 3,568

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
2014-02-18 04:00:00	AAPL	Stock	19.4982	19.4982	19.4643	19.4982	14000.0
2014-02-18 04:30:00	AAPL	Stock	19.4911	19.4911	19.4796	19.4796	5600.0
2014-02-18 05:00:00	AAPL	Stock	19.4796	19.4796	19.4796	19.4796	11088.0
2014-02-18 05:30:00	AAPL	Stock	19.4664	19.4664	19.4664	19.4664	8400.0
2014-02-18 06:00:00	AAPL	Stock	19.4604	19.4643	19.4275	19.4275	32536.0
2014-02-18 06:30:00	AAPL	Stock	19.4264	19.4304	19.4264	19.4304	16660.0
2014-02-18 07:00:00	AAPL	Stock	19.4464	19.4886	19.4357	19.4886	99316.0
2014-02-18 07:30:00	AAPL	Stock	19.4821	19.4886	19.4732	19.4804	90356.0
2014-02-18 08:00:00	AAPL	Stock	19.4768	19.5714	19.4107	19.5268	839356.0
2014-02-18 08:30:00	AAPL	Stock	19.5264	19.5375	19.5029	19.5289	698600.0
2014-02-18 09:00:00	AAPL	Stock	19.5343	19.5536	19.4929	19.5004	665308.0
2014-02-18 09:30:00	AAPL	Stock	19.5004	19.5882	19.4861	19.5086	43221360.0
2014-02-18 10:00:00	AAPL	Stock	19.5071	19.6854	19.4861	19.6582	39235812.0
2014-02-18 10:30:00	AAPL	Stock	19.6568	19.6761	19.6161	19.635	12750248.0
2014-02-18 11:00:00	AAPL	Stock	19.6379	19.6379	19.5779	19.5946	10908828.0
2014-02-18 11:30:00	AAPL	Stock	19.5968	19.6407	19.5932	19.6025	7761712.0
2014-02-18 12:00:00	AAPL	Stock	19.6021	19.6439	19.6021	19.6357	8690892.0
2014-02-18 12:30:00	AAPL	Stock	19.6346	19.6404	19.5893	19.6079	7749644.0
2014-02-18 13:00:00	AAPL	Stock	19.6079	19.625	19.6021	19.6129	5056492.0
2014-02-18 13:30:00	AAPL	Stock	19.6111	19.6214	19.5693	19.6	8422036.0
2014-02-18 14:00:00	AAPL	Stock	19.6	19.6307	19.5911	19.5932	6752508.0
2014-02-18 14:30:00	AAPL	Stock	19.5939	19.6054	19.5718	19.5782	7823592.0
2014-02-18 15:00:00	AAPL	Stock	19.5786	19.5832	19.5225	19.5786	13786444.0
2014-02-18 15:30:00	AAPL	Stock	19.5793	19.5832	19.4925	19.495	21600320.0
2014-02-18 16:00:00	AAPL	Stock	19.4996	19.619	19.4929	19.4973	19373144.0
2014-02-18 16:30:00	AAPL	Stock	19.4996	19.5107	19.4968	19.5054	522620.0
2014-02-18 17:00:00	AAPL	Stock	19.5025	19.5114	19.5025	19.5114	19600.0
2014-02-18 17:30:00	AAPL	Stock	19.5061	19.5143	19.5043	19.5054	41160.0
2014-02-18 18:00:00	AAPL	Stock	19.4996	19.5089	19.4996	19.5071	217420.0
2014-02-18 18:30:00	AAPL	Stock	19.5046	19.5046	19.4907	19.4907	446348.0
2014-02-18 19:00:00	AAPL	Stock	19.4875	19.4893	19.4729	19.4893	85988.0
2014-02-18 19:30:00	AAPL	Stock	19.4846	19.4864	19.475	19.4786	118832.0
2014-02-18 04:00:00	MSFT	Stock	37.55	37.55	37.55	37.55	7500.0
2014-02-18 07:00:00	MSFT	Stock	37.49	37.49	37.49	37.49	300.0
2014-02-18 07:30:00	MSFT	Stock	37.5	37.5	37.49	37.49	700.0
2014-02-18 08:00:00	MSFT	Stock	37.5	37.65	37.34	37.51	9370.0
2014-02-18 08:30:00	MSFT	Stock	37.51	37.62	37.5	37.52	3662.0
2014-02-18 09:00:00	MSFT	Stock	37.57	37.58	37.55	37.58	8647.0
2014-02-18 09:30:00	MSFT	Stock	37.63	37.78	37.51	37.55	5453471.0
2014-02-18 10:00:00	MSFT	Stock	37.55	37.618	37.51	37.55	2640527.0
2014-02-18 10:30:00	MSFT	Stock	37.55	37.62	37.54	37.57	2268698.0
2014-02-18 11:00:00	MSFT	Stock	37.57	37.58	37.51	37.53	1725363.0
2014-02-18 11:30:00	MSFT	Stock	37.525	37.54	37.42	37.47	1823199.0
2014-02-18 12:00:00	MSFT	Stock	37.474	37.52	37.45	37.515	1211616.0
2014-02-18 12:30:00	MSFT	Stock	37.51	37.52	37.45	37.45	1093193.0
2014-02-18 13:00:00	MSFT	Stock	37.459	37.49	37.43	37.43	820999.0
2014-02-18 13:30:00	MSFT	Stock	37.43	37.55	37.41	37.51	2082791.0
2014-02-18 14:00:00	MSFT	Stock	37.52	37.6	37.505	37.57	1612204.0
2014-02-18 14:30:00	MSFT	Stock	37.575	37.59	37.54	37.54	1139832.0
2014-02-18 15:00:00	MSFT	Stock	37.54	37.57	37.52	37.53	1564649.0

> showing 50 of 82,730 rows — these rows as CSV

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