PREVIEW / stock_30min / 2016-05-24

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-24.parquet
  size:    1.6 MB
  rows:    81,577
  symbols: 3,291

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-24 04:30:00	AAPL	Stock	24.2225	24.25	24.2225	24.25	4800.0
2016-05-24 05:00:00	AAPL	Stock	24.245	24.275	24.245	24.275	5300.0
2016-05-24 05:30:00	AAPL	Stock	24.275	24.275	24.275	24.275	2400.0
2016-05-24 06:00:00	AAPL	Stock	24.26	24.27	24.2325	24.2325	46384.0
2016-05-24 06:30:00	AAPL	Stock	24.25	24.26	24.2325	24.2325	19300.0
2016-05-24 07:00:00	AAPL	Stock	24.2325	24.2425	24.22	24.2275	45192.0
2016-05-24 07:30:00	AAPL	Stock	24.2375	24.2475	24.22	24.22	56388.0
2016-05-24 08:00:00	AAPL	Stock	24.25	24.2675	24.22	24.2575	345432.0
2016-05-24 08:30:00	AAPL	Stock	24.2575	24.2775	24.2525	24.27	172448.0
2016-05-24 09:00:00	AAPL	Stock	24.2725	24.31	24.2325	24.31	399328.0
2016-05-24 09:30:00	AAPL	Stock	24.31	24.345	24.21	24.3075	24819792.0
2016-05-24 10:00:00	AAPL	Stock	24.3075	24.36	24.2925	24.325	11727736.0
2016-05-24 10:30:00	AAPL	Stock	24.325	24.3825	24.3225	24.3675	9773896.0
2016-05-24 11:00:00	AAPL	Stock	24.37	24.4125	24.3675	24.4015	7516592.0
2016-05-24 11:30:00	AAPL	Stock	24.4012	24.435	24.3775	24.434	5976916.0
2016-05-24 12:00:00	AAPL	Stock	24.4348	24.4525	24.3975	24.4475	6412172.0
2016-05-24 12:30:00	AAPL	Stock	24.4488	24.4925	24.4425	24.4925	5734704.0
2016-05-24 13:00:00	AAPL	Stock	24.4925	24.5075	24.46	24.4675	6682252.0
2016-05-24 13:30:00	AAPL	Stock	24.4675	24.485	24.4128	24.4425	6115352.0
2016-05-24 14:00:00	AAPL	Stock	24.44	24.48	24.425	24.4412	5204004.0
2016-05-24 14:30:00	AAPL	Stock	24.4425	24.4875	24.43	24.4587	4983164.0
2016-05-24 15:00:00	AAPL	Stock	24.46	24.5225	24.445	24.485	8063088.0
2016-05-24 15:30:00	AAPL	Stock	24.485	24.4975	24.4488	24.475	13020620.0
2016-05-24 16:00:00	AAPL	Stock	24.475	24.5	24.475	24.4925	11447936.0
2016-05-24 16:30:00	AAPL	Stock	24.4875	24.5	24.4875	24.4975	52240.0
2016-05-24 17:00:00	AAPL	Stock	24.5	24.5	24.49	24.4975	43428.0
2016-05-24 17:30:00	AAPL	Stock	24.5	24.5	24.475	24.485	88348.0
2016-05-24 18:00:00	AAPL	Stock	24.4775	24.485	24.4775	24.485	28840.0
2016-05-24 18:30:00	AAPL	Stock	24.485	24.4875	24.4825	24.4825	33064.0
2016-05-24 19:00:00	AAPL	Stock	24.49	24.53	24.49	24.5125	29104.0
2016-05-24 19:30:00	AAPL	Stock	24.5	24.55	24.5	24.55	45508.0
2016-05-24 05:30:00	MSFT	Stock	50.5	50.55	50.5	50.55	3600.0
2016-05-24 06:00:00	MSFT	Stock	50.59	50.59	50.54	50.54	650.0
2016-05-24 06:30:00	MSFT	Stock	50.51	50.51	50.4	50.4	11599.0
2016-05-24 07:00:00	MSFT	Stock	50.45	50.57	50.45	50.55	10300.0
2016-05-24 07:30:00	MSFT	Stock	50.57	50.59	50.47	50.57	17872.0
2016-05-24 08:00:00	MSFT	Stock	50.53	50.57	50.4	50.5	42009.0
2016-05-24 08:30:00	MSFT	Stock	50.5	50.56	50.48	50.56	28414.0
2016-05-24 09:00:00	MSFT	Stock	50.51	50.72	50.5	50.69	79579.0
2016-05-24 09:30:00	MSFT	Stock	50.69	50.74	50.4	50.67	6225769.0
2016-05-24 10:00:00	MSFT	Stock	50.68	51.14	50.675	51.04	3724723.0
2016-05-24 10:30:00	MSFT	Stock	51.045	51.3	51.04	51.235	2719477.0
2016-05-24 11:00:00	MSFT	Stock	51.24	51.44	51.23	51.395	1628120.0
2016-05-24 11:30:00	MSFT	Stock	51.4	51.48	51.29	51.47	1610261.0
2016-05-24 12:00:00	MSFT	Stock	51.47	51.5	51.37	51.44	1181964.0
2016-05-24 12:30:00	MSFT	Stock	51.45	51.55	51.42	51.545	996169.0
2016-05-24 13:00:00	MSFT	Stock	51.542	51.71	51.5	51.531	1549618.0
2016-05-24 13:30:00	MSFT	Stock	51.535	51.61	51.45	51.526	1239559.0
2016-05-24 14:00:00	MSFT	Stock	51.53	51.575	51.44	51.475	1305530.0
2016-05-24 14:30:00	MSFT	Stock	51.48	51.61	51.42	51.535	1531149.0

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

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