PREVIEW / stock_30min / 2013-11-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-12.parquet
  size:    1.5 MB
  rows:    79,828
  symbols: 3,549

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-11-12 05:30:00	AAPL	Stock	18.4839	18.4839	18.4821	18.4821	5600.0
2013-11-12 07:00:00	AAPL	Stock	18.4936	18.5161	18.475	18.5011	148960.0
2013-11-12 07:30:00	AAPL	Stock	18.5025	18.5204	18.5018	18.5018	121800.0
2013-11-12 08:00:00	AAPL	Stock	18.4939	18.5374	18.4786	18.5	2272508.0
2013-11-12 08:30:00	AAPL	Stock	18.5036	18.5107	18.4957	18.4964	120064.0
2013-11-12 09:00:00	AAPL	Stock	18.5086	18.5125	18.4646	18.4679	540932.0
2013-11-12 09:30:00	AAPL	Stock	18.4882	18.6036	18.4643	18.5999	31720948.0
2013-11-12 10:00:00	AAPL	Stock	18.6016	18.6986	18.5714	18.6925	34936076.0
2013-11-12 10:30:00	AAPL	Stock	18.69	18.7114	18.615	18.6282	21304668.0
2013-11-12 11:00:00	AAPL	Stock	18.6279	18.6539	18.6007	18.6485	13395116.0
2013-11-12 11:30:00	AAPL	Stock	18.6486	18.6579	18.5886	18.6093	11177292.0
2013-11-12 12:00:00	AAPL	Stock	18.6107	18.6386	18.5946	18.6304	7817376.0
2013-11-12 12:30:00	AAPL	Stock	18.6386	18.6393	18.6022	18.6161	5888960.0
2013-11-12 13:00:00	AAPL	Stock	18.6161	18.6454	18.6071	18.6071	5228552.0
2013-11-12 13:30:00	AAPL	Stock	18.6093	18.6193	18.555	18.5725	10048360.0
2013-11-12 14:00:00	AAPL	Stock	18.5733	18.5886	18.5396	18.5457	8066856.0
2013-11-12 14:30:00	AAPL	Stock	18.5457	18.5786	18.5096	18.5636	10865736.0
2013-11-12 15:00:00	AAPL	Stock	18.5646	18.5925	18.5257	18.5489	8951796.0
2013-11-12 15:30:00	AAPL	Stock	18.5521	18.5814	18.5371	18.5754	15763580.0
2013-11-12 16:00:00	AAPL	Stock	18.5718	18.6	18.5	18.5871	9444428.0
2013-11-12 16:30:00	AAPL	Stock	18.5829	18.5989	18.5681	18.5979	265132.0
2013-11-12 17:00:00	AAPL	Stock	18.5864	18.5936	18.5839	18.5875	47236.0
2013-11-12 18:00:00	AAPL	Stock	18.5821	18.5868	18.5821	18.5857	16240.0
2013-11-12 18:30:00	AAPL	Stock	18.5857	18.5982	18.5857	18.5982	38584.0
2013-11-12 19:00:00	AAPL	Stock	18.5989	18.6	18.5964	18.6	46172.0
2013-11-12 19:30:00	AAPL	Stock	18.5971	18.6036	18.5964	18.6	81004.0
2013-11-12 06:00:00	MSFT	Stock	37.46	37.46	37.46	37.46	200.0
2013-11-12 06:30:00	MSFT	Stock	37.46	37.46	37.46	37.46	300.0
2013-11-12 07:00:00	MSFT	Stock	37.46	37.51	37.46	37.51	1700.0
2013-11-12 07:30:00	MSFT	Stock	37.51	37.51	37.51	37.51	600.0
2013-11-12 08:00:00	MSFT	Stock	37.5	37.5	37.42	37.45	2536.0
2013-11-12 08:30:00	MSFT	Stock	37.45	37.47	37.43	37.45	7900.0
2013-11-12 09:00:00	MSFT	Stock	37.47	37.51	37.2	37.38	29728.0
2013-11-12 09:30:00	MSFT	Stock	37.38	37.56	37.2	37.44	3876117.0
2013-11-12 10:00:00	MSFT	Stock	37.45	37.595	37.39	37.56	2301965.0
2013-11-12 10:30:00	MSFT	Stock	37.555	37.56	37.38	37.48	1877927.0
2013-11-12 11:00:00	MSFT	Stock	37.48	37.51	37.39	37.455	1660066.0
2013-11-12 11:30:00	MSFT	Stock	37.46	37.51	37.36	37.42	2533901.0
2013-11-12 12:00:00	MSFT	Stock	37.42	37.43	37.348	37.375	1869092.0
2013-11-12 12:30:00	MSFT	Stock	37.38	37.46	37.36	37.37	2543918.0
2013-11-12 13:00:00	MSFT	Stock	37.372	37.43	37.355	37.36	833060.0
2013-11-12 13:30:00	MSFT	Stock	37.36	37.39	37.31	37.321	1832252.0
2013-11-12 14:00:00	MSFT	Stock	37.32	37.33	37.28	37.3	1693523.0
2013-11-12 14:30:00	MSFT	Stock	37.29	37.38	37.28	37.373	1395617.0
2013-11-12 15:00:00	MSFT	Stock	37.38	37.39	37.34	37.345	1717242.0
2013-11-12 15:30:00	MSFT	Stock	37.345	37.37	37.31	37.355	3744394.0
2013-11-12 16:00:00	MSFT	Stock	37.35	37.392	37.35	37.362	3073912.0
2013-11-12 16:30:00	MSFT	Stock	37.34	37.41	37.34	37.41	12049.0
2013-11-12 18:00:00	MSFT	Stock	37.38	37.38	37.38	37.38	100.0
2013-11-12 18:30:00	MSFT	Stock	37.32	37.32	37.32	37.32	100.0

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

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