PREVIEW / stock_1min / 2024-10-09
file: by_date/stock_1min/2024/2024-10-09.parquet size: 20.6 MB rows: 1,178,245 symbols: 762
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-09 04:00:00 | AAPL | Stock | 225.12 | 225.12 | 225.12 | 225.12 | 194.0 |
| 2024-10-09 04:01:00 | AAPL | Stock | 225.1 | 225.1 | 225.1 | 225.1 | 174.0 |
| 2024-10-09 04:02:00 | AAPL | Stock | 225.1 | 225.1 | 225.1 | 225.1 | 190.0 |
| 2024-10-09 04:03:00 | AAPL | Stock | 225.05 | 225.05 | 225.03 | 225.03 | 413.0 |
| 2024-10-09 04:05:00 | AAPL | Stock | 224.87 | 224.87 | 224.87 | 224.87 | 188.0 |
| 2024-10-09 04:08:00 | AAPL | Stock | 224.75 | 224.75 | 224.74 | 224.74 | 322.0 |
| 2024-10-09 04:14:00 | AAPL | Stock | 224.76 | 224.76 | 224.75 | 224.75 | 498.0 |
| 2024-10-09 04:17:00 | AAPL | Stock | 224.62 | 224.65 | 224.62 | 224.65 | 200.0 |
| 2024-10-09 04:18:00 | AAPL | Stock | 224.65 | 224.65 | 224.65 | 224.65 | 100.0 |
| 2024-10-09 04:20:00 | AAPL | Stock | 224.61 | 224.61 | 224.61 | 224.61 | 118.0 |
| 2024-10-09 04:23:00 | AAPL | Stock | 224.61 | 224.61 | 224.61 | 224.61 | 200.0 |
| 2024-10-09 04:25:00 | AAPL | Stock | 224.68 | 224.69 | 224.68 | 224.69 | 272.0 |
| 2024-10-09 04:28:00 | AAPL | Stock | 224.5 | 224.5 | 224.5 | 224.5 | 107.0 |
| 2024-10-09 04:29:00 | AAPL | Stock | 224.56 | 224.56 | 224.56 | 224.56 | 100.0 |
| 2024-10-09 04:32:00 | AAPL | Stock | 224.45 | 224.45 | 224.45 | 224.45 | 300.0 |
| 2024-10-09 04:38:00 | AAPL | Stock | 224.51 | 224.51 | 224.51 | 224.51 | 200.0 |
| 2024-10-09 04:57:00 | AAPL | Stock | 224.68 | 224.72 | 224.68 | 224.72 | 420.0 |
| 2024-10-09 05:09:00 | AAPL | Stock | 224.83 | 224.83 | 224.82 | 224.82 | 333.0 |
| 2024-10-09 05:11:00 | AAPL | Stock | 224.88 | 224.88 | 224.88 | 224.88 | 220.0 |
| 2024-10-09 05:19:00 | AAPL | Stock | 224.89 | 224.89 | 224.89 | 224.89 | 300.0 |
| 2024-10-09 05:35:00 | AAPL | Stock | 225.0 | 225.0 | 225.0 | 225.0 | 218.0 |
| 2024-10-09 05:39:00 | AAPL | Stock | 225.0 | 225.0 | 225.0 | 225.0 | 500.0 |
| 2024-10-09 05:44:00 | AAPL | Stock | 225.03 | 225.03 | 225.03 | 225.03 | 187.0 |
| 2024-10-09 05:45:00 | AAPL | Stock | 225.06 | 225.07 | 225.06 | 225.07 | 414.0 |
| 2024-10-09 05:48:00 | AAPL | Stock | 225.13 | 225.16 | 225.13 | 225.16 | 722.0 |
| 2024-10-09 05:51:00 | AAPL | Stock | 225.25 | 225.26 | 225.25 | 225.25 | 513.0 |
| 2024-10-09 05:59:00 | AAPL | Stock | 225.13 | 225.13 | 225.13 | 225.13 | 187.0 |
| 2024-10-09 06:03:00 | AAPL | Stock | 224.99 | 224.99 | 224.95 | 224.95 | 448.0 |
| 2024-10-09 06:04:00 | AAPL | Stock | 224.95 | 224.95 | 224.94 | 224.94 | 346.0 |
| 2024-10-09 06:06:00 | AAPL | Stock | 224.93 | 224.97 | 224.93 | 224.97 | 604.0 |
| 2024-10-09 06:13:00 | AAPL | Stock | 225.01 | 225.01 | 225.01 | 225.01 | 100.0 |
| 2024-10-09 06:14:00 | AAPL | Stock | 225.1 | 225.1 | 225.1 | 225.1 | 200.0 |
| 2024-10-09 06:16:00 | AAPL | Stock | 225.15 | 225.15 | 225.15 | 225.15 | 377.0 |
| 2024-10-09 06:32:00 | AAPL | Stock | 225.15 | 225.15 | 225.15 | 225.15 | 698.0 |
| 2024-10-09 06:51:00 | AAPL | Stock | 225.15 | 225.15 | 225.15 | 225.15 | 400.0 |
| 2024-10-09 06:54:00 | AAPL | Stock | 225.17 | 225.17 | 225.17 | 225.17 | 200.0 |
| 2024-10-09 06:56:00 | AAPL | Stock | 225.15 | 225.15 | 225.15 | 225.15 | 417.0 |
| 2024-10-09 06:58:00 | AAPL | Stock | 225.15 | 225.15 | 225.0 | 225.0 | 782.0 |
| 2024-10-09 07:00:00 | AAPL | Stock | 225.14 | 225.19 | 225.14 | 225.19 | 696.0 |
| 2024-10-09 07:02:00 | AAPL | Stock | 225.22 | 225.28 | 225.22 | 225.28 | 1091.0 |
| 2024-10-09 07:04:00 | AAPL | Stock | 225.3 | 225.3 | 225.25 | 225.25 | 521.0 |
| 2024-10-09 07:05:00 | AAPL | Stock | 225.22 | 225.22 | 225.22 | 225.22 | 200.0 |
| 2024-10-09 07:06:00 | AAPL | Stock | 225.25 | 225.25 | 225.25 | 225.25 | 179.0 |
| 2024-10-09 07:07:00 | AAPL | Stock | 225.18 | 225.18 | 225.13 | 225.13 | 685.0 |
| 2024-10-09 07:09:00 | AAPL | Stock | 225.24 | 225.24 | 225.24 | 225.24 | 100.0 |
| 2024-10-09 07:11:00 | AAPL | Stock | 225.23 | 225.23 | 225.23 | 225.23 | 100.0 |
| 2024-10-09 07:12:00 | AAPL | Stock | 225.22 | 225.24 | 225.22 | 225.24 | 200.0 |
| 2024-10-09 07:13:00 | AAPL | Stock | 225.24 | 225.24 | 225.24 | 225.24 | 255.0 |
| 2024-10-09 07:14:00 | AAPL | Stock | 225.23 | 225.23 | 225.23 | 225.23 | 200.0 |
| 2024-10-09 07:15:00 | AAPL | Stock | 225.11 | 225.11 | 225.1 | 225.1 | 400.0 |
> showing 50 of 1,178,245 rows — these rows as CSV