PREVIEW / stock_1min / 2005-08-15
file: by_date/stock_1min/2005/2005-08-15.parquet size: 7.1 MB rows: 588,555 symbols: 1,688
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-15 07:18:00 | AAPL | Stock | 1.6536 | 1.6679 | 1.6536 | 1.6679 | 46900.0 |
| 2005-08-15 07:19:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6521 | 1.6532 | 33600.0 |
| 2005-08-15 07:20:00 | AAPL | Stock | 1.6532 | 1.6536 | 1.6532 | 1.6536 | 30800.0 |
| 2005-08-15 07:23:00 | AAPL | Stock | 1.6554 | 1.6554 | 1.6536 | 1.6536 | 25200.0 |
| 2005-08-15 07:29:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6532 | 1.6532 | 28000.0 |
| 2005-08-15 07:37:00 | AAPL | Stock | 1.6518 | 1.6518 | 1.6518 | 1.6518 | 14000.0 |
| 2005-08-15 07:54:00 | AAPL | Stock | 1.6475 | 1.6475 | 1.6475 | 1.6475 | 2800.0 |
| 2005-08-15 07:55:00 | AAPL | Stock | 1.65 | 1.65 | 1.65 | 1.65 | 30800.0 |
| 2005-08-15 07:56:00 | AAPL | Stock | 1.65 | 1.65 | 1.65 | 1.65 | 14000.0 |
| 2005-08-15 07:57:00 | AAPL | Stock | 1.65 | 1.65 | 1.6461 | 1.6461 | 61600.0 |
| 2005-08-15 07:58:00 | AAPL | Stock | 1.6464 | 1.65 | 1.6464 | 1.6482 | 419160.0 |
| 2005-08-15 07:59:00 | AAPL | Stock | 1.6482 | 1.6482 | 1.6482 | 1.6482 | 42000.0 |
| 2005-08-15 08:00:00 | AAPL | Stock | 1.6493 | 1.6511 | 1.6493 | 1.65 | 240800.0 |
| 2005-08-15 08:01:00 | AAPL | Stock | 1.6493 | 1.6521 | 1.6486 | 1.6521 | 892500.0 |
| 2005-08-15 08:02:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.65 | 1.6521 | 109200.0 |
| 2005-08-15 08:03:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.65 | 1.65 | 379568.0 |
| 2005-08-15 08:04:00 | AAPL | Stock | 1.6507 | 1.6518 | 1.6507 | 1.6507 | 101500.0 |
| 2005-08-15 08:05:00 | AAPL | Stock | 1.6518 | 1.6536 | 1.6518 | 1.6536 | 94752.0 |
| 2005-08-15 08:06:00 | AAPL | Stock | 1.6532 | 1.6532 | 1.6529 | 1.6532 | 123676.0 |
| 2005-08-15 08:07:00 | AAPL | Stock | 1.6521 | 1.6546 | 1.6521 | 1.6546 | 39200.0 |
| 2005-08-15 08:09:00 | AAPL | Stock | 1.6536 | 1.6536 | 1.6536 | 1.6536 | 24724.0 |
| 2005-08-15 08:10:00 | AAPL | Stock | 1.6546 | 1.655 | 1.6514 | 1.6514 | 47600.0 |
| 2005-08-15 08:11:00 | AAPL | Stock | 1.6507 | 1.6521 | 1.65 | 1.6521 | 106708.0 |
| 2005-08-15 08:12:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.6521 | 1.6521 | 19600.0 |
| 2005-08-15 08:13:00 | AAPL | Stock | 1.6521 | 1.6521 | 1.6514 | 1.6514 | 14000.0 |
| 2005-08-15 08:14:00 | AAPL | Stock | 1.6536 | 1.6546 | 1.6518 | 1.6546 | 55440.0 |
| 2005-08-15 08:15:00 | AAPL | Stock | 1.655 | 1.6554 | 1.655 | 1.6554 | 19096.0 |
| 2005-08-15 08:16:00 | AAPL | Stock | 1.6564 | 1.6564 | 1.6536 | 1.6536 | 84000.0 |
| 2005-08-15 08:17:00 | AAPL | Stock | 1.6543 | 1.6571 | 1.6536 | 1.6571 | 189280.0 |
| 2005-08-15 08:19:00 | AAPL | Stock | 1.6568 | 1.6582 | 1.6564 | 1.6582 | 149184.0 |
| 2005-08-15 08:20:00 | AAPL | Stock | 1.6586 | 1.6596 | 1.6586 | 1.6596 | 87584.0 |
| 2005-08-15 08:21:00 | AAPL | Stock | 1.6589 | 1.6604 | 1.6589 | 1.6604 | 205184.0 |
| 2005-08-15 08:22:00 | AAPL | Stock | 1.66 | 1.6604 | 1.6575 | 1.6604 | 83356.0 |
| 2005-08-15 08:23:00 | AAPL | Stock | 1.6604 | 1.6607 | 1.6593 | 1.66 | 219520.0 |
| 2005-08-15 08:24:00 | AAPL | Stock | 1.6604 | 1.6621 | 1.6571 | 1.6571 | 398384.0 |
| 2005-08-15 08:25:00 | AAPL | Stock | 1.6568 | 1.6593 | 1.6554 | 1.6593 | 193200.0 |
| 2005-08-15 08:26:00 | AAPL | Stock | 1.6582 | 1.6589 | 1.6579 | 1.6582 | 110600.0 |
| 2005-08-15 08:28:00 | AAPL | Stock | 1.6575 | 1.6596 | 1.6575 | 1.6596 | 140000.0 |
| 2005-08-15 08:29:00 | AAPL | Stock | 1.66 | 1.6786 | 1.6593 | 1.6639 | 1621900.0 |
| 2005-08-15 08:30:00 | AAPL | Stock | 1.6639 | 1.6664 | 1.6625 | 1.6661 | 311500.0 |
| 2005-08-15 08:31:00 | AAPL | Stock | 1.6661 | 1.6671 | 1.6636 | 1.6639 | 842800.0 |
| 2005-08-15 08:32:00 | AAPL | Stock | 1.6639 | 1.665 | 1.6629 | 1.6643 | 76020.0 |
| 2005-08-15 08:33:00 | AAPL | Stock | 1.6643 | 1.6661 | 1.6643 | 1.6661 | 214760.0 |
| 2005-08-15 08:34:00 | AAPL | Stock | 1.6657 | 1.6679 | 1.6657 | 1.6679 | 172200.0 |
| 2005-08-15 08:35:00 | AAPL | Stock | 1.6661 | 1.6675 | 1.6661 | 1.6671 | 155400.0 |
| 2005-08-15 08:36:00 | AAPL | Stock | 1.6675 | 1.6675 | 1.6671 | 1.6675 | 86520.0 |
| 2005-08-15 08:37:00 | AAPL | Stock | 1.6675 | 1.6696 | 1.6675 | 1.6686 | 670880.0 |
| 2005-08-15 08:38:00 | AAPL | Stock | 1.6679 | 1.6686 | 1.6664 | 1.6679 | 316120.0 |
| 2005-08-15 08:39:00 | AAPL | Stock | 1.6682 | 1.6696 | 1.6679 | 1.6689 | 1013684.0 |
| 2005-08-15 08:40:00 | AAPL | Stock | 1.6693 | 1.6714 | 1.6682 | 1.6696 | 268520.0 |
> showing 50 of 588,555 rows — these rows as CSV