PREVIEW / stock_30min / 2015-11-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-17.parquet
  size:    1.6 MB
  rows:    81,563
  symbols: 3,409

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-11-17 04:00:00	AAPL	Stock	28.5225	28.595	28.5225	28.595	1400.0
2015-11-17 04:30:00	AAPL	Stock	28.65	28.65	28.625	28.65	5016.0
2015-11-17 05:00:00	AAPL	Stock	28.6425	28.65	28.6425	28.65	1236.0
2015-11-17 06:00:00	AAPL	Stock	28.6625	28.6925	28.6425	28.6875	7536.0
2015-11-17 06:30:00	AAPL	Stock	28.675	28.6925	28.67	28.6775	23604.0
2015-11-17 07:00:00	AAPL	Stock	28.675	28.7725	28.655	28.75	96740.0
2015-11-17 07:30:00	AAPL	Stock	28.7175	28.7375	28.675	28.7	72120.0
2015-11-17 08:00:00	AAPL	Stock	28.71	28.7975	28.6425	28.685	231476.0
2015-11-17 08:30:00	AAPL	Stock	28.6775	28.7175	28.6625	28.6875	147756.0
2015-11-17 09:00:00	AAPL	Stock	28.6875	28.73	28.6625	28.73	357460.0
2015-11-17 09:30:00	AAPL	Stock	28.73	28.7625	28.455	28.505	18909948.0
2015-11-17 10:00:00	AAPL	Stock	28.505	28.55	28.4175	28.5425	9125244.0
2015-11-17 10:30:00	AAPL	Stock	28.545	28.6425	28.4625	28.6225	8573028.0
2015-11-17 11:00:00	AAPL	Stock	28.6225	28.65	28.5425	28.6438	6318244.0
2015-11-17 11:30:00	AAPL	Stock	28.6425	28.7025	28.5775	28.5975	7955732.0
2015-11-17 12:00:00	AAPL	Stock	28.5975	28.6725	28.5422	28.545	4929872.0
2015-11-17 12:30:00	AAPL	Stock	28.5425	28.58	28.48	28.575	4555196.0
2015-11-17 13:00:00	AAPL	Stock	28.5725	28.6	28.485	28.5	3218764.0
2015-11-17 13:30:00	AAPL	Stock	28.4988	28.59	28.49	28.58	3341484.0
2015-11-17 14:00:00	AAPL	Stock	28.58	28.61	28.4762	28.48	3893380.0
2015-11-17 14:30:00	AAPL	Stock	28.4775	28.495	28.3875	28.4728	6626572.0
2015-11-17 15:00:00	AAPL	Stock	28.4725	28.4765	28.33	28.4278	9293460.0
2015-11-17 15:30:00	AAPL	Stock	28.43	28.4602	28.3575	28.4175	10002716.0
2015-11-17 16:00:00	AAPL	Stock	28.4225	28.4575	28.415	28.445	4038316.0
2015-11-17 16:30:00	AAPL	Stock	28.445	28.4575	28.33	28.455	295300.0
2015-11-17 17:00:00	AAPL	Stock	28.4425	28.4625	28.4425	28.4625	16592.0
2015-11-17 17:30:00	AAPL	Stock	28.4425	28.445	28.4375	28.445	3840.0
2015-11-17 18:00:00	AAPL	Stock	28.435	28.4475	28.43	28.4475	33616.0
2015-11-17 18:30:00	AAPL	Stock	28.4475	28.4475	28.4375	28.4375	1600.0
2015-11-17 19:00:00	AAPL	Stock	28.4325	28.4425	28.4325	28.4325	15288.0
2015-11-17 19:30:00	AAPL	Stock	28.4425	28.4425	28.4275	28.4325	7516.0
2015-11-17 04:00:00	MSFT	Stock	53.7	53.7	53.51	53.51	780.0
2015-11-17 06:00:00	MSFT	Stock	53.75	53.75	53.75	53.75	1100.0
2015-11-17 06:30:00	MSFT	Stock	53.7	53.7	53.42	53.53	11600.0
2015-11-17 07:00:00	MSFT	Stock	53.67	53.67	53.66	53.67	1700.0
2015-11-17 07:30:00	MSFT	Stock	53.62	53.63	53.61	53.61	10700.0
2015-11-17 08:00:00	MSFT	Stock	53.67	53.67	53.55	53.55	3437.0
2015-11-17 08:30:00	MSFT	Stock	53.55	53.64	53.53	53.53	25872.0
2015-11-17 09:00:00	MSFT	Stock	53.52	53.6	53.26	53.31	79398.0
2015-11-17 09:30:00	MSFT	Stock	53.17	53.53	53.05	53.47	3741345.0
2015-11-17 10:00:00	MSFT	Stock	53.48	53.52	53.02	53.12	2532990.0
2015-11-17 10:30:00	MSFT	Stock	53.12	53.47	53.1	53.33	1872333.0
2015-11-17 11:00:00	MSFT	Stock	53.33	53.44	53.28	53.41	1505157.0
2015-11-17 11:30:00	MSFT	Stock	53.415	53.51	53.31	53.34	1382298.0
2015-11-17 12:00:00	MSFT	Stock	53.35	53.43	53.26	53.284	1420626.0
2015-11-17 12:30:00	MSFT	Stock	53.29	53.32	53.17	53.27	1205775.0
2015-11-17 13:00:00	MSFT	Stock	53.27	53.33	53.14	53.16	839968.0
2015-11-17 13:30:00	MSFT	Stock	53.16	53.26	53.05	53.245	1274232.0
2015-11-17 14:00:00	MSFT	Stock	53.246	53.246	53.03	53.031	1568824.0
2015-11-17 14:30:00	MSFT	Stock	53.04	53.126	52.88	53.12	1769554.0

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

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