PREVIEW / stock_1min / 2023-08-24
file: by_date/stock_1min/2023/2023-08-24.parquet size: 18.9 MB rows: 1,175,429 symbols: 1,396
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-24 04:00:00 | AAPL | Stock | 182.04 | 182.45 | 182.0 | 182.38 | 3830.0 |
| 2023-08-24 04:02:00 | AAPL | Stock | 182.48 | 182.5 | 182.48 | 182.5 | 1131.0 |
| 2023-08-24 04:03:00 | AAPL | Stock | 182.5 | 182.65 | 182.44 | 182.65 | 16496.0 |
| 2023-08-24 04:04:00 | AAPL | Stock | 182.77 | 182.78 | 182.62 | 182.62 | 1095.0 |
| 2023-08-24 04:05:00 | AAPL | Stock | 182.62 | 182.78 | 182.62 | 182.78 | 1452.0 |
| 2023-08-24 04:06:00 | AAPL | Stock | 182.65 | 182.65 | 182.65 | 182.65 | 439.0 |
| 2023-08-24 04:07:00 | AAPL | Stock | 182.7 | 182.7 | 182.58 | 182.58 | 682.0 |
| 2023-08-24 04:08:00 | AAPL | Stock | 182.59 | 182.59 | 182.54 | 182.54 | 458.0 |
| 2023-08-24 04:09:00 | AAPL | Stock | 182.52 | 182.59 | 182.49 | 182.59 | 2954.0 |
| 2023-08-24 04:10:00 | AAPL | Stock | 182.43 | 182.43 | 182.43 | 182.43 | 100.0 |
| 2023-08-24 04:11:00 | AAPL | Stock | 182.5 | 182.51 | 182.5 | 182.51 | 314.0 |
| 2023-08-24 04:12:00 | AAPL | Stock | 182.5 | 182.5 | 182.5 | 182.5 | 405.0 |
| 2023-08-24 04:13:00 | AAPL | Stock | 182.35 | 182.35 | 182.35 | 182.35 | 108.0 |
| 2023-08-24 04:14:00 | AAPL | Stock | 182.39 | 182.39 | 182.39 | 182.39 | 195.0 |
| 2023-08-24 04:15:00 | AAPL | Stock | 182.36 | 182.36 | 182.3 | 182.3 | 833.0 |
| 2023-08-24 04:16:00 | AAPL | Stock | 182.3 | 182.44 | 182.3 | 182.44 | 880.0 |
| 2023-08-24 04:17:00 | AAPL | Stock | 182.48 | 182.48 | 182.48 | 182.48 | 410.0 |
| 2023-08-24 04:18:00 | AAPL | Stock | 182.4 | 182.5 | 182.4 | 182.5 | 742.0 |
| 2023-08-24 04:20:00 | AAPL | Stock | 182.51 | 182.51 | 182.36 | 182.36 | 418.0 |
| 2023-08-24 04:21:00 | AAPL | Stock | 182.39 | 182.43 | 182.39 | 182.4 | 800.0 |
| 2023-08-24 04:22:00 | AAPL | Stock | 182.4 | 182.4 | 182.34 | 182.34 | 476.0 |
| 2023-08-24 04:23:00 | AAPL | Stock | 182.35 | 182.35 | 182.35 | 182.35 | 101.0 |
| 2023-08-24 04:24:00 | AAPL | Stock | 182.4 | 182.43 | 182.37 | 182.37 | 670.0 |
| 2023-08-24 04:25:00 | AAPL | Stock | 182.37 | 182.42 | 182.37 | 182.42 | 606.0 |
| 2023-08-24 04:26:00 | AAPL | Stock | 182.44 | 182.44 | 182.44 | 182.44 | 145.0 |
| 2023-08-24 04:27:00 | AAPL | Stock | 182.44 | 182.44 | 182.44 | 182.44 | 1157.0 |
| 2023-08-24 04:29:00 | AAPL | Stock | 182.41 | 182.44 | 182.41 | 182.44 | 957.0 |
| 2023-08-24 04:30:00 | AAPL | Stock | 182.4 | 182.44 | 182.38 | 182.44 | 699.0 |
| 2023-08-24 04:31:00 | AAPL | Stock | 182.44 | 182.44 | 182.41 | 182.41 | 450.0 |
| 2023-08-24 04:32:00 | AAPL | Stock | 182.35 | 182.35 | 182.35 | 182.35 | 100.0 |
| 2023-08-24 04:33:00 | AAPL | Stock | 182.34 | 182.34 | 182.32 | 182.32 | 524.0 |
| 2023-08-24 04:35:00 | AAPL | Stock | 182.32 | 182.32 | 182.2 | 182.2 | 2633.0 |
| 2023-08-24 04:36:00 | AAPL | Stock | 182.2 | 182.2 | 182.19 | 182.19 | 1093.0 |
| 2023-08-24 04:38:00 | AAPL | Stock | 182.15 | 182.15 | 182.1 | 182.1 | 979.0 |
| 2023-08-24 04:39:00 | AAPL | Stock | 182.04 | 182.04 | 182.0 | 182.0 | 3339.0 |
| 2023-08-24 04:40:00 | AAPL | Stock | 181.98 | 181.99 | 181.95 | 181.99 | 465.0 |
| 2023-08-24 04:41:00 | AAPL | Stock | 182.0 | 182.0 | 181.93 | 182.0 | 645.0 |
| 2023-08-24 04:42:00 | AAPL | Stock | 182.0 | 182.0 | 182.0 | 182.0 | 200.0 |
| 2023-08-24 04:43:00 | AAPL | Stock | 181.94 | 181.94 | 181.94 | 181.94 | 100.0 |
| 2023-08-24 04:45:00 | AAPL | Stock | 181.9 | 181.9 | 181.9 | 181.9 | 656.0 |
| 2023-08-24 04:50:00 | AAPL | Stock | 181.82 | 181.82 | 181.82 | 181.82 | 150.0 |
| 2023-08-24 04:51:00 | AAPL | Stock | 181.81 | 181.84 | 181.81 | 181.84 | 282.0 |
| 2023-08-24 04:52:00 | AAPL | Stock | 181.82 | 181.82 | 181.81 | 181.81 | 1082.0 |
| 2023-08-24 04:54:00 | AAPL | Stock | 181.8 | 181.81 | 181.8 | 181.81 | 1285.0 |
| 2023-08-24 04:55:00 | AAPL | Stock | 181.81 | 181.81 | 181.79 | 181.8 | 1400.0 |
| 2023-08-24 04:56:00 | AAPL | Stock | 181.8 | 181.81 | 181.79 | 181.81 | 1550.0 |
| 2023-08-24 04:59:00 | AAPL | Stock | 181.95 | 181.99 | 181.94 | 181.99 | 2679.0 |
| 2023-08-24 05:00:00 | AAPL | Stock | 181.94 | 181.95 | 181.94 | 181.95 | 250.0 |
| 2023-08-24 05:01:00 | AAPL | Stock | 181.95 | 181.95 | 181.95 | 181.95 | 300.0 |
| 2023-08-24 05:02:00 | AAPL | Stock | 181.94 | 181.95 | 181.87 | 181.87 | 3163.0 |
> showing 50 of 1,175,429 rows — these rows as CSV