PREVIEW / stock_1min / 2006-09-22
file: by_date/stock_1min/2006/2006-09-22.parquet size: 8.3 MB rows: 680,198 symbols: 1,932
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-09-22 08:00:00 | AAPL | Stock | 2.6661 | 2.6661 | 2.6661 | 2.6661 | 2884.0 |
| 2006-09-22 08:04:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 40852.0 |
| 2006-09-22 08:07:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 28000.0 |
| 2006-09-22 08:13:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 28000.0 |
| 2006-09-22 08:14:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6589 | 2.6589 | 137200.0 |
| 2006-09-22 08:15:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6589 | 2.6589 | 84000.0 |
| 2006-09-22 08:16:00 | AAPL | Stock | 2.6564 | 2.6564 | 2.6564 | 2.6564 | 2800.0 |
| 2006-09-22 08:20:00 | AAPL | Stock | 2.6561 | 2.6561 | 2.6561 | 2.6561 | 8400.0 |
| 2006-09-22 08:22:00 | AAPL | Stock | 2.6575 | 2.6575 | 2.6575 | 2.6575 | 2800.0 |
| 2006-09-22 08:28:00 | AAPL | Stock | 2.6575 | 2.6575 | 2.6575 | 2.6575 | 2800.0 |
| 2006-09-22 08:29:00 | AAPL | Stock | 2.6571 | 2.6571 | 2.6571 | 2.6571 | 14000.0 |
| 2006-09-22 08:32:00 | AAPL | Stock | 2.6571 | 2.6571 | 2.6571 | 2.6571 | 26600.0 |
| 2006-09-22 08:33:00 | AAPL | Stock | 2.66 | 2.66 | 2.66 | 2.66 | 14000.0 |
| 2006-09-22 08:36:00 | AAPL | Stock | 2.66 | 2.66 | 2.66 | 2.66 | 3696.0 |
| 2006-09-22 08:38:00 | AAPL | Stock | 2.66 | 2.66 | 2.66 | 2.66 | 12600.0 |
| 2006-09-22 08:39:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6589 | 2.6589 | 14000.0 |
| 2006-09-22 08:40:00 | AAPL | Stock | 2.6561 | 2.6561 | 2.6561 | 2.6561 | 64204.0 |
| 2006-09-22 08:44:00 | AAPL | Stock | 2.66 | 2.6607 | 2.66 | 2.6607 | 14000.0 |
| 2006-09-22 08:46:00 | AAPL | Stock | 2.66 | 2.66 | 2.66 | 2.66 | 2800.0 |
| 2006-09-22 08:51:00 | AAPL | Stock | 2.6586 | 2.6586 | 2.6586 | 2.6586 | 2800.0 |
| 2006-09-22 08:52:00 | AAPL | Stock | 2.66 | 2.66 | 2.66 | 2.66 | 2800.0 |
| 2006-09-22 08:53:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 65912.0 |
| 2006-09-22 08:56:00 | AAPL | Stock | 2.6639 | 2.6639 | 2.6639 | 2.6639 | 28000.0 |
| 2006-09-22 08:57:00 | AAPL | Stock | 2.6636 | 2.6636 | 2.6636 | 2.6636 | 5600.0 |
| 2006-09-22 09:00:00 | AAPL | Stock | 2.6621 | 2.6639 | 2.6621 | 2.6639 | 43400.0 |
| 2006-09-22 09:02:00 | AAPL | Stock | 2.6639 | 2.6661 | 2.6621 | 2.6621 | 127260.0 |
| 2006-09-22 09:03:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 5600.0 |
| 2006-09-22 09:05:00 | AAPL | Stock | 2.6607 | 2.6607 | 2.6607 | 2.6607 | 2800.0 |
| 2006-09-22 09:06:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6582 | 2.6582 | 14000.0 |
| 2006-09-22 09:07:00 | AAPL | Stock | 2.6582 | 2.6593 | 2.6582 | 2.6593 | 44800.0 |
| 2006-09-22 09:09:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6586 | 2.6586 | 22400.0 |
| 2006-09-22 09:10:00 | AAPL | Stock | 2.6582 | 2.6582 | 2.6582 | 2.6582 | 39032.0 |
| 2006-09-22 09:11:00 | AAPL | Stock | 2.6582 | 2.6586 | 2.6582 | 2.6586 | 22568.0 |
| 2006-09-22 09:12:00 | AAPL | Stock | 2.6586 | 2.6586 | 2.6586 | 2.6586 | 3920.0 |
| 2006-09-22 09:13:00 | AAPL | Stock | 2.6589 | 2.6589 | 2.6589 | 2.6589 | 2800.0 |
| 2006-09-22 09:22:00 | AAPL | Stock | 2.6586 | 2.6586 | 2.6582 | 2.6582 | 39480.0 |
| 2006-09-22 09:23:00 | AAPL | Stock | 2.6596 | 2.66 | 2.6596 | 2.6596 | 80220.0 |
| 2006-09-22 09:24:00 | AAPL | Stock | 2.6596 | 2.6596 | 2.6596 | 2.6596 | 8400.0 |
| 2006-09-22 09:25:00 | AAPL | Stock | 2.6571 | 2.6571 | 2.6571 | 2.6571 | 5600.0 |
| 2006-09-22 09:26:00 | AAPL | Stock | 2.6571 | 2.6571 | 2.6571 | 2.6571 | 2800.0 |
| 2006-09-22 09:27:00 | AAPL | Stock | 2.6571 | 2.6589 | 2.6571 | 2.6589 | 5600.0 |
| 2006-09-22 09:28:00 | AAPL | Stock | 2.6557 | 2.6561 | 2.6557 | 2.6561 | 50400.0 |
| 2006-09-22 09:29:00 | AAPL | Stock | 2.6557 | 2.6557 | 2.6521 | 2.6521 | 364000.0 |
| 2006-09-22 09:30:00 | AAPL | Stock | 2.6536 | 2.655 | 2.6454 | 2.6457 | 4648560.0 |
| 2006-09-22 09:31:00 | AAPL | Stock | 2.6464 | 2.6486 | 2.6436 | 2.6471 | 3934980.0 |
| 2006-09-22 09:32:00 | AAPL | Stock | 2.6468 | 2.6489 | 2.6461 | 2.6468 | 2864120.0 |
| 2006-09-22 09:33:00 | AAPL | Stock | 2.6461 | 2.6464 | 2.6429 | 2.6443 | 3205888.0 |
| 2006-09-22 09:34:00 | AAPL | Stock | 2.645 | 2.6539 | 2.6443 | 2.6446 | 6278440.0 |
| 2006-09-22 09:35:00 | AAPL | Stock | 2.6446 | 2.6457 | 2.6429 | 2.6443 | 3532564.0 |
| 2006-09-22 09:36:00 | AAPL | Stock | 2.6443 | 2.645 | 2.6375 | 2.6396 | 6294064.0 |
> showing 50 of 680,198 rows — these rows as CSV