PREVIEW / stock_1min / 2006-07-11
file: by_date/stock_1min/2006/2006-07-11.parquet size: 8.5 MB rows: 695,532 symbols: 1,890
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-11 06:37:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9643 | 1.9643 | 8400.0 |
| 2006-07-11 06:57:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9714 | 1.9714 | 5600.0 |
| 2006-07-11 07:06:00 | AAPL | Stock | 1.9732 | 1.9732 | 1.9732 | 1.9732 | 5600.0 |
| 2006-07-11 07:16:00 | AAPL | Stock | 1.9679 | 1.9679 | 1.9643 | 1.9643 | 22400.0 |
| 2006-07-11 07:36:00 | AAPL | Stock | 1.9693 | 1.9693 | 1.9693 | 1.9693 | 8400.0 |
| 2006-07-11 07:47:00 | AAPL | Stock | 1.9718 | 1.9718 | 1.9718 | 1.9718 | 14000.0 |
| 2006-07-11 08:00:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9614 | 1.9614 | 180040.0 |
| 2006-07-11 08:01:00 | AAPL | Stock | 1.9618 | 1.9707 | 1.9618 | 1.9643 | 204372.0 |
| 2006-07-11 08:02:00 | AAPL | Stock | 1.9679 | 1.9679 | 1.9643 | 1.9643 | 103600.0 |
| 2006-07-11 08:03:00 | AAPL | Stock | 1.9679 | 1.9714 | 1.9679 | 1.9714 | 13160.0 |
| 2006-07-11 08:04:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 5600.0 |
| 2006-07-11 08:05:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 2800.0 |
| 2006-07-11 08:06:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 36232.0 |
| 2006-07-11 08:07:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 2800.0 |
| 2006-07-11 08:08:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 14000.0 |
| 2006-07-11 08:09:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 14000.0 |
| 2006-07-11 08:10:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 28000.0 |
| 2006-07-11 08:11:00 | AAPL | Stock | 1.9704 | 1.9704 | 1.9704 | 1.9704 | 39200.0 |
| 2006-07-11 08:12:00 | AAPL | Stock | 1.9704 | 1.9704 | 1.9704 | 1.9704 | 32648.0 |
| 2006-07-11 08:13:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9689 | 1.9689 | 11200.0 |
| 2006-07-11 08:14:00 | AAPL | Stock | 1.9693 | 1.9704 | 1.9693 | 1.9696 | 31220.0 |
| 2006-07-11 08:15:00 | AAPL | Stock | 1.9696 | 1.9696 | 1.9696 | 1.9696 | 5180.0 |
| 2006-07-11 08:16:00 | AAPL | Stock | 1.9704 | 1.9714 | 1.9704 | 1.9714 | 125552.0 |
| 2006-07-11 08:17:00 | AAPL | Stock | 1.9714 | 1.9732 | 1.9696 | 1.9732 | 152516.0 |
| 2006-07-11 08:18:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9714 | 1.9714 | 28000.0 |
| 2006-07-11 08:19:00 | AAPL | Stock | 1.9714 | 1.975 | 1.9714 | 1.975 | 154560.0 |
| 2006-07-11 08:20:00 | AAPL | Stock | 1.9739 | 1.9739 | 1.9714 | 1.9714 | 67200.0 |
| 2006-07-11 08:21:00 | AAPL | Stock | 1.9714 | 1.9732 | 1.9714 | 1.9732 | 30800.0 |
| 2006-07-11 08:22:00 | AAPL | Stock | 1.9739 | 1.975 | 1.9739 | 1.975 | 26040.0 |
| 2006-07-11 08:23:00 | AAPL | Stock | 1.9739 | 1.9739 | 1.9714 | 1.9721 | 187600.0 |
| 2006-07-11 08:26:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9714 | 1.9714 | 97580.0 |
| 2006-07-11 08:29:00 | AAPL | Stock | 1.9682 | 1.9682 | 1.9682 | 1.9682 | 33600.0 |
| 2006-07-11 08:31:00 | AAPL | Stock | 1.9693 | 1.9693 | 1.9693 | 1.9693 | 4200.0 |
| 2006-07-11 08:33:00 | AAPL | Stock | 1.9686 | 1.9686 | 1.9682 | 1.9682 | 91000.0 |
| 2006-07-11 08:34:00 | AAPL | Stock | 1.9679 | 1.9679 | 1.9679 | 1.9679 | 138600.0 |
| 2006-07-11 08:35:00 | AAPL | Stock | 1.9675 | 1.9679 | 1.9657 | 1.9657 | 16800.0 |
| 2006-07-11 08:38:00 | AAPL | Stock | 1.9664 | 1.9664 | 1.9664 | 1.9664 | 2800.0 |
| 2006-07-11 08:39:00 | AAPL | Stock | 1.9675 | 1.9675 | 1.9675 | 1.9675 | 4200.0 |
| 2006-07-11 08:41:00 | AAPL | Stock | 1.965 | 1.965 | 1.965 | 1.965 | 5600.0 |
| 2006-07-11 08:44:00 | AAPL | Stock | 1.9664 | 1.9675 | 1.9664 | 1.9675 | 25200.0 |
| 2006-07-11 08:48:00 | AAPL | Stock | 1.9675 | 1.9686 | 1.9675 | 1.9686 | 149688.0 |
| 2006-07-11 08:49:00 | AAPL | Stock | 1.97 | 1.97 | 1.97 | 1.97 | 2800.0 |
| 2006-07-11 08:50:00 | AAPL | Stock | 1.9714 | 1.9714 | 1.9714 | 1.9714 | 24500.0 |
| 2006-07-11 08:52:00 | AAPL | Stock | 1.9704 | 1.9704 | 1.9704 | 1.9704 | 2800.0 |
| 2006-07-11 08:53:00 | AAPL | Stock | 1.9704 | 1.9704 | 1.9704 | 1.9704 | 5600.0 |
| 2006-07-11 08:54:00 | AAPL | Stock | 1.97 | 1.97 | 1.9696 | 1.97 | 33600.0 |
| 2006-07-11 08:55:00 | AAPL | Stock | 1.9707 | 1.9707 | 1.9707 | 1.9707 | 2800.0 |
| 2006-07-11 08:56:00 | AAPL | Stock | 1.9707 | 1.9707 | 1.9707 | 1.9707 | 8400.0 |
| 2006-07-11 08:57:00 | AAPL | Stock | 1.9707 | 1.9707 | 1.9707 | 1.9707 | 8400.0 |
| 2006-07-11 08:58:00 | AAPL | Stock | 1.9707 | 1.9707 | 1.9707 | 1.9707 | 2800.0 |
> showing 50 of 695,532 rows — these rows as CSV