PREVIEW / stock_1min / 2009-12-11
file: by_date/stock_1min/2009/2009-12-11.parquet size: 12.0 MB rows: 907,733 symbols: 2,801
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-12-11 06:31:00 | AAPL | Stock | 7.0614 | 7.0614 | 7.0614 | 7.0614 | 2800.0 |
| 2009-12-11 06:42:00 | AAPL | Stock | 7.0571 | 7.0571 | 7.0571 | 7.0571 | 2800.0 |
| 2009-12-11 07:09:00 | AAPL | Stock | 7.0536 | 7.0536 | 7.0536 | 7.0536 | 2800.0 |
| 2009-12-11 07:37:00 | AAPL | Stock | 7.06 | 7.06 | 7.06 | 7.06 | 5600.0 |
| 2009-12-11 07:38:00 | AAPL | Stock | 7.0604 | 7.0607 | 7.0604 | 7.0607 | 12712.0 |
| 2009-12-11 07:40:00 | AAPL | Stock | 7.0604 | 7.0604 | 7.0604 | 7.0604 | 3360.0 |
| 2009-12-11 07:43:00 | AAPL | Stock | 7.0657 | 7.0657 | 7.0657 | 7.0657 | 5600.0 |
| 2009-12-11 07:44:00 | AAPL | Stock | 7.0661 | 7.0661 | 7.0661 | 7.0661 | 18200.0 |
| 2009-12-11 07:45:00 | AAPL | Stock | 7.0675 | 7.0675 | 7.0675 | 7.0675 | 11200.0 |
| 2009-12-11 07:46:00 | AAPL | Stock | 7.0696 | 7.0714 | 7.0696 | 7.0714 | 113988.0 |
| 2009-12-11 07:47:00 | AAPL | Stock | 7.0771 | 7.0786 | 7.0771 | 7.0786 | 16800.0 |
| 2009-12-11 07:48:00 | AAPL | Stock | 7.0782 | 7.0782 | 7.0782 | 7.0782 | 5600.0 |
| 2009-12-11 07:49:00 | AAPL | Stock | 7.0771 | 7.0786 | 7.0771 | 7.0786 | 11200.0 |
| 2009-12-11 07:50:00 | AAPL | Stock | 7.0782 | 7.0786 | 7.0782 | 7.0786 | 14000.0 |
| 2009-12-11 07:52:00 | AAPL | Stock | 7.0725 | 7.0725 | 7.0725 | 7.0725 | 2800.0 |
| 2009-12-11 07:53:00 | AAPL | Stock | 7.0779 | 7.0786 | 7.0779 | 7.0786 | 10612.0 |
| 2009-12-11 07:54:00 | AAPL | Stock | 7.0725 | 7.0732 | 7.0725 | 7.0732 | 8400.0 |
| 2009-12-11 07:56:00 | AAPL | Stock | 7.0761 | 7.0893 | 7.0761 | 7.0893 | 41720.0 |
| 2009-12-11 07:59:00 | AAPL | Stock | 7.0896 | 7.0896 | 7.0754 | 7.0754 | 61600.0 |
| 2009-12-11 08:00:00 | AAPL | Stock | 7.0761 | 7.0786 | 7.0154 | 7.0714 | 879648.0 |
| 2009-12-11 08:01:00 | AAPL | Stock | 7.0579 | 7.0671 | 7.0557 | 7.0671 | 64400.0 |
| 2009-12-11 08:02:00 | AAPL | Stock | 7.0646 | 7.0661 | 7.0611 | 7.0614 | 72800.0 |
| 2009-12-11 08:03:00 | AAPL | Stock | 7.0643 | 7.0643 | 7.0643 | 7.0643 | 16800.0 |
| 2009-12-11 08:04:00 | AAPL | Stock | 7.0643 | 7.065 | 7.0611 | 7.0611 | 11676.0 |
| 2009-12-11 08:05:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0514 | 7.0514 | 34384.0 |
| 2009-12-11 08:06:00 | AAPL | Stock | 7.0471 | 7.0471 | 7.045 | 7.045 | 25200.0 |
| 2009-12-11 08:07:00 | AAPL | Stock | 7.0443 | 7.0464 | 7.0429 | 7.045 | 19600.0 |
| 2009-12-11 08:08:00 | AAPL | Stock | 7.0493 | 7.0536 | 7.0493 | 7.0536 | 78540.0 |
| 2009-12-11 08:09:00 | AAPL | Stock | 7.0514 | 7.0561 | 7.0514 | 7.0561 | 58464.0 |
| 2009-12-11 08:10:00 | AAPL | Stock | 7.0561 | 7.0589 | 7.0561 | 7.0589 | 65968.0 |
| 2009-12-11 08:11:00 | AAPL | Stock | 7.0625 | 7.0664 | 7.0575 | 7.0632 | 140812.0 |
| 2009-12-11 08:12:00 | AAPL | Stock | 7.0632 | 7.0682 | 7.0625 | 7.0625 | 63560.0 |
| 2009-12-11 08:13:00 | AAPL | Stock | 7.0643 | 7.0643 | 7.0575 | 7.0575 | 151508.0 |
| 2009-12-11 08:14:00 | AAPL | Stock | 7.0525 | 7.0536 | 7.0521 | 7.0536 | 21420.0 |
| 2009-12-11 08:16:00 | AAPL | Stock | 7.0539 | 7.0543 | 7.05 | 7.05 | 36400.0 |
| 2009-12-11 08:17:00 | AAPL | Stock | 7.0468 | 7.0468 | 7.045 | 7.045 | 14000.0 |
| 2009-12-11 08:18:00 | AAPL | Stock | 7.0536 | 7.0536 | 7.0536 | 7.0536 | 2800.0 |
| 2009-12-11 08:19:00 | AAPL | Stock | 7.0521 | 7.0546 | 7.0516 | 7.0518 | 18200.0 |
| 2009-12-11 08:20:00 | AAPL | Stock | 7.0536 | 7.0536 | 7.0521 | 7.0536 | 16800.0 |
| 2009-12-11 08:22:00 | AAPL | Stock | 7.0571 | 7.0582 | 7.0571 | 7.0575 | 18200.0 |
| 2009-12-11 08:24:00 | AAPL | Stock | 7.0536 | 7.0539 | 7.0518 | 7.0532 | 44604.0 |
| 2009-12-11 08:25:00 | AAPL | Stock | 7.0518 | 7.0582 | 7.0518 | 7.0575 | 83524.0 |
| 2009-12-11 08:26:00 | AAPL | Stock | 7.0536 | 7.0536 | 7.0525 | 7.0532 | 33740.0 |
| 2009-12-11 08:27:00 | AAPL | Stock | 7.0571 | 7.0582 | 7.0536 | 7.0582 | 42000.0 |
| 2009-12-11 08:28:00 | AAPL | Stock | 7.0539 | 7.0546 | 7.0536 | 7.0539 | 33180.0 |
| 2009-12-11 08:29:00 | AAPL | Stock | 7.05 | 7.05 | 7.05 | 7.05 | 21420.0 |
| 2009-12-11 08:30:00 | AAPL | Stock | 7.0564 | 7.0639 | 7.05 | 7.0639 | 206612.0 |
| 2009-12-11 08:31:00 | AAPL | Stock | 7.0614 | 7.0654 | 7.0557 | 7.0557 | 132132.0 |
| 2009-12-11 08:32:00 | AAPL | Stock | 7.0589 | 7.0614 | 7.0575 | 7.0614 | 82040.0 |
| 2009-12-11 08:33:00 | AAPL | Stock | 7.0614 | 7.0621 | 7.0589 | 7.0618 | 25200.0 |
> showing 50 of 907,733 rows — these rows as CSV