PREVIEW / stock_5min / 2000-10-11
file: by_date/stock_5min/2000/2000-10-11.parquet size: 1.3 MB rows: 94,760 symbols: 1,236
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-11 08:00:00 | AAPL | Stock | 0.3594 | 0.3683 | 0.3571 | 0.3571 | 968800.0 |
| 2000-10-11 08:05:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3571 | 0.3571 | 257600.0 |
| 2000-10-11 08:10:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3571 | 0.3571 | 112000.0 |
| 2000-10-11 08:20:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3594 | 0.3594 | 11200.0 |
| 2000-10-11 08:25:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3594 | 0.3594 | 280000.0 |
| 2000-10-11 08:30:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3594 | 0.3616 | 140000.0 |
| 2000-10-11 08:35:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3616 | 0.3616 | 16800.0 |
| 2000-10-11 08:45:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3627 | 0.3638 | 112000.0 |
| 2000-10-11 08:50:00 | AAPL | Stock | 0.3633 | 0.3633 | 0.3583 | 0.3616 | 134400.0 |
| 2000-10-11 08:55:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3583 | 0.3616 | 498400.0 |
| 2000-10-11 09:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3616 | 0.3616 | 84000.0 |
| 2000-10-11 09:05:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3594 | 0.3616 | 140000.0 |
| 2000-10-11 09:10:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3616 | 0.3638 | 504000.0 |
| 2000-10-11 09:15:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3616 | 0.3616 | 196000.0 |
| 2000-10-11 09:20:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3571 | 0.3583 | 2380000.0 |
| 2000-10-11 09:25:00 | AAPL | Stock | 0.3571 | 0.365 | 0.3571 | 0.3571 | 7515200.0 |
| 2000-10-11 09:30:00 | AAPL | Stock | 0.3594 | 0.3717 | 0.3583 | 0.3594 | 35700000.0 |
| 2000-10-11 09:35:00 | AAPL | Stock | 0.3594 | 0.3605 | 0.3571 | 0.3571 | 41260800.0 |
| 2000-10-11 09:40:00 | AAPL | Stock | 0.3571 | 0.3583 | 0.3571 | 0.3583 | 33812800.0 |
| 2000-10-11 09:45:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3549 | 0.3549 | 24819200.0 |
| 2000-10-11 09:50:00 | AAPL | Stock | 0.3549 | 0.3627 | 0.3527 | 0.3616 | 19784800.0 |
| 2000-10-11 09:55:00 | AAPL | Stock | 0.3583 | 0.3605 | 0.3571 | 0.3594 | 37066400.0 |
| 2000-10-11 10:00:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3571 | 0.3583 | 9945600.0 |
| 2000-10-11 10:05:00 | AAPL | Stock | 0.3594 | 0.3605 | 0.3583 | 0.3605 | 18972800.0 |
| 2000-10-11 10:10:00 | AAPL | Stock | 0.3605 | 0.3627 | 0.3583 | 0.3594 | 19028800.0 |
| 2000-10-11 10:15:00 | AAPL | Stock | 0.3583 | 0.3605 | 0.3571 | 0.3605 | 13193600.0 |
| 2000-10-11 10:20:00 | AAPL | Stock | 0.3594 | 0.3616 | 0.3571 | 0.3571 | 16335200.0 |
| 2000-10-11 10:25:00 | AAPL | Stock | 0.3577 | 0.3594 | 0.3549 | 0.3571 | 20781600.0 |
| 2000-10-11 10:30:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.356 | 0.3594 | 10309600.0 |
| 2000-10-11 10:35:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3583 | 0.3594 | 6249600.0 |
| 2000-10-11 10:40:00 | AAPL | Stock | 0.3594 | 0.3594 | 0.3571 | 0.3571 | 3147200.0 |
| 2000-10-11 10:45:00 | AAPL | Stock | 0.3583 | 0.3583 | 0.3527 | 0.3527 | 10360000.0 |
| 2000-10-11 10:50:00 | AAPL | Stock | 0.3527 | 0.356 | 0.3493 | 0.3493 | 10589600.0 |
| 2000-10-11 10:55:00 | AAPL | Stock | 0.3493 | 0.3549 | 0.3482 | 0.3493 | 16682400.0 |
| 2000-10-11 11:00:00 | AAPL | Stock | 0.3493 | 0.3538 | 0.3482 | 0.3527 | 12700800.0 |
| 2000-10-11 11:05:00 | AAPL | Stock | 0.3527 | 0.3527 | 0.3504 | 0.3504 | 6468000.0 |
| 2000-10-11 11:10:00 | AAPL | Stock | 0.3516 | 0.3516 | 0.3482 | 0.3482 | 8612800.0 |
| 2000-10-11 11:15:00 | AAPL | Stock | 0.3493 | 0.3493 | 0.3443 | 0.3465 | 13949600.0 |
| 2000-10-11 11:20:00 | AAPL | Stock | 0.346 | 0.3471 | 0.3426 | 0.3449 | 14201600.0 |
| 2000-10-11 11:25:00 | AAPL | Stock | 0.3438 | 0.3471 | 0.3426 | 0.346 | 32026400.0 |
| 2000-10-11 11:30:00 | AAPL | Stock | 0.346 | 0.3482 | 0.3449 | 0.3482 | 27109600.0 |
| 2000-10-11 11:35:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.346 | 0.3471 | 41462400.0 |
| 2000-10-11 11:40:00 | AAPL | Stock | 0.346 | 0.3504 | 0.346 | 0.3504 | 41456800.0 |
| 2000-10-11 11:45:00 | AAPL | Stock | 0.3504 | 0.3516 | 0.346 | 0.3504 | 32804800.0 |
| 2000-10-11 11:50:00 | AAPL | Stock | 0.3504 | 0.3538 | 0.3493 | 0.351 | 21812000.0 |
| 2000-10-11 11:55:00 | AAPL | Stock | 0.3504 | 0.3527 | 0.3504 | 0.3504 | 13557600.0 |
| 2000-10-11 12:00:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3493 | 0.3516 | 19342400.0 |
| 2000-10-11 12:05:00 | AAPL | Stock | 0.3504 | 0.3571 | 0.3493 | 0.356 | 19964000.0 |
| 2000-10-11 12:10:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3538 | 0.3571 | 26992000.0 |
| 2000-10-11 12:15:00 | AAPL | Stock | 0.3594 | 0.3605 | 0.3571 | 0.3594 | 20171200.0 |
> showing 50 of 94,760 rows — these rows as CSV