PREVIEW / stock_30min / 2012-07-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-07-06.parquet
  size:    1.4 MB
  rows:    73,624
  symbols: 3,477

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-06 04:00:00	AAPL	Stock	21.6825	21.6825	21.6786	21.6789	25200.0
2012-07-06 04:30:00	AAPL	Stock	21.6471	21.6786	21.6471	21.6471	37100.0
2012-07-06 05:00:00	AAPL	Stock	21.6471	21.6471	21.6232	21.6232	7700.0
2012-07-06 05:30:00	AAPL	Stock	21.6232	21.6232	21.6071	21.6071	36512.0
2012-07-06 06:00:00	AAPL	Stock	21.6336	21.6518	21.6336	21.6518	35000.0
2012-07-06 06:30:00	AAPL	Stock	21.6679	21.6679	21.6679	21.6679	5600.0
2012-07-06 07:00:00	AAPL	Stock	21.6696	21.7675	21.6689	21.75	191744.0
2012-07-06 07:30:00	AAPL	Stock	21.7589	21.7679	21.7257	21.7257	301224.0
2012-07-06 08:00:00	AAPL	Stock	21.7314	21.75	21.6964	21.74	1051764.0
2012-07-06 08:30:00	AAPL	Stock	21.7393	21.7393	21.6279	21.6571	3777620.0
2012-07-06 09:00:00	AAPL	Stock	21.6571	21.6893	21.6443	21.6814	2434236.0
2012-07-06 09:30:00	AAPL	Stock	21.6818	21.73	21.4879	21.59	79452296.0
2012-07-06 10:00:00	AAPL	Stock	21.5904	21.6218	21.5571	21.5766	39241048.0
2012-07-06 10:30:00	AAPL	Stock	21.5764	21.6107	21.5257	21.5632	28887796.0
2012-07-06 11:00:00	AAPL	Stock	21.5611	21.5779	21.5011	21.5168	24401468.0
2012-07-06 11:30:00	AAPL	Stock	21.5136	21.5554	21.485	21.5321	23903516.0
2012-07-06 12:00:00	AAPL	Stock	21.5305	21.5396	21.5011	21.5255	14851368.0
2012-07-06 12:30:00	AAPL	Stock	21.5239	21.5993	21.5204	21.5982	20753936.0
2012-07-06 13:00:00	AAPL	Stock	21.5993	21.625	21.5536	21.5789	21006748.0
2012-07-06 13:30:00	AAPL	Stock	21.5771	21.5814	21.5429	21.5566	11856040.0
2012-07-06 14:00:00	AAPL	Stock	21.5589	21.5589	21.5036	21.5354	18316396.0
2012-07-06 14:30:00	AAPL	Stock	21.5382	21.6096	21.5325	21.5964	19302948.0
2012-07-06 15:00:00	AAPL	Stock	21.5939	21.6971	21.5639	21.694	37592100.0
2012-07-06 15:30:00	AAPL	Stock	21.6954	21.7243	21.6325	21.6507	59618356.0
2012-07-06 16:00:00	AAPL	Stock	21.65	21.6589	21.5173	21.6518	5726672.0
2012-07-06 16:30:00	AAPL	Stock	21.6511	21.69	21.5588	21.6579	405944.0
2012-07-06 17:00:00	AAPL	Stock	21.6568	21.6593	21.6511	21.6532	94640.0
2012-07-06 17:30:00	AAPL	Stock	21.6525	21.6525	21.6464	21.6464	125300.0
2012-07-06 18:00:00	AAPL	Stock	21.6454	21.6482	21.6454	21.6464	29792.0
2012-07-06 18:30:00	AAPL	Stock	21.6479	21.6482	21.6479	21.6482	10220.0
2012-07-06 19:00:00	AAPL	Stock	21.6482	21.6518	21.6482	21.65	25788.0
2012-07-06 19:30:00	AAPL	Stock	21.65	21.6611	21.6468	21.6611	62272.0
2012-07-06 08:00:00	MSFT	Stock	30.64	30.64	30.6	30.6	1200.0
2012-07-06 08:30:00	MSFT	Stock	30.5	30.51	30.43	30.46	6680.0
2012-07-06 09:00:00	MSFT	Stock	30.43	30.67	30.43	30.6	118304.0
2012-07-06 09:30:00	MSFT	Stock	30.56	30.7	30.27	30.32	4505627.0
2012-07-06 10:00:00	MSFT	Stock	30.325	30.35	30.12	30.16	3720124.0
2012-07-06 10:30:00	MSFT	Stock	30.165	30.18	30.05	30.075	3439114.0
2012-07-06 11:00:00	MSFT	Stock	30.08	30.1	30.02	30.03	2017841.0
2012-07-06 11:30:00	MSFT	Stock	30.04	30.09	30.0	30.065	2311098.0
2012-07-06 12:00:00	MSFT	Stock	30.07	30.08	30.0	30.01	1504804.0
2012-07-06 12:30:00	MSFT	Stock	30.0	30.035	29.95	30.0	1897599.0
2012-07-06 13:00:00	MSFT	Stock	30.005	30.11	29.99	30.05	2567000.0
2012-07-06 13:30:00	MSFT	Stock	30.06	30.095	30.03	30.058	1369222.0
2012-07-06 14:00:00	MSFT	Stock	30.06	30.06	30.02	30.033	1346540.0
2012-07-06 14:30:00	MSFT	Stock	30.033	30.1	30.03	30.1	1269769.0
2012-07-06 15:00:00	MSFT	Stock	30.095	30.17	30.07	30.12	2993559.0
2012-07-06 15:30:00	MSFT	Stock	30.125	30.21	30.06	30.19	6630146.0
2012-07-06 16:00:00	MSFT	Stock	30.2	30.25	30.088	30.2	1575967.0
2012-07-06 16:30:00	MSFT	Stock	30.081	30.24	30.081	30.2	124080.0

> showing 50 of 73,624 rows — these rows as CSV

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