PREVIEW / stock_5min / 2024-09-17
file: by_date/stock_5min/2024/2024-09-17.parquet size: 6.7 MB rows: 401,914 symbols: 799
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-09-17 04:00:00 | AAPL | Stock | 216.37 | 216.91 | 216.29 | 216.85 | 6455.0 |
| 2024-09-17 04:05:00 | AAPL | Stock | 216.85 | 216.99 | 216.75 | 216.75 | 3350.0 |
| 2024-09-17 04:10:00 | AAPL | Stock | 216.98 | 216.99 | 216.82 | 216.85 | 3868.0 |
| 2024-09-17 04:15:00 | AAPL | Stock | 216.75 | 216.75 | 216.5 | 216.56 | 2073.0 |
| 2024-09-17 04:20:00 | AAPL | Stock | 216.5 | 216.64 | 216.5 | 216.64 | 245.0 |
| 2024-09-17 04:25:00 | AAPL | Stock | 216.62 | 216.62 | 216.43 | 216.43 | 2837.0 |
| 2024-09-17 04:30:00 | AAPL | Stock | 216.45 | 216.45 | 216.22 | 216.26 | 2061.0 |
| 2024-09-17 04:35:00 | AAPL | Stock | 216.27 | 216.34 | 216.27 | 216.34 | 469.0 |
| 2024-09-17 04:40:00 | AAPL | Stock | 216.48 | 216.48 | 216.48 | 216.48 | 100.0 |
| 2024-09-17 04:45:00 | AAPL | Stock | 216.42 | 216.42 | 216.42 | 216.42 | 100.0 |
| 2024-09-17 04:50:00 | AAPL | Stock | 216.48 | 216.48 | 216.48 | 216.48 | 100.0 |
| 2024-09-17 04:55:00 | AAPL | Stock | 216.52 | 216.52 | 216.52 | 216.52 | 100.0 |
| 2024-09-17 05:05:00 | AAPL | Stock | 216.62 | 216.68 | 216.6 | 216.68 | 633.0 |
| 2024-09-17 05:10:00 | AAPL | Stock | 216.7 | 216.7 | 216.7 | 216.7 | 214.0 |
| 2024-09-17 05:15:00 | AAPL | Stock | 216.74 | 216.83 | 216.71 | 216.83 | 926.0 |
| 2024-09-17 05:20:00 | AAPL | Stock | 216.71 | 216.75 | 216.71 | 216.75 | 270.0 |
| 2024-09-17 05:25:00 | AAPL | Stock | 216.79 | 216.79 | 216.79 | 216.79 | 141.0 |
| 2024-09-17 05:35:00 | AAPL | Stock | 216.89 | 216.97 | 216.89 | 216.97 | 599.0 |
| 2024-09-17 05:40:00 | AAPL | Stock | 216.95 | 216.95 | 216.91 | 216.95 | 550.0 |
| 2024-09-17 05:45:00 | AAPL | Stock | 216.94 | 216.97 | 216.89 | 216.95 | 1208.0 |
| 2024-09-17 05:50:00 | AAPL | Stock | 216.97 | 216.97 | 216.93 | 216.93 | 510.0 |
| 2024-09-17 05:55:00 | AAPL | Stock | 216.94 | 216.94 | 216.89 | 216.89 | 1028.0 |
| 2024-09-17 06:00:00 | AAPL | Stock | 216.85 | 216.85 | 216.85 | 216.85 | 100.0 |
| 2024-09-17 06:05:00 | AAPL | Stock | 216.91 | 216.91 | 216.9 | 216.9 | 600.0 |
| 2024-09-17 06:10:00 | AAPL | Stock | 216.83 | 216.83 | 216.77 | 216.8 | 450.0 |
| 2024-09-17 06:15:00 | AAPL | Stock | 216.8 | 216.92 | 216.8 | 216.9 | 792.0 |
| 2024-09-17 06:20:00 | AAPL | Stock | 216.92 | 216.92 | 216.85 | 216.85 | 748.0 |
| 2024-09-17 06:25:00 | AAPL | Stock | 216.9 | 216.9 | 216.76 | 216.8 | 1621.0 |
| 2024-09-17 06:30:00 | AAPL | Stock | 216.76 | 216.76 | 216.75 | 216.75 | 955.0 |
| 2024-09-17 06:35:00 | AAPL | Stock | 216.72 | 216.72 | 216.72 | 216.72 | 110.0 |
| 2024-09-17 06:40:00 | AAPL | Stock | 216.75 | 216.75 | 216.75 | 216.75 | 100.0 |
| 2024-09-17 06:50:00 | AAPL | Stock | 216.68 | 216.69 | 216.68 | 216.69 | 1006.0 |
| 2024-09-17 06:55:00 | AAPL | Stock | 216.7 | 216.7 | 216.65 | 216.65 | 1433.0 |
| 2024-09-17 07:00:00 | AAPL | Stock | 216.6 | 216.7 | 216.59 | 216.63 | 3232.0 |
| 2024-09-17 07:05:00 | AAPL | Stock | 216.66 | 216.68 | 216.52 | 216.52 | 3675.0 |
| 2024-09-17 07:10:00 | AAPL | Stock | 216.53 | 216.53 | 216.5 | 216.5 | 1213.0 |
| 2024-09-17 07:15:00 | AAPL | Stock | 216.45 | 216.45 | 216.35 | 216.35 | 1962.0 |
| 2024-09-17 07:20:00 | AAPL | Stock | 216.36 | 216.37 | 215.91 | 216.07 | 11980.0 |
| 2024-09-17 07:25:00 | AAPL | Stock | 215.95 | 216.04 | 215.02 | 215.02 | 30596.0 |
| 2024-09-17 07:30:00 | AAPL | Stock | 215.24 | 215.56 | 215.02 | 215.02 | 14251.0 |
| 2024-09-17 07:35:00 | AAPL | Stock | 215.13 | 215.5 | 215.1 | 215.5 | 3064.0 |
| 2024-09-17 07:40:00 | AAPL | Stock | 215.82 | 215.82 | 215.69 | 215.69 | 2025.0 |
| 2024-09-17 07:45:00 | AAPL | Stock | 215.78 | 216.36 | 215.73 | 216.28 | 17791.0 |
| 2024-09-17 07:50:00 | AAPL | Stock | 216.2 | 216.2 | 215.9 | 216.15 | 3915.0 |
| 2024-09-17 07:55:00 | AAPL | Stock | 216.19 | 216.345 | 216.19 | 216.26 | 5209.0 |
| 2024-09-17 08:00:00 | AAPL | Stock | 216.53 | 216.7 | 215.1494 | 216.2128 | 71835.0 |
| 2024-09-17 08:05:00 | AAPL | Stock | 216.21 | 216.29 | 216.18 | 216.21 | 8867.0 |
| 2024-09-17 08:10:00 | AAPL | Stock | 216.15 | 216.2477 | 216.0509 | 216.15 | 6270.0 |
| 2024-09-17 08:15:00 | AAPL | Stock | 216.14 | 216.185 | 215.85 | 215.97 | 10288.0 |
| 2024-09-17 08:20:00 | AAPL | Stock | 215.9997 | 216.1849 | 215.87 | 216.1849 | 4125.0 |
> showing 50 of 401,914 rows — these rows as CSV