PREVIEW / stock_1min / 2011-07-27

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-07-27.parquet
  size:    13.9 MB
  rows:    1,027,420
  symbols: 2,862

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-07-27 05:48:00	AAPL	Stock	14.4214	14.4214	14.4214	14.4214	2800.0
2011-07-27 06:49:00	AAPL	Stock	14.4018	14.4018	14.4018	14.4018	14000.0
2011-07-27 07:01:00	AAPL	Stock	14.4011	14.4111	14.4011	14.4111	8400.0
2011-07-27 07:04:00	AAPL	Stock	14.4107	14.4107	14.4107	14.4107	12600.0
2011-07-27 07:08:00	AAPL	Stock	14.4068	14.4068	14.4068	14.4068	8400.0
2011-07-27 07:09:00	AAPL	Stock	14.4082	14.4082	14.4082	14.4082	2800.0
2011-07-27 07:10:00	AAPL	Stock	14.4107	14.4107	14.4086	14.4086	40600.0
2011-07-27 07:15:00	AAPL	Stock	14.4107	14.4107	14.4107	14.4107	2800.0
2011-07-27 07:17:00	AAPL	Stock	14.4107	14.4107	14.4107	14.4107	2800.0
2011-07-27 07:20:00	AAPL	Stock	14.4107	14.4229	14.4104	14.4107	39200.0
2011-07-27 07:22:00	AAPL	Stock	14.4107	14.4107	14.4107	14.4107	11200.0
2011-07-27 07:25:00	AAPL	Stock	14.4075	14.4075	14.4075	14.4075	2800.0
2011-07-27 07:26:00	AAPL	Stock	14.4018	14.4018	14.4018	14.4018	8400.0
2011-07-27 07:27:00	AAPL	Stock	14.3964	14.3964	14.3929	14.3929	33600.0
2011-07-27 07:31:00	AAPL	Stock	14.3921	14.3921	14.3921	14.3921	2800.0
2011-07-27 07:33:00	AAPL	Stock	14.3929	14.3929	14.3929	14.3929	2800.0
2011-07-27 07:39:00	AAPL	Stock	14.3986	14.3986	14.3986	14.3986	7000.0
2011-07-27 07:41:00	AAPL	Stock	14.3932	14.3932	14.3929	14.3929	16800.0
2011-07-27 07:46:00	AAPL	Stock	14.3911	14.3911	14.3911	14.3911	8400.0
2011-07-27 07:52:00	AAPL	Stock	14.3911	14.3911	14.3875	14.3875	48524.0
2011-07-27 07:56:00	AAPL	Stock	14.3875	14.3875	14.3875	14.3875	2800.0
2011-07-27 07:58:00	AAPL	Stock	14.3786	14.3786	14.375	14.375	19600.0
2011-07-27 07:59:00	AAPL	Stock	14.3714	14.3714	14.3714	14.3714	5600.0
2011-07-27 08:00:00	AAPL	Stock	14.3714	14.375	14.3643	14.3661	162120.0
2011-07-27 08:01:00	AAPL	Stock	14.3729	14.3743	14.3679	14.3679	16800.0
2011-07-27 08:02:00	AAPL	Stock	14.375	14.375	14.365	14.365	89600.0
2011-07-27 08:03:00	AAPL	Stock	14.3729	14.3746	14.3729	14.3746	11200.0
2011-07-27 08:04:00	AAPL	Stock	14.3654	14.3743	14.3643	14.3743	25900.0
2011-07-27 08:05:00	AAPL	Stock	14.3636	14.3636	14.3629	14.3629	14000.0
2011-07-27 08:06:00	AAPL	Stock	14.3679	14.3679	14.3579	14.3625	51800.0
2011-07-27 08:07:00	AAPL	Stock	14.3593	14.3611	14.3579	14.36	43624.0
2011-07-27 08:08:00	AAPL	Stock	14.365	14.3657	14.3643	14.3643	24080.0
2011-07-27 08:09:00	AAPL	Stock	14.3611	14.3614	14.3607	14.3614	19040.0
2011-07-27 08:10:00	AAPL	Stock	14.3611	14.3611	14.3579	14.3611	44800.0
2011-07-27 08:11:00	AAPL	Stock	14.3607	14.3611	14.3607	14.3611	33600.0
2011-07-27 08:12:00	AAPL	Stock	14.3636	14.3661	14.3636	14.3661	16800.0
2011-07-27 08:13:00	AAPL	Stock	14.3661	14.3661	14.3661	14.3661	39200.0
2011-07-27 08:14:00	AAPL	Stock	14.3643	14.3643	14.36	14.36	21420.0
2011-07-27 08:15:00	AAPL	Stock	14.3643	14.3657	14.3639	14.3657	41972.0
2011-07-27 08:16:00	AAPL	Stock	14.3604	14.3618	14.3393	14.3393	450184.0
2011-07-27 08:17:00	AAPL	Stock	14.3411	14.3411	14.3214	14.3214	11620.0
2011-07-27 08:18:00	AAPL	Stock	14.3429	14.3429	14.3304	14.3357	20160.0
2011-07-27 08:19:00	AAPL	Stock	14.3357	14.3386	14.3357	14.3386	13720.0
2011-07-27 08:20:00	AAPL	Stock	14.3389	14.3393	14.3318	14.3389	60200.0
2011-07-27 08:21:00	AAPL	Stock	14.3318	14.3318	14.3318	14.3318	28420.0
2011-07-27 08:22:00	AAPL	Stock	14.3325	14.3393	14.3325	14.3393	39452.0
2011-07-27 08:24:00	AAPL	Stock	14.3393	14.3464	14.3364	14.3464	11200.0
2011-07-27 08:25:00	AAPL	Stock	14.3464	14.3507	14.3464	14.3504	23800.0
2011-07-27 08:26:00	AAPL	Stock	14.3418	14.3418	14.3418	14.3418	2800.0
2011-07-27 08:27:00	AAPL	Stock	14.3421	14.3421	14.3411	14.3414	54320.0

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

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