PREVIEW / stock_1min / 2024-07-31
file: by_date/stock_1min/2024/2024-07-31.parquet size: 20.8 MB rows: 1,282,482 symbols: 899
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-31 04:00:00 | AAPL | Stock | 219.67 | 219.67 | 219.29 | 219.67 | 1067.0 |
| 2024-07-31 04:01:00 | AAPL | Stock | 219.59 | 219.59 | 219.31 | 219.31 | 666.0 |
| 2024-07-31 04:02:00 | AAPL | Stock | 219.39 | 219.39 | 219.38 | 219.38 | 1297.0 |
| 2024-07-31 04:03:00 | AAPL | Stock | 219.37 | 219.45 | 219.37 | 219.4 | 1409.0 |
| 2024-07-31 04:04:00 | AAPL | Stock | 219.49 | 219.66 | 219.49 | 219.66 | 499.0 |
| 2024-07-31 04:05:00 | AAPL | Stock | 219.65 | 219.65 | 219.65 | 219.65 | 112.0 |
| 2024-07-31 04:06:00 | AAPL | Stock | 219.76 | 219.77 | 219.56 | 219.7 | 500.0 |
| 2024-07-31 04:07:00 | AAPL | Stock | 219.57 | 219.57 | 219.57 | 219.57 | 200.0 |
| 2024-07-31 04:08:00 | AAPL | Stock | 219.59 | 219.68 | 219.54 | 219.55 | 1120.0 |
| 2024-07-31 04:09:00 | AAPL | Stock | 219.7 | 219.7 | 219.7 | 219.7 | 499.0 |
| 2024-07-31 04:10:00 | AAPL | Stock | 219.62 | 219.62 | 219.53 | 219.61 | 4820.0 |
| 2024-07-31 04:12:00 | AAPL | Stock | 219.5 | 219.6 | 219.45 | 219.6 | 1249.0 |
| 2024-07-31 04:13:00 | AAPL | Stock | 219.54 | 219.7 | 219.54 | 219.69 | 959.0 |
| 2024-07-31 04:14:00 | AAPL | Stock | 219.7 | 219.86 | 219.7 | 219.85 | 712.0 |
| 2024-07-31 04:15:00 | AAPL | Stock | 219.85 | 219.85 | 219.72 | 219.72 | 206.0 |
| 2024-07-31 04:16:00 | AAPL | Stock | 219.75 | 219.75 | 219.75 | 219.75 | 214.0 |
| 2024-07-31 04:17:00 | AAPL | Stock | 219.79 | 219.79 | 219.79 | 219.79 | 200.0 |
| 2024-07-31 04:18:00 | AAPL | Stock | 219.77 | 219.77 | 219.77 | 219.77 | 100.0 |
| 2024-07-31 04:19:00 | AAPL | Stock | 219.9 | 219.9 | 219.77 | 219.77 | 227.0 |
| 2024-07-31 04:20:00 | AAPL | Stock | 219.77 | 219.96 | 219.77 | 219.96 | 500.0 |
| 2024-07-31 04:21:00 | AAPL | Stock | 219.96 | 219.96 | 219.96 | 219.96 | 200.0 |
| 2024-07-31 04:22:00 | AAPL | Stock | 219.95 | 219.96 | 219.95 | 219.96 | 400.0 |
| 2024-07-31 04:23:00 | AAPL | Stock | 219.94 | 219.96 | 219.94 | 219.96 | 600.0 |
| 2024-07-31 04:24:00 | AAPL | Stock | 219.95 | 219.95 | 219.95 | 219.95 | 300.0 |
| 2024-07-31 04:25:00 | AAPL | Stock | 219.89 | 219.89 | 219.89 | 219.89 | 100.0 |
| 2024-07-31 04:29:00 | AAPL | Stock | 219.78 | 219.78 | 219.69 | 219.69 | 430.0 |
| 2024-07-31 04:30:00 | AAPL | Stock | 219.74 | 220.0 | 219.74 | 220.0 | 300.0 |
| 2024-07-31 04:32:00 | AAPL | Stock | 219.8 | 219.93 | 219.8 | 219.93 | 400.0 |
| 2024-07-31 04:35:00 | AAPL | Stock | 219.9 | 219.9 | 219.9 | 219.9 | 226.0 |
| 2024-07-31 04:37:00 | AAPL | Stock | 219.9 | 219.9 | 219.9 | 219.9 | 240.0 |
| 2024-07-31 04:40:00 | AAPL | Stock | 219.97 | 219.97 | 219.97 | 219.97 | 400.0 |
| 2024-07-31 04:41:00 | AAPL | Stock | 219.99 | 220.0 | 219.99 | 220.0 | 200.0 |
| 2024-07-31 04:47:00 | AAPL | Stock | 219.96 | 219.96 | 219.9 | 219.91 | 741.0 |
| 2024-07-31 04:48:00 | AAPL | Stock | 219.99 | 219.99 | 219.99 | 219.99 | 100.0 |
| 2024-07-31 04:49:00 | AAPL | Stock | 219.99 | 220.09 | 219.99 | 220.09 | 1250.0 |
| 2024-07-31 04:50:00 | AAPL | Stock | 220.1 | 220.11 | 220.1 | 220.1 | 816.0 |
| 2024-07-31 04:55:00 | AAPL | Stock | 220.13 | 220.21 | 220.13 | 220.2 | 962.0 |
| 2024-07-31 04:56:00 | AAPL | Stock | 220.1 | 220.1 | 220.1 | 220.1 | 129.0 |
| 2024-07-31 04:57:00 | AAPL | Stock | 220.23 | 220.24 | 220.23 | 220.24 | 516.0 |
| 2024-07-31 05:00:00 | AAPL | Stock | 220.33 | 220.47 | 220.33 | 220.47 | 418.0 |
| 2024-07-31 05:01:00 | AAPL | Stock | 220.49 | 220.49 | 220.36 | 220.36 | 631.0 |
| 2024-07-31 05:02:00 | AAPL | Stock | 220.3 | 220.3 | 220.3 | 220.3 | 132.0 |
| 2024-07-31 05:03:00 | AAPL | Stock | 220.31 | 220.32 | 220.28 | 220.28 | 1561.0 |
| 2024-07-31 05:05:00 | AAPL | Stock | 220.18 | 220.2 | 220.15 | 220.2 | 401.0 |
| 2024-07-31 05:06:00 | AAPL | Stock | 220.3 | 220.3 | 220.29 | 220.3 | 750.0 |
| 2024-07-31 05:07:00 | AAPL | Stock | 220.17 | 220.17 | 220.17 | 220.17 | 100.0 |
| 2024-07-31 05:08:00 | AAPL | Stock | 220.18 | 220.18 | 220.18 | 220.18 | 200.0 |
| 2024-07-31 05:09:00 | AAPL | Stock | 220.17 | 220.17 | 220.17 | 220.17 | 160.0 |
| 2024-07-31 05:11:00 | AAPL | Stock | 220.11 | 220.11 | 220.11 | 220.11 | 100.0 |
| 2024-07-31 05:12:00 | AAPL | Stock | 220.02 | 220.02 | 220.02 | 220.02 | 497.0 |
> showing 50 of 1,282,482 rows — these rows as CSV