PREVIEW / stock_5min / 2024-08-07
file: by_date/stock_5min/2024/2024-08-07.parquet size: 6.6 MB rows: 403,648 symbols: 879
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-08-07 04:00:00 | AAPL | Stock | 208.3 | 208.85 | 207.12 | 207.69 | 5778.0 |
| 2024-08-07 04:05:00 | AAPL | Stock | 207.98 | 208.24 | 207.9 | 208.0 | 4113.0 |
| 2024-08-07 04:10:00 | AAPL | Stock | 207.92 | 208.25 | 207.92 | 208.22 | 11678.0 |
| 2024-08-07 04:15:00 | AAPL | Stock | 208.1 | 208.48 | 208.06 | 208.31 | 6698.0 |
| 2024-08-07 04:20:00 | AAPL | Stock | 208.34 | 208.37 | 208.03 | 208.08 | 1881.0 |
| 2024-08-07 04:25:00 | AAPL | Stock | 208.21 | 208.21 | 207.95 | 208.03 | 1076.0 |
| 2024-08-07 04:30:00 | AAPL | Stock | 208.26 | 208.28 | 208.26 | 208.28 | 416.0 |
| 2024-08-07 04:35:00 | AAPL | Stock | 208.0 | 208.04 | 207.99 | 208.0 | 1752.0 |
| 2024-08-07 04:40:00 | AAPL | Stock | 208.03 | 208.03 | 207.93 | 208.03 | 623.0 |
| 2024-08-07 04:45:00 | AAPL | Stock | 208.03 | 208.29 | 208.0 | 208.28 | 1076.0 |
| 2024-08-07 04:50:00 | AAPL | Stock | 208.29 | 208.3 | 208.19 | 208.19 | 919.0 |
| 2024-08-07 04:55:00 | AAPL | Stock | 208.14 | 208.4 | 208.12 | 208.33 | 2712.0 |
| 2024-08-07 05:00:00 | AAPL | Stock | 208.31 | 208.61 | 208.31 | 208.6 | 1606.0 |
| 2024-08-07 05:05:00 | AAPL | Stock | 208.73 | 208.92 | 208.67 | 208.67 | 1674.0 |
| 2024-08-07 05:10:00 | AAPL | Stock | 208.76 | 208.88 | 208.71 | 208.8 | 1958.0 |
| 2024-08-07 05:15:00 | AAPL | Stock | 208.49 | 208.8 | 208.43 | 208.64 | 6836.0 |
| 2024-08-07 05:20:00 | AAPL | Stock | 208.67 | 208.9 | 208.67 | 208.9 | 920.0 |
| 2024-08-07 05:25:00 | AAPL | Stock | 208.98 | 209.39 | 208.98 | 209.35 | 3192.0 |
| 2024-08-07 05:30:00 | AAPL | Stock | 209.31 | 209.31 | 209.13 | 209.13 | 300.0 |
| 2024-08-07 05:35:00 | AAPL | Stock | 209.08 | 209.19 | 208.89 | 208.89 | 1954.0 |
| 2024-08-07 05:40:00 | AAPL | Stock | 208.63 | 208.63 | 208.5 | 208.5 | 3359.0 |
| 2024-08-07 05:45:00 | AAPL | Stock | 208.53 | 208.53 | 208.38 | 208.41 | 1744.0 |
| 2024-08-07 05:50:00 | AAPL | Stock | 208.47 | 208.61 | 208.47 | 208.51 | 1500.0 |
| 2024-08-07 05:55:00 | AAPL | Stock | 208.5 | 208.5 | 208.41 | 208.44 | 1226.0 |
| 2024-08-07 06:00:00 | AAPL | Stock | 208.5 | 208.51 | 208.5 | 208.51 | 367.0 |
| 2024-08-07 06:05:00 | AAPL | Stock | 208.49 | 208.49 | 208.3 | 208.35 | 3351.0 |
| 2024-08-07 06:10:00 | AAPL | Stock | 208.4 | 208.41 | 208.4 | 208.41 | 2021.0 |
| 2024-08-07 06:15:00 | AAPL | Stock | 208.43 | 208.43 | 208.43 | 208.43 | 100.0 |
| 2024-08-07 06:20:00 | AAPL | Stock | 208.38 | 208.48 | 208.24 | 208.43 | 630.0 |
| 2024-08-07 06:25:00 | AAPL | Stock | 208.4 | 208.67 | 208.4 | 208.67 | 820.0 |
| 2024-08-07 06:30:00 | AAPL | Stock | 208.69 | 208.69 | 208.69 | 208.69 | 100.0 |
| 2024-08-07 06:35:00 | AAPL | Stock | 208.68 | 208.79 | 208.67 | 208.79 | 2236.0 |
| 2024-08-07 06:40:00 | AAPL | Stock | 208.76 | 208.76 | 208.76 | 208.76 | 100.0 |
| 2024-08-07 06:45:00 | AAPL | Stock | 208.8 | 208.8 | 208.6 | 208.6 | 3610.0 |
| 2024-08-07 06:50:00 | AAPL | Stock | 208.71 | 209.0 | 208.71 | 209.0 | 1980.0 |
| 2024-08-07 06:55:00 | AAPL | Stock | 209.01 | 209.27 | 209.0 | 209.27 | 3235.0 |
| 2024-08-07 07:00:00 | AAPL | Stock | 208.91 | 209.35 | 208.82 | 209.11 | 25052.0 |
| 2024-08-07 07:05:00 | AAPL | Stock | 209.11 | 209.11 | 208.71 | 209.04 | 6705.0 |
| 2024-08-07 07:10:00 | AAPL | Stock | 209.1 | 209.3 | 208.61 | 208.76 | 4002.0 |
| 2024-08-07 07:15:00 | AAPL | Stock | 208.79 | 208.8 | 208.75 | 208.75 | 9935.0 |
| 2024-08-07 07:20:00 | AAPL | Stock | 208.71 | 208.76 | 208.62 | 208.74 | 2933.0 |
| 2024-08-07 07:25:00 | AAPL | Stock | 208.68 | 208.68 | 208.36 | 208.41 | 6139.0 |
| 2024-08-07 07:30:00 | AAPL | Stock | 208.42 | 208.49 | 208.03 | 208.17 | 10309.0 |
| 2024-08-07 07:35:00 | AAPL | Stock | 208.12 | 208.61 | 208.05 | 208.55 | 6933.0 |
| 2024-08-07 07:40:00 | AAPL | Stock | 208.49 | 208.49 | 208.25 | 208.35 | 1595.0 |
| 2024-08-07 07:45:00 | AAPL | Stock | 208.35 | 208.35 | 207.92 | 208.04 | 6082.0 |
| 2024-08-07 07:50:00 | AAPL | Stock | 208.0 | 208.16 | 207.99 | 208.16 | 3968.0 |
| 2024-08-07 07:55:00 | AAPL | Stock | 208.25 | 208.3 | 207.8 | 207.95 | 4858.0 |
| 2024-08-07 08:00:00 | AAPL | Stock | 208.8 | 209.3 | 207.6 | 207.9 | 49939.0 |
| 2024-08-07 08:05:00 | AAPL | Stock | 207.84 | 208.2 | 207.7617 | 208.0 | 13891.0 |
> showing 50 of 403,648 rows — these rows as CSV