PREVIEW / stock_30min / 2013-04-11

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-11.parquet
  size:    1.5 MB
  rows:    75,851
  symbols: 3,465

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-04-11 04:00:00	AAPL	Stock	15.5421	15.5421	15.5357	15.5357	11200.0
2013-04-11 04:30:00	AAPL	Stock	15.5268	15.5714	15.5268	15.5714	14000.0
2013-04-11 05:30:00	AAPL	Stock	15.5504	15.5707	15.5489	15.5707	27076.0
2013-04-11 06:00:00	AAPL	Stock	15.5811	15.5811	15.5811	15.5811	2800.0
2013-04-11 06:30:00	AAPL	Stock	15.5736	15.5743	15.5486	15.5486	59640.0
2013-04-11 07:00:00	AAPL	Stock	15.5414	15.5414	15.4861	15.4911	201124.0
2013-04-11 07:30:00	AAPL	Stock	15.4911	15.4914	15.4179	15.4564	690676.0
2013-04-11 08:00:00	AAPL	Stock	15.4639	15.5361	15.4482	15.4689	988120.0
2013-04-11 08:30:00	AAPL	Stock	15.4789	15.5189	15.4643	15.4693	1364720.0
2013-04-11 09:00:00	AAPL	Stock	15.4761	15.4975	15.4482	15.4807	1100204.0
2013-04-11 09:30:00	AAPL	Stock	15.4854	15.4964	15.4	15.4707	53498060.0
2013-04-11 10:00:00	AAPL	Stock	15.4707	15.4725	15.4154	15.4371	22486744.0
2013-04-11 10:30:00	AAPL	Stock	15.4375	15.6229	15.43	15.6146	41183968.0
2013-04-11 11:00:00	AAPL	Stock	15.6168	15.6425	15.5846	15.6186	34053488.0
2013-04-11 11:30:00	AAPL	Stock	15.6211	15.6275	15.5032	15.5254	28460040.0
2013-04-11 12:00:00	AAPL	Stock	15.5268	15.5357	15.4836	15.485	14193620.0
2013-04-11 12:30:00	AAPL	Stock	15.486	15.5114	15.4575	15.5061	20594056.0
2013-04-11 13:00:00	AAPL	Stock	15.5071	15.5507	15.5071	15.5268	14024892.0
2013-04-11 13:30:00	AAPL	Stock	15.5309	15.5839	15.5086	15.5104	16264864.0
2013-04-11 14:00:00	AAPL	Stock	15.5139	15.5275	15.4734	15.5068	13703424.0
2013-04-11 14:30:00	AAPL	Stock	15.5064	15.5493	15.4825	15.5425	11866344.0
2013-04-11 15:00:00	AAPL	Stock	15.5436	15.5536	15.5007	15.5114	12122628.0
2013-04-11 15:30:00	AAPL	Stock	15.5132	15.5289	15.4821	15.5132	26790792.0
2013-04-11 16:00:00	AAPL	Stock	15.5143	15.5271	15.4647	15.5189	6071828.0
2013-04-11 16:30:00	AAPL	Stock	15.5243	15.5254	15.5118	15.5143	428568.0
2013-04-11 17:00:00	AAPL	Stock	15.5211	15.5225	15.5118	15.5143	25396.0
2013-04-11 17:30:00	AAPL	Stock	15.5136	15.5189	15.5071	15.5143	37436.0
2013-04-11 18:00:00	AAPL	Stock	15.5168	15.5171	15.5061	15.5061	69720.0
2013-04-11 18:30:00	AAPL	Stock	15.5161	15.5161	15.5114	15.5125	23184.0
2013-04-11 19:00:00	AAPL	Stock	15.5161	15.5193	15.5107	15.5193	154700.0
2013-04-11 19:30:00	AAPL	Stock	15.5186	15.5211	15.5071	15.5132	74256.0
2013-04-11 04:00:00	MSFT	Stock	29.3	29.38	29.17	29.17	2850.0
2013-04-11 04:30:00	MSFT	Stock	29.24	29.3	29.24	29.3	1300.0
2013-04-11 05:00:00	MSFT	Stock	29.31	29.31	29.27	29.27	500.0
2013-04-11 05:30:00	MSFT	Stock	29.3	29.3	29.26	29.26	400.0
2013-04-11 06:00:00	MSFT	Stock	29.25	29.25	29.23	29.24	5850.0
2013-04-11 06:30:00	MSFT	Stock	29.3	29.4	29.28	29.35	15325.0
2013-04-11 07:00:00	MSFT	Stock	29.39	29.45	29.35	29.38	79328.0
2013-04-11 07:30:00	MSFT	Stock	29.35	29.35	29.18	29.25	465785.0
2013-04-11 08:00:00	MSFT	Stock	29.25	30.15	29.05	29.2	582544.0
2013-04-11 08:30:00	MSFT	Stock	29.18	29.3	29.18	29.22	609319.0
2013-04-11 09:00:00	MSFT	Stock	29.23	29.3	29.05	29.1	1108366.0
2013-04-11 09:30:00	MSFT	Stock	29.1	29.2	28.76	28.831	28467111.0
2013-04-11 10:00:00	MSFT	Stock	28.84	29.0	28.83	28.881	11601070.0
2013-04-11 10:30:00	MSFT	Stock	28.885	28.9	28.76	28.81	9589026.0
2013-04-11 11:00:00	MSFT	Stock	28.819	28.84	28.75	28.78	6372455.0
2013-04-11 11:30:00	MSFT	Stock	28.78	28.83	28.75	28.8	6904704.0
2013-04-11 12:00:00	MSFT	Stock	28.8	28.82	28.75	28.8	6534517.0
2013-04-11 12:30:00	MSFT	Stock	28.791	28.8	28.73	28.78	7336335.0
2013-04-11 13:00:00	MSFT	Stock	28.79	28.86	28.78	28.81	4718039.0

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

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