PREVIEW / stock_5min / 2013-11-04

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-11-04.parquet
  size:    5.5 MB
  rows:    371,309
  symbols: 3,531

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
2013-11-04 04:00:00	AAPL	Stock	18.5771	18.5771	18.575	18.575	16800.0
2013-11-04 04:35:00	AAPL	Stock	18.6071	18.6071	18.6071	18.6071	2800.0
2013-11-04 04:40:00	AAPL	Stock	18.6089	18.6196	18.6089	18.6196	17892.0
2013-11-04 05:15:00	AAPL	Stock	18.6214	18.6214	18.6196	18.6196	8400.0
2013-11-04 05:25:00	AAPL	Stock	18.6429	18.6429	18.6429	18.6429	5600.0
2013-11-04 05:40:00	AAPL	Stock	18.6589	18.6589	18.6589	18.6589	3920.0
2013-11-04 06:25:00	AAPL	Stock	18.6518	18.6518	18.6518	18.6518	8400.0
2013-11-04 07:00:00	AAPL	Stock	18.6196	18.6196	18.5961	18.5961	74004.0
2013-11-04 07:05:00	AAPL	Stock	18.6071	18.6071	18.5964	18.5964	10528.0
2013-11-04 07:10:00	AAPL	Stock	18.5964	18.5964	18.5964	18.5964	2800.0
2013-11-04 07:15:00	AAPL	Stock	18.6032	18.6071	18.6032	18.6071	18200.0
2013-11-04 07:20:00	AAPL	Stock	18.6071	18.6161	18.6071	18.6161	33600.0
2013-11-04 07:25:00	AAPL	Stock	18.6143	18.6289	18.6143	18.6289	68040.0
2013-11-04 07:35:00	AAPL	Stock	18.6289	18.6425	18.6289	18.6425	35448.0
2013-11-04 07:40:00	AAPL	Stock	18.6214	18.6214	18.6214	18.6214	10920.0
2013-11-04 07:45:00	AAPL	Stock	18.625	18.6321	18.625	18.6321	19600.0
2013-11-04 07:50:00	AAPL	Stock	18.6218	18.625	18.6214	18.6214	14000.0
2013-11-04 07:55:00	AAPL	Stock	18.6214	18.6214	18.6214	18.6214	2800.0
2013-11-04 08:00:00	AAPL	Stock	18.6386	18.6425	18.5721	18.5893	208488.0
2013-11-04 08:05:00	AAPL	Stock	18.5893	18.5929	18.5789	18.5893	54012.0
2013-11-04 08:10:00	AAPL	Stock	18.5839	18.5964	18.5839	18.5964	180768.0
2013-11-04 08:15:00	AAPL	Stock	18.5996	18.6036	18.5893	18.5893	123004.0
2013-11-04 08:20:00	AAPL	Stock	18.5911	18.6	18.5893	18.5893	101640.0
2013-11-04 08:25:00	AAPL	Stock	18.5921	18.5964	18.5879	18.5929	197260.0
2013-11-04 08:30:00	AAPL	Stock	18.5929	18.6043	18.5929	18.6032	83972.0
2013-11-04 08:35:00	AAPL	Stock	18.6071	18.6214	18.6036	18.6161	245392.0
2013-11-04 08:40:00	AAPL	Stock	18.6179	18.6211	18.6011	18.6046	131600.0
2013-11-04 08:45:00	AAPL	Stock	18.6125	18.6125	18.6018	18.6086	91028.0
2013-11-04 08:50:00	AAPL	Stock	18.6086	18.6104	18.6086	18.6104	15960.0
2013-11-04 08:55:00	AAPL	Stock	18.6143	18.6225	18.6082	18.6214	158116.0
2013-11-04 09:00:00	AAPL	Stock	18.6161	18.6257	18.6157	18.6254	248388.0
2013-11-04 09:05:00	AAPL	Stock	18.6232	18.6368	18.6214	18.6364	245644.0
2013-11-04 09:10:00	AAPL	Stock	18.6311	18.6332	18.6254	18.6257	85988.0
2013-11-04 09:15:00	AAPL	Stock	18.6261	18.6261	18.6257	18.6257	11200.0
2013-11-04 09:20:00	AAPL	Stock	18.6296	18.6368	18.6296	18.6368	190148.0
2013-11-04 09:25:00	AAPL	Stock	18.6339	18.6407	18.5929	18.6071	417816.0
2013-11-04 09:30:00	AAPL	Stock	18.6093	18.6636	18.5625	18.6607	13886096.0
2013-11-04 09:35:00	AAPL	Stock	18.66	18.6746	18.5289	18.5514	9312688.0
2013-11-04 09:40:00	AAPL	Stock	18.5532	18.6064	18.5425	18.5843	5002872.0
2013-11-04 09:45:00	AAPL	Stock	18.5843	18.6018	18.5775	18.5789	2853004.0
2013-11-04 09:50:00	AAPL	Stock	18.5768	18.5907	18.5289	18.5557	5498500.0
2013-11-04 09:55:00	AAPL	Stock	18.5546	18.5936	18.5418	18.5889	3810800.0
2013-11-04 10:00:00	AAPL	Stock	18.59	18.6704	18.5804	18.6645	6543236.0
2013-11-04 10:05:00	AAPL	Stock	18.6659	18.6993	18.6489	18.6957	7011760.0
2013-11-04 10:10:00	AAPL	Stock	18.6954	18.7339	18.6707	18.7154	6759060.0
2013-11-04 10:15:00	AAPL	Stock	18.7154	18.7268	18.6989	18.7118	3621884.0
2013-11-04 10:20:00	AAPL	Stock	18.7082	18.7461	18.7011	18.741	4910836.0
2013-11-04 10:25:00	AAPL	Stock	18.7414	18.7536	18.7036	18.7069	4525388.0
2013-11-04 10:30:00	AAPL	Stock	18.7082	18.725	18.7064	18.7193	2105236.0
2013-11-04 10:35:00	AAPL	Stock	18.7164	18.7425	18.7143	18.7307	3038896.0

> showing 50 of 371,309 rows — these rows as CSV

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