PREVIEW / stock_30min / 2016-11-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-04.parquet
  size:    1.6 MB
  rows:    80,417
  symbols: 3,176

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-04 04:00:00	AAPL	Stock	27.4575	27.5025	27.4575	27.4575	4932.0
2016-11-04 04:30:00	AAPL	Stock	27.415	27.415	27.415	27.415	1200.0
2016-11-04 05:00:00	AAPL	Stock	27.4175	27.4175	27.395	27.395	5600.0
2016-11-04 05:30:00	AAPL	Stock	27.395	27.395	27.325	27.325	1680.0
2016-11-04 06:00:00	AAPL	Stock	27.35	27.35	27.35	27.35	1600.0
2016-11-04 06:30:00	AAPL	Stock	27.325	27.375	27.325	27.375	10776.0
2016-11-04 07:00:00	AAPL	Stock	27.37	27.4	27.37	27.375	6152.0
2016-11-04 07:30:00	AAPL	Stock	27.3925	27.4075	27.39	27.4075	15796.0
2016-11-04 08:00:00	AAPL	Stock	27.395	27.395	27.33	27.365	103560.0
2016-11-04 08:30:00	AAPL	Stock	27.375	27.46	27.34	27.435	113180.0
2016-11-04 09:00:00	AAPL	Stock	27.4175	27.4575	26.9275	27.075	2387636.0
2016-11-04 09:30:00	AAPL	Stock	27.1325	27.385	27.0275	27.1425	25530976.0
2016-11-04 10:00:00	AAPL	Stock	27.145	27.36	27.14	27.325	9690780.0
2016-11-04 10:30:00	AAPL	Stock	27.3238	27.4075	27.3025	27.3475	7841360.0
2016-11-04 11:00:00	AAPL	Stock	27.3475	27.455	27.3375	27.44	6004036.0
2016-11-04 11:30:00	AAPL	Stock	27.4375	27.4788	27.3875	27.4598	4702116.0
2016-11-04 12:00:00	AAPL	Stock	27.4588	27.49	27.4375	27.4658	4129260.0
2016-11-04 12:30:00	AAPL	Stock	27.4672	27.48	27.4338	27.4645	3372204.0
2016-11-04 13:00:00	AAPL	Stock	27.465	27.5625	27.455	27.4762	5655712.0
2016-11-04 13:30:00	AAPL	Stock	27.4775	27.51	27.4655	27.49	3111788.0
2016-11-04 14:00:00	AAPL	Stock	27.49	27.49	27.4128	27.425	3550704.0
2016-11-04 14:30:00	AAPL	Stock	27.425	27.4288	27.32	27.355	5623728.0
2016-11-04 15:00:00	AAPL	Stock	27.355	27.355	27.28	27.2975	8142240.0
2016-11-04 15:30:00	AAPL	Stock	27.295	27.3	27.185	27.21	14769304.0
2016-11-04 16:00:00	AAPL	Stock	27.21	27.225	27.1925	27.22	7995372.0
2016-11-04 16:30:00	AAPL	Stock	27.22	27.2375	27.21	27.2375	35800.0
2016-11-04 17:00:00	AAPL	Stock	27.2375	27.2375	27.21	27.21	59400.0
2016-11-04 17:30:00	AAPL	Stock	27.2125	27.22	27.175	27.175	13256.0
2016-11-04 18:00:00	AAPL	Stock	27.175	27.2	27.1625	27.2	6128.0
2016-11-04 18:30:00	AAPL	Stock	27.175	27.2	27.165	27.1875	62656.0
2016-11-04 19:00:00	AAPL	Stock	27.175	27.2075	27.165	27.175	9952.0
2016-11-04 19:30:00	AAPL	Stock	27.185	27.2	27.1675	27.2	24940.0
2016-11-04 08:00:00	MSFT	Stock	59.11	59.21	59.11	59.11	3640.0
2016-11-04 08:30:00	MSFT	Stock	59.11	59.19	59.11	59.19	1274.0
2016-11-04 09:00:00	MSFT	Stock	59.15	59.21	58.33	58.69	829351.0
2016-11-04 09:30:00	MSFT	Stock	58.74	58.97	58.52	58.665	5884803.0
2016-11-04 10:00:00	MSFT	Stock	58.67	59.08	58.67	59.07	1604979.0
2016-11-04 10:30:00	MSFT	Stock	59.06	59.24	59.03	59.17	1622598.0
2016-11-04 11:00:00	MSFT	Stock	59.17	59.28	59.15	59.22	1566973.0
2016-11-04 11:30:00	MSFT	Stock	59.215	59.225	59.06	59.1	1058528.0
2016-11-04 12:00:00	MSFT	Stock	59.1	59.22	59.094	59.16	1021558.0
2016-11-04 12:30:00	MSFT	Stock	59.155	59.18	59.09	59.145	770886.0
2016-11-04 13:00:00	MSFT	Stock	59.14	59.2	59.07	59.08	958115.0
2016-11-04 13:30:00	MSFT	Stock	59.08	59.13	59.04	59.1	712653.0
2016-11-04 14:00:00	MSFT	Stock	59.1	59.19	59.02	59.14	1197160.0
2016-11-04 14:30:00	MSFT	Stock	59.14	59.14	58.99	59.03	1042446.0
2016-11-04 15:00:00	MSFT	Stock	59.03	59.04	58.94	58.96	1195290.0
2016-11-04 15:30:00	MSFT	Stock	58.955	58.965	58.71	58.71	3750466.0
2016-11-04 16:00:00	MSFT	Stock	58.71	58.8	58.7	58.71	4304344.0
2016-11-04 16:30:00	MSFT	Stock	58.75	58.79	58.72	58.79	7290.0

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

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