PREVIEW / stock_5min / 2024-03-08
file: by_date/stock_5min/2024/2024-03-08.parquet size: 6.8 MB rows: 409,828 symbols: 1,099
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-03-08 04:00:00 | AAPL | Stock | 169.6 | 169.6 | 169.29 | 169.38 | 6113.0 |
| 2024-03-08 04:05:00 | AAPL | Stock | 169.38 | 169.39 | 169.38 | 169.38 | 3521.0 |
| 2024-03-08 04:10:00 | AAPL | Stock | 169.39 | 169.39 | 169.38 | 169.39 | 1013.0 |
| 2024-03-08 04:15:00 | AAPL | Stock | 169.39 | 169.4 | 169.38 | 169.4 | 2627.0 |
| 2024-03-08 04:25:00 | AAPL | Stock | 169.38 | 169.4 | 169.37 | 169.4 | 1124.0 |
| 2024-03-08 04:30:00 | AAPL | Stock | 169.38 | 169.4 | 169.38 | 169.4 | 1090.0 |
| 2024-03-08 04:35:00 | AAPL | Stock | 169.4 | 169.47 | 169.4 | 169.47 | 793.0 |
| 2024-03-08 04:40:00 | AAPL | Stock | 169.57 | 169.59 | 169.52 | 169.52 | 1635.0 |
| 2024-03-08 04:45:00 | AAPL | Stock | 169.52 | 169.52 | 169.51 | 169.51 | 783.0 |
| 2024-03-08 04:50:00 | AAPL | Stock | 169.5 | 169.52 | 169.5 | 169.52 | 2421.0 |
| 2024-03-08 04:55:00 | AAPL | Stock | 169.49 | 169.49 | 169.49 | 169.49 | 100.0 |
| 2024-03-08 05:05:00 | AAPL | Stock | 169.46 | 169.48 | 169.46 | 169.46 | 904.0 |
| 2024-03-08 05:10:00 | AAPL | Stock | 169.51 | 169.51 | 169.47 | 169.47 | 1211.0 |
| 2024-03-08 05:15:00 | AAPL | Stock | 169.49 | 169.52 | 169.49 | 169.52 | 1343.0 |
| 2024-03-08 05:20:00 | AAPL | Stock | 169.5 | 169.52 | 169.5 | 169.52 | 440.0 |
| 2024-03-08 05:25:00 | AAPL | Stock | 169.59 | 169.59 | 169.5 | 169.56 | 1752.0 |
| 2024-03-08 05:30:00 | AAPL | Stock | 169.6 | 169.7 | 169.6 | 169.7 | 309.0 |
| 2024-03-08 05:35:00 | AAPL | Stock | 169.77 | 170.03 | 169.77 | 169.99 | 6737.0 |
| 2024-03-08 05:40:00 | AAPL | Stock | 170.01 | 170.12 | 169.98 | 170.12 | 1375.0 |
| 2024-03-08 05:45:00 | AAPL | Stock | 170.19 | 170.19 | 170.15 | 170.15 | 800.0 |
| 2024-03-08 05:50:00 | AAPL | Stock | 170.12 | 170.12 | 170.09 | 170.09 | 460.0 |
| 2024-03-08 05:55:00 | AAPL | Stock | 170.04 | 170.07 | 170.04 | 170.07 | 320.0 |
| 2024-03-08 06:00:00 | AAPL | Stock | 170.0 | 170.0 | 169.99 | 169.99 | 993.0 |
| 2024-03-08 06:05:00 | AAPL | Stock | 169.96 | 170.19 | 169.96 | 170.19 | 10404.0 |
| 2024-03-08 06:10:00 | AAPL | Stock | 170.2 | 170.28 | 170.2 | 170.26 | 2061.0 |
| 2024-03-08 06:15:00 | AAPL | Stock | 170.2 | 170.22 | 170.2 | 170.22 | 845.0 |
| 2024-03-08 06:20:00 | AAPL | Stock | 170.21 | 170.23 | 170.09 | 170.15 | 2766.0 |
| 2024-03-08 06:25:00 | AAPL | Stock | 170.14 | 170.14 | 169.88 | 169.88 | 1668.0 |
| 2024-03-08 06:30:00 | AAPL | Stock | 169.84 | 169.92 | 169.84 | 169.92 | 377.0 |
| 2024-03-08 06:35:00 | AAPL | Stock | 169.88 | 169.88 | 169.82 | 169.82 | 881.0 |
| 2024-03-08 06:40:00 | AAPL | Stock | 169.8 | 169.83 | 169.74 | 169.83 | 1874.0 |
| 2024-03-08 06:45:00 | AAPL | Stock | 169.7 | 169.7 | 169.7 | 169.7 | 200.0 |
| 2024-03-08 06:50:00 | AAPL | Stock | 169.7 | 169.72 | 169.63 | 169.72 | 667.0 |
| 2024-03-08 06:55:00 | AAPL | Stock | 169.64 | 169.65 | 169.64 | 169.65 | 1990.0 |
| 2024-03-08 07:00:00 | AAPL | Stock | 169.64 | 169.7 | 169.35 | 169.41 | 10680.0 |
| 2024-03-08 07:05:00 | AAPL | Stock | 169.43 | 169.45 | 169.35 | 169.43 | 3307.0 |
| 2024-03-08 07:10:00 | AAPL | Stock | 169.46 | 169.6 | 169.46 | 169.55 | 4841.0 |
| 2024-03-08 07:15:00 | AAPL | Stock | 169.54 | 169.54 | 169.4 | 169.4 | 3457.0 |
| 2024-03-08 07:20:00 | AAPL | Stock | 169.4 | 169.4 | 169.29 | 169.38 | 2632.0 |
| 2024-03-08 07:25:00 | AAPL | Stock | 169.4 | 169.4 | 169.36 | 169.38 | 2031.0 |
| 2024-03-08 07:30:00 | AAPL | Stock | 169.37 | 169.49 | 169.36 | 169.49 | 3693.0 |
| 2024-03-08 07:35:00 | AAPL | Stock | 169.45 | 169.49 | 169.45 | 169.45 | 3334.0 |
| 2024-03-08 07:40:00 | AAPL | Stock | 169.48 | 169.55 | 169.48 | 169.49 | 5972.0 |
| 2024-03-08 07:45:00 | AAPL | Stock | 169.49 | 169.6 | 169.49 | 169.6 | 2760.0 |
| 2024-03-08 07:50:00 | AAPL | Stock | 169.56 | 169.56 | 169.56 | 169.56 | 1300.0 |
| 2024-03-08 07:55:00 | AAPL | Stock | 169.6 | 169.72 | 169.6 | 169.72 | 3577.0 |
| 2024-03-08 08:00:00 | AAPL | Stock | 169.48 | 169.7492 | 169.08 | 169.34 | 71826.0 |
| 2024-03-08 08:05:00 | AAPL | Stock | 169.22 | 169.67 | 169.01 | 169.67 | 9191.0 |
| 2024-03-08 08:10:00 | AAPL | Stock | 169.62 | 169.78 | 169.62 | 169.78 | 12853.0 |
| 2024-03-08 08:15:00 | AAPL | Stock | 169.85 | 170.0 | 169.8 | 169.85 | 12918.0 |
> showing 50 of 409,828 rows — these rows as CSV