PREVIEW / stock_1min / 2009-04-27

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-27.parquet
  size:    12.6 MB
  rows:    968,238
  symbols: 2,702

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-04-27 04:15:00	AAPL	Stock	4.4107	4.4107	4.3961	4.3961	7280.0
2009-04-27 04:25:00	AAPL	Stock	4.3961	4.3961	4.3961	4.3961	2800.0
2009-04-27 06:29:00	AAPL	Stock	4.3921	4.3921	4.3921	4.3921	28000.0
2009-04-27 06:59:00	AAPL	Stock	4.365	4.365	4.365	4.365	2800.0
2009-04-27 07:08:00	AAPL	Stock	4.37	4.3718	4.37	4.3718	16800.0
2009-04-27 07:52:00	AAPL	Stock	4.3857	4.3857	4.3857	4.3857	3332.0
2009-04-27 08:00:00	AAPL	Stock	4.3779	4.4214	4.3779	4.3857	141428.0
2009-04-27 08:01:00	AAPL	Stock	4.3893	4.3911	4.3893	4.3911	32200.0
2009-04-27 08:02:00	AAPL	Stock	4.3893	4.3929	4.3893	4.3893	28000.0
2009-04-27 08:04:00	AAPL	Stock	4.3804	4.3804	4.3804	4.3804	14000.0
2009-04-27 08:05:00	AAPL	Stock	4.3893	4.3893	4.3893	4.3893	3920.0
2009-04-27 08:07:00	AAPL	Stock	4.3789	4.3789	4.3786	4.3786	20860.0
2009-04-27 08:09:00	AAPL	Stock	4.3814	4.3839	4.3814	4.3814	14980.0
2009-04-27 08:14:00	AAPL	Stock	4.3786	4.3786	4.3775	4.3775	7840.0
2009-04-27 08:15:00	AAPL	Stock	4.375	4.375	4.375	4.375	2800.0
2009-04-27 08:16:00	AAPL	Stock	4.3775	4.3775	4.3775	4.3775	4312.0
2009-04-27 08:21:00	AAPL	Stock	4.3836	4.3857	4.3836	4.3857	9800.0
2009-04-27 08:25:00	AAPL	Stock	4.3857	4.3861	4.3857	4.3861	15960.0
2009-04-27 08:28:00	AAPL	Stock	4.3868	4.3868	4.3861	4.3861	5600.0
2009-04-27 08:31:00	AAPL	Stock	4.39	4.39	4.3893	4.3893	14000.0
2009-04-27 08:32:00	AAPL	Stock	4.3861	4.3861	4.3861	4.3861	14252.0
2009-04-27 08:33:00	AAPL	Stock	4.3875	4.3875	4.3857	4.3857	15932.0
2009-04-27 08:34:00	AAPL	Stock	4.3836	4.3854	4.3836	4.3854	10416.0
2009-04-27 08:35:00	AAPL	Stock	4.3836	4.3857	4.3836	4.3857	10052.0
2009-04-27 08:36:00	AAPL	Stock	4.3875	4.3875	4.3875	4.3875	2800.0
2009-04-27 08:38:00	AAPL	Stock	4.3875	4.3875	4.3875	4.3875	18844.0
2009-04-27 08:39:00	AAPL	Stock	4.3904	4.3911	4.3904	4.3911	12012.0
2009-04-27 08:40:00	AAPL	Stock	4.3925	4.3925	4.3886	4.3886	5600.0
2009-04-27 08:41:00	AAPL	Stock	4.3929	4.3929	4.3925	4.3925	5600.0
2009-04-27 08:42:00	AAPL	Stock	4.3936	4.3996	4.3936	4.3996	14000.0
2009-04-27 08:44:00	AAPL	Stock	4.3989	4.3989	4.3989	4.3989	11284.0
2009-04-27 08:46:00	AAPL	Stock	4.3989	4.3989	4.3989	4.3989	5376.0
2009-04-27 08:47:00	AAPL	Stock	4.3932	4.3932	4.3932	4.3932	2800.0
2009-04-27 08:49:00	AAPL	Stock	4.3932	4.3932	4.3932	4.3932	2800.0
2009-04-27 08:50:00	AAPL	Stock	4.3932	4.3932	4.3929	4.3929	8288.0
2009-04-27 08:51:00	AAPL	Stock	4.3943	4.3943	4.3914	4.3914	36904.0
2009-04-27 08:52:00	AAPL	Stock	4.3914	4.3914	4.3914	4.3914	8400.0
2009-04-27 08:53:00	AAPL	Stock	4.3964	4.3964	4.3957	4.3957	5600.0
2009-04-27 08:54:00	AAPL	Stock	4.3875	4.3875	4.3875	4.3875	9800.0
2009-04-27 08:57:00	AAPL	Stock	4.3886	4.3929	4.3886	4.3886	22400.0
2009-04-27 08:58:00	AAPL	Stock	4.3925	4.3925	4.3925	4.3925	4816.0
2009-04-27 08:59:00	AAPL	Stock	4.3943	4.3943	4.3939	4.3943	14000.0
2009-04-27 09:00:00	AAPL	Stock	4.3929	4.3929	4.3929	4.3929	16800.0
2009-04-27 09:03:00	AAPL	Stock	4.3932	4.3989	4.3932	4.3989	25200.0
2009-04-27 09:04:00	AAPL	Stock	4.3964	4.3964	4.3964	4.3964	2800.0
2009-04-27 09:08:00	AAPL	Stock	4.3943	4.3943	4.3943	4.3943	2800.0
2009-04-27 09:11:00	AAPL	Stock	4.3946	4.3946	4.3929	4.3943	18200.0
2009-04-27 09:13:00	AAPL	Stock	4.3946	4.3946	4.3946	4.3946	2800.0
2009-04-27 09:14:00	AAPL	Stock	4.3929	4.3929	4.3929	4.3929	14000.0
2009-04-27 09:15:00	AAPL	Stock	4.3929	4.3929	4.3929	4.3929	2800.0

> showing 50 of 968,238 rows — these rows as CSV

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