PREVIEW / stock_1min / 2024-01-22
file: by_date/stock_1min/2024/2024-01-22.parquet size: 21.3 MB rows: 1,271,774 symbols: 1,191
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-01-22 04:00:00 | AAPL | Stock | 192.18 | 192.18 | 191.56 | 191.93 | 1134.0 |
| 2024-01-22 04:01:00 | AAPL | Stock | 191.99 | 191.99 | 191.99 | 191.99 | 100.0 |
| 2024-01-22 04:02:00 | AAPL | Stock | 191.9 | 191.9 | 191.8 | 191.8 | 880.0 |
| 2024-01-22 04:03:00 | AAPL | Stock | 191.75 | 191.86 | 191.75 | 191.86 | 367.0 |
| 2024-01-22 04:05:00 | AAPL | Stock | 191.85 | 191.85 | 191.83 | 191.84 | 1048.0 |
| 2024-01-22 04:06:00 | AAPL | Stock | 191.73 | 191.79 | 191.73 | 191.75 | 806.0 |
| 2024-01-22 04:08:00 | AAPL | Stock | 191.81 | 191.81 | 191.8 | 191.8 | 248.0 |
| 2024-01-22 04:10:00 | AAPL | Stock | 191.87 | 191.87 | 191.86 | 191.86 | 475.0 |
| 2024-01-22 04:11:00 | AAPL | Stock | 191.8 | 191.8 | 191.8 | 191.8 | 163.0 |
| 2024-01-22 04:12:00 | AAPL | Stock | 191.8 | 191.8 | 191.8 | 191.8 | 528.0 |
| 2024-01-22 04:15:00 | AAPL | Stock | 191.79 | 191.79 | 191.79 | 191.79 | 100.0 |
| 2024-01-22 04:16:00 | AAPL | Stock | 191.8 | 191.8 | 191.8 | 191.8 | 125.0 |
| 2024-01-22 04:18:00 | AAPL | Stock | 191.85 | 191.85 | 191.8 | 191.8 | 668.0 |
| 2024-01-22 04:19:00 | AAPL | Stock | 191.85 | 191.85 | 191.85 | 191.85 | 775.0 |
| 2024-01-22 04:22:00 | AAPL | Stock | 191.89 | 191.89 | 191.89 | 191.89 | 100.0 |
| 2024-01-22 04:36:00 | AAPL | Stock | 191.85 | 191.85 | 191.85 | 191.85 | 100.0 |
| 2024-01-22 04:38:00 | AAPL | Stock | 191.89 | 191.89 | 191.84 | 191.84 | 770.0 |
| 2024-01-22 04:39:00 | AAPL | Stock | 191.85 | 191.85 | 191.85 | 191.85 | 600.0 |
| 2024-01-22 04:40:00 | AAPL | Stock | 191.85 | 191.85 | 191.85 | 191.85 | 916.0 |
| 2024-01-22 04:43:00 | AAPL | Stock | 191.87 | 191.87 | 191.87 | 191.87 | 1186.0 |
| 2024-01-22 04:44:00 | AAPL | Stock | 191.89 | 191.89 | 191.87 | 191.87 | 665.0 |
| 2024-01-22 04:45:00 | AAPL | Stock | 191.86 | 191.86 | 191.86 | 191.86 | 174.0 |
| 2024-01-22 04:46:00 | AAPL | Stock | 191.84 | 191.84 | 191.84 | 191.84 | 353.0 |
| 2024-01-22 04:50:00 | AAPL | Stock | 191.81 | 191.82 | 191.81 | 191.82 | 328.0 |
| 2024-01-22 04:51:00 | AAPL | Stock | 191.86 | 191.86 | 191.86 | 191.86 | 276.0 |
| 2024-01-22 04:52:00 | AAPL | Stock | 191.83 | 191.83 | 191.83 | 191.83 | 100.0 |
| 2024-01-22 04:53:00 | AAPL | Stock | 191.83 | 191.83 | 191.83 | 191.83 | 363.0 |
| 2024-01-22 04:54:00 | AAPL | Stock | 191.87 | 191.88 | 191.87 | 191.88 | 925.0 |
| 2024-01-22 04:55:00 | AAPL | Stock | 191.88 | 191.88 | 191.86 | 191.86 | 756.0 |
| 2024-01-22 04:56:00 | AAPL | Stock | 191.88 | 191.88 | 191.88 | 191.88 | 800.0 |
| 2024-01-22 04:57:00 | AAPL | Stock | 191.88 | 191.9 | 191.88 | 191.9 | 729.0 |
| 2024-01-22 04:58:00 | AAPL | Stock | 191.92 | 191.92 | 191.92 | 191.92 | 440.0 |
| 2024-01-22 05:02:00 | AAPL | Stock | 191.92 | 191.93 | 191.92 | 191.92 | 3035.0 |
| 2024-01-22 05:03:00 | AAPL | Stock | 191.91 | 191.92 | 191.9 | 191.92 | 525.0 |
| 2024-01-22 05:04:00 | AAPL | Stock | 191.93 | 191.93 | 191.93 | 191.93 | 100.0 |
| 2024-01-22 05:05:00 | AAPL | Stock | 191.93 | 191.93 | 191.9 | 191.9 | 300.0 |
| 2024-01-22 05:06:00 | AAPL | Stock | 191.9 | 191.9 | 191.9 | 191.9 | 375.0 |
| 2024-01-22 05:07:00 | AAPL | Stock | 191.92 | 191.92 | 191.92 | 191.92 | 263.0 |
| 2024-01-22 05:09:00 | AAPL | Stock | 191.92 | 191.92 | 191.92 | 191.92 | 163.0 |
| 2024-01-22 05:10:00 | AAPL | Stock | 191.91 | 191.91 | 191.91 | 191.91 | 105.0 |
| 2024-01-22 05:11:00 | AAPL | Stock | 191.93 | 191.95 | 191.92 | 191.95 | 363.0 |
| 2024-01-22 05:12:00 | AAPL | Stock | 191.95 | 191.95 | 191.94 | 191.95 | 782.0 |
| 2024-01-22 05:13:00 | AAPL | Stock | 191.95 | 192.0 | 191.95 | 192.0 | 4088.0 |
| 2024-01-22 05:15:00 | AAPL | Stock | 192.11 | 192.11 | 192.11 | 192.11 | 100.0 |
| 2024-01-22 05:16:00 | AAPL | Stock | 192.13 | 192.13 | 192.13 | 192.13 | 152.0 |
| 2024-01-22 05:18:00 | AAPL | Stock | 192.02 | 192.02 | 192.02 | 192.02 | 108.0 |
| 2024-01-22 05:20:00 | AAPL | Stock | 192.07 | 192.07 | 192.07 | 192.07 | 100.0 |
| 2024-01-22 05:22:00 | AAPL | Stock | 192.02 | 192.02 | 192.02 | 192.02 | 100.0 |
| 2024-01-22 05:23:00 | AAPL | Stock | 192.07 | 192.07 | 192.07 | 192.07 | 449.0 |
| 2024-01-22 05:24:00 | AAPL | Stock | 192.05 | 192.06 | 192.05 | 192.06 | 495.0 |
> showing 50 of 1,271,774 rows — these rows as CSV