PREVIEW / stock_1min / 2011-04-01

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-04-01.parquet
  size:    13.8 MB
  rows:    1,027,733
  symbols: 2,869

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
2011-04-01 05:00:00	AAPL	Stock	12.4786	12.4786	12.4786	12.4786	2800.0
2011-04-01 06:13:00	AAPL	Stock	12.4707	12.4707	12.4707	12.4707	2800.0
2011-04-01 07:00:00	AAPL	Stock	12.4796	12.4821	12.4796	12.4821	11200.0
2011-04-01 07:01:00	AAPL	Stock	12.4821	12.4857	12.4821	12.4857	25060.0
2011-04-01 07:03:00	AAPL	Stock	12.5089	12.5179	12.5089	12.5179	10640.0
2011-04-01 07:05:00	AAPL	Stock	12.5093	12.5093	12.5093	12.5093	9380.0
2011-04-01 07:06:00	AAPL	Stock	12.4857	12.4918	12.4857	12.4918	5600.0
2011-04-01 07:09:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-01 07:15:00	AAPL	Stock	12.5079	12.5079	12.5079	12.5079	2800.0
2011-04-01 07:17:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-01 07:22:00	AAPL	Stock	12.4996	12.4996	12.4996	12.4996	2800.0
2011-04-01 07:23:00	AAPL	Stock	12.5018	12.5021	12.5018	12.5021	5600.0
2011-04-01 07:24:00	AAPL	Stock	12.5036	12.5036	12.5036	12.5036	4900.0
2011-04-01 07:25:00	AAPL	Stock	12.5	12.5	12.5	12.5	30800.0
2011-04-01 07:28:00	AAPL	Stock	12.5	12.5	12.4968	12.4968	11200.0
2011-04-01 07:29:00	AAPL	Stock	12.4968	12.4968	12.4968	12.4968	5600.0
2011-04-01 07:30:00	AAPL	Stock	12.4968	12.4968	12.4968	12.4968	5600.0
2011-04-01 07:31:00	AAPL	Stock	12.4929	12.4971	12.4893	12.4893	50400.0
2011-04-01 07:32:00	AAPL	Stock	12.49	12.4946	12.49	12.4946	5600.0
2011-04-01 07:34:00	AAPL	Stock	12.4996	12.4996	12.4996	12.4996	5600.0
2011-04-01 07:36:00	AAPL	Stock	12.4914	12.4914	12.4839	12.4839	25200.0
2011-04-01 07:37:00	AAPL	Stock	12.4732	12.4732	12.4732	12.4732	11620.0
2011-04-01 07:40:00	AAPL	Stock	12.475	12.475	12.475	12.475	2800.0
2011-04-01 07:42:00	AAPL	Stock	12.4857	12.4857	12.4857	12.4857	2800.0
2011-04-01 07:50:00	AAPL	Stock	12.4911	12.4911	12.4911	12.4911	7028.0
2011-04-01 07:53:00	AAPL	Stock	12.4911	12.4911	12.4911	12.4911	4200.0
2011-04-01 07:58:00	AAPL	Stock	12.4907	12.4907	12.4907	12.4907	3500.0
2011-04-01 08:00:00	AAPL	Stock	12.4893	12.5	12.4446	12.4889	476252.0
2011-04-01 08:01:00	AAPL	Stock	12.4893	12.4893	12.4882	12.4882	16800.0
2011-04-01 08:02:00	AAPL	Stock	12.4886	12.4893	12.4446	12.4446	85540.0
2011-04-01 08:03:00	AAPL	Stock	12.4886	12.4886	12.4886	12.4886	2800.0
2011-04-01 08:04:00	AAPL	Stock	12.4889	12.4896	12.4889	12.4896	5600.0
2011-04-01 08:06:00	AAPL	Stock	12.4875	12.4875	12.4857	12.4857	19600.0
2011-04-01 08:08:00	AAPL	Stock	12.4896	12.4896	12.4896	12.4896	4200.0
2011-04-01 08:09:00	AAPL	Stock	12.4893	12.4946	12.4893	12.4946	78736.0
2011-04-01 08:10:00	AAPL	Stock	12.4946	12.4946	12.4946	12.4946	3360.0
2011-04-01 08:11:00	AAPL	Stock	12.4943	12.4946	12.4943	12.4946	26824.0
2011-04-01 08:12:00	AAPL	Stock	12.4446	12.4446	12.4446	12.4446	128800.0
2011-04-01 08:13:00	AAPL	Stock	12.4929	12.4929	12.4929	12.4929	2800.0
2011-04-01 08:14:00	AAPL	Stock	12.4957	12.4964	12.4957	12.4964	14000.0
2011-04-01 08:15:00	AAPL	Stock	12.4957	12.4957	12.4861	12.4932	8400.0
2011-04-01 08:16:00	AAPL	Stock	12.4957	12.4957	12.4957	12.4957	7000.0
2011-04-01 08:17:00	AAPL	Stock	12.4954	12.4964	12.4954	12.4964	35588.0
2011-04-01 08:18:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	11900.0
2011-04-01 08:21:00	AAPL	Stock	12.4961	12.4961	12.4946	12.4946	19600.0
2011-04-01 08:22:00	AAPL	Stock	12.4929	12.4929	12.4857	12.4857	19600.0
2011-04-01 08:23:00	AAPL	Stock	12.4857	12.4857	12.4839	12.4857	14000.0
2011-04-01 08:25:00	AAPL	Stock	12.4857	12.4857	12.4857	12.4857	7000.0
2011-04-01 08:27:00	AAPL	Stock	12.4821	12.4821	12.4807	12.4807	11200.0
2011-04-01 08:28:00	AAPL	Stock	12.4786	12.4857	12.4768	12.4857	28280.0

> showing 50 of 1,027,733 rows — these rows as CSV

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