PREVIEW / stock_5min / 2024-03-25
file: by_date/stock_5min/2024/2024-03-25.parquet size: 6.7 MB rows: 399,543 symbols: 1,058
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-25 04:00:00 | AAPL | Stock | 172.2 | 172.2 | 172.0 | 172.0 | 1787.0 |
| 2024-03-25 04:10:00 | AAPL | Stock | 172.07 | 172.07 | 172.07 | 172.07 | 200.0 |
| 2024-03-25 04:15:00 | AAPL | Stock | 172.1 | 172.12 | 172.1 | 172.12 | 200.0 |
| 2024-03-25 04:20:00 | AAPL | Stock | 172.1 | 172.14 | 172.1 | 172.1 | 796.0 |
| 2024-03-25 04:25:00 | AAPL | Stock | 172.07 | 172.19 | 172.07 | 172.19 | 840.0 |
| 2024-03-25 04:40:00 | AAPL | Stock | 172.18 | 172.2 | 172.18 | 172.2 | 297.0 |
| 2024-03-25 04:45:00 | AAPL | Stock | 172.18 | 172.18 | 172.18 | 172.18 | 100.0 |
| 2024-03-25 05:00:00 | AAPL | Stock | 172.17 | 172.17 | 172.1 | 172.1 | 2933.0 |
| 2024-03-25 05:05:00 | AAPL | Stock | 172.0 | 172.01 | 171.86 | 171.87 | 2032.0 |
| 2024-03-25 05:10:00 | AAPL | Stock | 171.88 | 171.94 | 171.88 | 171.94 | 4398.0 |
| 2024-03-25 05:15:00 | AAPL | Stock | 171.94 | 171.96 | 171.85 | 171.85 | 1495.0 |
| 2024-03-25 05:20:00 | AAPL | Stock | 171.83 | 171.83 | 171.83 | 171.83 | 199.0 |
| 2024-03-25 05:25:00 | AAPL | Stock | 171.77 | 171.77 | 171.72 | 171.72 | 313.0 |
| 2024-03-25 05:30:00 | AAPL | Stock | 171.81 | 171.81 | 171.81 | 171.81 | 100.0 |
| 2024-03-25 05:35:00 | AAPL | Stock | 171.72 | 171.72 | 171.7 | 171.71 | 1286.0 |
| 2024-03-25 05:40:00 | AAPL | Stock | 171.71 | 171.71 | 171.71 | 171.71 | 660.0 |
| 2024-03-25 05:45:00 | AAPL | Stock | 171.68 | 171.68 | 171.68 | 171.68 | 121.0 |
| 2024-03-25 05:50:00 | AAPL | Stock | 171.71 | 171.71 | 171.71 | 171.71 | 483.0 |
| 2024-03-25 05:55:00 | AAPL | Stock | 171.7 | 171.71 | 171.69 | 171.71 | 2291.0 |
| 2024-03-25 06:00:00 | AAPL | Stock | 171.7 | 171.8 | 171.7 | 171.8 | 324.0 |
| 2024-03-25 06:05:00 | AAPL | Stock | 171.85 | 171.85 | 171.8 | 171.8 | 984.0 |
| 2024-03-25 06:10:00 | AAPL | Stock | 171.74 | 171.74 | 171.72 | 171.72 | 2280.0 |
| 2024-03-25 06:15:00 | AAPL | Stock | 171.72 | 171.73 | 171.7 | 171.7 | 4566.0 |
| 2024-03-25 06:20:00 | AAPL | Stock | 171.7 | 171.7 | 171.51 | 171.51 | 414.0 |
| 2024-03-25 06:25:00 | AAPL | Stock | 171.5 | 171.5 | 171.5 | 171.5 | 561.0 |
| 2024-03-25 06:30:00 | AAPL | Stock | 171.36 | 171.36 | 171.36 | 171.36 | 412.0 |
| 2024-03-25 06:35:00 | AAPL | Stock | 171.34 | 171.34 | 171.34 | 171.34 | 325.0 |
| 2024-03-25 06:45:00 | AAPL | Stock | 171.34 | 171.34 | 171.34 | 171.34 | 318.0 |
| 2024-03-25 06:50:00 | AAPL | Stock | 171.32 | 171.38 | 171.32 | 171.37 | 986.0 |
| 2024-03-25 06:55:00 | AAPL | Stock | 171.31 | 171.31 | 171.3 | 171.3 | 700.0 |
| 2024-03-25 07:00:00 | AAPL | Stock | 171.39 | 171.41 | 171.21 | 171.25 | 5098.0 |
| 2024-03-25 07:05:00 | AAPL | Stock | 171.24 | 171.34 | 171.2 | 171.31 | 8526.0 |
| 2024-03-25 07:10:00 | AAPL | Stock | 171.3 | 171.3 | 171.2 | 171.2 | 5023.0 |
| 2024-03-25 07:15:00 | AAPL | Stock | 171.3 | 171.3 | 171.1 | 171.11 | 14950.0 |
| 2024-03-25 07:20:00 | AAPL | Stock | 171.1 | 171.1 | 171.07 | 171.07 | 3632.0 |
| 2024-03-25 07:25:00 | AAPL | Stock | 171.11 | 171.2 | 171.08 | 171.2 | 7448.0 |
| 2024-03-25 07:30:00 | AAPL | Stock | 171.19 | 171.2 | 171.17 | 171.19 | 2163.0 |
| 2024-03-25 07:35:00 | AAPL | Stock | 171.19 | 171.19 | 171.15 | 171.15 | 814.0 |
| 2024-03-25 07:40:00 | AAPL | Stock | 171.13 | 171.15 | 171.08 | 171.1 | 964.0 |
| 2024-03-25 07:45:00 | AAPL | Stock | 171.18 | 171.2 | 171.18 | 171.2 | 7563.0 |
| 2024-03-25 07:50:00 | AAPL | Stock | 171.18 | 171.2 | 171.13 | 171.2 | 1927.0 |
| 2024-03-25 07:55:00 | AAPL | Stock | 171.12 | 171.19 | 171.12 | 171.19 | 2003.0 |
| 2024-03-25 08:00:00 | AAPL | Stock | 171.4 | 172.27 | 171.05 | 172.24 | 56694.0 |
| 2024-03-25 08:05:00 | AAPL | Stock | 171.12 | 172.27 | 171.09 | 171.09 | 9512.0 |
| 2024-03-25 08:10:00 | AAPL | Stock | 171.08 | 171.1 | 171.0 | 171.04 | 19130.0 |
| 2024-03-25 08:15:00 | AAPL | Stock | 171.05 | 171.1899 | 171.05 | 171.0629 | 14709.0 |
| 2024-03-25 08:20:00 | AAPL | Stock | 171.1323 | 171.15 | 171.05 | 171.06 | 5078.0 |
| 2024-03-25 08:25:00 | AAPL | Stock | 171.1 | 171.1 | 171.05 | 171.08 | 5398.0 |
| 2024-03-25 08:30:00 | AAPL | Stock | 171.08 | 171.24 | 171.08 | 171.21 | 11875.0 |
| 2024-03-25 08:35:00 | AAPL | Stock | 171.21 | 171.22 | 171.1 | 171.1 | 3185.0 |
> showing 50 of 399,543 rows — these rows as CSV