PREVIEW / stock_1min / 2012-07-23

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-23.parquet
  size:    12.3 MB
  rows:    913,399
  symbols: 2,817

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-07-23 04:00:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2012-07-23 04:04:00	AAPL	Stock	21.4282	21.4282	21.4282	21.4282	2800.0
2012-07-23 04:09:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	11200.0
2012-07-23 04:10:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	2800.0
2012-07-23 04:17:00	AAPL	Stock	21.3968	21.3968	21.3968	21.3968	8400.0
2012-07-23 04:21:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	2800.0
2012-07-23 04:22:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	5600.0
2012-07-23 04:29:00	AAPL	Stock	21.395	21.3964	21.395	21.3964	8960.0
2012-07-23 04:31:00	AAPL	Stock	21.3964	21.3964	21.3964	21.3964	5600.0
2012-07-23 04:32:00	AAPL	Stock	21.3946	21.3946	21.3946	21.3946	2800.0
2012-07-23 04:40:00	AAPL	Stock	21.3932	21.3932	21.3932	21.3932	2800.0
2012-07-23 04:47:00	AAPL	Stock	21.3607	21.3607	21.3607	21.3607	5600.0
2012-07-23 04:51:00	AAPL	Stock	21.3607	21.3607	21.3607	21.3607	7000.0
2012-07-23 04:52:00	AAPL	Stock	21.3607	21.3607	21.3607	21.3607	2800.0
2012-07-23 04:54:00	AAPL	Stock	21.3607	21.3607	21.3607	21.3607	8400.0
2012-07-23 04:57:00	AAPL	Stock	21.3429	21.3429	21.3429	21.3429	5600.0
2012-07-23 04:58:00	AAPL	Stock	21.3429	21.3429	21.3429	21.3429	7308.0
2012-07-23 05:30:00	AAPL	Stock	21.3661	21.3818	21.3661	21.3818	5600.0
2012-07-23 05:32:00	AAPL	Stock	21.3754	21.3754	21.3754	21.3754	2800.0
2012-07-23 05:48:00	AAPL	Stock	21.3625	21.3625	21.3625	21.3625	2800.0
2012-07-23 06:17:00	AAPL	Stock	21.375	21.375	21.375	21.375	5600.0
2012-07-23 06:18:00	AAPL	Stock	21.3804	21.3821	21.3804	21.3821	5600.0
2012-07-23 06:24:00	AAPL	Stock	21.375	21.375	21.375	21.375	5600.0
2012-07-23 06:30:00	AAPL	Stock	21.375	21.375	21.375	21.375	2800.0
2012-07-23 06:46:00	AAPL	Stock	21.3893	21.3893	21.3893	21.3893	2800.0
2012-07-23 06:48:00	AAPL	Stock	21.3893	21.3929	21.3893	21.3929	24836.0
2012-07-23 06:59:00	AAPL	Stock	21.3929	21.3929	21.3929	21.3929	8512.0
2012-07-23 07:00:00	AAPL	Stock	21.3929	21.4286	21.3807	21.4286	28000.0
2012-07-23 07:01:00	AAPL	Stock	21.4286	21.4286	21.3857	21.4282	14000.0
2012-07-23 07:02:00	AAPL	Stock	21.3957	21.3957	21.395	21.395	11200.0
2012-07-23 07:03:00	AAPL	Stock	21.4	21.4107	21.4	21.4107	30800.0
2012-07-23 07:04:00	AAPL	Stock	21.4196	21.4196	21.4196	21.4196	8400.0
2012-07-23 07:05:00	AAPL	Stock	21.4193	21.4196	21.4107	21.4196	11984.0
2012-07-23 07:06:00	AAPL	Stock	21.4196	21.4196	21.4107	21.4107	7476.0
2012-07-23 07:09:00	AAPL	Stock	21.4039	21.4039	21.4039	21.4039	2800.0
2012-07-23 07:10:00	AAPL	Stock	21.4043	21.4107	21.3975	21.4107	23156.0
2012-07-23 07:11:00	AAPL	Stock	21.4168	21.4168	21.3929	21.3964	22400.0
2012-07-23 07:15:00	AAPL	Stock	21.3929	21.3929	21.3929	21.3929	2800.0
2012-07-23 07:16:00	AAPL	Stock	21.3807	21.3807	21.3786	21.3786	5600.0
2012-07-23 07:19:00	AAPL	Stock	21.3768	21.3768	21.3711	21.3711	5600.0
2012-07-23 07:20:00	AAPL	Stock	21.375	21.375	21.375	21.375	17052.0
2012-07-23 07:22:00	AAPL	Stock	21.3732	21.3732	21.3732	21.3732	2800.0
2012-07-23 07:25:00	AAPL	Stock	21.3714	21.3714	21.3625	21.3625	11200.0
2012-07-23 07:26:00	AAPL	Stock	21.3579	21.3579	21.345	21.345	22400.0
2012-07-23 07:27:00	AAPL	Stock	21.3536	21.3536	21.3214	21.3214	14560.0
2012-07-23 07:29:00	AAPL	Stock	21.3529	21.3546	21.3529	21.3546	13300.0
2012-07-23 07:30:00	AAPL	Stock	21.3311	21.3311	21.3214	21.3214	39200.0
2012-07-23 07:32:00	AAPL	Stock	21.3254	21.3254	21.325	21.325	5600.0
2012-07-23 07:33:00	AAPL	Stock	21.3146	21.3146	21.3111	21.3111	5600.0
2012-07-23 07:34:00	AAPL	Stock	21.35	21.3521	21.35	21.3521	12180.0

> showing 50 of 913,399 rows — these rows as CSV

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