PREVIEW / stock_30min / 2012-02-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-21.parquet
  size:    1.5 MB
  rows:    77,204
  symbols: 3,558

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-02-21 04:00:00	AAPL	Stock	18.1068	18.1089	18.0696	18.0696	105000.0
2012-02-21 04:30:00	AAPL	Stock	18.0629	18.0629	18.0589	18.0589	11200.0
2012-02-21 05:00:00	AAPL	Stock	18.0543	18.0543	17.9714	17.9714	75600.0
2012-02-21 05:30:00	AAPL	Stock	17.9993	18.0	17.9704	17.9704	72856.0
2012-02-21 06:00:00	AAPL	Stock	17.9857	18.0268	17.9857	17.9857	107548.0
2012-02-21 06:30:00	AAPL	Stock	17.9679	17.9679	17.9643	17.9643	28084.0
2012-02-21 07:00:00	AAPL	Stock	17.985	18.0175	17.945	17.9554	875028.0
2012-02-21 07:30:00	AAPL	Stock	17.9575	18.0007	17.9575	17.9893	332724.0
2012-02-21 08:00:00	AAPL	Stock	17.9982	18.0861	17.9689	18.0861	2705472.0
2012-02-21 08:30:00	AAPL	Stock	18.0871	18.125	18.0625	18.0829	2045596.0
2012-02-21 09:00:00	AAPL	Stock	18.0829	18.1179	18.0821	18.1089	2081520.0
2012-02-21 09:30:00	AAPL	Stock	18.1029	18.1314	18.0043	18.0614	79940168.0
2012-02-21 10:00:00	AAPL	Stock	18.0598	18.1054	18.0571	18.1032	29038912.0
2012-02-21 10:30:00	AAPL	Stock	18.1032	18.2857	18.1004	18.2854	75903800.0
2012-02-21 11:00:00	AAPL	Stock	18.2854	18.2896	18.2396	18.2614	38727248.0
2012-02-21 11:30:00	AAPL	Stock	18.2582	18.3361	18.2536	18.3297	38903060.0
2012-02-21 12:00:00	AAPL	Stock	18.3275	18.355	18.2639	18.3004	33967136.0
2012-02-21 12:30:00	AAPL	Stock	18.2989	18.3157	18.2321	18.2536	29323840.0
2012-02-21 13:00:00	AAPL	Stock	18.2554	18.2732	18.2089	18.2729	23670192.0
2012-02-21 13:30:00	AAPL	Stock	18.2695	18.2857	18.2279	18.2582	21895916.0
2012-02-21 14:00:00	AAPL	Stock	18.26	18.2679	18.1246	18.1943	40542628.0
2012-02-21 14:30:00	AAPL	Stock	18.1932	18.2125	18.0821	18.1632	43169448.0
2012-02-21 15:00:00	AAPL	Stock	18.1646	18.2421	18.1396	18.2289	37328424.0
2012-02-21 15:30:00	AAPL	Stock	18.2286	18.3875	18.2114	18.3771	68501272.0
2012-02-21 16:00:00	AAPL	Stock	18.3804	18.4389	18.2151	18.4214	21495152.0
2012-02-21 16:30:00	AAPL	Stock	18.4221	18.4357	18.206	18.4336	970452.0
2012-02-21 17:00:00	AAPL	Stock	18.4321	18.4321	18.4075	18.4243	435120.0
2012-02-21 17:30:00	AAPL	Stock	18.4232	18.4521	18.4143	18.4521	603596.0
2012-02-21 18:00:00	AAPL	Stock	18.4543	18.4621	18.4379	18.4457	591668.0
2012-02-21 18:30:00	AAPL	Stock	18.4454	18.4454	18.395	18.4036	1243424.0
2012-02-21 19:00:00	AAPL	Stock	18.4036	18.4036	18.36	18.3604	732340.0
2012-02-21 19:30:00	AAPL	Stock	18.3657	18.375	18.3321	18.3404	675612.0
2012-02-21 05:00:00	MSFT	Stock	31.49	31.49	31.49	31.49	175.0
2012-02-21 07:00:00	MSFT	Stock	31.27	31.27	31.26	31.26	3000.0
2012-02-21 08:00:00	MSFT	Stock	31.24	31.25	31.15	31.23	11200.0
2012-02-21 08:30:00	MSFT	Stock	31.21	31.23	31.2	31.23	1900.0
2012-02-21 09:00:00	MSFT	Stock	31.23	31.26	31.18	31.19	54565.0
2012-02-21 09:30:00	MSFT	Stock	31.2	31.26	31.15	31.22	5718119.0
2012-02-21 10:00:00	MSFT	Stock	31.22	31.48	31.2	31.41	6132341.0
2012-02-21 10:30:00	MSFT	Stock	31.41	31.5	31.39	31.43	4252381.0
2012-02-21 11:00:00	MSFT	Stock	31.42	31.47	31.38	31.46	2671232.0
2012-02-21 11:30:00	MSFT	Stock	31.46	31.5	31.43	31.5	1748843.0
2012-02-21 12:00:00	MSFT	Stock	31.49	31.52	31.31	31.35	4207772.0
2012-02-21 12:30:00	MSFT	Stock	31.345	31.39	31.34	31.37	1620099.0
2012-02-21 13:00:00	MSFT	Stock	31.38	31.405	31.35	31.36	2358164.0
2012-02-21 13:30:00	MSFT	Stock	31.36	31.38	31.29	31.324	2318216.0
2012-02-21 14:00:00	MSFT	Stock	31.325	31.35	31.25	31.34	2587768.0
2012-02-21 14:30:00	MSFT	Stock	31.34	31.35	31.29	31.3	3225522.0
2012-02-21 15:00:00	MSFT	Stock	31.31	31.35	31.25	31.295	2433751.0
2012-02-21 15:30:00	MSFT	Stock	31.3	31.45	31.26	31.438	7350249.0

> showing 50 of 77,204 rows — these rows as CSV

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