PREVIEW / stock_5min / 2024-06-05
file: by_date/stock_5min/2024/2024-06-05.parquet size: 6.7 MB rows: 398,552 symbols: 981
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-06-05 04:00:00 | AAPL | Stock | 194.99 | 195.1 | 194.99 | 195.0 | 1027.0 |
| 2024-06-05 04:05:00 | AAPL | Stock | 195.03 | 195.03 | 195.03 | 195.03 | 449.0 |
| 2024-06-05 04:10:00 | AAPL | Stock | 195.0 | 195.2 | 195.0 | 195.11 | 2809.0 |
| 2024-06-05 04:15:00 | AAPL | Stock | 195.15 | 195.2 | 194.8 | 194.8 | 2283.0 |
| 2024-06-05 04:20:00 | AAPL | Stock | 194.73 | 194.8 | 194.7 | 194.79 | 1945.0 |
| 2024-06-05 04:30:00 | AAPL | Stock | 194.82 | 194.84 | 194.82 | 194.82 | 509.0 |
| 2024-06-05 04:35:00 | AAPL | Stock | 194.81 | 194.85 | 194.81 | 194.85 | 250.0 |
| 2024-06-05 04:45:00 | AAPL | Stock | 194.9 | 194.9 | 194.9 | 194.9 | 117.0 |
| 2024-06-05 04:50:00 | AAPL | Stock | 194.85 | 194.85 | 194.81 | 194.81 | 253.0 |
| 2024-06-05 04:55:00 | AAPL | Stock | 194.81 | 194.81 | 194.81 | 194.81 | 100.0 |
| 2024-06-05 05:00:00 | AAPL | Stock | 194.85 | 194.9 | 194.85 | 194.9 | 1933.0 |
| 2024-06-05 05:05:00 | AAPL | Stock | 194.94 | 194.95 | 194.9 | 194.95 | 952.0 |
| 2024-06-05 05:10:00 | AAPL | Stock | 194.95 | 194.95 | 194.91 | 194.91 | 1421.0 |
| 2024-06-05 05:15:00 | AAPL | Stock | 194.84 | 194.86 | 194.84 | 194.86 | 550.0 |
| 2024-06-05 05:20:00 | AAPL | Stock | 194.92 | 194.92 | 194.82 | 194.82 | 200.0 |
| 2024-06-05 05:25:00 | AAPL | Stock | 194.75 | 194.8 | 194.71 | 194.8 | 785.0 |
| 2024-06-05 05:30:00 | AAPL | Stock | 194.68 | 194.68 | 194.68 | 194.68 | 100.0 |
| 2024-06-05 05:35:00 | AAPL | Stock | 194.68 | 194.68 | 194.58 | 194.58 | 8067.0 |
| 2024-06-05 05:45:00 | AAPL | Stock | 194.75 | 194.75 | 194.72 | 194.72 | 685.0 |
| 2024-06-05 05:50:00 | AAPL | Stock | 194.79 | 194.79 | 194.72 | 194.79 | 450.0 |
| 2024-06-05 06:00:00 | AAPL | Stock | 194.67 | 194.72 | 194.64 | 194.72 | 519.0 |
| 2024-06-05 06:05:00 | AAPL | Stock | 194.71 | 194.71 | 194.71 | 194.71 | 117.0 |
| 2024-06-05 06:15:00 | AAPL | Stock | 194.8 | 194.83 | 194.8 | 194.83 | 200.0 |
| 2024-06-05 06:20:00 | AAPL | Stock | 194.83 | 194.88 | 194.8 | 194.88 | 440.0 |
| 2024-06-05 06:25:00 | AAPL | Stock | 194.88 | 194.9 | 194.88 | 194.9 | 1305.0 |
| 2024-06-05 06:30:00 | AAPL | Stock | 194.9 | 194.9 | 194.76 | 194.76 | 1112.0 |
| 2024-06-05 06:35:00 | AAPL | Stock | 194.79 | 194.95 | 194.79 | 194.95 | 1999.0 |
| 2024-06-05 06:40:00 | AAPL | Stock | 194.91 | 194.91 | 194.91 | 194.91 | 100.0 |
| 2024-06-05 06:45:00 | AAPL | Stock | 194.78 | 194.94 | 194.78 | 194.8 | 2744.0 |
| 2024-06-05 06:50:00 | AAPL | Stock | 194.81 | 194.83 | 194.73 | 194.73 | 2753.0 |
| 2024-06-05 06:55:00 | AAPL | Stock | 194.73 | 194.73 | 194.61 | 194.61 | 1975.0 |
| 2024-06-05 07:00:00 | AAPL | Stock | 194.82 | 194.93 | 194.75 | 194.8 | 3792.0 |
| 2024-06-05 07:05:00 | AAPL | Stock | 194.71 | 194.73 | 194.71 | 194.73 | 266.0 |
| 2024-06-05 07:10:00 | AAPL | Stock | 194.8 | 194.83 | 194.72 | 194.83 | 2480.0 |
| 2024-06-05 07:15:00 | AAPL | Stock | 194.81 | 194.9 | 194.72 | 194.72 | 10679.0 |
| 2024-06-05 07:20:00 | AAPL | Stock | 194.8 | 194.8 | 194.72 | 194.74 | 3796.0 |
| 2024-06-05 07:25:00 | AAPL | Stock | 194.84 | 194.84 | 194.84 | 194.84 | 1066.0 |
| 2024-06-05 07:30:00 | AAPL | Stock | 194.81 | 194.81 | 194.75 | 194.75 | 1764.0 |
| 2024-06-05 07:35:00 | AAPL | Stock | 194.74 | 194.76 | 194.7 | 194.76 | 1230.0 |
| 2024-06-05 07:40:00 | AAPL | Stock | 194.76 | 194.8 | 194.76 | 194.8 | 200.0 |
| 2024-06-05 07:45:00 | AAPL | Stock | 194.75 | 194.8 | 194.75 | 194.8 | 1590.0 |
| 2024-06-05 07:50:00 | AAPL | Stock | 194.88 | 194.88 | 194.88 | 194.88 | 100.0 |
| 2024-06-05 07:55:00 | AAPL | Stock | 194.86 | 194.86 | 194.81 | 194.83 | 3315.0 |
| 2024-06-05 08:00:00 | AAPL | Stock | 194.79 | 195.04 | 194.6678 | 194.81 | 35525.0 |
| 2024-06-05 08:05:00 | AAPL | Stock | 195.0 | 195.04 | 194.8 | 194.86 | 6409.0 |
| 2024-06-05 08:10:00 | AAPL | Stock | 194.9 | 194.91 | 194.85 | 194.85 | 1404.0 |
| 2024-06-05 08:15:00 | AAPL | Stock | 194.95 | 194.98 | 194.8 | 194.9 | 9396.0 |
| 2024-06-05 08:20:00 | AAPL | Stock | 194.91 | 194.9198 | 194.8 | 194.86 | 2040.0 |
| 2024-06-05 08:25:00 | AAPL | Stock | 194.861 | 195.0 | 194.86 | 195.0 | 5257.0 |
| 2024-06-05 08:30:00 | AAPL | Stock | 195.0 | 195.03 | 194.8 | 194.88 | 11449.0 |
> showing 50 of 398,552 rows — these rows as CSV