PREVIEW / stock_5min / 2024-04-23
file: by_date/stock_5min/2024/2024-04-23.parquet size: 6.5 MB rows: 393,988 symbols: 979
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-04-23 04:00:00 | AAPL | Stock | 165.8 | 165.8 | 165.0 | 165.33 | 6211.0 |
| 2024-04-23 04:05:00 | AAPL | Stock | 165.38 | 165.45 | 165.35 | 165.45 | 1080.0 |
| 2024-04-23 04:10:00 | AAPL | Stock | 165.48 | 165.64 | 165.48 | 165.64 | 1902.0 |
| 2024-04-23 04:15:00 | AAPL | Stock | 165.63 | 165.73 | 165.63 | 165.72 | 1400.0 |
| 2024-04-23 04:20:00 | AAPL | Stock | 165.79 | 165.79 | 165.5 | 165.59 | 9423.0 |
| 2024-04-23 04:25:00 | AAPL | Stock | 165.53 | 165.53 | 165.53 | 165.53 | 212.0 |
| 2024-04-23 04:30:00 | AAPL | Stock | 165.5 | 165.5 | 165.08 | 165.12 | 13333.0 |
| 2024-04-23 04:35:00 | AAPL | Stock | 165.22 | 165.33 | 165.2 | 165.27 | 482.0 |
| 2024-04-23 04:40:00 | AAPL | Stock | 165.27 | 165.35 | 165.27 | 165.35 | 512.0 |
| 2024-04-23 04:45:00 | AAPL | Stock | 165.32 | 165.32 | 165.31 | 165.31 | 317.0 |
| 2024-04-23 04:50:00 | AAPL | Stock | 165.27 | 165.3 | 165.01 | 165.1 | 5338.0 |
| 2024-04-23 04:55:00 | AAPL | Stock | 165.12 | 165.12 | 165.04 | 165.05 | 1198.0 |
| 2024-04-23 05:00:00 | AAPL | Stock | 165.03 | 165.13 | 165.03 | 165.1 | 2511.0 |
| 2024-04-23 05:05:00 | AAPL | Stock | 165.13 | 165.5 | 165.13 | 165.35 | 19216.0 |
| 2024-04-23 05:15:00 | AAPL | Stock | 165.55 | 165.67 | 165.51 | 165.58 | 2096.0 |
| 2024-04-23 05:20:00 | AAPL | Stock | 165.4 | 165.4 | 165.14 | 165.25 | 2580.0 |
| 2024-04-23 05:25:00 | AAPL | Stock | 165.3 | 165.3 | 165.3 | 165.3 | 100.0 |
| 2024-04-23 05:30:00 | AAPL | Stock | 165.39 | 165.39 | 165.13 | 165.24 | 1837.0 |
| 2024-04-23 05:35:00 | AAPL | Stock | 165.24 | 165.24 | 165.18 | 165.18 | 300.0 |
| 2024-04-23 05:40:00 | AAPL | Stock | 165.2 | 165.21 | 165.2 | 165.21 | 388.0 |
| 2024-04-23 05:45:00 | AAPL | Stock | 165.2 | 165.2 | 165.15 | 165.2 | 1587.0 |
| 2024-04-23 05:50:00 | AAPL | Stock | 165.2 | 165.22 | 165.19 | 165.22 | 652.0 |
| 2024-04-23 05:55:00 | AAPL | Stock | 165.2 | 165.29 | 165.2 | 165.29 | 1385.0 |
| 2024-04-23 06:00:00 | AAPL | Stock | 165.31 | 165.31 | 165.31 | 165.31 | 100.0 |
| 2024-04-23 06:05:00 | AAPL | Stock | 165.22 | 165.22 | 165.22 | 165.22 | 171.0 |
| 2024-04-23 06:10:00 | AAPL | Stock | 165.28 | 165.28 | 165.2 | 165.22 | 5916.0 |
| 2024-04-23 06:15:00 | AAPL | Stock | 165.21 | 165.21 | 165.2 | 165.2 | 400.0 |
| 2024-04-23 06:25:00 | AAPL | Stock | 165.2 | 165.2 | 165.18 | 165.18 | 1570.0 |
| 2024-04-23 06:30:00 | AAPL | Stock | 165.18 | 165.25 | 165.18 | 165.25 | 903.0 |
| 2024-04-23 06:35:00 | AAPL | Stock | 165.22 | 165.3 | 165.22 | 165.3 | 2345.0 |
| 2024-04-23 06:40:00 | AAPL | Stock | 165.36 | 165.36 | 165.2 | 165.34 | 3699.0 |
| 2024-04-23 06:45:00 | AAPL | Stock | 165.21 | 165.21 | 165.1 | 165.11 | 1218.0 |
| 2024-04-23 06:50:00 | AAPL | Stock | 165.27 | 165.5 | 165.27 | 165.5 | 4645.0 |
| 2024-04-23 06:55:00 | AAPL | Stock | 165.5 | 165.6 | 165.5 | 165.5 | 4247.0 |
| 2024-04-23 07:00:00 | AAPL | Stock | 165.55 | 165.55 | 165.41 | 165.5 | 3078.0 |
| 2024-04-23 07:05:00 | AAPL | Stock | 165.4 | 165.51 | 165.4 | 165.5 | 2271.0 |
| 2024-04-23 07:10:00 | AAPL | Stock | 165.53 | 165.87 | 165.53 | 165.87 | 5371.0 |
| 2024-04-23 07:15:00 | AAPL | Stock | 165.75 | 165.83 | 165.34 | 165.34 | 6119.0 |
| 2024-04-23 07:20:00 | AAPL | Stock | 165.34 | 165.43 | 165.25 | 165.4 | 3576.0 |
| 2024-04-23 07:25:00 | AAPL | Stock | 165.35 | 165.42 | 165.2 | 165.2 | 3022.0 |
| 2024-04-23 07:30:00 | AAPL | Stock | 165.21 | 165.31 | 165.18 | 165.25 | 954.0 |
| 2024-04-23 07:35:00 | AAPL | Stock | 165.4 | 166.0 | 165.35 | 165.8 | 18402.0 |
| 2024-04-23 07:40:00 | AAPL | Stock | 165.75 | 166.25 | 165.7 | 165.81 | 16817.0 |
| 2024-04-23 07:45:00 | AAPL | Stock | 165.7 | 165.71 | 165.61 | 165.61 | 2181.0 |
| 2024-04-23 07:50:00 | AAPL | Stock | 165.68 | 165.69 | 165.6 | 165.66 | 3731.0 |
| 2024-04-23 07:55:00 | AAPL | Stock | 165.71 | 165.71 | 165.6 | 165.6 | 5407.0 |
| 2024-04-23 08:00:00 | AAPL | Stock | 165.7 | 166.14 | 164.81 | 165.51 | 51871.0 |
| 2024-04-23 08:05:00 | AAPL | Stock | 165.6032 | 165.6032 | 165.34 | 165.34 | 3555.0 |
| 2024-04-23 08:10:00 | AAPL | Stock | 165.37 | 165.45 | 165.27 | 165.27 | 3536.0 |
| 2024-04-23 08:15:00 | AAPL | Stock | 165.36 | 165.36 | 165.11 | 165.15 | 20966.0 |
> showing 50 of 393,988 rows — these rows as CSV