PREVIEW / stock_30min / 2013-11-21

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-21.parquet
  size:    1.6 MB
  rows:    81,433
  symbols: 3,525

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-21 04:00:00	AAPL	Stock	18.3889	18.3889	18.3768	18.3889	8400.0
2013-11-21 04:30:00	AAPL	Stock	18.3818	18.3946	18.3771	18.3918	45416.0
2013-11-21 05:00:00	AAPL	Stock	18.3929	18.4114	18.3929	18.4114	30800.0
2013-11-21 05:30:00	AAPL	Stock	18.4161	18.4161	18.4161	18.4161	5600.0
2013-11-21 06:00:00	AAPL	Stock	18.4232	18.4286	18.415	18.415	61852.0
2013-11-21 06:30:00	AAPL	Stock	18.4286	18.4286	18.4286	18.4286	4620.0
2013-11-21 07:00:00	AAPL	Stock	18.4129	18.4514	18.4118	18.4464	45780.0
2013-11-21 07:30:00	AAPL	Stock	18.4607	18.4864	18.4486	18.4821	290920.0
2013-11-21 08:00:00	AAPL	Stock	18.4786	18.4861	18.3893	18.4679	670012.0
2013-11-21 08:30:00	AAPL	Stock	18.47	18.5254	18.4596	18.5089	1462300.0
2013-11-21 09:00:00	AAPL	Stock	18.5089	18.5518	18.4843	18.4857	1912652.0
2013-11-21 09:30:00	AAPL	Stock	18.4871	18.5314	18.4396	18.492	40545008.0
2013-11-21 10:00:00	AAPL	Stock	18.4964	18.4996	18.4089	18.4464	20325564.0
2013-11-21 10:30:00	AAPL	Stock	18.4464	18.4907	18.4261	18.4371	21057120.0
2013-11-21 11:00:00	AAPL	Stock	18.4361	18.4386	18.395	18.4246	15981420.0
2013-11-21 11:30:00	AAPL	Stock	18.4226	18.455	18.414	18.4243	13161484.0
2013-11-21 12:00:00	AAPL	Stock	18.4254	18.4304	18.3454	18.4139	21156016.0
2013-11-21 12:30:00	AAPL	Stock	18.417	18.4214	18.3793	18.3904	6843088.0
2013-11-21 13:00:00	AAPL	Stock	18.3911	18.4457	18.3857	18.4411	7249844.0
2013-11-21 13:30:00	AAPL	Stock	18.4416	18.4479	18.4229	18.4439	7979412.0
2013-11-21 14:00:00	AAPL	Stock	18.4436	18.5157	18.4357	18.4941	15407812.0
2013-11-21 14:30:00	AAPL	Stock	18.4936	18.5668	18.4804	18.5554	18567556.0
2013-11-21 15:00:00	AAPL	Stock	18.5568	18.5868	18.5254	18.58	20024228.0
2013-11-21 15:30:00	AAPL	Stock	18.5807	18.6146	18.5564	18.6079	31433304.0
2013-11-21 16:00:00	AAPL	Stock	18.6075	18.6214	18.3854	18.6161	12657120.0
2013-11-21 16:30:00	AAPL	Stock	18.6129	18.6229	18.4455	18.6157	599592.0
2013-11-21 17:00:00	AAPL	Stock	18.6229	18.6254	18.6075	18.6254	419384.0
2013-11-21 17:30:00	AAPL	Stock	18.6325	18.6471	18.6286	18.6396	247436.0
2013-11-21 18:00:00	AAPL	Stock	18.6411	18.6411	18.6314	18.6318	28588.0
2013-11-21 18:30:00	AAPL	Stock	18.6339	18.6421	18.6286	18.6286	105336.0
2013-11-21 19:00:00	AAPL	Stock	18.6293	18.6429	18.6293	18.6411	71680.0
2013-11-21 19:30:00	AAPL	Stock	18.6421	18.6471	18.6304	18.6429	43932.0
2013-11-21 06:00:00	MSFT	Stock	37.16	37.16	37.16	37.16	200.0
2013-11-21 06:30:00	MSFT	Stock	37.16	37.16	37.16	37.16	300.0
2013-11-21 07:00:00	MSFT	Stock	37.17	37.17	37.17	37.17	200.0
2013-11-21 07:30:00	MSFT	Stock	37.23	37.23	37.21	37.21	700.0
2013-11-21 08:00:00	MSFT	Stock	37.2	37.23	37.07	37.21	100750.0
2013-11-21 08:30:00	MSFT	Stock	37.21	37.23	37.12	37.21	9662.0
2013-11-21 09:00:00	MSFT	Stock	37.23	37.35	37.21	37.3	45007.0
2013-11-21 09:30:00	MSFT	Stock	37.27	37.499	37.26	37.46	3069383.0
2013-11-21 10:00:00	MSFT	Stock	37.46	37.53	37.35	37.386	2039370.0
2013-11-21 10:30:00	MSFT	Stock	37.39	37.47	37.36	37.412	1664933.0
2013-11-21 11:00:00	MSFT	Stock	37.42	37.43	37.366	37.385	1135564.0
2013-11-21 11:30:00	MSFT	Stock	37.39	37.43	37.27	37.29	1171841.0
2013-11-21 12:00:00	MSFT	Stock	37.29	37.43	37.29	37.415	1065877.0
2013-11-21 12:30:00	MSFT	Stock	37.41	37.44	37.33	37.336	764913.0
2013-11-21 13:00:00	MSFT	Stock	37.33	37.43	37.29	37.395	1156763.0
2013-11-21 13:30:00	MSFT	Stock	37.4	37.51	37.39	37.45	1253776.0
2013-11-21 14:00:00	MSFT	Stock	37.453	37.49	37.42	37.42	875153.0
2013-11-21 14:30:00	MSFT	Stock	37.42	37.45	37.35	37.375	1383610.0

> showing 50 of 81,433 rows — these rows as CSV

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