PREVIEW / stock_1min / 2024-09-16
file: by_date/stock_1min/2024/2024-09-16.parquet size: 19.5 MB rows: 1,219,521 symbols: 825
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-09-16 04:00:00 | AAPL | Stock | 222.2 | 222.2 | 220.0 | 220.88 | 10925.0 |
| 2024-09-16 04:01:00 | AAPL | Stock | 220.81 | 220.81 | 220.44 | 220.44 | 3088.0 |
| 2024-09-16 04:02:00 | AAPL | Stock | 220.56 | 220.63 | 220.56 | 220.63 | 481.0 |
| 2024-09-16 04:04:00 | AAPL | Stock | 220.63 | 220.63 | 220.6 | 220.6 | 742.0 |
| 2024-09-16 04:05:00 | AAPL | Stock | 220.58 | 220.61 | 220.58 | 220.61 | 300.0 |
| 2024-09-16 04:06:00 | AAPL | Stock | 220.59 | 220.59 | 220.45 | 220.45 | 2630.0 |
| 2024-09-16 04:07:00 | AAPL | Stock | 220.5 | 220.5 | 220.5 | 220.5 | 227.0 |
| 2024-09-16 04:08:00 | AAPL | Stock | 220.42 | 220.42 | 220.39 | 220.39 | 1355.0 |
| 2024-09-16 04:10:00 | AAPL | Stock | 220.39 | 220.39 | 220.39 | 220.39 | 100.0 |
| 2024-09-16 04:14:00 | AAPL | Stock | 220.36 | 220.36 | 220.2 | 220.29 | 3045.0 |
| 2024-09-16 04:15:00 | AAPL | Stock | 220.13 | 220.13 | 219.9 | 219.9 | 3918.0 |
| 2024-09-16 04:16:00 | AAPL | Stock | 219.99 | 219.99 | 219.69 | 219.7 | 5808.0 |
| 2024-09-16 04:17:00 | AAPL | Stock | 219.65 | 219.77 | 219.65 | 219.71 | 997.0 |
| 2024-09-16 04:18:00 | AAPL | Stock | 219.9 | 219.9 | 219.9 | 219.9 | 100.0 |
| 2024-09-16 04:19:00 | AAPL | Stock | 219.9 | 219.9 | 219.88 | 219.89 | 509.0 |
| 2024-09-16 04:20:00 | AAPL | Stock | 219.86 | 219.86 | 219.48 | 219.48 | 5239.0 |
| 2024-09-16 04:21:00 | AAPL | Stock | 219.41 | 219.5 | 219.4 | 219.47 | 1177.0 |
| 2024-09-16 04:22:00 | AAPL | Stock | 219.51 | 219.51 | 219.5 | 219.5 | 200.0 |
| 2024-09-16 04:23:00 | AAPL | Stock | 219.51 | 219.51 | 219.51 | 219.51 | 200.0 |
| 2024-09-16 04:24:00 | AAPL | Stock | 219.42 | 219.42 | 219.35 | 219.35 | 684.0 |
| 2024-09-16 04:26:00 | AAPL | Stock | 219.7 | 219.7 | 219.7 | 219.7 | 100.0 |
| 2024-09-16 04:28:00 | AAPL | Stock | 219.61 | 219.61 | 219.35 | 219.35 | 2729.0 |
| 2024-09-16 04:29:00 | AAPL | Stock | 219.61 | 219.61 | 219.5 | 219.5 | 730.0 |
| 2024-09-16 04:30:00 | AAPL | Stock | 219.4 | 219.4 | 219.4 | 219.4 | 715.0 |
| 2024-09-16 04:31:00 | AAPL | Stock | 219.35 | 219.35 | 219.35 | 219.35 | 972.0 |
| 2024-09-16 04:32:00 | AAPL | Stock | 219.43 | 219.49 | 219.43 | 219.49 | 452.0 |
| 2024-09-16 04:33:00 | AAPL | Stock | 219.41 | 219.41 | 219.2 | 219.2 | 3236.0 |
| 2024-09-16 04:34:00 | AAPL | Stock | 219.21 | 219.21 | 219.2 | 219.2 | 1950.0 |
| 2024-09-16 04:35:00 | AAPL | Stock | 219.2 | 219.2 | 219.2 | 219.2 | 700.0 |
| 2024-09-16 04:36:00 | AAPL | Stock | 219.0 | 219.0 | 219.0 | 219.0 | 1050.0 |
| 2024-09-16 04:37:00 | AAPL | Stock | 218.9 | 218.9 | 218.34 | 218.44 | 766.0 |
| 2024-09-16 04:39:00 | AAPL | Stock | 218.9 | 218.9 | 218.9 | 218.9 | 100.0 |
| 2024-09-16 04:41:00 | AAPL | Stock | 219.0 | 219.0 | 219.0 | 219.0 | 100.0 |
| 2024-09-16 04:42:00 | AAPL | Stock | 218.87 | 218.87 | 218.87 | 218.87 | 100.0 |
| 2024-09-16 04:45:00 | AAPL | Stock | 219.0 | 219.0 | 219.0 | 219.0 | 299.0 |
| 2024-09-16 04:47:00 | AAPL | Stock | 219.0 | 219.0 | 219.0 | 219.0 | 105.0 |
| 2024-09-16 04:48:00 | AAPL | Stock | 219.02 | 219.13 | 219.02 | 219.13 | 438.0 |
| 2024-09-16 04:49:00 | AAPL | Stock | 219.2 | 219.2 | 219.2 | 219.2 | 100.0 |
| 2024-09-16 04:50:00 | AAPL | Stock | 219.28 | 219.28 | 219.28 | 219.28 | 180.0 |
| 2024-09-16 04:51:00 | AAPL | Stock | 219.25 | 219.25 | 219.25 | 219.25 | 300.0 |
| 2024-09-16 04:52:00 | AAPL | Stock | 219.25 | 219.5 | 219.25 | 219.25 | 2007.0 |
| 2024-09-16 04:54:00 | AAPL | Stock | 219.21 | 219.21 | 219.21 | 219.21 | 126.0 |
| 2024-09-16 04:55:00 | AAPL | Stock | 219.2 | 219.25 | 219.2 | 219.25 | 354.0 |
| 2024-09-16 04:56:00 | AAPL | Stock | 219.25 | 219.25 | 219.25 | 219.25 | 214.0 |
| 2024-09-16 04:57:00 | AAPL | Stock | 219.21 | 219.21 | 219.21 | 219.21 | 100.0 |
| 2024-09-16 05:03:00 | AAPL | Stock | 219.16 | 219.17 | 219.16 | 219.17 | 352.0 |
| 2024-09-16 05:05:00 | AAPL | Stock | 219.06 | 219.06 | 219.0 | 219.0 | 1562.0 |
| 2024-09-16 05:06:00 | AAPL | Stock | 218.82 | 218.82 | 218.81 | 218.82 | 1173.0 |
| 2024-09-16 05:07:00 | AAPL | Stock | 218.8 | 218.8 | 218.8 | 218.8 | 910.0 |
| 2024-09-16 05:09:00 | AAPL | Stock | 218.9 | 218.9 | 218.9 | 218.9 | 200.0 |
> showing 50 of 1,219,521 rows — these rows as CSV