PREVIEW / stock_1min / 2009-05-27

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-05-27.parquet
  size:    12.9 MB
  rows:    985,425
  symbols: 2,718

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
2009-05-27 05:05:00	AAPL	Stock	4.7236	4.7236	4.7236	4.7236	2800.0
2009-05-27 07:00:00	AAPL	Stock	4.7186	4.7186	4.7186	4.7186	19600.0
2009-05-27 07:01:00	AAPL	Stock	4.7186	4.7186	4.7186	4.7186	36400.0
2009-05-27 07:02:00	AAPL	Stock	4.7186	4.7186	4.7186	4.7186	2800.0
2009-05-27 07:04:00	AAPL	Stock	4.7143	4.7143	4.7143	4.7143	5600.0
2009-05-27 07:05:00	AAPL	Stock	4.7146	4.7146	4.7071	4.7071	149800.0
2009-05-27 07:07:00	AAPL	Stock	4.7004	4.7004	4.6804	4.6804	72800.0
2009-05-27 07:08:00	AAPL	Stock	4.6804	4.6804	4.6804	4.6804	70000.0
2009-05-27 07:10:00	AAPL	Stock	4.6929	4.6929	4.6929	4.6929	14000.0
2009-05-27 07:11:00	AAPL	Stock	4.6932	4.6932	4.6932	4.6932	2800.0
2009-05-27 07:20:00	AAPL	Stock	4.6896	4.6896	4.6896	4.6896	2800.0
2009-05-27 07:22:00	AAPL	Stock	4.6832	4.6832	4.6832	4.6832	2800.0
2009-05-27 07:27:00	AAPL	Stock	4.6868	4.6868	4.6868	4.6868	2800.0
2009-05-27 07:29:00	AAPL	Stock	4.6875	4.6875	4.6875	4.6875	2800.0
2009-05-27 07:30:00	AAPL	Stock	4.6857	4.6857	4.6857	4.6857	2800.0
2009-05-27 07:32:00	AAPL	Stock	4.6889	4.6889	4.6889	4.6889	5600.0
2009-05-27 07:34:00	AAPL	Stock	4.6893	4.6893	4.6893	4.6893	14000.0
2009-05-27 07:51:00	AAPL	Stock	4.6929	4.6932	4.6929	4.6932	56000.0
2009-05-27 07:55:00	AAPL	Stock	4.6968	4.6968	4.6879	4.6893	56000.0
2009-05-27 07:56:00	AAPL	Stock	4.6879	4.6879	4.6875	4.6875	5600.0
2009-05-27 07:58:00	AAPL	Stock	4.6893	4.6893	4.6893	4.6893	2800.0
2009-05-27 07:59:00	AAPL	Stock	4.6893	4.6893	4.6893	4.6893	2800.0
2009-05-27 08:00:00	AAPL	Stock	4.6929	4.6964	4.6925	4.6929	130480.0
2009-05-27 08:01:00	AAPL	Stock	4.6964	4.6964	4.6957	4.6957	83860.0
2009-05-27 08:02:00	AAPL	Stock	4.6957	4.6964	4.6946	4.6946	77616.0
2009-05-27 08:03:00	AAPL	Stock	4.6964	4.6964	4.6929	4.6932	112700.0
2009-05-27 08:04:00	AAPL	Stock	4.6936	4.6936	4.6879	4.6911	32480.0
2009-05-27 08:05:00	AAPL	Stock	4.6911	4.6911	4.6875	4.6875	25900.0
2009-05-27 08:06:00	AAPL	Stock	4.6875	4.6875	4.6875	4.6875	2800.0
2009-05-27 08:08:00	AAPL	Stock	4.6875	4.6875	4.6861	4.6861	11200.0
2009-05-27 08:10:00	AAPL	Stock	4.6914	4.6946	4.6914	4.6929	152628.0
2009-05-27 08:11:00	AAPL	Stock	4.6929	4.6929	4.6929	4.6929	41832.0
2009-05-27 08:12:00	AAPL	Stock	4.6921	4.6921	4.6921	4.6921	2800.0
2009-05-27 08:16:00	AAPL	Stock	4.6882	4.6904	4.6871	4.6904	19600.0
2009-05-27 08:17:00	AAPL	Stock	4.6875	4.6893	4.6875	4.6882	67256.0
2009-05-27 08:18:00	AAPL	Stock	4.6875	4.6889	4.6875	4.6889	9884.0
2009-05-27 08:19:00	AAPL	Stock	4.6864	4.6864	4.685	4.6857	84028.0
2009-05-27 08:20:00	AAPL	Stock	4.6857	4.6857	4.6857	4.6857	8400.0
2009-05-27 08:21:00	AAPL	Stock	4.6821	4.6846	4.6821	4.6846	32200.0
2009-05-27 08:22:00	AAPL	Stock	4.6857	4.6857	4.6829	4.6829	14000.0
2009-05-27 08:23:00	AAPL	Stock	4.6825	4.6825	4.6811	4.6811	20440.0
2009-05-27 08:24:00	AAPL	Stock	4.6804	4.6821	4.6804	4.6807	8400.0
2009-05-27 08:25:00	AAPL	Stock	4.6804	4.6804	4.6789	4.68	28000.0
2009-05-27 08:26:00	AAPL	Stock	4.6789	4.6821	4.6782	4.6821	140504.0
2009-05-27 08:27:00	AAPL	Stock	4.6789	4.6821	4.6789	4.6821	29400.0
2009-05-27 08:28:00	AAPL	Stock	4.6821	4.6821	4.6821	4.6821	15540.0
2009-05-27 08:29:00	AAPL	Stock	4.6839	4.6871	4.6839	4.6871	22400.0
2009-05-27 08:31:00	AAPL	Stock	4.6875	4.6875	4.6868	4.6868	14000.0
2009-05-27 08:34:00	AAPL	Stock	4.6879	4.6893	4.6879	4.6893	42000.0
2009-05-27 08:35:00	AAPL	Stock	4.6882	4.6882	4.6854	4.6854	21000.0

> showing 50 of 985,425 rows — these rows as CSV

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