PREVIEW / stock_5min / 2024-02-06
file: by_date/stock_5min/2024/2024-02-06.parquet size: 6.6 MB rows: 399,408 symbols: 1,151
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-06 04:00:00 | AAPL | Stock | 188.4 | 188.4 | 187.95 | 188.0 | 1588.0 |
| 2024-02-06 04:05:00 | AAPL | Stock | 188.13 | 188.15 | 188.13 | 188.15 | 2165.0 |
| 2024-02-06 04:10:00 | AAPL | Stock | 188.15 | 188.15 | 188.09 | 188.1 | 1638.0 |
| 2024-02-06 04:15:00 | AAPL | Stock | 188.08 | 188.09 | 188.08 | 188.09 | 200.0 |
| 2024-02-06 04:20:00 | AAPL | Stock | 188.08 | 188.08 | 187.94 | 187.94 | 2400.0 |
| 2024-02-06 04:25:00 | AAPL | Stock | 187.9 | 187.9 | 187.9 | 187.9 | 284.0 |
| 2024-02-06 04:30:00 | AAPL | Stock | 187.92 | 187.92 | 187.8 | 187.85 | 2516.0 |
| 2024-02-06 04:45:00 | AAPL | Stock | 187.98 | 187.98 | 187.95 | 187.95 | 593.0 |
| 2024-02-06 04:55:00 | AAPL | Stock | 187.87 | 187.88 | 187.87 | 187.88 | 426.0 |
| 2024-02-06 05:00:00 | AAPL | Stock | 187.86 | 187.86 | 187.8 | 187.8 | 1431.0 |
| 2024-02-06 05:05:00 | AAPL | Stock | 187.92 | 187.92 | 187.83 | 187.83 | 546.0 |
| 2024-02-06 05:15:00 | AAPL | Stock | 187.86 | 187.86 | 187.86 | 187.86 | 100.0 |
| 2024-02-06 05:20:00 | AAPL | Stock | 187.88 | 187.88 | 187.81 | 187.81 | 938.0 |
| 2024-02-06 05:25:00 | AAPL | Stock | 187.83 | 187.83 | 187.83 | 187.83 | 100.0 |
| 2024-02-06 05:30:00 | AAPL | Stock | 187.8 | 187.8 | 187.7 | 187.72 | 1448.0 |
| 2024-02-06 05:35:00 | AAPL | Stock | 187.73 | 187.73 | 187.67 | 187.67 | 400.0 |
| 2024-02-06 05:40:00 | AAPL | Stock | 187.72 | 187.73 | 187.72 | 187.73 | 628.0 |
| 2024-02-06 05:45:00 | AAPL | Stock | 187.68 | 187.71 | 187.68 | 187.7 | 996.0 |
| 2024-02-06 05:50:00 | AAPL | Stock | 187.72 | 187.89 | 187.7 | 187.89 | 1819.0 |
| 2024-02-06 06:10:00 | AAPL | Stock | 187.95 | 188.09 | 187.95 | 188.09 | 1592.0 |
| 2024-02-06 06:15:00 | AAPL | Stock | 188.28 | 188.28 | 188.08 | 188.08 | 2132.0 |
| 2024-02-06 06:20:00 | AAPL | Stock | 188.2 | 188.22 | 188.2 | 188.22 | 300.0 |
| 2024-02-06 06:25:00 | AAPL | Stock | 188.09 | 188.09 | 188.08 | 188.09 | 780.0 |
| 2024-02-06 06:30:00 | AAPL | Stock | 188.07 | 188.08 | 188.01 | 188.01 | 620.0 |
| 2024-02-06 06:35:00 | AAPL | Stock | 187.88 | 187.88 | 187.77 | 187.77 | 1920.0 |
| 2024-02-06 06:40:00 | AAPL | Stock | 187.8 | 187.81 | 187.79 | 187.81 | 616.0 |
| 2024-02-06 06:45:00 | AAPL | Stock | 187.69 | 187.73 | 187.63 | 187.64 | 2233.0 |
| 2024-02-06 06:50:00 | AAPL | Stock | 187.6 | 187.7 | 187.6 | 187.66 | 1639.0 |
| 2024-02-06 07:00:00 | AAPL | Stock | 187.8 | 187.81 | 187.72 | 187.72 | 2958.0 |
| 2024-02-06 07:05:00 | AAPL | Stock | 187.73 | 187.83 | 187.71 | 187.83 | 4152.0 |
| 2024-02-06 07:10:00 | AAPL | Stock | 187.81 | 187.82 | 187.8 | 187.8 | 1465.0 |
| 2024-02-06 07:20:00 | AAPL | Stock | 187.75 | 187.75 | 187.5 | 187.55 | 7099.0 |
| 2024-02-06 07:25:00 | AAPL | Stock | 187.5 | 187.53 | 187.5 | 187.53 | 2134.0 |
| 2024-02-06 07:30:00 | AAPL | Stock | 187.5 | 187.51 | 187.5 | 187.5 | 650.0 |
| 2024-02-06 07:35:00 | AAPL | Stock | 187.46 | 187.46 | 187.33 | 187.35 | 1715.0 |
| 2024-02-06 07:40:00 | AAPL | Stock | 187.43 | 187.5 | 187.37 | 187.5 | 1744.0 |
| 2024-02-06 07:45:00 | AAPL | Stock | 187.55 | 187.6 | 187.55 | 187.55 | 1894.0 |
| 2024-02-06 07:50:00 | AAPL | Stock | 187.64 | 187.64 | 187.58 | 187.6 | 1104.0 |
| 2024-02-06 07:55:00 | AAPL | Stock | 187.56 | 187.56 | 187.55 | 187.55 | 906.0 |
| 2024-02-06 08:00:00 | AAPL | Stock | 187.8 | 188.24 | 187.2703 | 188.1 | 35678.0 |
| 2024-02-06 08:05:00 | AAPL | Stock | 187.75 | 187.75 | 187.6499 | 187.65 | 5890.0 |
| 2024-02-06 08:10:00 | AAPL | Stock | 187.67 | 187.7357 | 187.67 | 187.73 | 3668.0 |
| 2024-02-06 08:15:00 | AAPL | Stock | 187.73 | 187.73 | 187.69 | 187.7298 | 4143.0 |
| 2024-02-06 08:20:00 | AAPL | Stock | 187.73 | 187.75 | 187.6206 | 187.68 | 6594.0 |
| 2024-02-06 08:25:00 | AAPL | Stock | 187.74 | 187.75 | 187.69 | 187.69 | 2627.0 |
| 2024-02-06 08:30:00 | AAPL | Stock | 187.65 | 187.74 | 187.6247 | 187.7375 | 2243.0 |
| 2024-02-06 08:35:00 | AAPL | Stock | 187.6346 | 187.68 | 187.6 | 187.6 | 1224.0 |
| 2024-02-06 08:40:00 | AAPL | Stock | 187.63 | 187.72 | 187.63 | 187.72 | 4422.0 |
| 2024-02-06 08:45:00 | AAPL | Stock | 187.7 | 187.73 | 187.68 | 187.68 | 1480.0 |
| 2024-02-06 08:50:00 | AAPL | Stock | 187.7 | 187.7 | 187.6 | 187.69 | 4141.0 |
> showing 50 of 399,408 rows — these rows as CSV