PREVIEW / stock_1min / 2009-04-20

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-20.parquet
  size:    12.6 MB
  rows:    964,403
  symbols: 2,693

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-20 04:45:00	AAPL	Stock	4.3882	4.3882	4.3882	4.3882	2800.0
2009-04-20 05:42:00	AAPL	Stock	4.3214	4.3214	4.3214	4.3214	2800.0
2009-04-20 06:26:00	AAPL	Stock	4.3564	4.3564	4.3564	4.3564	8400.0
2009-04-20 06:58:00	AAPL	Stock	4.3464	4.3464	4.3464	4.3464	2800.0
2009-04-20 07:01:00	AAPL	Stock	4.3464	4.35	4.3464	4.35	14000.0
2009-04-20 07:02:00	AAPL	Stock	4.3357	4.3357	4.3357	4.3357	4200.0
2009-04-20 07:08:00	AAPL	Stock	4.365	4.365	4.365	4.365	9800.0
2009-04-20 07:11:00	AAPL	Stock	4.3643	4.3643	4.3643	4.3643	13860.0
2009-04-20 07:17:00	AAPL	Stock	4.3571	4.3571	4.3571	4.3571	5600.0
2009-04-20 07:18:00	AAPL	Stock	4.3571	4.3571	4.3571	4.3571	2800.0
2009-04-20 07:24:00	AAPL	Stock	4.3643	4.3643	4.3643	4.3643	11200.0
2009-04-20 07:39:00	AAPL	Stock	4.3704	4.3714	4.3704	4.3714	30800.0
2009-04-20 07:50:00	AAPL	Stock	4.3761	4.3761	4.3761	4.3761	5600.0
2009-04-20 07:53:00	AAPL	Stock	4.3775	4.3775	4.3775	4.3775	5600.0
2009-04-20 07:54:00	AAPL	Stock	4.3796	4.3796	4.3775	4.3775	11200.0
2009-04-20 07:56:00	AAPL	Stock	4.3775	4.3775	4.3686	4.3729	70000.0
2009-04-20 07:58:00	AAPL	Stock	4.3754	4.3754	4.3725	4.375	25200.0
2009-04-20 07:59:00	AAPL	Stock	4.3775	4.3821	4.3775	4.3821	11200.0
2009-04-20 08:00:00	AAPL	Stock	4.3832	4.3839	4.3768	4.3839	51240.0
2009-04-20 08:01:00	AAPL	Stock	4.375	4.375	4.375	4.375	13160.0
2009-04-20 08:02:00	AAPL	Stock	4.375	4.375	4.3714	4.375	76524.0
2009-04-20 08:05:00	AAPL	Stock	4.3846	4.3846	4.3843	4.3843	15680.0
2009-04-20 08:06:00	AAPL	Stock	4.3786	4.3786	4.3786	4.3786	2800.0
2009-04-20 08:07:00	AAPL	Stock	4.3775	4.3786	4.3775	4.3786	5600.0
2009-04-20 08:08:00	AAPL	Stock	4.3782	4.3782	4.3782	4.3782	11200.0
2009-04-20 08:09:00	AAPL	Stock	4.3786	4.3786	4.3768	4.3768	17500.0
2009-04-20 08:11:00	AAPL	Stock	4.3782	4.3786	4.3782	4.3786	25900.0
2009-04-20 08:12:00	AAPL	Stock	4.3857	4.3857	4.3804	4.3804	26152.0
2009-04-20 08:13:00	AAPL	Stock	4.3861	4.3861	4.3861	4.3861	2800.0
2009-04-20 08:14:00	AAPL	Stock	4.3861	4.3893	4.3861	4.3893	27048.0
2009-04-20 08:15:00	AAPL	Stock	4.3893	4.3893	4.3893	4.3893	2800.0
2009-04-20 08:16:00	AAPL	Stock	4.3925	4.3946	4.3925	4.3946	5600.0
2009-04-20 08:17:00	AAPL	Stock	4.3946	4.3946	4.3893	4.3929	32732.0
2009-04-20 08:18:00	AAPL	Stock	4.3925	4.3925	4.3857	4.3868	23968.0
2009-04-20 08:19:00	AAPL	Stock	4.3857	4.3868	4.3825	4.3825	19880.0
2009-04-20 08:20:00	AAPL	Stock	4.3829	4.3829	4.3821	4.3821	22456.0
2009-04-20 08:21:00	AAPL	Stock	4.3775	4.3775	4.3771	4.3771	14000.0
2009-04-20 08:23:00	AAPL	Stock	4.3786	4.3786	4.3786	4.3786	5600.0
2009-04-20 08:24:00	AAPL	Stock	4.3768	4.3768	4.3768	4.3768	11200.0
2009-04-20 08:25:00	AAPL	Stock	4.3768	4.3771	4.3754	4.3768	101080.0
2009-04-20 08:26:00	AAPL	Stock	4.3768	4.3768	4.3754	4.3754	32116.0
2009-04-20 08:27:00	AAPL	Stock	4.3754	4.3825	4.3689	4.3689	223216.0
2009-04-20 08:28:00	AAPL	Stock	4.3679	4.3679	4.3571	4.3586	112560.0
2009-04-20 08:29:00	AAPL	Stock	4.3657	4.3679	4.3607	4.3607	44800.0
2009-04-20 08:30:00	AAPL	Stock	4.3607	4.3607	4.3607	4.3607	8428.0
2009-04-20 08:31:00	AAPL	Stock	4.3643	4.3643	4.3643	4.3643	2800.0
2009-04-20 08:32:00	AAPL	Stock	4.3607	4.3607	4.3607	4.3607	63084.0
2009-04-20 08:33:00	AAPL	Stock	4.3607	4.3607	4.3607	4.3607	2800.0
2009-04-20 08:35:00	AAPL	Stock	4.3614	4.3661	4.3604	4.3661	37940.0
2009-04-20 08:36:00	AAPL	Stock	4.3671	4.3671	4.3671	4.3671	2800.0

> showing 50 of 964,403 rows — these rows as CSV

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