PREVIEW / stock_5min / 2001-01-31
file: by_date/stock_5min/2001/2001-01-31.parquet size: 1.6 MB rows: 106,744 symbols: 1,280
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-31 08:00:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 5600.0 |
| 2001-01-31 08:10:00 | AAPL | Stock | 0.3817 | 0.3817 | 0.3817 | 0.3817 | 5600.0 |
| 2001-01-31 08:20:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 5600.0 |
| 2001-01-31 08:45:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 11200.0 |
| 2001-01-31 09:00:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.385 | 0.385 | 72800.0 |
| 2001-01-31 09:05:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 5600.0 |
| 2001-01-31 09:15:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 33600.0 |
| 2001-01-31 09:20:00 | AAPL | Stock | 0.385 | 0.385 | 0.385 | 0.385 | 56000.0 |
| 2001-01-31 09:25:00 | AAPL | Stock | 0.3845 | 0.3845 | 0.3828 | 0.3839 | 649600.0 |
| 2001-01-31 09:30:00 | AAPL | Stock | 0.3839 | 0.3895 | 0.3828 | 0.3862 | 16380000.0 |
| 2001-01-31 09:35:00 | AAPL | Stock | 0.3862 | 0.3906 | 0.3839 | 0.3884 | 7952000.0 |
| 2001-01-31 09:40:00 | AAPL | Stock | 0.3862 | 0.3895 | 0.385 | 0.3862 | 3511200.0 |
| 2001-01-31 09:45:00 | AAPL | Stock | 0.3873 | 0.3895 | 0.3862 | 0.3884 | 5269600.0 |
| 2001-01-31 09:50:00 | AAPL | Stock | 0.3873 | 0.3984 | 0.3873 | 0.3973 | 28268800.0 |
| 2001-01-31 09:55:00 | AAPL | Stock | 0.3973 | 0.3984 | 0.3917 | 0.3951 | 19185600.0 |
| 2001-01-31 10:00:00 | AAPL | Stock | 0.3951 | 0.4007 | 0.394 | 0.3984 | 21464800.0 |
| 2001-01-31 10:05:00 | AAPL | Stock | 0.3984 | 0.3996 | 0.3973 | 0.3973 | 7688800.0 |
| 2001-01-31 10:10:00 | AAPL | Stock | 0.3973 | 0.4007 | 0.3951 | 0.3984 | 8814400.0 |
| 2001-01-31 10:15:00 | AAPL | Stock | 0.3996 | 0.3996 | 0.3973 | 0.3996 | 3628800.0 |
| 2001-01-31 10:20:00 | AAPL | Stock | 0.3996 | 0.4018 | 0.3984 | 0.3996 | 6854400.0 |
| 2001-01-31 10:25:00 | AAPL | Stock | 0.4007 | 0.4007 | 0.3973 | 0.3996 | 10057600.0 |
| 2001-01-31 10:30:00 | AAPL | Stock | 0.3984 | 0.3996 | 0.3973 | 0.3973 | 1808800.0 |
| 2001-01-31 10:35:00 | AAPL | Stock | 0.3984 | 0.3984 | 0.3962 | 0.3962 | 6535200.0 |
| 2001-01-31 10:40:00 | AAPL | Stock | 0.3962 | 0.3973 | 0.394 | 0.394 | 13686400.0 |
| 2001-01-31 10:45:00 | AAPL | Stock | 0.394 | 0.3951 | 0.3873 | 0.3917 | 19353600.0 |
| 2001-01-31 10:50:00 | AAPL | Stock | 0.3917 | 0.3917 | 0.3873 | 0.3884 | 17309600.0 |
| 2001-01-31 10:55:00 | AAPL | Stock | 0.3884 | 0.3906 | 0.3884 | 0.3906 | 29668800.0 |
| 2001-01-31 11:00:00 | AAPL | Stock | 0.3895 | 0.3906 | 0.3884 | 0.3895 | 1836800.0 |
| 2001-01-31 11:05:00 | AAPL | Stock | 0.3895 | 0.3929 | 0.3884 | 0.3929 | 4676000.0 |
| 2001-01-31 11:10:00 | AAPL | Stock | 0.3929 | 0.394 | 0.3917 | 0.3929 | 3852800.0 |
| 2001-01-31 11:15:00 | AAPL | Stock | 0.394 | 0.394 | 0.3917 | 0.3917 | 3264800.0 |
| 2001-01-31 11:20:00 | AAPL | Stock | 0.3917 | 0.3929 | 0.3884 | 0.3884 | 10998400.0 |
| 2001-01-31 11:25:00 | AAPL | Stock | 0.3895 | 0.3906 | 0.3895 | 0.3895 | 2592800.0 |
| 2001-01-31 11:30:00 | AAPL | Stock | 0.3895 | 0.3906 | 0.3895 | 0.3895 | 2044000.0 |
| 2001-01-31 11:35:00 | AAPL | Stock | 0.3895 | 0.3906 | 0.3884 | 0.3906 | 1965600.0 |
| 2001-01-31 11:40:00 | AAPL | Stock | 0.3906 | 0.3906 | 0.3895 | 0.3906 | 985600.0 |
| 2001-01-31 11:45:00 | AAPL | Stock | 0.3906 | 0.3906 | 0.3884 | 0.3895 | 4580800.0 |
| 2001-01-31 11:50:00 | AAPL | Stock | 0.3895 | 0.3906 | 0.3895 | 0.3895 | 3757600.0 |
| 2001-01-31 11:55:00 | AAPL | Stock | 0.3895 | 0.3917 | 0.3895 | 0.3917 | 1685600.0 |
| 2001-01-31 12:00:00 | AAPL | Stock | 0.3906 | 0.3917 | 0.3895 | 0.3906 | 2447200.0 |
| 2001-01-31 12:05:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3906 | 0.3917 | 3539200.0 |
| 2001-01-31 12:10:00 | AAPL | Stock | 0.3906 | 0.3917 | 0.3895 | 0.3906 | 2592800.0 |
| 2001-01-31 12:15:00 | AAPL | Stock | 0.3906 | 0.3917 | 0.3895 | 0.3906 | 2228800.0 |
| 2001-01-31 12:20:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3906 | 0.3923 | 6641600.0 |
| 2001-01-31 12:25:00 | AAPL | Stock | 0.3917 | 0.3917 | 0.3906 | 0.3906 | 1030400.0 |
| 2001-01-31 12:30:00 | AAPL | Stock | 0.3917 | 0.394 | 0.3906 | 0.3906 | 3830400.0 |
| 2001-01-31 12:35:00 | AAPL | Stock | 0.3906 | 0.3917 | 0.3906 | 0.3906 | 1030400.0 |
| 2001-01-31 12:40:00 | AAPL | Stock | 0.3906 | 0.3929 | 0.3906 | 0.3917 | 1876000.0 |
| 2001-01-31 12:45:00 | AAPL | Stock | 0.3917 | 0.3929 | 0.3906 | 0.3917 | 537600.0 |
| 2001-01-31 12:50:00 | AAPL | Stock | 0.3917 | 0.3929 | 0.3912 | 0.3917 | 716800.0 |
> showing 50 of 106,744 rows — these rows as CSV