PREVIEW / stock_30min / 2012-04-11

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-11.parquet
  size:    1.4 MB
  rows:    75,156
  symbols: 3,525

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-04-11 04:00:00	AAPL	Stock	22.5714	22.625	22.5214	22.6	121632.0
2012-04-11 04:30:00	AAPL	Stock	22.6004	22.6071	22.6004	22.6071	16800.0
2012-04-11 05:00:00	AAPL	Stock	22.6232	22.6607	22.6214	22.6429	25200.0
2012-04-11 05:30:00	AAPL	Stock	22.6268	22.6607	22.6268	22.6607	14924.0
2012-04-11 06:00:00	AAPL	Stock	22.7071	22.7461	22.7071	22.7214	112700.0
2012-04-11 06:30:00	AAPL	Stock	22.7143	22.7357	22.6964	22.7054	137536.0
2012-04-11 07:00:00	AAPL	Stock	22.7107	22.75	22.7043	22.7225	923440.0
2012-04-11 07:30:00	AAPL	Stock	22.7214	22.7332	22.7107	22.7179	679112.0
2012-04-11 08:00:00	AAPL	Stock	22.72	22.7461	22.6911	22.7093	2370088.0
2012-04-11 08:30:00	AAPL	Stock	22.7029	22.7143	22.655	22.7014	2393804.0
2012-04-11 09:00:00	AAPL	Stock	22.6961	22.7232	22.6554	22.7179	2918804.0
2012-04-11 09:30:00	AAPL	Stock	22.7214	22.7454	22.5236	22.6286	103800340.0
2012-04-11 10:00:00	AAPL	Stock	22.6271	22.6714	22.5536	22.5946	43855868.0
2012-04-11 10:30:00	AAPL	Stock	22.5971	22.655	22.5804	22.6268	39147780.0
2012-04-11 11:00:00	AAPL	Stock	22.6279	22.6532	22.5821	22.5929	25113312.0
2012-04-11 11:30:00	AAPL	Stock	22.5854	22.6114	22.4204	22.4475	62719860.0
2012-04-11 12:00:00	AAPL	Stock	22.4436	22.5089	22.2893	22.5024	86240084.0
2012-04-11 12:30:00	AAPL	Stock	22.5014	22.5045	22.3768	22.4179	31852548.0
2012-04-11 13:00:00	AAPL	Stock	22.4214	22.5075	22.3879	22.4871	25861556.0
2012-04-11 13:30:00	AAPL	Stock	22.4871	22.5	22.4193	22.4518	18322164.0
2012-04-11 14:00:00	AAPL	Stock	22.4496	22.4786	22.3571	22.4025	29635956.0
2012-04-11 14:30:00	AAPL	Stock	22.4022	22.4125	22.2622	22.3586	58585828.0
2012-04-11 15:00:00	AAPL	Stock	22.36	22.3857	22.2725	22.3214	35468272.0
2012-04-11 15:30:00	AAPL	Stock	22.3236	22.4068	22.3143	22.3611	57106644.0
2012-04-11 16:00:00	AAPL	Stock	22.3611	22.4823	22.3575	22.3811	55073256.0
2012-04-11 16:30:00	AAPL	Stock	22.3807	22.3925	22.3217	22.3611	634760.0
2012-04-11 17:00:00	AAPL	Stock	22.3821	22.3893	22.321	22.3893	217280.0
2012-04-11 17:30:00	AAPL	Stock	22.3911	22.4004	22.3911	22.3979	407400.0
2012-04-11 18:00:00	AAPL	Stock	22.3929	22.3961	22.3857	22.3893	69104.0
2012-04-11 18:30:00	AAPL	Stock	22.3893	22.4036	22.3893	22.3986	223216.0
2012-04-11 19:00:00	AAPL	Stock	22.3925	22.4	22.3875	22.4	202384.0
2012-04-11 19:30:00	AAPL	Stock	22.3939	22.4018	22.3643	22.3643	273532.0
2012-04-11 06:00:00	MSFT	Stock	30.76	30.77	30.76	30.77	1500.0
2012-04-11 07:00:00	MSFT	Stock	30.77	30.79	30.77	30.79	1243.0
2012-04-11 07:30:00	MSFT	Stock	30.79	30.79	30.79	30.79	500.0
2012-04-11 08:00:00	MSFT	Stock	30.76	30.79	30.47	30.59	158357.0
2012-04-11 08:30:00	MSFT	Stock	30.55	30.6	30.53	30.54	32605.0
2012-04-11 09:00:00	MSFT	Stock	30.54	30.55	30.42	30.45	64715.0
2012-04-11 09:30:00	MSFT	Stock	30.46	30.53	30.34	30.4	5990987.0
2012-04-11 10:00:00	MSFT	Stock	30.398	30.49	30.37	30.47	3918964.0
2012-04-11 10:30:00	MSFT	Stock	30.47	30.5	30.36	30.42	3516564.0
2012-04-11 11:00:00	MSFT	Stock	30.42	30.44	30.31	30.342	2855064.0
2012-04-11 11:30:00	MSFT	Stock	30.345	30.37	30.29	30.3	2292817.0
2012-04-11 12:00:00	MSFT	Stock	30.292	30.37	30.28	30.35	2559860.0
2012-04-11 12:30:00	MSFT	Stock	30.34	30.42	30.34	30.4	1215452.0
2012-04-11 13:00:00	MSFT	Stock	30.39	30.42	30.35	30.355	1658911.0
2012-04-11 13:30:00	MSFT	Stock	30.355	30.375	30.33	30.36	1776585.0
2012-04-11 14:00:00	MSFT	Stock	30.355	30.39	30.3	30.38	1362501.0
2012-04-11 14:30:00	MSFT	Stock	30.388	30.4	30.27	30.38	2298360.0
2012-04-11 15:00:00	MSFT	Stock	30.385	30.4	30.24	30.245	2860825.0

> showing 50 of 75,156 rows — these rows as CSV

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