PREVIEW / stock_30min / 2016-11-03

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-03.parquet
  size:    1.6 MB
  rows:    80,526
  symbols: 3,173

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
2016-11-03 04:00:00	AAPL	Stock	27.685	27.685	27.665	27.68	6320.0
2016-11-03 04:30:00	AAPL	Stock	27.675	27.6825	27.6625	27.6825	2800.0
2016-11-03 05:00:00	AAPL	Stock	27.6825	27.685	27.6825	27.6825	10696.0
2016-11-03 05:30:00	AAPL	Stock	27.7275	27.7325	27.7275	27.7325	1308.0
2016-11-03 06:00:00	AAPL	Stock	27.73	27.7325	27.7175	27.7175	4724.0
2016-11-03 06:30:00	AAPL	Stock	27.7	27.7125	27.7	27.7125	10360.0
2016-11-03 07:00:00	AAPL	Stock	27.7225	27.7925	27.7225	27.775	41892.0
2016-11-03 07:30:00	AAPL	Stock	27.76	27.7925	27.76	27.79	6904.0
2016-11-03 08:00:00	AAPL	Stock	27.735	27.8	27.71	27.7275	135152.0
2016-11-03 08:30:00	AAPL	Stock	27.7275	27.7575	27.7	27.7425	165712.0
2016-11-03 09:00:00	AAPL	Stock	27.725	27.7625	27.7175	27.7375	138016.0
2016-11-03 09:30:00	AAPL	Stock	27.745	27.865	27.675	27.75	10049288.0
2016-11-03 10:00:00	AAPL	Stock	27.7475	27.76	27.675	27.7008	6017636.0
2016-11-03 10:30:00	AAPL	Stock	27.7025	27.7475	27.6925	27.7175	4430036.0
2016-11-03 11:00:00	AAPL	Stock	27.7175	27.725	27.655	27.6585	4015424.0
2016-11-03 11:30:00	AAPL	Stock	27.659	27.67	27.5875	27.61	5774820.0
2016-11-03 12:00:00	AAPL	Stock	27.6118	27.625	27.575	27.6225	4880540.0
2016-11-03 12:30:00	AAPL	Stock	27.62	27.635	27.57	27.5768	4841256.0
2016-11-03 13:00:00	AAPL	Stock	27.575	27.5825	27.4475	27.5	9509600.0
2016-11-03 13:30:00	AAPL	Stock	27.5	27.54	27.49	27.5138	6283452.0
2016-11-03 14:00:00	AAPL	Stock	27.5125	27.5375	27.48	27.5075	4894956.0
2016-11-03 14:30:00	AAPL	Stock	27.5075	27.5125	27.455	27.4875	6757344.0
2016-11-03 15:00:00	AAPL	Stock	27.4875	27.4975	27.41	27.44	7058780.0
2016-11-03 15:30:00	AAPL	Stock	27.44	27.4775	27.3875	27.455	12794384.0
2016-11-03 16:00:00	AAPL	Stock	27.45	27.4575	27.3825	27.42	8219120.0
2016-11-03 16:30:00	AAPL	Stock	27.4125	27.4575	27.4075	27.4075	44216.0
2016-11-03 17:00:00	AAPL	Stock	27.425	27.4625	27.3825	27.3825	127688.0
2016-11-03 17:30:00	AAPL	Stock	27.385	27.41	27.3825	27.3825	15684.0
2016-11-03 18:00:00	AAPL	Stock	27.395	27.395	27.3575	27.3575	86408.0
2016-11-03 18:30:00	AAPL	Stock	27.36	27.4075	27.36	27.4075	131876.0
2016-11-03 19:00:00	AAPL	Stock	27.405	27.4125	27.385	27.4125	1252456.0
2016-11-03 19:30:00	AAPL	Stock	27.4025	27.4125	27.3975	27.4125	36720.0
2016-11-03 05:00:00	MSFT	Stock	59.3	59.33	59.3	59.33	2600.0
2016-11-03 07:00:00	MSFT	Stock	59.34	59.57	59.34	59.57	6465.0
2016-11-03 08:00:00	MSFT	Stock	59.53	59.57	59.45	59.45	2382.0
2016-11-03 08:30:00	MSFT	Stock	59.45	59.55	59.45	59.54	3415.0
2016-11-03 09:00:00	MSFT	Stock	59.55	59.69	59.53	59.6	6723.0
2016-11-03 09:30:00	MSFT	Stock	59.53	59.64	59.35	59.35	1924518.0
2016-11-03 10:00:00	MSFT	Stock	59.35	59.41	59.24	59.313	1316943.0
2016-11-03 10:30:00	MSFT	Stock	59.31	59.37	59.24	59.34	1491920.0
2016-11-03 11:00:00	MSFT	Stock	59.33	59.36	59.24	59.328	1052144.0
2016-11-03 11:30:00	MSFT	Stock	59.33	59.37	59.29	59.34	860986.0
2016-11-03 12:00:00	MSFT	Stock	59.34	59.34	59.13	59.2	1053912.0
2016-11-03 12:30:00	MSFT	Stock	59.19	59.25	59.13	59.22	823320.0
2016-11-03 13:00:00	MSFT	Stock	59.21	59.28	59.12	59.23	971731.0
2016-11-03 13:30:00	MSFT	Stock	59.23	59.275	59.11	59.145	736475.0
2016-11-03 14:00:00	MSFT	Stock	59.15	59.26	59.11	59.23	821246.0
2016-11-03 14:30:00	MSFT	Stock	59.23	59.28	59.205	59.27	1208785.0
2016-11-03 15:00:00	MSFT	Stock	59.26	59.273	59.175	59.2	1331169.0
2016-11-03 15:30:00	MSFT	Stock	59.21	59.25	59.12	59.2	3102816.0

> showing 50 of 80,526 rows — these rows as CSV

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