PREVIEW / stock_30min / 2014-02-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-07.parquet
  size:    1.6 MB
  rows:    84,534
  symbols: 3,531

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
2014-02-07 04:00:00	AAPL	Stock	18.3893	18.6239	18.3893	18.6004	163128.0
2014-02-07 04:30:00	AAPL	Stock	18.6414	18.7107	18.6414	18.6561	84252.0
2014-02-07 05:00:00	AAPL	Stock	18.6632	18.7314	18.6521	18.7314	50400.0
2014-02-07 05:30:00	AAPL	Stock	18.7218	18.7321	18.6979	18.7232	68292.0
2014-02-07 06:00:00	AAPL	Stock	18.7189	18.7679	18.6979	18.7607	608832.0
2014-02-07 06:30:00	AAPL	Stock	18.75	18.7943	18.6979	18.7189	498288.0
2014-02-07 07:00:00	AAPL	Stock	18.6943	18.7143	18.625	18.6579	1034236.0
2014-02-07 07:30:00	AAPL	Stock	18.6471	18.6575	18.5904	18.6243	1210748.0
2014-02-07 08:00:00	AAPL	Stock	18.6232	18.7143	18.5196	18.5679	3940104.0
2014-02-07 08:30:00	AAPL	Stock	18.5679	18.6414	18.5004	18.6143	4287836.0
2014-02-07 09:00:00	AAPL	Stock	18.6179	18.6579	18.6039	18.6214	2563736.0
2014-02-07 09:30:00	AAPL	Stock	18.6246	18.6446	18.5536	18.5818	61810364.0
2014-02-07 10:00:00	AAPL	Stock	18.5818	18.6143	18.4779	18.5482	36375864.0
2014-02-07 10:30:00	AAPL	Stock	18.5514	18.5704	18.5177	18.5518	14722484.0
2014-02-07 11:00:00	AAPL	Stock	18.5514	18.5746	18.5111	18.5725	12944652.0
2014-02-07 11:30:00	AAPL	Stock	18.5714	18.63	18.5664	18.6289	15859368.0
2014-02-07 12:00:00	AAPL	Stock	18.6314	18.6689	18.6036	18.6618	20308344.0
2014-02-07 12:30:00	AAPL	Stock	18.6643	18.6761	18.6132	18.6171	14228256.0
2014-02-07 13:00:00	AAPL	Stock	18.6168	18.6514	18.6164	18.6232	9097172.0
2014-02-07 13:30:00	AAPL	Stock	18.6232	18.6375	18.5971	18.6217	12815516.0
2014-02-07 14:00:00	AAPL	Stock	18.6218	18.6339	18.6089	18.6214	12087992.0
2014-02-07 14:30:00	AAPL	Stock	18.6232	18.6321	18.5882	18.5929	12054140.0
2014-02-07 15:00:00	AAPL	Stock	18.5954	18.6129	18.5779	18.5888	13538308.0
2014-02-07 15:30:00	AAPL	Stock	18.5893	18.5925	18.5521	18.5625	43277556.0
2014-02-07 16:00:00	AAPL	Stock	18.5629	18.5908	18.5565	18.5679	12475876.0
2014-02-07 16:30:00	AAPL	Stock	18.5679	18.5821	18.5382	18.5736	409808.0
2014-02-07 17:00:00	AAPL	Stock	18.5714	18.5721	18.5686	18.5686	141316.0
2014-02-07 17:30:00	AAPL	Stock	18.5696	18.5911	18.5675	18.5857	286272.0
2014-02-07 18:00:00	AAPL	Stock	18.5875	18.5982	18.5861	18.5982	65772.0
2014-02-07 18:30:00	AAPL	Stock	18.5907	18.5982	18.5896	18.5982	25200.0
2014-02-07 19:00:00	AAPL	Stock	18.6039	18.6054	18.5982	18.5989	29176.0
2014-02-07 19:30:00	AAPL	Stock	18.6046	18.6064	18.6	18.6064	111328.0
2014-02-07 04:00:00	MSFT	Stock	36.32	36.32	36.32	36.32	100.0
2014-02-07 06:30:00	MSFT	Stock	36.35	36.35	36.32	36.32	600.0
2014-02-07 07:30:00	MSFT	Stock	36.2	36.28	36.2	36.28	600.0
2014-02-07 08:00:00	MSFT	Stock	36.35	36.35	36.21	36.26	3986.0
2014-02-07 08:30:00	MSFT	Stock	36.26	36.3	36.05	36.3	10670.0
2014-02-07 09:00:00	MSFT	Stock	36.3	36.3	36.22	36.29	12448.0
2014-02-07 09:30:00	MSFT	Stock	36.28	36.4	36.07	36.18	4587324.0
2014-02-07 10:00:00	MSFT	Stock	36.19	36.33	36.01	36.06	3553354.0
2014-02-07 10:30:00	MSFT	Stock	36.06	36.15	36.03	36.13	1943815.0
2014-02-07 11:00:00	MSFT	Stock	36.133	36.2	36.07	36.19	2013823.0
2014-02-07 11:30:00	MSFT	Stock	36.2	36.39	36.19	36.35	1472726.0
2014-02-07 12:00:00	MSFT	Stock	36.35	36.43	36.3	36.33	1325834.0
2014-02-07 12:30:00	MSFT	Stock	36.335	36.36	36.28	36.33	775727.0
2014-02-07 13:00:00	MSFT	Stock	36.33	36.43	36.325	36.42	830201.0
2014-02-07 13:30:00	MSFT	Stock	36.41	36.5	36.4	36.485	1025582.0
2014-02-07 14:00:00	MSFT	Stock	36.484	36.52	36.43	36.466	1304133.0
2014-02-07 14:30:00	MSFT	Stock	36.47	36.585	36.463	36.53	1448044.0
2014-02-07 15:00:00	MSFT	Stock	36.54	36.56	36.47	36.525	1391996.0

> showing 50 of 84,534 rows — these rows as CSV

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