PREVIEW / stock_1min / 2024-07-02
file: by_date/stock_1min/2024/2024-07-02.parquet size: 19.7 MB rows: 1,188,490 symbols: 917
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-07-02 04:00:00 | AAPL | Stock | 216.5 | 216.5 | 215.99 | 216.25 | 1811.0 |
| 2024-07-02 04:01:00 | AAPL | Stock | 216.11 | 216.11 | 216.1 | 216.1 | 250.0 |
| 2024-07-02 04:02:00 | AAPL | Stock | 216.27 | 216.31 | 216.27 | 216.3 | 1077.0 |
| 2024-07-02 04:03:00 | AAPL | Stock | 216.3 | 216.38 | 216.3 | 216.38 | 774.0 |
| 2024-07-02 04:04:00 | AAPL | Stock | 216.3 | 216.3 | 216.1 | 216.1 | 2383.0 |
| 2024-07-02 04:08:00 | AAPL | Stock | 216.1 | 216.11 | 216.1 | 216.11 | 628.0 |
| 2024-07-02 04:09:00 | AAPL | Stock | 216.2 | 216.2 | 216.2 | 216.2 | 499.0 |
| 2024-07-02 04:11:00 | AAPL | Stock | 216.23 | 216.23 | 216.2 | 216.2 | 298.0 |
| 2024-07-02 04:16:00 | AAPL | Stock | 216.31 | 216.45 | 216.31 | 216.45 | 999.0 |
| 2024-07-02 04:17:00 | AAPL | Stock | 216.34 | 216.34 | 216.31 | 216.31 | 200.0 |
| 2024-07-02 04:20:00 | AAPL | Stock | 216.41 | 216.42 | 216.4 | 216.4 | 450.0 |
| 2024-07-02 04:25:00 | AAPL | Stock | 216.24 | 216.31 | 216.21 | 216.31 | 1028.0 |
| 2024-07-02 04:26:00 | AAPL | Stock | 216.3 | 216.3 | 216.29 | 216.29 | 282.0 |
| 2024-07-02 04:27:00 | AAPL | Stock | 216.41 | 216.41 | 216.41 | 216.41 | 250.0 |
| 2024-07-02 04:29:00 | AAPL | Stock | 216.4 | 216.4 | 216.38 | 216.38 | 680.0 |
| 2024-07-02 04:30:00 | AAPL | Stock | 216.38 | 216.38 | 216.32 | 216.32 | 2440.0 |
| 2024-07-02 04:34:00 | AAPL | Stock | 216.36 | 216.37 | 216.36 | 216.37 | 250.0 |
| 2024-07-02 04:35:00 | AAPL | Stock | 216.39 | 216.39 | 216.37 | 216.37 | 350.0 |
| 2024-07-02 04:36:00 | AAPL | Stock | 216.36 | 216.36 | 216.2 | 216.2 | 1140.0 |
| 2024-07-02 04:48:00 | AAPL | Stock | 216.19 | 216.19 | 216.19 | 216.19 | 100.0 |
| 2024-07-02 04:49:00 | AAPL | Stock | 216.11 | 216.11 | 216.01 | 216.01 | 1510.0 |
| 2024-07-02 04:50:00 | AAPL | Stock | 216.0 | 216.01 | 216.0 | 216.01 | 1087.0 |
| 2024-07-02 04:51:00 | AAPL | Stock | 216.05 | 216.2 | 216.05 | 216.2 | 999.0 |
| 2024-07-02 04:52:00 | AAPL | Stock | 216.19 | 216.19 | 216.19 | 216.19 | 100.0 |
| 2024-07-02 04:54:00 | AAPL | Stock | 216.01 | 216.01 | 216.01 | 216.01 | 300.0 |
| 2024-07-02 04:55:00 | AAPL | Stock | 216.1 | 216.1 | 216.06 | 216.06 | 650.0 |
| 2024-07-02 04:56:00 | AAPL | Stock | 216.1 | 216.1 | 216.09 | 216.09 | 705.0 |
| 2024-07-02 04:57:00 | AAPL | Stock | 216.09 | 216.1 | 216.09 | 216.1 | 952.0 |
| 2024-07-02 04:58:00 | AAPL | Stock | 216.11 | 216.11 | 216.1 | 216.1 | 500.0 |
| 2024-07-02 05:01:00 | AAPL | Stock | 216.07 | 216.07 | 216.07 | 216.07 | 400.0 |
| 2024-07-02 05:25:00 | AAPL | Stock | 216.1 | 216.1 | 216.1 | 216.1 | 308.0 |
| 2024-07-02 05:29:00 | AAPL | Stock | 216.11 | 216.11 | 216.06 | 216.09 | 1248.0 |
| 2024-07-02 05:32:00 | AAPL | Stock | 216.05 | 216.05 | 216.05 | 216.05 | 190.0 |
| 2024-07-02 05:33:00 | AAPL | Stock | 216.0 | 216.0 | 216.0 | 216.0 | 864.0 |
| 2024-07-02 05:34:00 | AAPL | Stock | 215.93 | 215.93 | 215.75 | 215.75 | 1433.0 |
| 2024-07-02 05:37:00 | AAPL | Stock | 215.78 | 215.78 | 215.77 | 215.77 | 200.0 |
| 2024-07-02 05:38:00 | AAPL | Stock | 215.75 | 215.77 | 215.65 | 215.65 | 1757.0 |
| 2024-07-02 05:39:00 | AAPL | Stock | 215.6 | 215.6 | 215.58 | 215.58 | 428.0 |
| 2024-07-02 05:40:00 | AAPL | Stock | 215.57 | 215.57 | 215.57 | 215.57 | 400.0 |
| 2024-07-02 05:42:00 | AAPL | Stock | 215.58 | 215.58 | 215.57 | 215.57 | 200.0 |
| 2024-07-02 05:43:00 | AAPL | Stock | 215.6 | 215.6 | 215.6 | 215.6 | 799.0 |
| 2024-07-02 05:45:00 | AAPL | Stock | 215.63 | 215.63 | 215.62 | 215.62 | 400.0 |
| 2024-07-02 05:46:00 | AAPL | Stock | 215.63 | 215.63 | 215.63 | 215.63 | 127.0 |
| 2024-07-02 05:48:00 | AAPL | Stock | 215.63 | 215.63 | 215.63 | 215.63 | 200.0 |
| 2024-07-02 05:50:00 | AAPL | Stock | 215.71 | 215.71 | 215.71 | 215.71 | 387.0 |
| 2024-07-02 05:51:00 | AAPL | Stock | 215.77 | 215.77 | 215.77 | 215.77 | 271.0 |
| 2024-07-02 05:52:00 | AAPL | Stock | 215.8 | 215.83 | 215.8 | 215.83 | 781.0 |
| 2024-07-02 05:58:00 | AAPL | Stock | 215.9 | 215.9 | 215.9 | 215.9 | 100.0 |
| 2024-07-02 06:01:00 | AAPL | Stock | 215.9 | 215.9 | 215.9 | 215.9 | 150.0 |
| 2024-07-02 06:33:00 | AAPL | Stock | 215.89 | 215.9 | 215.89 | 215.9 | 550.0 |
> showing 50 of 1,188,490 rows — these rows as CSV