PREVIEW / stock_5min / 2024-10-24
file: by_date/stock_5min/2024/2024-10-24.parquet size: 6.7 MB rows: 401,404 symbols: 723
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-10-24 04:00:00 | AAPL | Stock | 230.66 | 231.48 | 230.66 | 231.39 | 3012.0 |
| 2024-10-24 04:05:00 | AAPL | Stock | 231.4 | 231.45 | 231.34 | 231.4 | 2218.0 |
| 2024-10-24 04:10:00 | AAPL | Stock | 231.34 | 231.4 | 231.34 | 231.4 | 3035.0 |
| 2024-10-24 04:15:00 | AAPL | Stock | 231.4 | 231.4 | 231.37 | 231.4 | 954.0 |
| 2024-10-24 04:20:00 | AAPL | Stock | 231.4 | 231.4 | 231.38 | 231.4 | 1572.0 |
| 2024-10-24 04:25:00 | AAPL | Stock | 231.37 | 231.4 | 231.37 | 231.38 | 571.0 |
| 2024-10-24 04:30:00 | AAPL | Stock | 231.38 | 231.4 | 231.36 | 231.36 | 568.0 |
| 2024-10-24 04:35:00 | AAPL | Stock | 231.36 | 231.37 | 231.36 | 231.37 | 1301.0 |
| 2024-10-24 04:40:00 | AAPL | Stock | 231.33 | 231.37 | 231.33 | 231.37 | 1748.0 |
| 2024-10-24 04:45:00 | AAPL | Stock | 231.32 | 231.32 | 231.2 | 231.2 | 3014.0 |
| 2024-10-24 05:00:00 | AAPL | Stock | 231.28 | 231.32 | 231.21 | 231.31 | 958.0 |
| 2024-10-24 05:05:00 | AAPL | Stock | 231.31 | 231.38 | 231.21 | 231.38 | 1553.0 |
| 2024-10-24 05:15:00 | AAPL | Stock | 231.38 | 231.38 | 231.36 | 231.36 | 3342.0 |
| 2024-10-24 05:20:00 | AAPL | Stock | 231.36 | 231.36 | 231.36 | 231.36 | 100.0 |
| 2024-10-24 05:25:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 100.0 |
| 2024-10-24 05:35:00 | AAPL | Stock | 231.32 | 231.32 | 231.32 | 231.32 | 100.0 |
| 2024-10-24 05:55:00 | AAPL | Stock | 231.29 | 231.34 | 231.28 | 231.34 | 579.0 |
| 2024-10-24 06:10:00 | AAPL | Stock | 231.36 | 231.36 | 231.36 | 231.36 | 121.0 |
| 2024-10-24 06:15:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 100.0 |
| 2024-10-24 06:20:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 1019.0 |
| 2024-10-24 06:25:00 | AAPL | Stock | 231.38 | 231.38 | 231.38 | 231.38 | 100.0 |
| 2024-10-24 06:35:00 | AAPL | Stock | 231.44 | 231.44 | 231.44 | 231.44 | 200.0 |
| 2024-10-24 06:40:00 | AAPL | Stock | 231.45 | 231.45 | 231.45 | 231.45 | 300.0 |
| 2024-10-24 06:45:00 | AAPL | Stock | 231.45 | 231.45 | 231.45 | 231.45 | 698.0 |
| 2024-10-24 06:50:00 | AAPL | Stock | 231.39 | 231.39 | 231.39 | 231.39 | 100.0 |
| 2024-10-24 06:55:00 | AAPL | Stock | 231.45 | 231.45 | 231.4 | 231.4 | 1479.0 |
| 2024-10-24 07:00:00 | AAPL | Stock | 231.4 | 231.46 | 231.1 | 231.1 | 6083.0 |
| 2024-10-24 07:05:00 | AAPL | Stock | 231.1 | 231.27 | 231.1 | 231.27 | 931.0 |
| 2024-10-24 07:10:00 | AAPL | Stock | 231.37 | 231.46 | 231.2 | 231.2 | 4093.0 |
| 2024-10-24 07:15:00 | AAPL | Stock | 231.15 | 231.15 | 231.07 | 231.07 | 609.0 |
| 2024-10-24 07:20:00 | AAPL | Stock | 231.11 | 231.11 | 231.11 | 231.11 | 3464.0 |
| 2024-10-24 07:25:00 | AAPL | Stock | 231.18 | 231.18 | 231.18 | 231.18 | 250.0 |
| 2024-10-24 07:30:00 | AAPL | Stock | 231.19 | 231.19 | 231.19 | 231.19 | 428.0 |
| 2024-10-24 07:35:00 | AAPL | Stock | 231.15 | 231.15 | 231.05 | 231.15 | 1134.0 |
| 2024-10-24 07:40:00 | AAPL | Stock | 231.15 | 231.2 | 231.14 | 231.2 | 1615.0 |
| 2024-10-24 07:45:00 | AAPL | Stock | 231.24 | 231.24 | 231.21 | 231.22 | 343.0 |
| 2024-10-24 07:50:00 | AAPL | Stock | 231.24 | 231.33 | 231.24 | 231.33 | 900.0 |
| 2024-10-24 07:55:00 | AAPL | Stock | 231.33 | 231.33 | 231.33 | 231.33 | 270.0 |
| 2024-10-24 08:00:00 | AAPL | Stock | 231.27 | 231.61 | 230.52 | 231.28 | 46162.0 |
| 2024-10-24 08:05:00 | AAPL | Stock | 231.2503 | 231.2503 | 231.25 | 231.25 | 1423.0 |
| 2024-10-24 08:10:00 | AAPL | Stock | 231.28 | 231.28 | 231.22 | 231.22 | 2128.0 |
| 2024-10-24 08:15:00 | AAPL | Stock | 231.25 | 231.37 | 231.25 | 231.37 | 3386.0 |
| 2024-10-24 08:20:00 | AAPL | Stock | 231.4 | 231.4 | 231.23 | 231.25 | 3078.0 |
| 2024-10-24 08:25:00 | AAPL | Stock | 231.2 | 231.2011 | 231.2 | 231.2 | 4180.0 |
| 2024-10-24 08:30:00 | AAPL | Stock | 231.2 | 231.33 | 231.11 | 231.19 | 8715.0 |
| 2024-10-24 08:35:00 | AAPL | Stock | 231.18 | 231.19 | 231.07 | 231.07 | 8747.0 |
| 2024-10-24 08:40:00 | AAPL | Stock | 231.0 | 231.02 | 230.9 | 230.9999 | 14885.0 |
| 2024-10-24 08:45:00 | AAPL | Stock | 230.9999 | 231.0 | 230.88 | 230.88 | 4286.0 |
| 2024-10-24 08:50:00 | AAPL | Stock | 230.88 | 230.93 | 230.81 | 230.83 | 10483.0 |
| 2024-10-24 08:55:00 | AAPL | Stock | 230.81 | 230.9049 | 230.45 | 230.5 | 11916.0 |
> showing 50 of 401,404 rows — these rows as CSV