PREVIEW / stock_30min / 2016-05-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-02.parquet
  size:    1.6 MB
  rows:    82,370
  symbols: 3,326

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-05-02 04:00:00	AAPL	Stock	24.0	24.0	23.49	23.555	41480.0
2016-05-02 04:30:00	AAPL	Stock	23.585	23.585	23.5375	23.575	17736.0
2016-05-02 05:00:00	AAPL	Stock	23.57	23.57	23.57	23.57	1600.0
2016-05-02 05:30:00	AAPL	Stock	23.5625	23.5625	23.5375	23.56	7928.0
2016-05-02 06:00:00	AAPL	Stock	23.55	23.55	23.5325	23.54	15292.0
2016-05-02 06:30:00	AAPL	Stock	23.535	23.565	23.535	23.565	4856.0
2016-05-02 07:00:00	AAPL	Stock	23.55	23.575	23.5425	23.575	55688.0
2016-05-02 07:30:00	AAPL	Stock	23.565	23.575	23.545	23.565	43236.0
2016-05-02 08:00:00	AAPL	Stock	23.555	23.595	23.5125	23.5325	258012.0
2016-05-02 08:30:00	AAPL	Stock	23.5325	23.535	23.5	23.535	187968.0
2016-05-02 09:00:00	AAPL	Stock	23.5325	23.5375	23.49	23.4925	264416.0
2016-05-02 09:30:00	AAPL	Stock	23.49	23.52	23.14	23.145	29157324.0
2016-05-02 10:00:00	AAPL	Stock	23.1425	23.3675	23.1	23.2675	23655780.0
2016-05-02 10:30:00	AAPL	Stock	23.265	23.3125	23.1775	23.1775	13126996.0
2016-05-02 11:00:00	AAPL	Stock	23.1775	23.295	23.1725	23.2855	9440096.0
2016-05-02 11:30:00	AAPL	Stock	23.285	23.2875	23.2125	23.23	8307948.0
2016-05-02 12:00:00	AAPL	Stock	23.23	23.2325	23.1625	23.1675	7350688.0
2016-05-02 12:30:00	AAPL	Stock	23.17	23.2475	23.1525	23.195	7758516.0
2016-05-02 13:00:00	AAPL	Stock	23.1925	23.2682	23.1675	23.2288	8065080.0
2016-05-02 13:30:00	AAPL	Stock	23.2275	23.235	23.1725	23.19	7454084.0
2016-05-02 14:00:00	AAPL	Stock	23.19	23.26	23.17	23.2472	7793580.0
2016-05-02 14:30:00	AAPL	Stock	23.245	23.41	23.245	23.4065	13344544.0
2016-05-02 15:00:00	AAPL	Stock	23.4062	23.4425	23.3375	23.39	13401764.0
2016-05-02 15:30:00	AAPL	Stock	23.39	23.485	23.3375	23.41	22134960.0
2016-05-02 16:00:00	AAPL	Stock	23.4	23.425	23.1895	23.405	5451000.0
2016-05-02 16:30:00	AAPL	Stock	23.405	23.45	23.4025	23.45	196052.0
2016-05-02 17:00:00	AAPL	Stock	23.4525	23.46	23.4375	23.4525	148964.0
2016-05-02 17:30:00	AAPL	Stock	23.4525	23.455	23.45	23.455	189532.0
2016-05-02 18:00:00	AAPL	Stock	23.4525	23.47	23.435	23.435	633800.0
2016-05-02 18:30:00	AAPL	Stock	23.445	23.4675	23.425	23.46	135836.0
2016-05-02 19:00:00	AAPL	Stock	23.4625	23.4625	23.45	23.4575	58976.0
2016-05-02 19:30:00	AAPL	Stock	23.4575	23.4625	23.445	23.4525	107028.0
2016-05-02 04:00:00	MSFT	Stock	49.94	50.0	49.94	50.0	1090.0
2016-05-02 07:00:00	MSFT	Stock	49.95	49.97	49.95	49.97	2900.0
2016-05-02 07:30:00	MSFT	Stock	49.9	49.97	49.85	49.85	2400.0
2016-05-02 08:00:00	MSFT	Stock	49.99	49.99	49.9	49.95	2931.0
2016-05-02 08:30:00	MSFT	Stock	49.85	49.95	49.85	49.95	500.0
2016-05-02 09:00:00	MSFT	Stock	49.91	50.0	49.91	50.0	9024.0
2016-05-02 09:30:00	MSFT	Stock	50.01	50.11	49.78	49.91	3430402.0
2016-05-02 10:00:00	MSFT	Stock	49.91	50.18	49.86	50.123	2854844.0
2016-05-02 10:30:00	MSFT	Stock	50.12	50.2	49.9	49.916	2356126.0
2016-05-02 11:00:00	MSFT	Stock	49.919	49.995	49.85	49.97	1699571.0
2016-05-02 11:30:00	MSFT	Stock	49.98	50.04	49.905	49.91	1270146.0
2016-05-02 12:00:00	MSFT	Stock	49.91	50.07	49.85	49.92	1795743.0
2016-05-02 12:30:00	MSFT	Stock	49.93	50.06	49.925	50.03	1391737.0
2016-05-02 13:00:00	MSFT	Stock	50.03	50.36	49.97	50.325	2237942.0
2016-05-02 13:30:00	MSFT	Stock	50.32	50.59	50.28	50.51	2728707.0
2016-05-02 14:00:00	MSFT	Stock	50.51	50.67	50.49	50.61	2043812.0
2016-05-02 14:30:00	MSFT	Stock	50.6	50.745	50.56	50.715	1885066.0
2016-05-02 15:00:00	MSFT	Stock	50.715	50.75	50.6	50.65	2318348.0

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

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