PREVIEW / stock_1min / 2011-06-20

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-06-20.parquet
  size:    13.2 MB
  rows:    1,001,647
  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-06-20 04:00:00	AAPL	Stock	11.5	11.5	11.5	11.5	2800.0
2011-06-20 04:25:00	AAPL	Stock	11.35	11.35	11.35	11.35	5600.0
2011-06-20 04:32:00	AAPL	Stock	11.3954	11.3954	11.3954	11.3954	2800.0
2011-06-20 04:37:00	AAPL	Stock	11.3529	11.3529	11.3529	11.3529	2996.0
2011-06-20 05:07:00	AAPL	Stock	11.4	11.4	11.4	11.4	2800.0
2011-06-20 06:15:00	AAPL	Stock	11.3875	11.3875	11.3875	11.3875	2800.0
2011-06-20 06:52:00	AAPL	Stock	11.4104	11.4104	11.4104	11.4104	5600.0
2011-06-20 07:00:00	AAPL	Stock	11.3932	11.3932	11.3932	11.3932	2800.0
2011-06-20 07:01:00	AAPL	Stock	11.3929	11.3929	11.3929	11.3929	2800.0
2011-06-20 07:02:00	AAPL	Stock	11.3771	11.3771	11.3757	11.3757	12600.0
2011-06-20 07:03:00	AAPL	Stock	11.3757	11.3757	11.3757	11.3757	2800.0
2011-06-20 07:04:00	AAPL	Stock	11.3768	11.3768	11.3757	11.3768	31920.0
2011-06-20 07:05:00	AAPL	Stock	11.38	11.38	11.3757	11.3757	8400.0
2011-06-20 07:06:00	AAPL	Stock	11.3757	11.3846	11.3757	11.3846	16800.0
2011-06-20 07:08:00	AAPL	Stock	11.3814	11.3814	11.3814	11.3814	2800.0
2011-06-20 07:09:00	AAPL	Stock	11.3814	11.3814	11.3814	11.3814	6020.0
2011-06-20 07:11:00	AAPL	Stock	11.3918	11.3918	11.3782	11.3914	11200.0
2011-06-20 07:12:00	AAPL	Stock	11.3886	11.3886	11.3771	11.3771	33600.0
2011-06-20 07:13:00	AAPL	Stock	11.3807	11.3807	11.3782	11.3782	14000.0
2011-06-20 07:14:00	AAPL	Stock	11.3786	11.3786	11.3786	11.3786	2800.0
2011-06-20 07:18:00	AAPL	Stock	11.3771	11.3771	11.3771	11.3771	2800.0
2011-06-20 07:21:00	AAPL	Stock	11.3771	11.3771	11.3764	11.3764	5600.0
2011-06-20 07:27:00	AAPL	Stock	11.3771	11.3771	11.3771	11.3771	8400.0
2011-06-20 07:29:00	AAPL	Stock	11.385	11.385	11.385	11.385	2800.0
2011-06-20 07:31:00	AAPL	Stock	11.3779	11.3779	11.3775	11.3775	28000.0
2011-06-20 07:34:00	AAPL	Stock	11.3771	11.3775	11.3757	11.3775	38696.0
2011-06-20 07:35:00	AAPL	Stock	11.3761	11.3761	11.3761	11.3761	2800.0
2011-06-20 07:36:00	AAPL	Stock	11.3757	11.3775	11.3757	11.3775	8400.0
2011-06-20 07:37:00	AAPL	Stock	11.3775	11.3775	11.3775	11.3775	4200.0
2011-06-20 07:41:00	AAPL	Stock	11.3757	11.3757	11.3757	11.3757	11200.0
2011-06-20 07:42:00	AAPL	Stock	11.3757	11.3768	11.3757	11.3768	47600.0
2011-06-20 07:43:00	AAPL	Stock	11.3757	11.3757	11.3757	11.3757	8400.0
2011-06-20 07:44:00	AAPL	Stock	11.3757	11.3757	11.3657	11.3657	79436.0
2011-06-20 07:45:00	AAPL	Stock	11.365	11.3661	11.3571	11.3571	72800.0
2011-06-20 07:46:00	AAPL	Stock	11.3532	11.3571	11.3429	11.3429	58660.0
2011-06-20 07:47:00	AAPL	Stock	11.3532	11.3532	11.3532	11.3532	2800.0
2011-06-20 07:48:00	AAPL	Stock	11.3536	11.3536	11.3536	11.3536	2996.0
2011-06-20 07:49:00	AAPL	Stock	11.3564	11.3564	11.3561	11.3564	8400.0
2011-06-20 07:50:00	AAPL	Stock	11.3536	11.3536	11.3475	11.3518	33460.0
2011-06-20 07:52:00	AAPL	Stock	11.3482	11.3482	11.3482	11.3482	8596.0
2011-06-20 07:53:00	AAPL	Stock	11.3482	11.3482	11.3446	11.3446	25200.0
2011-06-20 07:54:00	AAPL	Stock	11.34	11.34	11.34	11.34	3080.0
2011-06-20 07:55:00	AAPL	Stock	11.34	11.34	11.3393	11.3393	36400.0
2011-06-20 07:57:00	AAPL	Stock	11.35	11.3511	11.35	11.3511	17276.0
2011-06-20 07:58:00	AAPL	Stock	11.3429	11.3464	11.3429	11.3464	30800.0
2011-06-20 07:59:00	AAPL	Stock	11.3464	11.3464	11.3464	11.3464	17612.0
2011-06-20 08:00:00	AAPL	Stock	11.3511	11.3571	11.3464	11.3571	201460.0
2011-06-20 08:01:00	AAPL	Stock	11.3536	11.3536	11.3536	11.3536	14000.0
2011-06-20 08:02:00	AAPL	Stock	11.3464	11.35	11.3464	11.35	20720.0
2011-06-20 08:03:00	AAPL	Stock	11.34	11.3518	11.3396	11.3518	23800.0

> showing 50 of 1,001,647 rows — these rows as CSV

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