PREVIEW / stock_30min / 2015-02-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-23.parquet
  size:    1.6 MB
  rows:    82,862
  symbols: 3,534

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-23 04:00:00	AAPL	Stock	32.47	32.4875	32.405	32.4875	32912.0
2015-02-23 04:30:00	AAPL	Stock	32.485	32.485	32.45	32.4625	13092.0
2015-02-23 05:00:00	AAPL	Stock	32.4425	32.47	32.4425	32.465	13004.0
2015-02-23 05:30:00	AAPL	Stock	32.4675	32.51	32.425	32.4925	74884.0
2015-02-23 06:00:00	AAPL	Stock	32.5075	32.545	32.475	32.5	95824.0
2015-02-23 06:30:00	AAPL	Stock	32.48	32.4875	32.4525	32.4875	23204.0
2015-02-23 07:00:00	AAPL	Stock	32.4975	32.4975	32.4175	32.43	73940.0
2015-02-23 07:30:00	AAPL	Stock	32.4325	32.495	32.4275	32.4825	163052.0
2015-02-23 08:00:00	AAPL	Stock	32.4825	32.525	32.4175	32.4275	586160.0
2015-02-23 08:30:00	AAPL	Stock	32.4325	32.45	32.41	32.4125	380336.0
2015-02-23 09:00:00	AAPL	Stock	32.4225	32.54	32.4025	32.5075	884580.0
2015-02-23 09:30:00	AAPL	Stock	32.5075	32.6225	32.415	32.62	36262008.0
2015-02-23 10:00:00	AAPL	Stock	32.62	32.7125	32.5975	32.69	22287128.0
2015-02-23 10:30:00	AAPL	Stock	32.69	32.841	32.67	32.8325	23113892.0
2015-02-23 11:00:00	AAPL	Stock	32.83	32.9725	32.8275	32.9718	21216256.0
2015-02-23 11:30:00	AAPL	Stock	32.9725	32.975	32.87	32.9302	17233948.0
2015-02-23 12:00:00	AAPL	Stock	32.93	32.96	32.8775	32.945	10651764.0
2015-02-23 12:30:00	AAPL	Stock	32.9462	33.035	32.9275	33.035	16182220.0
2015-02-23 13:00:00	AAPL	Stock	33.0348	33.05	32.965	33.0088	10356596.0
2015-02-23 13:30:00	AAPL	Stock	33.0075	33.0375	32.965	33.0185	9785680.0
2015-02-23 14:00:00	AAPL	Stock	33.0175	33.1175	33.015	33.115	10768756.0
2015-02-23 14:30:00	AAPL	Stock	33.1125	33.15	33.095	33.0975	15888836.0
2015-02-23 15:00:00	AAPL	Stock	33.0975	33.1375	33.0138	33.1275	16282996.0
2015-02-23 15:30:00	AAPL	Stock	33.1275	33.25	33.1225	33.2438	23771596.0
2015-02-23 16:00:00	AAPL	Stock	33.25	33.255	32.9018	33.2525	12927456.0
2015-02-23 16:30:00	AAPL	Stock	33.255	33.2625	32.9325	33.245	260792.0
2015-02-23 17:00:00	AAPL	Stock	33.2498	33.255	33.2425	33.25	123428.0
2015-02-23 17:30:00	AAPL	Stock	33.25	33.25	33.24	33.2475	1333128.0
2015-02-23 18:00:00	AAPL	Stock	33.245	33.245	33.235	33.2375	69644.0
2015-02-23 18:30:00	AAPL	Stock	33.235	33.245	33.2275	33.2375	78796.0
2015-02-23 19:00:00	AAPL	Stock	33.2375	33.255	33.2325	33.255	59984.0
2015-02-23 19:30:00	AAPL	Stock	33.255	33.2875	33.2525	33.2775	173436.0
2015-02-23 06:00:00	MSFT	Stock	43.6	43.6	43.6	43.6	300.0
2015-02-23 06:30:00	MSFT	Stock	43.61	43.61	43.6	43.6	300.0
2015-02-23 08:00:00	MSFT	Stock	43.6	43.69	43.56	43.69	820.0
2015-02-23 08:30:00	MSFT	Stock	43.61	43.7	43.61	43.68	404.0
2015-02-23 09:00:00	MSFT	Stock	43.651	43.79	43.651	43.66	13437.0
2015-02-23 09:30:00	MSFT	Stock	43.67	43.93	43.65	43.84	5247204.0
2015-02-23 10:00:00	MSFT	Stock	43.84	43.84	43.74	43.79	2440045.0
2015-02-23 10:30:00	MSFT	Stock	43.795	43.86	43.775	43.81	2078175.0
2015-02-23 11:00:00	MSFT	Stock	43.81	43.93	43.8	43.9	1750666.0
2015-02-23 11:30:00	MSFT	Stock	43.91	43.97	43.885	43.942	931361.0
2015-02-23 12:00:00	MSFT	Stock	43.942	43.985	43.89	43.895	1079773.0
2015-02-23 12:30:00	MSFT	Stock	43.894	43.92	43.87	43.915	1337229.0
2015-02-23 13:00:00	MSFT	Stock	43.915	43.93	43.9	43.925	976702.0
2015-02-23 13:30:00	MSFT	Stock	43.93	43.99	43.92	43.966	2005761.0
2015-02-23 14:00:00	MSFT	Stock	43.96	44.19	43.96	44.18	2100627.0
2015-02-23 14:30:00	MSFT	Stock	44.185	44.19	44.12	44.125	1908323.0
2015-02-23 15:00:00	MSFT	Stock	44.12	44.123	44.0	44.054	1873392.0
2015-02-23 15:30:00	MSFT	Stock	44.05	44.19	44.045	44.15	4736444.0

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

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