PREVIEW / stock_5min / 2000-10-12
file: by_date/stock_5min/2000/2000-10-12.parquet size: 1.3 MB rows: 94,777 symbols: 1,241
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-12 08:00:00 | AAPL | Stock | 0.3571 | 0.3683 | 0.3504 | 0.3504 | 1467200.0 |
| 2000-10-12 08:05:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3571 | 0.3571 | 117600.0 |
| 2000-10-12 08:10:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 50400.0 |
| 2000-10-12 08:15:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3594 | 0.3616 | 89600.0 |
| 2000-10-12 08:20:00 | AAPL | Stock | 0.3583 | 0.3616 | 0.3583 | 0.3611 | 179200.0 |
| 2000-10-12 08:25:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3594 | 0.3594 | 22400.0 |
| 2000-10-12 08:30:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3594 | 0.3616 | 106400.0 |
| 2000-10-12 08:35:00 | AAPL | Stock | 0.3594 | 0.3605 | 0.3594 | 0.3605 | 56000.0 |
| 2000-10-12 08:40:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3571 | 0.3571 | 375200.0 |
| 2000-10-12 08:45:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 134400.0 |
| 2000-10-12 08:50:00 | AAPL | Stock | 0.3571 | 0.3616 | 0.3571 | 0.3571 | 190400.0 |
| 2000-10-12 08:55:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3566 | 0.3571 | 548800.0 |
| 2000-10-12 09:00:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3571 | 0.3571 | 263200.0 |
| 2000-10-12 09:05:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 72800.0 |
| 2000-10-12 09:10:00 | AAPL | Stock | 0.3583 | 0.3583 | 0.3583 | 0.3583 | 285600.0 |
| 2000-10-12 09:15:00 | AAPL | Stock | 0.3583 | 0.3616 | 0.3583 | 0.3616 | 1120000.0 |
| 2000-10-12 09:20:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3605 | 0.3627 | 5000800.0 |
| 2000-10-12 09:25:00 | AAPL | Stock | 0.3605 | 0.3638 | 0.3605 | 0.3622 | 8769600.0 |
| 2000-10-12 09:30:00 | AAPL | Stock | 0.3627 | 0.3661 | 0.3616 | 0.365 | 35778400.0 |
| 2000-10-12 09:35:00 | AAPL | Stock | 0.3638 | 0.365 | 0.3583 | 0.3594 | 19684000.0 |
| 2000-10-12 09:40:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3566 | 0.3583 | 33420800.0 |
| 2000-10-12 09:45:00 | AAPL | Stock | 0.3583 | 0.3616 | 0.3571 | 0.3605 | 18726400.0 |
| 2000-10-12 09:50:00 | AAPL | Stock | 0.3605 | 0.3627 | 0.3594 | 0.3616 | 13748000.0 |
| 2000-10-12 09:55:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3571 | 0.3571 | 14056000.0 |
| 2000-10-12 10:00:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3549 | 0.3594 | 22792000.0 |
| 2000-10-12 10:05:00 | AAPL | Stock | 0.3571 | 0.3583 | 0.3538 | 0.3538 | 13770400.0 |
| 2000-10-12 10:10:00 | AAPL | Stock | 0.3549 | 0.3571 | 0.3538 | 0.356 | 15136800.0 |
| 2000-10-12 10:15:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3538 | 0.3538 | 9430400.0 |
| 2000-10-12 10:20:00 | AAPL | Stock | 0.3538 | 0.3571 | 0.3538 | 0.3549 | 12180000.0 |
| 2000-10-12 10:25:00 | AAPL | Stock | 0.3549 | 0.3594 | 0.3549 | 0.3583 | 14184800.0 |
| 2000-10-12 10:30:00 | AAPL | Stock | 0.3583 | 0.3605 | 0.3571 | 0.3605 | 7767200.0 |
| 2000-10-12 10:35:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.356 | 0.3571 | 16688000.0 |
| 2000-10-12 10:40:00 | AAPL | Stock | 0.3583 | 0.3583 | 0.356 | 0.3577 | 8220800.0 |
| 2000-10-12 10:45:00 | AAPL | Stock | 0.3577 | 0.3583 | 0.3549 | 0.3571 | 10074400.0 |
| 2000-10-12 10:50:00 | AAPL | Stock | 0.3571 | 0.3638 | 0.3549 | 0.3638 | 37217600.0 |
| 2000-10-12 10:55:00 | AAPL | Stock | 0.3638 | 0.3705 | 0.3594 | 0.3683 | 28817600.0 |
| 2000-10-12 11:00:00 | AAPL | Stock | 0.3683 | 0.3717 | 0.3672 | 0.3705 | 49179200.0 |
| 2000-10-12 11:05:00 | AAPL | Stock | 0.3694 | 0.3705 | 0.3661 | 0.3694 | 9688000.0 |
| 2000-10-12 11:10:00 | AAPL | Stock | 0.3694 | 0.3694 | 0.3638 | 0.3638 | 10164000.0 |
| 2000-10-12 11:15:00 | AAPL | Stock | 0.365 | 0.3661 | 0.3616 | 0.3627 | 17376800.0 |
| 2000-10-12 11:20:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3594 | 0.3605 | 10942400.0 |
| 2000-10-12 11:25:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3571 | 0.3583 | 9788800.0 |
| 2000-10-12 11:30:00 | AAPL | Stock | 0.3594 | 0.3627 | 0.3583 | 0.3616 | 15304800.0 |
| 2000-10-12 11:35:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3594 | 0.3594 | 6210400.0 |
| 2000-10-12 11:40:00 | AAPL | Stock | 0.3605 | 0.3605 | 0.3583 | 0.3594 | 41328000.0 |
| 2000-10-12 11:45:00 | AAPL | Stock | 0.3594 | 0.3605 | 0.3571 | 0.3571 | 24018400.0 |
| 2000-10-12 11:50:00 | AAPL | Stock | 0.3577 | 0.3594 | 0.356 | 0.3571 | 44094400.0 |
| 2000-10-12 11:55:00 | AAPL | Stock | 0.3571 | 0.3583 | 0.3516 | 0.3549 | 15820000.0 |
| 2000-10-12 12:00:00 | AAPL | Stock | 0.3549 | 0.3549 | 0.3482 | 0.3493 | 11905600.0 |
| 2000-10-12 12:05:00 | AAPL | Stock | 0.3493 | 0.3504 | 0.3482 | 0.3493 | 17752000.0 |
> showing 50 of 94,777 rows — these rows as CSV