PREVIEW / stock_5min / 2024-09-06
file: by_date/stock_5min/2024/2024-09-06.parquet size: 6.4 MB rows: 389,728 symbols: 802
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-06 04:00:00 | AAPL | Stock | 219.0 | 221.87 | 219.0 | 220.86 | 2856.0 |
| 2024-09-06 04:05:00 | AAPL | Stock | 221.07 | 221.24 | 221.02 | 221.24 | 1104.0 |
| 2024-09-06 04:10:00 | AAPL | Stock | 221.27 | 221.32 | 221.27 | 221.28 | 904.0 |
| 2024-09-06 04:20:00 | AAPL | Stock | 221.37 | 221.4 | 221.31 | 221.4 | 1383.0 |
| 2024-09-06 04:25:00 | AAPL | Stock | 221.55 | 221.55 | 221.55 | 221.55 | 182.0 |
| 2024-09-06 04:35:00 | AAPL | Stock | 221.55 | 221.55 | 221.55 | 221.55 | 474.0 |
| 2024-09-06 04:40:00 | AAPL | Stock | 221.3 | 221.3 | 221.3 | 221.3 | 983.0 |
| 2024-09-06 04:45:00 | AAPL | Stock | 221.22 | 221.22 | 221.22 | 221.22 | 440.0 |
| 2024-09-06 05:00:00 | AAPL | Stock | 221.17 | 221.17 | 221.17 | 221.17 | 200.0 |
| 2024-09-06 05:05:00 | AAPL | Stock | 221.13 | 221.13 | 221.13 | 221.13 | 275.0 |
| 2024-09-06 05:15:00 | AAPL | Stock | 220.99 | 220.99 | 220.71 | 220.71 | 600.0 |
| 2024-09-06 05:20:00 | AAPL | Stock | 221.0 | 221.0 | 221.0 | 221.0 | 195.0 |
| 2024-09-06 05:25:00 | AAPL | Stock | 221.18 | 221.18 | 221.18 | 221.18 | 207.0 |
| 2024-09-06 05:30:00 | AAPL | Stock | 221.03 | 221.03 | 221.03 | 221.03 | 181.0 |
| 2024-09-06 05:35:00 | AAPL | Stock | 221.2 | 221.2 | 221.18 | 221.18 | 200.0 |
| 2024-09-06 05:40:00 | AAPL | Stock | 221.13 | 221.14 | 221.13 | 221.14 | 309.0 |
| 2024-09-06 05:45:00 | AAPL | Stock | 221.13 | 221.24 | 221.13 | 221.24 | 477.0 |
| 2024-09-06 05:50:00 | AAPL | Stock | 221.24 | 221.24 | 221.24 | 221.24 | 225.0 |
| 2024-09-06 06:05:00 | AAPL | Stock | 221.25 | 221.25 | 221.25 | 221.25 | 100.0 |
| 2024-09-06 06:10:00 | AAPL | Stock | 221.29 | 221.3 | 221.29 | 221.3 | 400.0 |
| 2024-09-06 06:20:00 | AAPL | Stock | 221.27 | 221.27 | 221.27 | 221.27 | 450.0 |
| 2024-09-06 06:30:00 | AAPL | Stock | 221.22 | 221.22 | 221.22 | 221.22 | 100.0 |
| 2024-09-06 06:40:00 | AAPL | Stock | 221.2 | 221.2 | 221.17 | 221.17 | 232.0 |
| 2024-09-06 06:45:00 | AAPL | Stock | 221.0 | 221.0 | 221.0 | 221.0 | 455.0 |
| 2024-09-06 06:55:00 | AAPL | Stock | 220.95 | 220.95 | 220.95 | 220.95 | 107.0 |
| 2024-09-06 07:00:00 | AAPL | Stock | 221.09 | 222.1 | 221.0 | 221.5 | 9835.0 |
| 2024-09-06 07:05:00 | AAPL | Stock | 221.51 | 221.55 | 221.42 | 221.42 | 1160.0 |
| 2024-09-06 07:10:00 | AAPL | Stock | 221.59 | 221.59 | 221.39 | 221.4 | 1310.0 |
| 2024-09-06 07:15:00 | AAPL | Stock | 221.45 | 221.45 | 221.45 | 221.45 | 320.0 |
| 2024-09-06 07:25:00 | AAPL | Stock | 221.5 | 221.5 | 221.25 | 221.25 | 2624.0 |
| 2024-09-06 07:30:00 | AAPL | Stock | 221.32 | 221.55 | 221.32 | 221.55 | 2333.0 |
| 2024-09-06 07:35:00 | AAPL | Stock | 221.41 | 221.42 | 221.4 | 221.4 | 651.0 |
| 2024-09-06 07:40:00 | AAPL | Stock | 221.41 | 221.42 | 220.95 | 221.0 | 12427.0 |
| 2024-09-06 07:45:00 | AAPL | Stock | 220.99 | 221.0 | 220.9 | 221.0 | 2788.0 |
| 2024-09-06 07:50:00 | AAPL | Stock | 221.0 | 221.0 | 220.99 | 221.0 | 3201.0 |
| 2024-09-06 07:55:00 | AAPL | Stock | 221.29 | 221.35 | 221.11 | 221.35 | 2072.0 |
| 2024-09-06 08:00:00 | AAPL | Stock | 221.8256 | 222.02 | 220.85 | 221.75 | 27526.0 |
| 2024-09-06 08:05:00 | AAPL | Stock | 221.64 | 221.7779 | 221.51 | 221.51 | 5934.0 |
| 2024-09-06 08:10:00 | AAPL | Stock | 221.3501 | 221.5622 | 221.29 | 221.5622 | 4275.0 |
| 2024-09-06 08:15:00 | AAPL | Stock | 221.3 | 221.59 | 221.3 | 221.59 | 3308.0 |
| 2024-09-06 08:20:00 | AAPL | Stock | 221.48 | 221.66 | 221.48 | 221.66 | 1096.0 |
| 2024-09-06 08:25:00 | AAPL | Stock | 221.7 | 222.0 | 221.6435 | 221.86 | 6156.0 |
| 2024-09-06 08:30:00 | AAPL | Stock | 221.48 | 222.95 | 220.96 | 222.21 | 50178.0 |
| 2024-09-06 08:35:00 | AAPL | Stock | 222.22 | 223.0 | 222.21 | 222.9 | 53969.0 |
| 2024-09-06 08:40:00 | AAPL | Stock | 222.89 | 222.95 | 222.4613 | 222.51 | 35660.0 |
| 2024-09-06 08:45:00 | AAPL | Stock | 222.49 | 223.48 | 222.2203 | 223.4497 | 25580.0 |
| 2024-09-06 08:50:00 | AAPL | Stock | 223.42 | 223.652 | 223.001 | 223.0185 | 33080.0 |
| 2024-09-06 08:55:00 | AAPL | Stock | 223.18 | 223.45 | 223.12 | 223.4 | 12817.0 |
| 2024-09-06 09:00:00 | AAPL | Stock | 223.38 | 223.5 | 223.0765 | 223.3 | 15678.0 |
| 2024-09-06 09:05:00 | AAPL | Stock | 223.3 | 223.5892 | 223.3 | 223.42 | 8179.0 |
> showing 50 of 389,728 rows — these rows as CSV