PREVIEW / stock_30min / 2011-12-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-02.parquet
  size:    1.4 MB
  rows:    74,179
  symbols: 3,536

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-02 04:00:00	AAPL	Stock	13.9321	13.945	13.8768	13.8768	31360.0
2011-12-02 04:30:00	AAPL	Stock	14.0	14.0193	14.0	14.0193	22260.0
2011-12-02 05:00:00	AAPL	Stock	14.0179	14.0357	14.0107	14.0107	16800.0
2011-12-02 05:30:00	AAPL	Stock	14.0107	14.0107	14.0071	14.0071	25200.0
2011-12-02 06:00:00	AAPL	Stock	13.9929	13.9929	13.9929	13.9929	2800.0
2011-12-02 06:30:00	AAPL	Stock	13.9821	14.0	13.9482	13.9607	53760.0
2011-12-02 07:00:00	AAPL	Stock	13.9468	13.9911	13.9411	13.9804	335104.0
2011-12-02 07:30:00	AAPL	Stock	13.9725	13.9957	13.9643	13.975	485156.0
2011-12-02 08:00:00	AAPL	Stock	13.9643	13.9782	13.9443	13.9643	1501500.0
2011-12-02 08:30:00	AAPL	Stock	13.9579	13.9907	13.9289	13.9304	4837868.0
2011-12-02 09:00:00	AAPL	Stock	13.9293	13.9421	13.9036	13.9236	3619448.0
2011-12-02 09:30:00	AAPL	Stock	13.9286	13.9982	13.8779	13.9975	63533344.0
2011-12-02 10:00:00	AAPL	Stock	13.9964	14.0582	13.9782	14.0254	47822096.0
2011-12-02 10:30:00	AAPL	Stock	14.0246	14.0421	14.0043	14.025	24011148.0
2011-12-02 11:00:00	AAPL	Stock	14.0239	14.0429	13.9793	14.0018	23949996.0
2011-12-02 11:30:00	AAPL	Stock	14.0021	14.01	13.9271	13.9532	23390472.0
2011-12-02 12:00:00	AAPL	Stock	13.9568	13.9643	13.9404	13.9521	14128044.0
2011-12-02 12:30:00	AAPL	Stock	13.9504	13.9932	13.945	13.9868	12295304.0
2011-12-02 13:00:00	AAPL	Stock	13.9868	14.0	13.9561	13.9696	13365464.0
2011-12-02 13:30:00	AAPL	Stock	13.9693	13.9882	13.9589	13.9754	10956316.0
2011-12-02 14:00:00	AAPL	Stock	13.9736	13.9796	13.9296	13.9575	19715360.0
2011-12-02 14:30:00	AAPL	Stock	13.9564	13.9761	13.9338	13.9675	17470852.0
2011-12-02 15:00:00	AAPL	Stock	13.9646	13.9746	13.9332	13.9486	19442752.0
2011-12-02 15:30:00	AAPL	Stock	13.9482	13.9486	13.9157	13.9179	51294180.0
2011-12-02 16:00:00	AAPL	Stock	13.9261	13.9714	13.9179	13.9296	17848572.0
2011-12-02 16:30:00	AAPL	Stock	13.9289	14.0157	13.9179	13.9261	637868.0
2011-12-02 17:00:00	AAPL	Stock	13.9264	13.9264	13.9154	13.9207	266868.0
2011-12-02 17:30:00	AAPL	Stock	13.9161	13.9179	13.9161	13.9175	22400.0
2011-12-02 18:00:00	AAPL	Stock	13.9179	13.9207	13.9107	13.9207	122052.0
2011-12-02 18:30:00	AAPL	Stock	13.9207	13.925	13.9146	13.9179	141428.0
2011-12-02 19:00:00	AAPL	Stock	13.9179	13.9182	13.9179	13.9179	44800.0
2011-12-02 19:30:00	AAPL	Stock	13.915	13.9279	13.915	13.9229	45780.0
2011-12-02 04:30:00	MSFT	Stock	25.49	25.51	25.49	25.51	2221.0
2011-12-02 05:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	100.0
2011-12-02 07:00:00	MSFT	Stock	25.49	25.53	25.49	25.52	4290.0
2011-12-02 07:30:00	MSFT	Stock	25.5	25.58	25.5	25.58	19470.0
2011-12-02 08:00:00	MSFT	Stock	25.54	25.56	25.51	25.56	64483.0
2011-12-02 08:30:00	MSFT	Stock	25.56	25.6	25.5	25.54	44865.0
2011-12-02 09:00:00	MSFT	Stock	25.55	25.64	25.55	25.64	37351.0
2011-12-02 09:30:00	MSFT	Stock	25.59	25.62	25.35	25.43	4789537.0
2011-12-02 10:00:00	MSFT	Stock	25.42	25.45	25.37	25.38	3389889.0
2011-12-02 10:30:00	MSFT	Stock	25.38	25.39	25.29	25.316	3853653.0
2011-12-02 11:00:00	MSFT	Stock	25.315	25.33	25.231	25.26	4806126.0
2011-12-02 11:30:00	MSFT	Stock	25.255	25.32	25.16	25.23	5953803.0
2011-12-02 12:00:00	MSFT	Stock	25.24	25.32	25.2	25.3	2424441.0
2011-12-02 12:30:00	MSFT	Stock	25.3	25.35	25.22	25.25	3961269.0
2011-12-02 13:00:00	MSFT	Stock	25.25	25.255	25.19	25.244	2242288.0
2011-12-02 13:30:00	MSFT	Stock	25.245	25.26	25.22	25.248	2298626.0
2011-12-02 14:00:00	MSFT	Stock	25.245	25.28	25.22	25.28	2301864.0
2011-12-02 14:30:00	MSFT	Stock	25.27	25.28	25.22	25.244	2369415.0

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

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