PREVIEW / stock_5min / 2012-07-02

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-02.parquet
  size:    4.7 MB
  rows:    323,566
  symbols: 3,490

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
2012-07-02 04:00:00	AAPL	Stock	20.875	20.875	20.875	20.875	2800.0
2012-07-02 04:05:00	AAPL	Stock	20.8836	20.8836	20.8836	20.8836	11200.0
2012-07-02 04:10:00	AAPL	Stock	20.8821	20.8875	20.8821	20.8875	67200.0
2012-07-02 04:25:00	AAPL	Stock	20.9286	20.9532	20.9286	20.9464	44800.0
2012-07-02 05:00:00	AAPL	Stock	20.9532	20.9532	20.9532	20.9532	8120.0
2012-07-02 05:20:00	AAPL	Stock	20.9532	20.9532	20.9532	20.9532	2800.0
2012-07-02 05:25:00	AAPL	Stock	20.9536	20.9536	20.9536	20.9536	2800.0
2012-07-02 05:30:00	AAPL	Stock	20.9482	20.9482	20.9286	20.9286	40600.0
2012-07-02 06:00:00	AAPL	Stock	20.9214	20.9214	20.9214	20.9214	14000.0
2012-07-02 06:05:00	AAPL	Stock	20.9168	20.9168	20.9168	20.9168	2800.0
2012-07-02 06:15:00	AAPL	Stock	20.9107	20.9107	20.9	20.9	8400.0
2012-07-02 06:30:00	AAPL	Stock	20.8982	20.8982	20.8982	20.8982	2800.0
2012-07-02 06:35:00	AAPL	Stock	20.9107	20.9143	20.9107	20.9143	17080.0
2012-07-02 06:40:00	AAPL	Stock	20.9168	20.9168	20.9107	20.9107	8400.0
2012-07-02 06:50:00	AAPL	Stock	20.9018	20.9018	20.9018	20.9018	2800.0
2012-07-02 07:00:00	AAPL	Stock	20.9	20.9561	20.9	20.9429	80696.0
2012-07-02 07:10:00	AAPL	Stock	20.9286	20.9404	20.9286	20.9404	22400.0
2012-07-02 07:20:00	AAPL	Stock	20.9214	20.9214	20.9143	20.9143	22316.0
2012-07-02 07:25:00	AAPL	Stock	20.9104	20.9104	20.9104	20.9104	2800.0
2012-07-02 07:30:00	AAPL	Stock	20.9107	20.9139	20.9107	20.9107	14000.0
2012-07-02 07:40:00	AAPL	Stock	20.9018	20.9139	20.8929	20.9139	45976.0
2012-07-02 07:45:00	AAPL	Stock	20.8968	20.8968	20.8968	20.8968	5096.0
2012-07-02 07:50:00	AAPL	Stock	20.8975	20.8975	20.8929	20.8929	38612.0
2012-07-02 07:55:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	39620.0
2012-07-02 08:00:00	AAPL	Stock	20.8929	20.8982	20.8536	20.8571	234304.0
2012-07-02 08:05:00	AAPL	Stock	20.8571	20.8729	20.8571	20.8625	85960.0
2012-07-02 08:10:00	AAPL	Stock	20.8661	20.8696	20.8579	20.8579	121044.0
2012-07-02 08:15:00	AAPL	Stock	20.8568	20.8571	20.8243	20.8243	126112.0
2012-07-02 08:20:00	AAPL	Stock	20.8254	20.8389	20.8196	20.8239	105532.0
2012-07-02 08:25:00	AAPL	Stock	20.8268	20.8571	20.8268	20.8429	111216.0
2012-07-02 08:30:00	AAPL	Stock	20.8464	20.855	20.8457	20.855	72800.0
2012-07-02 08:35:00	AAPL	Stock	20.8521	20.8554	20.8482	20.8482	45500.0
2012-07-02 08:40:00	AAPL	Stock	20.8557	20.8643	20.8557	20.8643	28896.0
2012-07-02 08:45:00	AAPL	Stock	20.8579	20.8646	20.8571	20.8571	64148.0
2012-07-02 08:50:00	AAPL	Stock	20.8604	20.8611	20.8546	20.8571	160720.0
2012-07-02 08:55:00	AAPL	Stock	20.8536	20.8661	20.8536	20.8661	97300.0
2012-07-02 09:00:00	AAPL	Stock	20.8607	20.8643	20.855	20.855	67760.0
2012-07-02 09:05:00	AAPL	Stock	20.8464	20.8518	20.8411	20.845	122276.0
2012-07-02 09:10:00	AAPL	Stock	20.8571	20.8571	20.8429	20.8486	120932.0
2012-07-02 09:15:00	AAPL	Stock	20.8525	20.8654	20.8525	20.8632	53760.0
2012-07-02 09:20:00	AAPL	Stock	20.8607	20.8661	20.8571	20.8661	123900.0
2012-07-02 09:25:00	AAPL	Stock	20.8614	20.8929	20.86	20.8804	349860.0
2012-07-02 09:30:00	AAPL	Stock	20.8804	20.9321	20.8429	20.9236	12066236.0
2012-07-02 09:35:00	AAPL	Stock	20.9282	20.99	20.92	20.9796	15185940.0
2012-07-02 09:40:00	AAPL	Stock	20.9818	21.0639	20.9779	21.0529	17187380.0
2012-07-02 09:45:00	AAPL	Stock	21.0532	21.1389	21.0493	21.0896	20517504.0
2012-07-02 09:50:00	AAPL	Stock	21.0932	21.105	21.06	21.1029	11446064.0
2012-07-02 09:55:00	AAPL	Stock	21.1043	21.1211	21.0714	21.0791	7159628.0
2012-07-02 10:00:00	AAPL	Stock	21.0825	21.0825	20.9679	21.0125	18633104.0
2012-07-02 10:05:00	AAPL	Stock	21.015	21.0632	21.0004	21.025	7464940.0

> showing 50 of 323,566 rows — these rows as CSV

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