PREVIEW / stock_1min / 2024-10-29
file: by_date/stock_1min/2024/2024-10-29.parquet size: 21.4 MB rows: 1,251,698 symbols: 746
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-10-29 04:00:00 | AAPL | Stock | 232.7 | 232.7 | 232.69 | 232.69 | 2456.0 |
| 2024-10-29 04:01:00 | AAPL | Stock | 232.69 | 232.69 | 232.41 | 232.64 | 3051.0 |
| 2024-10-29 04:03:00 | AAPL | Stock | 232.88 | 232.92 | 232.88 | 232.92 | 200.0 |
| 2024-10-29 04:04:00 | AAPL | Stock | 232.96 | 232.96 | 232.72 | 232.72 | 629.0 |
| 2024-10-29 04:06:00 | AAPL | Stock | 232.67 | 232.84 | 232.65 | 232.84 | 682.0 |
| 2024-10-29 04:10:00 | AAPL | Stock | 232.84 | 232.84 | 232.7 | 232.7 | 404.0 |
| 2024-10-29 04:11:00 | AAPL | Stock | 232.75 | 232.75 | 232.48 | 232.48 | 2990.0 |
| 2024-10-29 04:12:00 | AAPL | Stock | 232.29 | 232.29 | 232.29 | 232.29 | 100.0 |
| 2024-10-29 04:17:00 | AAPL | Stock | 232.74 | 232.74 | 232.74 | 232.74 | 105.0 |
| 2024-10-29 04:19:00 | AAPL | Stock | 232.76 | 232.76 | 232.76 | 232.76 | 250.0 |
| 2024-10-29 04:20:00 | AAPL | Stock | 232.71 | 232.73 | 232.71 | 232.73 | 704.0 |
| 2024-10-29 04:29:00 | AAPL | Stock | 232.88 | 232.98 | 232.88 | 232.98 | 448.0 |
| 2024-10-29 04:30:00 | AAPL | Stock | 232.89 | 232.89 | 232.89 | 232.89 | 614.0 |
| 2024-10-29 04:38:00 | AAPL | Stock | 232.99 | 233.1 | 232.99 | 233.1 | 204.0 |
| 2024-10-29 04:51:00 | AAPL | Stock | 233.2 | 233.2 | 233.18 | 233.18 | 300.0 |
| 2024-10-29 04:52:00 | AAPL | Stock | 233.19 | 233.2 | 233.18 | 233.18 | 1080.0 |
| 2024-10-29 04:53:00 | AAPL | Stock | 233.17 | 233.17 | 233.17 | 233.17 | 432.0 |
| 2024-10-29 04:55:00 | AAPL | Stock | 233.05 | 233.05 | 233.05 | 233.05 | 139.0 |
| 2024-10-29 04:56:00 | AAPL | Stock | 233.01 | 233.01 | 233.0 | 233.0 | 496.0 |
| 2024-10-29 04:57:00 | AAPL | Stock | 233.11 | 233.11 | 232.98 | 232.98 | 1039.0 |
| 2024-10-29 05:04:00 | AAPL | Stock | 233.11 | 233.11 | 233.11 | 233.11 | 100.0 |
| 2024-10-29 05:06:00 | AAPL | Stock | 232.99 | 232.99 | 232.99 | 232.99 | 100.0 |
| 2024-10-29 05:09:00 | AAPL | Stock | 232.95 | 233.0 | 232.95 | 233.0 | 1034.0 |
| 2024-10-29 05:10:00 | AAPL | Stock | 232.95 | 232.95 | 232.95 | 232.95 | 444.0 |
| 2024-10-29 05:11:00 | AAPL | Stock | 232.87 | 232.87 | 232.87 | 232.87 | 176.0 |
| 2024-10-29 05:12:00 | AAPL | Stock | 232.91 | 232.91 | 232.8 | 232.8 | 371.0 |
| 2024-10-29 05:14:00 | AAPL | Stock | 232.74 | 232.74 | 232.73 | 232.73 | 200.0 |
| 2024-10-29 05:15:00 | AAPL | Stock | 232.77 | 232.77 | 232.77 | 232.77 | 160.0 |
| 2024-10-29 05:17:00 | AAPL | Stock | 232.79 | 232.79 | 232.69 | 232.69 | 2556.0 |
| 2024-10-29 05:20:00 | AAPL | Stock | 232.6 | 232.6 | 232.6 | 232.6 | 100.0 |
| 2024-10-29 05:21:00 | AAPL | Stock | 232.62 | 232.62 | 232.62 | 232.62 | 792.0 |
| 2024-10-29 05:22:00 | AAPL | Stock | 232.7 | 232.7 | 232.7 | 232.7 | 100.0 |
| 2024-10-29 05:24:00 | AAPL | Stock | 232.79 | 232.8 | 232.79 | 232.8 | 350.0 |
| 2024-10-29 05:30:00 | AAPL | Stock | 232.7 | 232.7 | 232.7 | 232.7 | 166.0 |
| 2024-10-29 05:31:00 | AAPL | Stock | 232.51 | 232.54 | 232.5 | 232.5 | 1157.0 |
| 2024-10-29 05:32:00 | AAPL | Stock | 232.65 | 232.68 | 232.65 | 232.68 | 500.0 |
| 2024-10-29 05:38:00 | AAPL | Stock | 232.54 | 232.54 | 232.54 | 232.54 | 100.0 |
| 2024-10-29 05:45:00 | AAPL | Stock | 232.73 | 232.75 | 232.73 | 232.75 | 650.0 |
| 2024-10-29 05:47:00 | AAPL | Stock | 232.7 | 232.7 | 232.7 | 232.7 | 100.0 |
| 2024-10-29 05:48:00 | AAPL | Stock | 232.7 | 232.7 | 232.7 | 232.7 | 150.0 |
| 2024-10-29 05:49:00 | AAPL | Stock | 232.69 | 232.69 | 232.69 | 232.69 | 204.0 |
| 2024-10-29 05:51:00 | AAPL | Stock | 232.6 | 232.6 | 232.6 | 232.6 | 123.0 |
| 2024-10-29 05:57:00 | AAPL | Stock | 232.68 | 232.68 | 232.68 | 232.68 | 190.0 |
| 2024-10-29 05:58:00 | AAPL | Stock | 232.68 | 232.68 | 232.68 | 232.68 | 100.0 |
| 2024-10-29 06:01:00 | AAPL | Stock | 232.69 | 232.69 | 232.65 | 232.65 | 720.0 |
| 2024-10-29 06:06:00 | AAPL | Stock | 232.61 | 232.61 | 232.61 | 232.61 | 1471.0 |
| 2024-10-29 06:07:00 | AAPL | Stock | 232.61 | 232.61 | 232.61 | 232.61 | 200.0 |
| 2024-10-29 06:09:00 | AAPL | Stock | 232.61 | 232.61 | 232.61 | 232.61 | 200.0 |
| 2024-10-29 06:13:00 | AAPL | Stock | 232.62 | 232.62 | 232.6 | 232.6 | 952.0 |
| 2024-10-29 06:22:00 | AAPL | Stock | 232.52 | 232.52 | 232.52 | 232.52 | 134.0 |
> showing 50 of 1,251,698 rows — these rows as CSV