PREVIEW / stock_30min / 2013-07-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-26.parquet
  size:    1.5 MB
  rows:    77,926
  symbols: 3,510

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-07-26 04:00:00	AAPL	Stock	15.665	15.6946	15.665	15.6857	16800.0
2013-07-26 05:30:00	AAPL	Stock	15.6571	15.6571	15.6432	15.6432	8792.0
2013-07-26 06:00:00	AAPL	Stock	15.6071	15.6732	15.6071	15.6732	11620.0
2013-07-26 06:30:00	AAPL	Stock	15.6429	15.6429	15.6146	15.6146	18256.0
2013-07-26 07:00:00	AAPL	Stock	15.6232	15.6232	15.6146	15.6175	19600.0
2013-07-26 07:30:00	AAPL	Stock	15.6143	15.6393	15.6143	15.6268	19600.0
2013-07-26 08:00:00	AAPL	Stock	15.64	15.6429	15.6079	15.6268	200900.0
2013-07-26 08:30:00	AAPL	Stock	15.6268	15.6268	15.5929	15.6068	242732.0
2013-07-26 09:00:00	AAPL	Stock	15.6064	15.6143	15.5375	15.55	957376.0
2013-07-26 09:30:00	AAPL	Stock	15.5536	15.6736	15.5121	15.6607	34442324.0
2013-07-26 10:00:00	AAPL	Stock	15.6636	15.7032	15.6414	15.665	19819940.0
2013-07-26 10:30:00	AAPL	Stock	15.6614	15.7207	15.6368	15.6664	23062928.0
2013-07-26 11:00:00	AAPL	Stock	15.6664	15.7164	15.6618	15.6979	14530320.0
2013-07-26 11:30:00	AAPL	Stock	15.6975	15.7179	15.6725	15.6827	9931684.0
2013-07-26 12:00:00	AAPL	Stock	15.6829	15.6893	15.6625	15.6779	6103860.0
2013-07-26 12:30:00	AAPL	Stock	15.672	15.7018	15.6639	15.6904	9888928.0
2013-07-26 13:00:00	AAPL	Stock	15.6904	15.71	15.68	15.7049	5637576.0
2013-07-26 13:30:00	AAPL	Stock	15.7075	15.7084	15.6804	15.6957	5021604.0
2013-07-26 14:00:00	AAPL	Stock	15.6964	15.7071	15.6729	15.6789	7184044.0
2013-07-26 14:30:00	AAPL	Stock	15.6792	15.7036	15.6736	15.6968	8199492.0
2013-07-26 15:00:00	AAPL	Stock	15.6968	15.7068	15.6829	15.7004	7244720.0
2013-07-26 15:30:00	AAPL	Stock	15.6975	15.7514	15.6954	15.7496	27761748.0
2013-07-26 16:00:00	AAPL	Stock	15.7496	15.75	15.6786	15.7496	8035384.0
2013-07-26 16:30:00	AAPL	Stock	15.75	15.7589	15.6795	15.7493	447272.0
2013-07-26 17:00:00	AAPL	Stock	15.7529	15.7818	15.7446	15.745	248864.0
2013-07-26 17:30:00	AAPL	Stock	15.7446	15.7496	15.7414	15.7489	47936.0
2013-07-26 18:00:00	AAPL	Stock	15.6377	15.7536	15.6377	15.7518	36456.0
2013-07-26 18:30:00	AAPL	Stock	15.7496	15.7607	15.7496	15.7607	45640.0
2013-07-26 19:00:00	AAPL	Stock	15.7589	15.7589	15.7589	15.7589	5600.0
2013-07-26 19:30:00	AAPL	Stock	15.7589	15.7661	15.7514	15.7521	62636.0
2013-07-26 05:30:00	MSFT	Stock	31.4	31.4	31.35	31.35	10100.0
2013-07-26 06:30:00	MSFT	Stock	31.35	31.35	31.35	31.35	500.0
2013-07-26 07:00:00	MSFT	Stock	31.3	31.38	31.3	31.38	3800.0
2013-07-26 07:30:00	MSFT	Stock	31.35	31.35	31.35	31.35	3200.0
2013-07-26 08:00:00	MSFT	Stock	31.3	31.35	31.27	31.3	8452.0
2013-07-26 08:30:00	MSFT	Stock	31.3	31.34	31.28	31.3	18379.0
2013-07-26 09:00:00	MSFT	Stock	31.3	31.39	31.25	31.25	109040.0
2013-07-26 09:30:00	MSFT	Stock	31.25	31.4	31.205	31.345	3546108.0
2013-07-26 10:00:00	MSFT	Stock	31.35	31.42	31.34	31.38	2433066.0
2013-07-26 10:30:00	MSFT	Stock	31.38	31.415	31.29	31.324	2848179.0
2013-07-26 11:00:00	MSFT	Stock	31.325	31.36	31.28	31.31	2929412.0
2013-07-26 11:30:00	MSFT	Stock	31.31	31.41	31.3	31.373	2167923.0
2013-07-26 12:00:00	MSFT	Stock	31.375	31.4	31.35	31.37	1145373.0
2013-07-26 12:30:00	MSFT	Stock	31.375	31.44	31.36	31.4	1450104.0
2013-07-26 13:00:00	MSFT	Stock	31.4	31.43	31.35	31.405	1684699.0
2013-07-26 13:30:00	MSFT	Stock	31.41	31.42	31.37	31.39	1533468.0
2013-07-26 14:00:00	MSFT	Stock	31.39	31.44	31.345	31.355	2550706.0
2013-07-26 14:30:00	MSFT	Stock	31.36	31.49	31.35	31.475	2909201.0
2013-07-26 15:00:00	MSFT	Stock	31.475	31.5	31.41	31.5	2788717.0
2013-07-26 15:30:00	MSFT	Stock	31.494	31.62	31.49	31.62	6731058.0

> showing 50 of 77,926 rows — these rows as CSV

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