PREVIEW / stock_5min / 2000-01-31
file: by_date/stock_5min/2000/2000-01-31.parquet size: 1.1 MB rows: 85,968 symbols: 1,129
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-01-31 09:30:00 | AAPL | Stock | 0.9018 | 0.9018 | 0.8884 | 0.8884 | 10606400.0 |
| 2000-01-31 09:35:00 | AAPL | Stock | 0.8878 | 0.899 | 0.8839 | 0.8956 | 12835200.0 |
| 2000-01-31 09:40:00 | AAPL | Stock | 0.8956 | 0.8984 | 0.885 | 0.8884 | 11222400.0 |
| 2000-01-31 09:45:00 | AAPL | Stock | 0.8884 | 0.894 | 0.8862 | 0.8917 | 6316800.0 |
| 2000-01-31 09:50:00 | AAPL | Stock | 0.8912 | 0.8929 | 0.885 | 0.8884 | 6070400.0 |
| 2000-01-31 09:55:00 | AAPL | Stock | 0.8878 | 0.8884 | 0.8789 | 0.8789 | 10236800.0 |
| 2000-01-31 10:00:00 | AAPL | Stock | 0.8795 | 0.8862 | 0.8733 | 0.8853 | 13731200.0 |
| 2000-01-31 10:05:00 | AAPL | Stock | 0.8853 | 0.8923 | 0.8772 | 0.8839 | 12096000.0 |
| 2000-01-31 10:10:00 | AAPL | Stock | 0.8834 | 0.8929 | 0.8772 | 0.8929 | 9004800.0 |
| 2000-01-31 10:15:00 | AAPL | Stock | 0.8929 | 0.8956 | 0.8906 | 0.8912 | 12555200.0 |
| 2000-01-31 10:20:00 | AAPL | Stock | 0.8912 | 0.8929 | 0.8867 | 0.8884 | 6294400.0 |
| 2000-01-31 10:25:00 | AAPL | Stock | 0.8906 | 0.8968 | 0.8884 | 0.889 | 10236800.0 |
| 2000-01-31 10:30:00 | AAPL | Stock | 0.889 | 0.8906 | 0.8873 | 0.8884 | 5230400.0 |
| 2000-01-31 10:35:00 | AAPL | Stock | 0.8884 | 0.8906 | 0.8806 | 0.8806 | 4636800.0 |
| 2000-01-31 10:40:00 | AAPL | Stock | 0.8806 | 0.8862 | 0.8728 | 0.8739 | 8724800.0 |
| 2000-01-31 10:45:00 | AAPL | Stock | 0.8728 | 0.875 | 0.8583 | 0.8594 | 13820800.0 |
| 2000-01-31 10:50:00 | AAPL | Stock | 0.861 | 0.8661 | 0.8571 | 0.8594 | 14313600.0 |
| 2000-01-31 10:55:00 | AAPL | Stock | 0.8588 | 0.8689 | 0.8571 | 0.8661 | 14392000.0 |
| 2000-01-31 11:00:00 | AAPL | Stock | 0.8666 | 0.8694 | 0.8627 | 0.8694 | 13160000.0 |
| 2000-01-31 11:05:00 | AAPL | Stock | 0.8705 | 0.8705 | 0.8638 | 0.865 | 7571200.0 |
| 2000-01-31 11:10:00 | AAPL | Stock | 0.865 | 0.8661 | 0.8616 | 0.8661 | 11457600.0 |
| 2000-01-31 11:15:00 | AAPL | Stock | 0.8661 | 0.8694 | 0.8644 | 0.8689 | 28492800.0 |
| 2000-01-31 11:20:00 | AAPL | Stock | 0.8691 | 0.8705 | 0.8655 | 0.8672 | 16296000.0 |
| 2000-01-31 11:25:00 | AAPL | Stock | 0.8655 | 0.8672 | 0.8655 | 0.8672 | 5006400.0 |
| 2000-01-31 11:30:00 | AAPL | Stock | 0.8666 | 0.8694 | 0.8627 | 0.8666 | 3136000.0 |
| 2000-01-31 11:35:00 | AAPL | Stock | 0.8672 | 0.8705 | 0.8638 | 0.8677 | 4121600.0 |
| 2000-01-31 11:40:00 | AAPL | Stock | 0.87 | 0.87 | 0.865 | 0.8661 | 3382400.0 |
| 2000-01-31 11:45:00 | AAPL | Stock | 0.8661 | 0.8672 | 0.8638 | 0.8672 | 1512000.0 |
| 2000-01-31 11:50:00 | AAPL | Stock | 0.8672 | 0.8672 | 0.8616 | 0.8655 | 2385600.0 |
| 2000-01-31 11:55:00 | AAPL | Stock | 0.8627 | 0.865 | 0.8527 | 0.8527 | 5342400.0 |
| 2000-01-31 12:00:00 | AAPL | Stock | 0.8532 | 0.856 | 0.8471 | 0.8488 | 15243200.0 |
| 2000-01-31 12:05:00 | AAPL | Stock | 0.8488 | 0.8504 | 0.8438 | 0.8482 | 24371200.0 |
| 2000-01-31 12:10:00 | AAPL | Stock | 0.8482 | 0.8504 | 0.8438 | 0.8493 | 13865600.0 |
| 2000-01-31 12:15:00 | AAPL | Stock | 0.8482 | 0.8516 | 0.8471 | 0.8502 | 16004800.0 |
| 2000-01-31 12:20:00 | AAPL | Stock | 0.8504 | 0.8616 | 0.8493 | 0.861 | 21112000.0 |
| 2000-01-31 12:25:00 | AAPL | Stock | 0.8616 | 0.8616 | 0.8538 | 0.8588 | 10651200.0 |
| 2000-01-31 12:30:00 | AAPL | Stock | 0.856 | 0.8638 | 0.856 | 0.8627 | 9340800.0 |
| 2000-01-31 12:35:00 | AAPL | Stock | 0.8616 | 0.8627 | 0.8571 | 0.8616 | 6115200.0 |
| 2000-01-31 12:40:00 | AAPL | Stock | 0.8616 | 0.8655 | 0.861 | 0.8638 | 5723200.0 |
| 2000-01-31 12:45:00 | AAPL | Stock | 0.865 | 0.8661 | 0.8622 | 0.8638 | 3819200.0 |
| 2000-01-31 12:50:00 | AAPL | Stock | 0.8638 | 0.8694 | 0.8638 | 0.8683 | 3124800.0 |
| 2000-01-31 12:55:00 | AAPL | Stock | 0.8683 | 0.8683 | 0.8616 | 0.8661 | 1590400.0 |
| 2000-01-31 13:00:00 | AAPL | Stock | 0.8661 | 0.8744 | 0.8661 | 0.8739 | 12241600.0 |
| 2000-01-31 13:05:00 | AAPL | Stock | 0.8739 | 0.875 | 0.8717 | 0.875 | 7246400.0 |
| 2000-01-31 13:10:00 | AAPL | Stock | 0.875 | 0.8772 | 0.8705 | 0.8705 | 8232000.0 |
| 2000-01-31 13:15:00 | AAPL | Stock | 0.8711 | 0.8795 | 0.8694 | 0.8778 | 8355200.0 |
| 2000-01-31 13:20:00 | AAPL | Stock | 0.8795 | 0.88 | 0.8739 | 0.875 | 5969600.0 |
| 2000-01-31 13:25:00 | AAPL | Stock | 0.8739 | 0.8772 | 0.8717 | 0.8722 | 2486400.0 |
| 2000-01-31 13:30:00 | AAPL | Stock | 0.8722 | 0.8767 | 0.8705 | 0.8767 | 1411200.0 |
| 2000-01-31 13:35:00 | AAPL | Stock | 0.8772 | 0.8772 | 0.8728 | 0.8761 | 1019200.0 |
> showing 50 of 85,968 rows — these rows as CSV