PREVIEW / stock_5min / 2000-11-01
file: by_date/stock_5min/2000/2000-11-01.parquet size: 1.2 MB rows: 90,601 symbols: 1,235
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-11-01 08:00:00 | AAPL | Stock | 0.3482 | 0.3488 | 0.3482 | 0.3488 | 3326400.0 |
| 2000-11-01 08:30:00 | AAPL | Stock | 0.346 | 0.346 | 0.3449 | 0.3449 | 33600.0 |
| 2000-11-01 08:35:00 | AAPL | Stock | 0.346 | 0.346 | 0.346 | 0.346 | 28000.0 |
| 2000-11-01 08:40:00 | AAPL | Stock | 0.3449 | 0.3449 | 0.3449 | 0.3449 | 5600.0 |
| 2000-11-01 08:45:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 5600.0 |
| 2000-11-01 08:50:00 | AAPL | Stock | 0.3449 | 0.346 | 0.3449 | 0.346 | 106400.0 |
| 2000-11-01 08:55:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3449 | 0.3449 | 84000.0 |
| 2000-11-01 09:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 61600.0 |
| 2000-11-01 09:05:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 16800.0 |
| 2000-11-01 09:10:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.3471 | 0.3482 | 168000.0 |
| 2000-11-01 09:15:00 | AAPL | Stock | 0.3471 | 0.3482 | 0.3471 | 0.3471 | 313600.0 |
| 2000-11-01 09:20:00 | AAPL | Stock | 0.3477 | 0.3482 | 0.3471 | 0.3471 | 224000.0 |
| 2000-11-01 09:25:00 | AAPL | Stock | 0.3482 | 0.3504 | 0.3304 | 0.3471 | 1058400.0 |
| 2000-11-01 09:30:00 | AAPL | Stock | 0.3471 | 0.3493 | 0.3471 | 0.3482 | 13955200.0 |
| 2000-11-01 09:35:00 | AAPL | Stock | 0.3471 | 0.3571 | 0.3471 | 0.3571 | 7660800.0 |
| 2000-11-01 09:40:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3527 | 0.356 | 10063200.0 |
| 2000-11-01 09:45:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3527 | 0.3549 | 3712800.0 |
| 2000-11-01 09:50:00 | AAPL | Stock | 0.3538 | 0.3571 | 0.3538 | 0.3549 | 3858400.0 |
| 2000-11-01 09:55:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3549 | 0.3571 | 7397600.0 |
| 2000-11-01 10:00:00 | AAPL | Stock | 0.3571 | 0.3605 | 0.356 | 0.3583 | 17231200.0 |
| 2000-11-01 10:05:00 | AAPL | Stock | 0.3588 | 0.3594 | 0.3571 | 0.3571 | 21330400.0 |
| 2000-11-01 10:10:00 | AAPL | Stock | 0.3583 | 0.3583 | 0.3549 | 0.3571 | 4564000.0 |
| 2000-11-01 10:15:00 | AAPL | Stock | 0.3571 | 0.3605 | 0.3571 | 0.3594 | 9206400.0 |
| 2000-11-01 10:20:00 | AAPL | Stock | 0.3594 | 0.3638 | 0.3583 | 0.3638 | 13484800.0 |
| 2000-11-01 10:25:00 | AAPL | Stock | 0.3627 | 0.3661 | 0.3627 | 0.3661 | 15215200.0 |
| 2000-11-01 10:30:00 | AAPL | Stock | 0.365 | 0.3672 | 0.3638 | 0.3638 | 21179200.0 |
| 2000-11-01 10:35:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3638 | 0.365 | 7571200.0 |
| 2000-11-01 10:40:00 | AAPL | Stock | 0.365 | 0.3683 | 0.3638 | 0.3683 | 8467200.0 |
| 2000-11-01 10:45:00 | AAPL | Stock | 0.3672 | 0.3683 | 0.365 | 0.3655 | 7240800.0 |
| 2000-11-01 10:50:00 | AAPL | Stock | 0.3661 | 0.3683 | 0.3661 | 0.3683 | 8932000.0 |
| 2000-11-01 10:55:00 | AAPL | Stock | 0.3683 | 0.3705 | 0.3672 | 0.3705 | 10354400.0 |
| 2000-11-01 11:00:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3683 | 0.3694 | 7845600.0 |
| 2000-11-01 11:05:00 | AAPL | Stock | 0.3683 | 0.3705 | 0.3661 | 0.3694 | 11508000.0 |
| 2000-11-01 11:10:00 | AAPL | Stock | 0.3694 | 0.3705 | 0.3672 | 0.3705 | 8377600.0 |
| 2000-11-01 11:15:00 | AAPL | Stock | 0.3705 | 0.3728 | 0.3683 | 0.3705 | 10309600.0 |
| 2000-11-01 11:20:00 | AAPL | Stock | 0.3711 | 0.3728 | 0.3694 | 0.3694 | 7448000.0 |
| 2000-11-01 11:25:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3683 | 0.3683 | 6176800.0 |
| 2000-11-01 11:30:00 | AAPL | Stock | 0.3694 | 0.3705 | 0.3672 | 0.3672 | 5521600.0 |
| 2000-11-01 11:35:00 | AAPL | Stock | 0.3672 | 0.3694 | 0.3672 | 0.3683 | 10931200.0 |
| 2000-11-01 11:40:00 | AAPL | Stock | 0.3672 | 0.3705 | 0.3672 | 0.3672 | 9352000.0 |
| 2000-11-01 11:45:00 | AAPL | Stock | 0.3672 | 0.3694 | 0.3661 | 0.3672 | 3729600.0 |
| 2000-11-01 11:50:00 | AAPL | Stock | 0.3672 | 0.3705 | 0.3672 | 0.3683 | 7117600.0 |
| 2000-11-01 11:55:00 | AAPL | Stock | 0.3694 | 0.3705 | 0.3683 | 0.3705 | 4334400.0 |
| 2000-11-01 12:00:00 | AAPL | Stock | 0.3705 | 0.3705 | 0.3683 | 0.3694 | 6641600.0 |
| 2000-11-01 12:05:00 | AAPL | Stock | 0.3694 | 0.3705 | 0.3672 | 0.3694 | 2688000.0 |
| 2000-11-01 12:10:00 | AAPL | Stock | 0.3694 | 0.3694 | 0.3672 | 0.3683 | 4860800.0 |
| 2000-11-01 12:15:00 | AAPL | Stock | 0.3683 | 0.3694 | 0.3672 | 0.3683 | 6557600.0 |
| 2000-11-01 12:20:00 | AAPL | Stock | 0.3672 | 0.3694 | 0.3672 | 0.3683 | 1008000.0 |
| 2000-11-01 12:25:00 | AAPL | Stock | 0.3694 | 0.3694 | 0.3672 | 0.3683 | 5185600.0 |
| 2000-11-01 12:30:00 | AAPL | Stock | 0.3683 | 0.3694 | 0.3672 | 0.3683 | 4300800.0 |
> showing 50 of 90,601 rows — these rows as CSV