PREVIEW / stock_5min / 2011-08-08

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-08-08.parquet
  size:    5.8 MB
  rows:    384,292
  symbols: 3,592

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
2011-08-08 04:00:00	AAPL	Stock	13.2932	13.2932	13.0357	13.0786	72520.0
2011-08-08 04:05:00	AAPL	Stock	13.0786	13.1143	13.0786	13.0893	58800.0
2011-08-08 04:10:00	AAPL	Stock	13.0879	13.0964	13.0786	13.0839	114408.0
2011-08-08 04:15:00	AAPL	Stock	13.0821	13.0875	13.0579	13.0625	98000.0
2011-08-08 04:20:00	AAPL	Stock	13.0786	13.0786	13.0643	13.0786	88956.0
2011-08-08 04:25:00	AAPL	Stock	13.0864	13.1225	13.0786	13.0786	30800.0
2011-08-08 04:35:00	AAPL	Stock	13.0875	13.0875	13.0786	13.08	19600.0
2011-08-08 04:40:00	AAPL	Stock	13.0786	13.0786	13.0764	13.0764	27356.0
2011-08-08 04:45:00	AAPL	Stock	13.0764	13.0764	13.0471	13.0471	13524.0
2011-08-08 04:50:00	AAPL	Stock	13.0625	13.0625	13.0625	13.0625	31556.0
2011-08-08 04:55:00	AAPL	Stock	13.0625	13.0625	13.045	13.045	48720.0
2011-08-08 05:00:00	AAPL	Stock	13.0368	13.0536	13.0368	13.0536	14000.0
2011-08-08 05:05:00	AAPL	Stock	13.0443	13.0443	13.0429	13.0429	8400.0
2011-08-08 05:10:00	AAPL	Stock	13.0429	13.0429	13.0429	13.0429	47040.0
2011-08-08 05:15:00	AAPL	Stock	13.0446	13.0536	13.0179	13.0179	33600.0
2011-08-08 05:20:00	AAPL	Stock	13.0179	13.0179	13.0179	13.0179	2800.0
2011-08-08 05:25:00	AAPL	Stock	13.0093	13.0179	13.0	13.0179	37800.0
2011-08-08 05:30:00	AAPL	Stock	13.0179	13.02	13.0179	13.02	50064.0
2011-08-08 05:35:00	AAPL	Stock	13.0329	13.0429	13.0329	13.0357	19600.0
2011-08-08 05:40:00	AAPL	Stock	13.0357	13.0357	12.975	12.975	39200.0
2011-08-08 05:45:00	AAPL	Stock	12.9954	13.0107	12.9821	12.9821	39760.0
2011-08-08 05:50:00	AAPL	Stock	12.9821	12.9929	12.975	12.9929	11200.0
2011-08-08 05:55:00	AAPL	Stock	12.9929	13.0007	12.9821	13.0007	58800.0
2011-08-08 06:00:00	AAPL	Stock	13.0086	13.0261	13.0043	13.0121	33600.0
2011-08-08 06:05:00	AAPL	Stock	13.0357	13.0357	13.0071	13.0071	47600.0
2011-08-08 06:10:00	AAPL	Stock	13.0079	13.0179	13.0071	13.0179	30660.0
2011-08-08 06:15:00	AAPL	Stock	13.0071	13.0218	13.0071	13.0071	111720.0
2011-08-08 06:20:00	AAPL	Stock	13.0071	13.0071	13.0071	13.0071	14000.0
2011-08-08 06:25:00	AAPL	Stock	13.0071	13.0336	13.0071	13.0336	54600.0
2011-08-08 06:40:00	AAPL	Stock	13.0232	13.0332	13.0232	13.0332	25200.0
2011-08-08 06:45:00	AAPL	Stock	13.0271	13.0271	13.0271	13.0271	5600.0
2011-08-08 06:50:00	AAPL	Stock	13.0268	13.0268	13.0268	13.0268	5600.0
2011-08-08 06:55:00	AAPL	Stock	13.0429	13.0429	13.0357	13.0357	5600.0
2011-08-08 07:00:00	AAPL	Stock	13.0289	13.0768	13.0289	13.0714	158760.0
2011-08-08 07:05:00	AAPL	Stock	13.0546	13.0871	13.0357	13.085	200704.0
2011-08-08 07:10:00	AAPL	Stock	13.0643	13.0982	13.0643	13.0893	36820.0
2011-08-08 07:15:00	AAPL	Stock	13.0982	13.1143	13.0893	13.1079	266196.0
2011-08-08 07:20:00	AAPL	Stock	13.1282	13.1468	13.1146	13.1421	265804.0
2011-08-08 07:25:00	AAPL	Stock	13.1261	13.1261	13.0836	13.0836	201040.0
2011-08-08 07:30:00	AAPL	Stock	13.0839	13.0893	13.0557	13.0696	341320.0
2011-08-08 07:35:00	AAPL	Stock	13.0568	13.1029	13.0468	13.1029	552860.0
2011-08-08 07:40:00	AAPL	Stock	13.0961	13.0961	13.0536	13.0536	120652.0
2011-08-08 07:45:00	AAPL	Stock	13.0714	13.0714	13.0354	13.0357	416052.0
2011-08-08 07:50:00	AAPL	Stock	13.0511	13.0657	13.0054	13.0379	581392.0
2011-08-08 07:55:00	AAPL	Stock	13.0414	13.0729	13.0268	13.0714	245280.0
2011-08-08 08:00:00	AAPL	Stock	13.0539	13.0854	13.0236	13.0271	1547840.0
2011-08-08 08:05:00	AAPL	Stock	13.0271	13.0589	13.0143	13.0532	1072960.0
2011-08-08 08:10:00	AAPL	Stock	13.0468	13.0518	13.0236	13.0446	536704.0
2011-08-08 08:15:00	AAPL	Stock	13.0411	13.0411	12.9286	13.0229	431480.0
2011-08-08 08:20:00	AAPL	Stock	13.0229	13.0821	13.0186	13.0821	1495536.0

> showing 50 of 384,292 rows — these rows as CSV

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