PREVIEW / stock_30min / 2013-03-05

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-05.parquet
  size:    1.5 MB
  rows:    79,830
  symbols: 3,491

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
2013-03-05 04:00:00	AAPL	Stock	14.9893	14.9893	14.9496	14.9496	12124.0
2013-03-05 04:30:00	AAPL	Stock	15.0	15.0	14.9893	14.9893	19600.0
2013-03-05 05:00:00	AAPL	Stock	14.995	15.0	14.9946	15.0	25844.0
2013-03-05 05:30:00	AAPL	Stock	15.0	15.0	14.9946	15.0	56000.0
2013-03-05 06:00:00	AAPL	Stock	15.0	15.0125	15.0	15.0	42420.0
2013-03-05 06:30:00	AAPL	Stock	15.0071	15.0404	15.0004	15.0357	64512.0
2013-03-05 07:00:00	AAPL	Stock	15.0246	15.1657	15.0246	15.1436	416080.0
2013-03-05 07:30:00	AAPL	Stock	15.1425	15.1425	15.0857	15.0982	358456.0
2013-03-05 08:00:00	AAPL	Stock	15.0961	15.1546	14.9821	15.035	2051420.0
2013-03-05 08:30:00	AAPL	Stock	15.0286	15.1036	15.0275	15.0821	1126776.0
2013-03-05 09:00:00	AAPL	Stock	15.0829	15.1571	15.0375	15.0525	3203648.0
2013-03-05 09:30:00	AAPL	Stock	15.0525	15.2232	15.0268	15.0868	98945728.0
2013-03-05 10:00:00	AAPL	Stock	15.0871	15.3321	15.0775	15.3207	81138456.0
2013-03-05 10:30:00	AAPL	Stock	15.3182	15.3625	15.2875	15.3296	48792380.0
2013-03-05 11:00:00	AAPL	Stock	15.331	15.4471	15.3282	15.4025	52344376.0
2013-03-05 11:30:00	AAPL	Stock	15.4	15.5121	15.3932	15.4961	42064428.0
2013-03-05 12:00:00	AAPL	Stock	15.4946	15.5325	15.4821	15.525	30822848.0
2013-03-05 12:30:00	AAPL	Stock	15.525	15.5425	15.4471	15.4739	35104328.0
2013-03-05 13:00:00	AAPL	Stock	15.4714	15.4925	15.4393	15.4803	20161596.0
2013-03-05 13:30:00	AAPL	Stock	15.4811	15.4975	15.3857	15.4082	25331628.0
2013-03-05 14:00:00	AAPL	Stock	15.41	15.4521	15.3946	15.3971	18406472.0
2013-03-05 14:30:00	AAPL	Stock	15.3992	15.4096	15.2579	15.3	53724664.0
2013-03-05 15:00:00	AAPL	Stock	15.2996	15.3854	15.2686	15.3321	36280244.0
2013-03-05 15:30:00	AAPL	Stock	15.3321	15.4464	15.3286	15.4021	45727724.0
2013-03-05 16:00:00	AAPL	Stock	15.4021	15.4279	15.3333	15.4218	23186016.0
2013-03-05 16:30:00	AAPL	Stock	15.4264	15.4659	15.0018	15.45	4316900.0
2013-03-05 17:00:00	AAPL	Stock	15.45	15.4643	15.398	15.4375	377860.0
2013-03-05 17:30:00	AAPL	Stock	15.4375	15.4375	15.4189	15.4246	248892.0
2013-03-05 18:00:00	AAPL	Stock	15.4243	15.4286	15.4168	15.4286	97160.0
2013-03-05 18:30:00	AAPL	Stock	15.425	15.4286	15.3989	15.4279	766276.0
2013-03-05 19:00:00	AAPL	Stock	15.4275	15.4275	15.4214	15.4243	63084.0
2013-03-05 19:30:00	AAPL	Stock	15.4214	15.4339	15.4196	15.4336	309568.0
2013-03-05 04:00:00	MSFT	Stock	28.2	28.2	28.2	28.2	200.0
2013-03-05 04:30:00	MSFT	Stock	28.31	28.31	28.22	28.22	1500.0
2013-03-05 06:30:00	MSFT	Stock	28.31	28.31	28.26	28.26	5996.0
2013-03-05 07:00:00	MSFT	Stock	28.27	28.33	28.2	28.2	17114.0
2013-03-05 07:30:00	MSFT	Stock	28.23	28.24	28.2	28.24	3094.0
2013-03-05 08:00:00	MSFT	Stock	28.2	28.27	28.1	28.24	17883.0
2013-03-05 08:30:00	MSFT	Stock	28.23	28.25	28.15	28.2	27850.0
2013-03-05 09:00:00	MSFT	Stock	28.23	28.3	28.15	28.27	34333.0
2013-03-05 09:30:00	MSFT	Stock	28.29	28.35	28.16	28.34	7366094.0
2013-03-05 10:00:00	MSFT	Stock	28.34	28.44	28.34	28.43	4829507.0
2013-03-05 10:30:00	MSFT	Stock	28.43	28.54	28.42	28.46	4373776.0
2013-03-05 11:00:00	MSFT	Stock	28.46	28.46	28.39	28.43	2562995.0
2013-03-05 11:30:00	MSFT	Stock	28.435	28.452	28.38	28.43	1952208.0
2013-03-05 12:00:00	MSFT	Stock	28.42	28.43	28.3	28.31	1691967.0
2013-03-05 12:30:00	MSFT	Stock	28.31	28.34	28.3	28.306	1212793.0
2013-03-05 13:00:00	MSFT	Stock	28.304	28.34	28.25	28.306	1749663.0
2013-03-05 13:30:00	MSFT	Stock	28.305	28.38	28.282	28.325	2235938.0
2013-03-05 14:00:00	MSFT	Stock	28.32	28.34	28.235	28.265	1385971.0

> showing 50 of 79,830 rows — these rows as CSV

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