PREVIEW / stock_5min / 2024-02-20
file: by_date/stock_5min/2024/2024-02-20.parquet size: 6.9 MB rows: 416,226 symbols: 1,124
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-02-20 04:00:00 | AAPL | Stock | 181.7 | 181.9 | 181.5 | 181.64 | 3525.0 |
| 2024-02-20 04:05:00 | AAPL | Stock | 181.64 | 181.68 | 181.51 | 181.51 | 1451.0 |
| 2024-02-20 04:10:00 | AAPL | Stock | 181.51 | 181.62 | 181.51 | 181.62 | 657.0 |
| 2024-02-20 04:15:00 | AAPL | Stock | 181.62 | 181.72 | 181.62 | 181.71 | 811.0 |
| 2024-02-20 04:20:00 | AAPL | Stock | 181.66 | 181.66 | 181.66 | 181.66 | 100.0 |
| 2024-02-20 04:25:00 | AAPL | Stock | 181.59 | 181.6 | 181.5 | 181.51 | 1830.0 |
| 2024-02-20 04:30:00 | AAPL | Stock | 181.43 | 181.51 | 181.28 | 181.28 | 6078.0 |
| 2024-02-20 04:35:00 | AAPL | Stock | 181.39 | 181.39 | 181.31 | 181.31 | 380.0 |
| 2024-02-20 04:40:00 | AAPL | Stock | 181.35 | 181.35 | 181.25 | 181.35 | 1866.0 |
| 2024-02-20 04:45:00 | AAPL | Stock | 181.3 | 181.3 | 181.15 | 181.16 | 1244.0 |
| 2024-02-20 04:50:00 | AAPL | Stock | 181.15 | 181.33 | 181.15 | 181.32 | 1137.0 |
| 2024-02-20 04:55:00 | AAPL | Stock | 181.48 | 181.48 | 181.47 | 181.48 | 956.0 |
| 2024-02-20 05:00:00 | AAPL | Stock | 181.32 | 181.44 | 181.32 | 181.39 | 1133.0 |
| 2024-02-20 05:05:00 | AAPL | Stock | 181.28 | 181.28 | 181.15 | 181.15 | 1323.0 |
| 2024-02-20 05:15:00 | AAPL | Stock | 181.21 | 181.22 | 181.16 | 181.16 | 550.0 |
| 2024-02-20 05:20:00 | AAPL | Stock | 181.2 | 181.2 | 181.2 | 181.2 | 106.0 |
| 2024-02-20 05:40:00 | AAPL | Stock | 181.27 | 181.27 | 181.27 | 181.27 | 200.0 |
| 2024-02-20 05:45:00 | AAPL | Stock | 181.3 | 181.38 | 181.3 | 181.38 | 1336.0 |
| 2024-02-20 05:50:00 | AAPL | Stock | 181.36 | 181.39 | 181.32 | 181.32 | 652.0 |
| 2024-02-20 05:55:00 | AAPL | Stock | 181.34 | 181.43 | 181.34 | 181.38 | 1236.0 |
| 2024-02-20 06:00:00 | AAPL | Stock | 181.4 | 181.4 | 181.31 | 181.31 | 1329.0 |
| 2024-02-20 06:05:00 | AAPL | Stock | 181.34 | 181.35 | 181.34 | 181.35 | 231.0 |
| 2024-02-20 06:10:00 | AAPL | Stock | 181.25 | 181.37 | 181.25 | 181.33 | 1684.0 |
| 2024-02-20 06:15:00 | AAPL | Stock | 181.33 | 181.47 | 181.33 | 181.43 | 936.0 |
| 2024-02-20 06:20:00 | AAPL | Stock | 181.49 | 181.49 | 181.43 | 181.43 | 250.0 |
| 2024-02-20 06:25:00 | AAPL | Stock | 181.5 | 181.5 | 181.49 | 181.49 | 200.0 |
| 2024-02-20 06:30:00 | AAPL | Stock | 181.5 | 181.5 | 181.5 | 181.5 | 308.0 |
| 2024-02-20 06:40:00 | AAPL | Stock | 181.54 | 181.54 | 181.54 | 181.54 | 100.0 |
| 2024-02-20 06:45:00 | AAPL | Stock | 181.59 | 181.65 | 181.59 | 181.62 | 1854.0 |
| 2024-02-20 06:50:00 | AAPL | Stock | 181.58 | 181.58 | 181.58 | 181.58 | 471.0 |
| 2024-02-20 06:55:00 | AAPL | Stock | 181.59 | 181.59 | 181.59 | 181.59 | 375.0 |
| 2024-02-20 07:00:00 | AAPL | Stock | 181.65 | 181.66 | 181.5 | 181.66 | 4675.0 |
| 2024-02-20 07:05:00 | AAPL | Stock | 181.65 | 181.75 | 181.62 | 181.73 | 2414.0 |
| 2024-02-20 07:10:00 | AAPL | Stock | 181.72 | 182.0 | 181.72 | 182.0 | 7103.0 |
| 2024-02-20 07:15:00 | AAPL | Stock | 181.98 | 182.05 | 181.76 | 181.76 | 3858.0 |
| 2024-02-20 07:20:00 | AAPL | Stock | 181.77 | 181.82 | 181.77 | 181.82 | 935.0 |
| 2024-02-20 07:25:00 | AAPL | Stock | 181.84 | 181.84 | 181.83 | 181.83 | 450.0 |
| 2024-02-20 07:30:00 | AAPL | Stock | 181.79 | 181.8 | 181.75 | 181.75 | 1246.0 |
| 2024-02-20 07:35:00 | AAPL | Stock | 181.8 | 181.86 | 181.8 | 181.86 | 733.0 |
| 2024-02-20 07:40:00 | AAPL | Stock | 181.81 | 181.88 | 181.8 | 181.8 | 2872.0 |
| 2024-02-20 07:45:00 | AAPL | Stock | 181.82 | 181.85 | 181.79 | 181.79 | 1513.0 |
| 2024-02-20 07:50:00 | AAPL | Stock | 181.83 | 181.88 | 181.83 | 181.84 | 2518.0 |
| 2024-02-20 07:55:00 | AAPL | Stock | 181.89 | 181.9 | 181.89 | 181.89 | 556.0 |
| 2024-02-20 08:00:00 | AAPL | Stock | 181.9 | 182.0 | 181.14 | 181.89 | 26346.0 |
| 2024-02-20 08:05:00 | AAPL | Stock | 181.855 | 181.855 | 181.38 | 181.78 | 1830.0 |
| 2024-02-20 08:10:00 | AAPL | Stock | 181.82 | 181.82 | 181.79 | 181.79 | 850.0 |
| 2024-02-20 08:15:00 | AAPL | Stock | 181.83 | 181.9 | 181.78 | 181.9 | 5765.0 |
| 2024-02-20 08:20:00 | AAPL | Stock | 181.92 | 181.92 | 181.77 | 181.83 | 7395.0 |
| 2024-02-20 08:25:00 | AAPL | Stock | 181.89 | 181.89 | 181.7 | 181.7 | 7940.0 |
| 2024-02-20 08:30:00 | AAPL | Stock | 181.7 | 181.85 | 181.7 | 181.8 | 4463.0 |
> showing 50 of 416,226 rows — these rows as CSV