PREVIEW / stock_1min / 2023-01-06
file: by_date/stock_1min/2023/2023-01-06.parquet size: 21.3 MB rows: 1,308,644 symbols: 1,813
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-01-06 04:00:00 | AAPL | Stock | 125.52 | 125.52 | 125.31 | 125.34 | 2416.0 |
| 2023-01-06 04:01:00 | AAPL | Stock | 125.31 | 125.31 | 125.26 | 125.28 | 2846.0 |
| 2023-01-06 04:02:00 | AAPL | Stock | 125.25 | 125.25 | 125.15 | 125.15 | 2120.0 |
| 2023-01-06 04:03:00 | AAPL | Stock | 125.29 | 125.29 | 125.23 | 125.23 | 633.0 |
| 2023-01-06 04:04:00 | AAPL | Stock | 125.21 | 125.21 | 125.1 | 125.1 | 5414.0 |
| 2023-01-06 04:05:00 | AAPL | Stock | 125.13 | 125.15 | 125.12 | 125.15 | 1257.0 |
| 2023-01-06 04:06:00 | AAPL | Stock | 125.13 | 125.15 | 125.13 | 125.15 | 390.0 |
| 2023-01-06 04:07:00 | AAPL | Stock | 125.11 | 125.11 | 125.11 | 125.11 | 432.0 |
| 2023-01-06 04:08:00 | AAPL | Stock | 125.11 | 125.11 | 125.0 | 125.0 | 632.0 |
| 2023-01-06 04:09:00 | AAPL | Stock | 125.0 | 125.14 | 125.0 | 125.14 | 876.0 |
| 2023-01-06 04:11:00 | AAPL | Stock | 124.94 | 124.94 | 124.94 | 124.94 | 100.0 |
| 2023-01-06 04:12:00 | AAPL | Stock | 124.91 | 124.91 | 124.91 | 124.91 | 1440.0 |
| 2023-01-06 04:16:00 | AAPL | Stock | 124.9 | 124.9 | 124.9 | 124.9 | 1730.0 |
| 2023-01-06 04:19:00 | AAPL | Stock | 124.94 | 124.98 | 124.94 | 124.98 | 435.0 |
| 2023-01-06 04:20:00 | AAPL | Stock | 124.95 | 124.95 | 124.9 | 124.9 | 213.0 |
| 2023-01-06 04:21:00 | AAPL | Stock | 124.9 | 124.9 | 124.72 | 124.75 | 3018.0 |
| 2023-01-06 04:22:00 | AAPL | Stock | 124.77 | 124.78 | 124.64 | 124.66 | 1772.0 |
| 2023-01-06 04:25:00 | AAPL | Stock | 124.83 | 124.83 | 124.82 | 124.82 | 499.0 |
| 2023-01-06 04:26:00 | AAPL | Stock | 124.8 | 124.8 | 124.8 | 124.8 | 358.0 |
| 2023-01-06 04:27:00 | AAPL | Stock | 124.8 | 124.8 | 124.8 | 124.8 | 400.0 |
| 2023-01-06 04:31:00 | AAPL | Stock | 124.73 | 124.73 | 124.73 | 124.73 | 489.0 |
| 2023-01-06 04:38:00 | AAPL | Stock | 124.76 | 124.78 | 124.76 | 124.78 | 200.0 |
| 2023-01-06 04:39:00 | AAPL | Stock | 124.78 | 124.78 | 124.78 | 124.78 | 1011.0 |
| 2023-01-06 04:41:00 | AAPL | Stock | 124.73 | 124.73 | 124.73 | 124.73 | 267.0 |
| 2023-01-06 04:43:00 | AAPL | Stock | 124.77 | 124.84 | 124.77 | 124.84 | 734.0 |
| 2023-01-06 04:44:00 | AAPL | Stock | 124.87 | 124.87 | 124.87 | 124.87 | 100.0 |
| 2023-01-06 04:46:00 | AAPL | Stock | 124.84 | 124.84 | 124.84 | 124.84 | 100.0 |
| 2023-01-06 04:47:00 | AAPL | Stock | 124.84 | 124.86 | 124.84 | 124.85 | 1871.0 |
| 2023-01-06 04:48:00 | AAPL | Stock | 124.86 | 124.86 | 124.86 | 124.86 | 327.0 |
| 2023-01-06 04:51:00 | AAPL | Stock | 124.85 | 124.86 | 124.84 | 124.86 | 1412.0 |
| 2023-01-06 04:52:00 | AAPL | Stock | 124.86 | 124.86 | 124.86 | 124.86 | 100.0 |
| 2023-01-06 04:54:00 | AAPL | Stock | 124.87 | 124.92 | 124.87 | 124.92 | 3747.0 |
| 2023-01-06 04:57:00 | AAPL | Stock | 124.92 | 124.92 | 124.92 | 124.92 | 112.0 |
| 2023-01-06 04:59:00 | AAPL | Stock | 124.96 | 124.96 | 124.96 | 124.96 | 466.0 |
| 2023-01-06 05:00:00 | AAPL | Stock | 124.96 | 124.96 | 124.92 | 124.92 | 1863.0 |
| 2023-01-06 05:10:00 | AAPL | Stock | 124.94 | 124.99 | 124.94 | 124.99 | 635.0 |
| 2023-01-06 05:11:00 | AAPL | Stock | 124.99 | 125.0 | 124.99 | 124.99 | 1335.0 |
| 2023-01-06 05:12:00 | AAPL | Stock | 124.99 | 125.0 | 124.99 | 125.0 | 1802.0 |
| 2023-01-06 05:13:00 | AAPL | Stock | 125.02 | 125.02 | 125.0 | 125.01 | 817.0 |
| 2023-01-06 05:15:00 | AAPL | Stock | 125.03 | 125.03 | 125.03 | 125.03 | 213.0 |
| 2023-01-06 05:19:00 | AAPL | Stock | 125.03 | 125.03 | 125.03 | 125.03 | 100.0 |
| 2023-01-06 05:21:00 | AAPL | Stock | 125.01 | 125.01 | 125.01 | 125.01 | 100.0 |
| 2023-01-06 05:22:00 | AAPL | Stock | 125.06 | 125.06 | 125.06 | 125.06 | 300.0 |
| 2023-01-06 05:26:00 | AAPL | Stock | 125.08 | 125.08 | 125.08 | 125.08 | 581.0 |
| 2023-01-06 05:27:00 | AAPL | Stock | 125.08 | 125.08 | 125.08 | 125.08 | 200.0 |
| 2023-01-06 05:28:00 | AAPL | Stock | 125.13 | 125.13 | 125.13 | 125.13 | 100.0 |
| 2023-01-06 05:29:00 | AAPL | Stock | 125.12 | 125.12 | 125.12 | 125.12 | 787.0 |
| 2023-01-06 05:30:00 | AAPL | Stock | 125.13 | 125.14 | 125.08 | 125.08 | 1787.0 |
| 2023-01-06 05:35:00 | AAPL | Stock | 125.11 | 125.11 | 125.11 | 125.11 | 357.0 |
| 2023-01-06 05:38:00 | AAPL | Stock | 125.13 | 125.16 | 125.13 | 125.16 | 200.0 |
> showing 50 of 1,308,644 rows — these rows as CSV