PREVIEW / stock_30min / 2015-02-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-20.parquet
  size:    1.6 MB
  rows:    82,156
  symbols: 3,506

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
2015-02-20 04:00:00	AAPL	Stock	32.18	32.18	32.1325	32.18	7200.0
2015-02-20 04:30:00	AAPL	Stock	32.1725	32.2075	32.155	32.2075	7640.0
2015-02-20 05:00:00	AAPL	Stock	32.2125	32.2525	32.2075	32.25	36848.0
2015-02-20 05:30:00	AAPL	Stock	32.2325	32.25	32.225	32.25	5648.0
2015-02-20 06:00:00	AAPL	Stock	32.2475	32.25	32.225	32.225	55200.0
2015-02-20 06:30:00	AAPL	Stock	32.225	32.25	32.2225	32.225	16468.0
2015-02-20 07:00:00	AAPL	Stock	32.225	32.2475	32.1875	32.2125	131000.0
2015-02-20 07:30:00	AAPL	Stock	32.19	32.2125	32.175	32.19	52512.0
2015-02-20 08:00:00	AAPL	Stock	32.19	32.25	32.1125	32.15	413528.0
2015-02-20 08:30:00	AAPL	Stock	32.1475	32.2	32.1475	32.2	361192.0
2015-02-20 09:00:00	AAPL	Stock	32.2	32.2075	32.12	32.1525	1715776.0
2015-02-20 09:30:00	AAPL	Stock	32.155	32.21	32.0125	32.105	33576984.0
2015-02-20 10:00:00	AAPL	Stock	32.1025	32.19	32.07	32.1525	15606532.0
2015-02-20 10:30:00	AAPL	Stock	32.1545	32.205	32.1375	32.19	12584176.0
2015-02-20 11:00:00	AAPL	Stock	32.1925	32.22	32.1425	32.1658	9987748.0
2015-02-20 11:30:00	AAPL	Stock	32.1675	32.175	32.1375	32.162	6358212.0
2015-02-20 12:00:00	AAPL	Stock	32.16	32.165	32.1175	32.124	5590648.0
2015-02-20 12:30:00	AAPL	Stock	32.125	32.1502	32.0775	32.1375	9553016.0
2015-02-20 13:00:00	AAPL	Stock	32.14	32.1725	32.1275	32.1725	7427728.0
2015-02-20 13:30:00	AAPL	Stock	32.17	32.205	32.1625	32.2032	8014992.0
2015-02-20 14:00:00	AAPL	Stock	32.205	32.2475	32.195	32.2275	11006384.0
2015-02-20 14:30:00	AAPL	Stock	32.23	32.3237	32.2225	32.2988	12668344.0
2015-02-20 15:00:00	AAPL	Stock	32.3	32.3725	32.26	32.3475	16439260.0
2015-02-20 15:30:00	AAPL	Stock	32.35	32.375	32.305	32.375	21070732.0
2015-02-20 16:00:00	AAPL	Stock	32.3738	32.3765	32.156	32.36	10190720.0
2015-02-20 16:30:00	AAPL	Stock	32.3625	32.3725	32.355	32.3725	1305852.0
2015-02-20 17:00:00	AAPL	Stock	32.3675	32.3725	32.199	32.3625	122760.0
2015-02-20 17:30:00	AAPL	Stock	32.3725	32.3725	32.36	32.3675	39292.0
2015-02-20 18:00:00	AAPL	Stock	32.37	32.3738	32.36	32.37	43136.0
2015-02-20 18:30:00	AAPL	Stock	32.37	32.37	32.365	32.3653	51060.0
2015-02-20 19:00:00	AAPL	Stock	32.3675	32.375	32.365	32.375	49948.0
2015-02-20 19:30:00	AAPL	Stock	32.3725	32.3775	32.37	32.3775	61552.0
2015-02-20 07:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	2808.0
2015-02-20 07:30:00	MSFT	Stock	43.5	43.5	43.5	43.5	1652.0
2015-02-20 08:00:00	MSFT	Stock	43.59	43.65	43.42	43.5	5360.0
2015-02-20 08:30:00	MSFT	Stock	43.6	43.6	43.49	43.49	900.0
2015-02-20 09:00:00	MSFT	Stock	43.48	43.6	43.48	43.52	170639.0
2015-02-20 09:30:00	MSFT	Stock	43.51	43.66	43.29	43.37	6840126.0
2015-02-20 10:00:00	MSFT	Stock	43.37	43.45	43.365	43.43	2093648.0
2015-02-20 10:30:00	MSFT	Stock	43.43	43.66	43.39	43.62	2279087.0
2015-02-20 11:00:00	MSFT	Stock	43.625	43.7	43.535	43.642	1241410.0
2015-02-20 11:30:00	MSFT	Stock	43.645	43.67	43.58	43.65	902095.0
2015-02-20 12:00:00	MSFT	Stock	43.64	43.67	43.605	43.62	736225.0
2015-02-20 12:30:00	MSFT	Stock	43.615	43.68	43.56	43.65	1302514.0
2015-02-20 13:00:00	MSFT	Stock	43.646	43.7	43.62	43.665	915956.0
2015-02-20 13:30:00	MSFT	Stock	43.661	43.806	43.66	43.79	1154424.0
2015-02-20 14:00:00	MSFT	Stock	43.79	43.83	43.73	43.756	1661124.0
2015-02-20 14:30:00	MSFT	Stock	43.75	43.83	43.72	43.804	1225758.0
2015-02-20 15:00:00	MSFT	Stock	43.81	43.88	43.78	43.835	1540710.0
2015-02-20 15:30:00	MSFT	Stock	43.84	43.87	43.78	43.86	3700883.0

> showing 50 of 82,156 rows — these rows as CSV

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