PREVIEW / stock_30min / 2012-07-31

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-31.parquet
  size:    1.4 MB
  rows:    74,803
  symbols: 3,501

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-07-31 04:30:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	14000.0
2012-07-31 05:00:00	AAPL	Stock	21.4286	21.4643	21.4286	21.4643	37100.0
2012-07-31 06:00:00	AAPL	Stock	21.4643	21.4643	21.4143	21.4143	43120.0
2012-07-31 06:30:00	AAPL	Stock	21.4232	21.4232	21.4089	21.4214	14000.0
2012-07-31 07:00:00	AAPL	Stock	21.4196	21.5339	21.3929	21.5179	1016596.0
2012-07-31 07:30:00	AAPL	Stock	21.5164	21.5179	21.4857	21.5011	260988.0
2012-07-31 08:00:00	AAPL	Stock	21.4932	21.5493	21.4196	21.5093	1719256.0
2012-07-31 08:30:00	AAPL	Stock	21.5079	21.5768	21.4925	21.5468	2445744.0
2012-07-31 09:00:00	AAPL	Stock	21.5496	21.5714	21.5164	21.5357	2564856.0
2012-07-31 09:30:00	AAPL	Stock	21.5368	21.7154	21.5257	21.6686	94860444.0
2012-07-31 10:00:00	AAPL	Stock	21.6704	21.6939	21.6114	21.6714	36735328.0
2012-07-31 10:30:00	AAPL	Stock	21.6707	21.8311	21.6493	21.7821	57633744.0
2012-07-31 11:00:00	AAPL	Stock	21.7843	21.8114	21.7414	21.7965	27832868.0
2012-07-31 11:30:00	AAPL	Stock	21.7946	21.7989	21.7071	21.7196	23850820.0
2012-07-31 12:00:00	AAPL	Stock	21.715	21.7321	21.6643	21.7311	19440932.0
2012-07-31 12:30:00	AAPL	Stock	21.7304	21.7625	21.6964	21.7039	13991628.0
2012-07-31 13:00:00	AAPL	Stock	21.7025	21.8025	21.6936	21.7968	20988912.0
2012-07-31 13:30:00	AAPL	Stock	21.7993	21.825	21.7629	21.7993	26645640.0
2012-07-31 14:00:00	AAPL	Stock	21.7954	21.8454	21.7904	21.8229	23682596.0
2012-07-31 14:30:00	AAPL	Stock	21.8277	21.8393	21.7771	21.7854	20160420.0
2012-07-31 15:00:00	AAPL	Stock	21.7854	21.8357	21.7461	21.8204	22598436.0
2012-07-31 15:30:00	AAPL	Stock	21.8218	21.8464	21.7725	21.8129	42580748.0
2012-07-31 16:00:00	AAPL	Stock	21.8114	21.8261	21.6929	21.7857	13295352.0
2012-07-31 16:30:00	AAPL	Stock	21.7911	21.8129	21.7871	21.7968	1123752.0
2012-07-31 17:00:00	AAPL	Stock	21.795	21.7993	21.7907	21.7914	220612.0
2012-07-31 17:30:00	AAPL	Stock	21.7957	21.8129	21.7946	21.7982	328804.0
2012-07-31 18:00:00	AAPL	Stock	21.7982	21.7996	21.795	21.7968	123648.0
2012-07-31 18:30:00	AAPL	Stock	21.7986	21.8054	21.7964	21.8054	94556.0
2012-07-31 19:00:00	AAPL	Stock	21.8025	21.8064	21.8025	21.8064	30296.0
2012-07-31 19:30:00	AAPL	Stock	21.8061	21.8071	21.7861	21.7929	257320.0
2012-07-31 07:30:00	MSFT	Stock	29.75	29.75	29.75	29.75	200.0
2012-07-31 08:00:00	MSFT	Stock	29.62	29.74	29.62	29.74	7000.0
2012-07-31 08:30:00	MSFT	Stock	29.74	29.74	29.64	29.7	4510.0
2012-07-31 09:00:00	MSFT	Stock	29.65	29.69	29.39	29.51	24000.0
2012-07-31 09:30:00	MSFT	Stock	29.48	29.71	29.42	29.53	5241885.0
2012-07-31 10:00:00	MSFT	Stock	29.53	29.66	29.46	29.62	4096631.0
2012-07-31 10:30:00	MSFT	Stock	29.62	29.66	29.53	29.58	3051334.0
2012-07-31 11:00:00	MSFT	Stock	29.581	29.64	29.56	29.595	2046409.0
2012-07-31 11:30:00	MSFT	Stock	29.6	29.61	29.49	29.49	2329625.0
2012-07-31 12:00:00	MSFT	Stock	29.5	29.5	29.33	29.48	2802788.0
2012-07-31 12:30:00	MSFT	Stock	29.471	29.48	29.363	29.42	1769915.0
2012-07-31 13:00:00	MSFT	Stock	29.41	29.53	29.38	29.502	1327096.0
2012-07-31 13:30:00	MSFT	Stock	29.51	29.52	29.452	29.495	1220540.0
2012-07-31 14:00:00	MSFT	Stock	29.495	29.55	29.48	29.53	1954087.0
2012-07-31 14:30:00	MSFT	Stock	29.53	29.59	29.5	29.518	1483622.0
2012-07-31 15:00:00	MSFT	Stock	29.515	29.56	29.47	29.55	1712023.0
2012-07-31 15:30:00	MSFT	Stock	29.56	29.58	29.45	29.46	4403589.0
2012-07-31 16:00:00	MSFT	Stock	29.46	29.607	29.4	29.41	3300602.0
2012-07-31 16:30:00	MSFT	Stock	29.41	29.543	29.41	29.47	125468.0
2012-07-31 17:00:00	MSFT	Stock	29.46	29.46	29.4	29.4	304.0

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

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