PREVIEW / stock_30min / 2011-07-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-28.parquet
  size:    1.4 MB
  rows:    74,914
  symbols: 3,528

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-07-28 04:00:00	AAPL	Stock	13.9682	13.9682	13.9682	13.9682	7000.0
2011-07-28 04:30:00	AAPL	Stock	14.0518	14.0543	14.0518	14.0543	8400.0
2011-07-28 05:00:00	AAPL	Stock	14.025	14.0354	14.0086	14.0146	25200.0
2011-07-28 05:30:00	AAPL	Stock	13.9871	13.9925	13.9839	13.9839	30800.0
2011-07-28 06:00:00	AAPL	Stock	13.99	13.9904	13.95	13.9643	119700.0
2011-07-28 06:30:00	AAPL	Stock	13.9946	13.9946	13.9946	13.9946	2800.0
2011-07-28 07:00:00	AAPL	Stock	14.0	14.04	13.9782	14.0211	352016.0
2011-07-28 07:30:00	AAPL	Stock	14.0196	14.05	14.0186	14.0186	268940.0
2011-07-28 08:00:00	AAPL	Stock	14.0232	14.0439	13.9557	13.9586	2514876.0
2011-07-28 08:30:00	AAPL	Stock	13.9625	14.0857	13.9625	14.0554	5308800.0
2011-07-28 09:00:00	AAPL	Stock	14.0554	14.0711	13.9814	13.9907	2708804.0
2011-07-28 09:30:00	AAPL	Stock	13.9864	14.0229	13.8618	13.9804	111703312.0
2011-07-28 10:00:00	AAPL	Stock	13.9818	14.07	13.9439	14.0268	65647960.0
2011-07-28 10:30:00	AAPL	Stock	14.0257	14.1143	14.0146	14.0879	49572264.0
2011-07-28 11:00:00	AAPL	Stock	14.0859	14.1757	14.0789	14.1757	36420356.0
2011-07-28 11:30:00	AAPL	Stock	14.1754	14.1782	14.1461	14.1607	39177572.0
2011-07-28 12:00:00	AAPL	Stock	14.1596	14.1707	14.1107	14.1386	35705404.0
2011-07-28 12:30:00	AAPL	Stock	14.1389	14.1485	14.1196	14.1299	18690308.0
2011-07-28 13:00:00	AAPL	Stock	14.1307	14.1529	14.1211	14.1334	14871164.0
2011-07-28 13:30:00	AAPL	Stock	14.1318	14.1486	14.1261	14.1439	12956720.0
2011-07-28 14:00:00	AAPL	Stock	14.1461	14.1464	14.0325	14.0416	37714600.0
2011-07-28 14:30:00	AAPL	Stock	14.0436	14.0862	13.9821	14.0725	47542796.0
2011-07-28 15:00:00	AAPL	Stock	14.0721	14.0752	13.99	14.0175	36405040.0
2011-07-28 15:30:00	AAPL	Stock	14.015	14.0436	13.9793	13.9968	49243488.0
2011-07-28 16:00:00	AAPL	Stock	13.9993	14.0449	13.9532	13.9936	20536516.0
2011-07-28 16:30:00	AAPL	Stock	13.9793	14.0168	13.9643	13.9707	357448.0
2011-07-28 17:00:00	AAPL	Stock	13.9714	13.9904	13.9646	13.9646	390432.0
2011-07-28 17:30:00	AAPL	Stock	13.9668	13.9871	13.9525	13.9821	338240.0
2011-07-28 18:00:00	AAPL	Stock	13.9768	13.9936	13.9768	13.9821	83160.0
2011-07-28 18:30:00	AAPL	Stock	13.9757	13.9804	13.9679	13.9804	44660.0
2011-07-28 19:00:00	AAPL	Stock	13.9821	13.9854	13.9643	13.9732	175000.0
2011-07-28 19:30:00	AAPL	Stock	13.9679	13.9714	13.9625	13.9682	203448.0
2011-07-28 05:30:00	MSFT	Stock	27.25	27.25	27.2	27.2	10000.0
2011-07-28 06:00:00	MSFT	Stock	27.17	27.18	27.1	27.1	900.0
2011-07-28 06:30:00	MSFT	Stock	27.2	27.2	27.07	27.07	2200.0
2011-07-28 07:00:00	MSFT	Stock	27.18	27.25	27.14	27.25	4700.0
2011-07-28 07:30:00	MSFT	Stock	27.23	27.25	27.22	27.25	2700.0
2011-07-28 08:00:00	MSFT	Stock	27.22	27.22	27.17	27.22	18142.0
2011-07-28 08:30:00	MSFT	Stock	27.22	27.4	27.22	27.34	17808.0
2011-07-28 09:00:00	MSFT	Stock	27.35	27.35	27.22	27.28	13878.0
2011-07-28 09:30:00	MSFT	Stock	27.27	27.715	27.21	27.564	7232386.0
2011-07-28 10:00:00	MSFT	Stock	27.56	27.63	27.45	27.6	9209074.0
2011-07-28 10:30:00	MSFT	Stock	27.608	27.78	27.59	27.74	6020000.0
2011-07-28 11:00:00	MSFT	Stock	27.74	28.0	27.7	27.99	8268442.0
2011-07-28 11:30:00	MSFT	Stock	27.99	28.05	27.928	28.01	5885470.0
2011-07-28 12:00:00	MSFT	Stock	28.01	28.07	27.94	28.015	3990371.0
2011-07-28 12:30:00	MSFT	Stock	28.011	28.02	27.98	28.008	2888680.0
2011-07-28 13:00:00	MSFT	Stock	28.005	28.044	27.93	27.965	3696560.0
2011-07-28 13:30:00	MSFT	Stock	27.96	28.01	27.95	27.985	2823398.0
2011-07-28 14:00:00	MSFT	Stock	27.981	27.995	27.805	27.845	3022628.0

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

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