PREVIEW / stock_1min / 2024-07-26
file: by_date/stock_1min/2024/2024-07-26.parquet size: 19.9 MB rows: 1,221,269 symbols: 885
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-26 04:00:00 | AAPL | Stock | 218.9 | 219.05 | 218.81 | 218.81 | 2428.0 |
| 2024-07-26 04:01:00 | AAPL | Stock | 219.1 | 219.19 | 219.1 | 219.19 | 569.0 |
| 2024-07-26 04:02:00 | AAPL | Stock | 219.35 | 219.35 | 219.35 | 219.35 | 100.0 |
| 2024-07-26 04:03:00 | AAPL | Stock | 219.3 | 219.35 | 219.3 | 219.35 | 300.0 |
| 2024-07-26 04:06:00 | AAPL | Stock | 219.27 | 219.27 | 219.27 | 219.27 | 300.0 |
| 2024-07-26 04:07:00 | AAPL | Stock | 219.27 | 219.27 | 219.27 | 219.27 | 202.0 |
| 2024-07-26 04:08:00 | AAPL | Stock | 219.27 | 219.27 | 219.27 | 219.27 | 1067.0 |
| 2024-07-26 04:09:00 | AAPL | Stock | 219.27 | 219.28 | 219.27 | 219.28 | 474.0 |
| 2024-07-26 04:10:00 | AAPL | Stock | 219.29 | 219.29 | 219.28 | 219.28 | 1300.0 |
| 2024-07-26 04:12:00 | AAPL | Stock | 219.34 | 219.35 | 219.34 | 219.35 | 309.0 |
| 2024-07-26 04:17:00 | AAPL | Stock | 219.27 | 219.28 | 219.27 | 219.28 | 1021.0 |
| 2024-07-26 04:19:00 | AAPL | Stock | 219.26 | 219.26 | 219.26 | 219.26 | 100.0 |
| 2024-07-26 04:20:00 | AAPL | Stock | 219.26 | 219.28 | 219.26 | 219.28 | 2964.0 |
| 2024-07-26 04:21:00 | AAPL | Stock | 219.27 | 219.28 | 219.27 | 219.28 | 500.0 |
| 2024-07-26 04:23:00 | AAPL | Stock | 219.22 | 219.22 | 219.22 | 219.22 | 239.0 |
| 2024-07-26 04:25:00 | AAPL | Stock | 219.23 | 219.23 | 219.22 | 219.22 | 315.0 |
| 2024-07-26 04:26:00 | AAPL | Stock | 219.25 | 219.25 | 219.25 | 219.25 | 100.0 |
| 2024-07-26 04:28:00 | AAPL | Stock | 219.28 | 219.28 | 219.28 | 219.28 | 300.0 |
| 2024-07-26 04:36:00 | AAPL | Stock | 219.18 | 219.18 | 219.15 | 219.15 | 200.0 |
| 2024-07-26 04:40:00 | AAPL | Stock | 219.22 | 219.22 | 219.22 | 219.22 | 200.0 |
| 2024-07-26 04:42:00 | AAPL | Stock | 219.3 | 219.35 | 219.3 | 219.35 | 599.0 |
| 2024-07-26 04:43:00 | AAPL | Stock | 219.35 | 219.35 | 219.35 | 219.35 | 1268.0 |
| 2024-07-26 04:44:00 | AAPL | Stock | 219.44 | 219.44 | 219.4 | 219.4 | 697.0 |
| 2024-07-26 04:47:00 | AAPL | Stock | 219.41 | 219.41 | 219.41 | 219.41 | 200.0 |
| 2024-07-26 04:51:00 | AAPL | Stock | 219.41 | 219.41 | 219.41 | 219.41 | 100.0 |
| 2024-07-26 04:56:00 | AAPL | Stock | 219.48 | 219.48 | 219.48 | 219.48 | 400.0 |
| 2024-07-26 04:57:00 | AAPL | Stock | 219.49 | 219.59 | 219.49 | 219.59 | 3073.0 |
| 2024-07-26 04:58:00 | AAPL | Stock | 219.96 | 219.96 | 219.96 | 219.96 | 165.0 |
| 2024-07-26 04:59:00 | AAPL | Stock | 219.99 | 220.0 | 219.99 | 220.0 | 912.0 |
| 2024-07-26 05:00:00 | AAPL | Stock | 220.25 | 220.25 | 220.21 | 220.21 | 245.0 |
| 2024-07-26 05:01:00 | AAPL | Stock | 220.0 | 220.0 | 220.0 | 220.0 | 1228.0 |
| 2024-07-26 05:04:00 | AAPL | Stock | 219.84 | 219.84 | 219.83 | 219.83 | 200.0 |
| 2024-07-26 05:06:00 | AAPL | Stock | 219.69 | 219.7 | 219.69 | 219.7 | 703.0 |
| 2024-07-26 05:08:00 | AAPL | Stock | 219.68 | 219.68 | 219.68 | 219.68 | 100.0 |
| 2024-07-26 05:09:00 | AAPL | Stock | 219.63 | 219.63 | 219.63 | 219.63 | 100.0 |
| 2024-07-26 05:10:00 | AAPL | Stock | 219.51 | 219.51 | 219.51 | 219.51 | 127.0 |
| 2024-07-26 05:12:00 | AAPL | Stock | 219.59 | 219.59 | 219.54 | 219.54 | 200.0 |
| 2024-07-26 05:13:00 | AAPL | Stock | 219.56 | 219.57 | 219.56 | 219.57 | 1432.0 |
| 2024-07-26 05:20:00 | AAPL | Stock | 219.62 | 219.62 | 219.61 | 219.61 | 265.0 |
| 2024-07-26 05:22:00 | AAPL | Stock | 219.6 | 219.6 | 219.6 | 219.6 | 300.0 |
| 2024-07-26 05:27:00 | AAPL | Stock | 219.6 | 219.6 | 219.6 | 219.6 | 153.0 |
| 2024-07-26 05:35:00 | AAPL | Stock | 219.56 | 219.56 | 219.56 | 219.56 | 100.0 |
| 2024-07-26 05:37:00 | AAPL | Stock | 219.63 | 219.63 | 219.63 | 219.63 | 100.0 |
| 2024-07-26 05:38:00 | AAPL | Stock | 219.72 | 219.72 | 219.72 | 219.72 | 100.0 |
| 2024-07-26 05:40:00 | AAPL | Stock | 219.7 | 219.7 | 219.7 | 219.7 | 196.0 |
| 2024-07-26 05:43:00 | AAPL | Stock | 219.5 | 219.5 | 219.5 | 219.5 | 213.0 |
| 2024-07-26 05:49:00 | AAPL | Stock | 219.55 | 219.66 | 219.54 | 219.66 | 1249.0 |
| 2024-07-26 05:57:00 | AAPL | Stock | 219.63 | 219.63 | 219.63 | 219.63 | 122.0 |
| 2024-07-26 06:00:00 | AAPL | Stock | 219.63 | 220.0 | 219.63 | 220.0 | 4915.0 |
| 2024-07-26 06:03:00 | AAPL | Stock | 219.94 | 219.94 | 219.94 | 219.94 | 200.0 |
> showing 50 of 1,221,269 rows — these rows as CSV