PREVIEW / stock_1min / 2012-04-18

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-04-18.parquet
  size:    12.5 MB
  rows:    934,019
  symbols: 2,825

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-04-18 04:00:00	AAPL	Stock	21.7982	21.8929	21.7982	21.8929	125860.0
2012-04-18 04:02:00	AAPL	Stock	21.8754	21.8929	21.8754	21.8929	44800.0
2012-04-18 04:05:00	AAPL	Stock	21.8929	21.8929	21.8929	21.8929	16800.0
2012-04-18 04:15:00	AAPL	Stock	21.8932	21.8961	21.8932	21.8961	5600.0
2012-04-18 04:19:00	AAPL	Stock	21.8961	21.8964	21.8961	21.8964	5600.0
2012-04-18 04:32:00	AAPL	Stock	21.9089	21.9089	21.9089	21.9089	2800.0
2012-04-18 04:35:00	AAPL	Stock	21.8936	21.8936	21.8932	21.8936	14000.0
2012-04-18 04:36:00	AAPL	Stock	21.8754	21.8754	21.875	21.875	5600.0
2012-04-18 04:37:00	AAPL	Stock	21.875	21.8929	21.875	21.8757	8400.0
2012-04-18 04:43:00	AAPL	Stock	21.8575	21.8575	21.8571	21.8571	11200.0
2012-04-18 04:45:00	AAPL	Stock	21.8396	21.8396	21.8396	21.8396	2800.0
2012-04-18 04:46:00	AAPL	Stock	21.8218	21.8218	21.8214	21.8214	5600.0
2012-04-18 04:48:00	AAPL	Stock	21.8389	21.8393	21.8389	21.8393	14000.0
2012-04-18 05:00:00	AAPL	Stock	21.8071	21.8071	21.7929	21.7929	11200.0
2012-04-18 05:04:00	AAPL	Stock	21.7893	21.7893	21.7893	21.7893	5600.0
2012-04-18 05:09:00	AAPL	Stock	21.7918	21.7918	21.7893	21.7893	9800.0
2012-04-18 05:10:00	AAPL	Stock	21.7875	21.7875	21.7825	21.7825	11200.0
2012-04-18 05:23:00	AAPL	Stock	21.75	21.75	21.75	21.75	2800.0
2012-04-18 05:43:00	AAPL	Stock	21.775	21.775	21.775	21.775	8400.0
2012-04-18 05:49:00	AAPL	Stock	21.7439	21.7439	21.7439	21.7439	2800.0
2012-04-18 05:54:00	AAPL	Stock	21.7321	21.7321	21.6911	21.7143	28000.0
2012-04-18 05:55:00	AAPL	Stock	21.6796	21.6796	21.6796	21.6796	5600.0
2012-04-18 05:56:00	AAPL	Stock	21.6796	21.6796	21.6793	21.6793	8400.0
2012-04-18 05:59:00	AAPL	Stock	21.6964	21.6964	21.6889	21.6889	14000.0
2012-04-18 06:01:00	AAPL	Stock	21.6896	21.6907	21.6896	21.6907	5600.0
2012-04-18 06:04:00	AAPL	Stock	21.6832	21.6832	21.68	21.68	7000.0
2012-04-18 06:05:00	AAPL	Stock	21.6825	21.6825	21.6825	21.6825	2800.0
2012-04-18 06:10:00	AAPL	Stock	21.6807	21.6807	21.6807	21.6807	4200.0
2012-04-18 06:13:00	AAPL	Stock	21.6839	21.6839	21.6839	21.6839	2800.0
2012-04-18 06:14:00	AAPL	Stock	21.6839	21.6839	21.6839	21.6839	12040.0
2012-04-18 06:22:00	AAPL	Stock	21.6875	21.6929	21.6875	21.6929	5600.0
2012-04-18 06:27:00	AAPL	Stock	21.6929	21.6929	21.6929	21.6929	2800.0
2012-04-18 06:32:00	AAPL	Stock	21.6964	21.6964	21.6964	21.6964	5600.0
2012-04-18 06:35:00	AAPL	Stock	21.7139	21.7143	21.7139	21.7143	28000.0
2012-04-18 06:37:00	AAPL	Stock	21.7143	21.7143	21.7139	21.7143	16800.0
2012-04-18 06:38:00	AAPL	Stock	21.6875	21.6875	21.6875	21.6875	14140.0
2012-04-18 06:39:00	AAPL	Stock	21.7089	21.7089	21.7089	21.7089	2800.0
2012-04-18 06:40:00	AAPL	Stock	21.6968	21.6968	21.6968	21.6968	2800.0
2012-04-18 07:00:00	AAPL	Stock	21.705	21.705	21.6993	21.6993	8400.0
2012-04-18 07:01:00	AAPL	Stock	21.7054	21.7054	21.6961	21.6961	12600.0
2012-04-18 07:02:00	AAPL	Stock	21.7036	21.7143	21.7	21.7	71148.0
2012-04-18 07:05:00	AAPL	Stock	21.7143	21.7143	21.7	21.7	11200.0
2012-04-18 07:06:00	AAPL	Stock	21.7036	21.7036	21.6971	21.6971	42924.0
2012-04-18 07:07:00	AAPL	Stock	21.6964	21.6964	21.6875	21.6875	29820.0
2012-04-18 07:08:00	AAPL	Stock	21.6857	21.6857	21.6857	21.6857	2800.0
2012-04-18 07:09:00	AAPL	Stock	21.6811	21.6811	21.6811	21.6811	2800.0
2012-04-18 07:10:00	AAPL	Stock	21.6875	21.6875	21.6811	21.6811	5600.0
2012-04-18 07:13:00	AAPL	Stock	21.6814	21.6821	21.6814	21.6821	11200.0
2012-04-18 07:14:00	AAPL	Stock	21.6821	21.6929	21.6821	21.6929	15904.0
2012-04-18 07:16:00	AAPL	Stock	21.7071	21.7089	21.7071	21.7089	8400.0

> showing 50 of 934,019 rows — these rows as CSV

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