PREVIEW / stock_1min / 2024-09-11
file: by_date/stock_1min/2024/2024-09-11.parquet size: 19.8 MB rows: 1,214,469 symbols: 874
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-11 04:00:00 | AAPL | Stock | 217.8 | 219.37 | 217.12 | 219.26 | 3242.0 |
| 2024-09-11 04:01:00 | AAPL | Stock | 219.28 | 219.28 | 219.28 | 219.28 | 100.0 |
| 2024-09-11 04:02:00 | AAPL | Stock | 219.53 | 219.53 | 219.53 | 219.53 | 300.0 |
| 2024-09-11 04:05:00 | AAPL | Stock | 219.51 | 219.51 | 219.51 | 219.51 | 400.0 |
| 2024-09-11 04:15:00 | AAPL | Stock | 219.36 | 219.36 | 219.36 | 219.36 | 100.0 |
| 2024-09-11 04:18:00 | AAPL | Stock | 219.5 | 219.5 | 219.5 | 219.5 | 2248.0 |
| 2024-09-11 04:20:00 | AAPL | Stock | 219.5 | 219.5 | 219.5 | 219.5 | 100.0 |
| 2024-09-11 04:25:00 | AAPL | Stock | 219.43 | 219.44 | 219.43 | 219.44 | 200.0 |
| 2024-09-11 04:27:00 | AAPL | Stock | 219.46 | 219.46 | 219.46 | 219.46 | 100.0 |
| 2024-09-11 04:29:00 | AAPL | Stock | 219.49 | 219.5 | 219.49 | 219.5 | 1698.0 |
| 2024-09-11 04:31:00 | AAPL | Stock | 219.5 | 219.5 | 219.37 | 219.37 | 482.0 |
| 2024-09-11 04:32:00 | AAPL | Stock | 219.3 | 219.3 | 219.3 | 219.3 | 300.0 |
| 2024-09-11 04:38:00 | AAPL | Stock | 219.26 | 219.26 | 219.22 | 219.22 | 264.0 |
| 2024-09-11 04:40:00 | AAPL | Stock | 219.21 | 219.21 | 219.21 | 219.21 | 153.0 |
| 2024-09-11 04:41:00 | AAPL | Stock | 219.01 | 219.01 | 219.01 | 219.01 | 100.0 |
| 2024-09-11 04:46:00 | AAPL | Stock | 219.01 | 219.01 | 219.0 | 219.0 | 2495.0 |
| 2024-09-11 04:47:00 | AAPL | Stock | 219.0 | 219.0 | 219.0 | 219.0 | 153.0 |
| 2024-09-11 04:51:00 | AAPL | Stock | 219.12 | 219.12 | 219.12 | 219.12 | 100.0 |
| 2024-09-11 04:58:00 | AAPL | Stock | 219.22 | 219.22 | 219.22 | 219.22 | 161.0 |
| 2024-09-11 05:18:00 | AAPL | Stock | 219.47 | 219.47 | 219.47 | 219.47 | 405.0 |
| 2024-09-11 05:35:00 | AAPL | Stock | 219.43 | 219.43 | 219.43 | 219.43 | 100.0 |
| 2024-09-11 05:37:00 | AAPL | Stock | 219.54 | 219.54 | 219.54 | 219.54 | 594.0 |
| 2024-09-11 05:41:00 | AAPL | Stock | 219.41 | 219.41 | 219.41 | 219.41 | 300.0 |
| 2024-09-11 05:42:00 | AAPL | Stock | 219.39 | 219.39 | 219.39 | 219.39 | 119.0 |
| 2024-09-11 06:01:00 | AAPL | Stock | 219.56 | 219.56 | 219.56 | 219.56 | 445.0 |
| 2024-09-11 06:05:00 | AAPL | Stock | 219.58 | 219.58 | 219.58 | 219.58 | 100.0 |
| 2024-09-11 06:06:00 | AAPL | Stock | 219.5 | 219.5 | 219.44 | 219.44 | 1183.0 |
| 2024-09-11 06:15:00 | AAPL | Stock | 219.58 | 219.6 | 219.58 | 219.6 | 234.0 |
| 2024-09-11 06:26:00 | AAPL | Stock | 219.6 | 219.6 | 219.6 | 219.6 | 801.0 |
| 2024-09-11 06:31:00 | AAPL | Stock | 219.42 | 219.42 | 219.42 | 219.42 | 153.0 |
| 2024-09-11 06:50:00 | AAPL | Stock | 219.61 | 219.61 | 219.59 | 219.59 | 7352.0 |
| 2024-09-11 06:53:00 | AAPL | Stock | 219.6 | 219.6 | 219.6 | 219.6 | 978.0 |
| 2024-09-11 06:58:00 | AAPL | Stock | 219.6 | 219.6 | 219.6 | 219.6 | 500.0 |
| 2024-09-11 06:59:00 | AAPL | Stock | 219.63 | 219.63 | 219.63 | 219.63 | 100.0 |
| 2024-09-11 07:00:00 | AAPL | Stock | 219.6 | 219.72 | 219.6 | 219.72 | 500.0 |
| 2024-09-11 07:01:00 | AAPL | Stock | 219.66 | 219.66 | 219.65 | 219.65 | 718.0 |
| 2024-09-11 07:02:00 | AAPL | Stock | 219.6 | 219.62 | 219.6 | 219.62 | 336.0 |
| 2024-09-11 07:03:00 | AAPL | Stock | 219.69 | 219.69 | 219.69 | 219.69 | 149.0 |
| 2024-09-11 07:05:00 | AAPL | Stock | 219.6 | 219.6 | 219.58 | 219.58 | 560.0 |
| 2024-09-11 07:07:00 | AAPL | Stock | 219.63 | 219.63 | 219.63 | 219.63 | 115.0 |
| 2024-09-11 07:12:00 | AAPL | Stock | 219.7 | 219.7 | 219.7 | 219.7 | 100.0 |
| 2024-09-11 07:21:00 | AAPL | Stock | 219.68 | 219.68 | 219.68 | 219.68 | 463.0 |
| 2024-09-11 07:23:00 | AAPL | Stock | 219.67 | 219.67 | 219.67 | 219.67 | 100.0 |
| 2024-09-11 07:32:00 | AAPL | Stock | 219.67 | 219.68 | 219.64 | 219.68 | 429.0 |
| 2024-09-11 07:37:00 | AAPL | Stock | 219.68 | 219.75 | 219.68 | 219.75 | 2170.0 |
| 2024-09-11 07:38:00 | AAPL | Stock | 219.77 | 219.8 | 219.77 | 219.8 | 1495.0 |
| 2024-09-11 07:40:00 | AAPL | Stock | 219.9 | 219.95 | 219.9 | 219.95 | 948.0 |
| 2024-09-11 07:47:00 | AAPL | Stock | 219.87 | 219.87 | 219.87 | 219.87 | 237.0 |
| 2024-09-11 07:50:00 | AAPL | Stock | 219.85 | 220.0 | 219.85 | 220.0 | 3110.0 |
| 2024-09-11 07:53:00 | AAPL | Stock | 220.0 | 220.0 | 220.0 | 220.0 | 706.0 |
> showing 50 of 1,214,469 rows — these rows as CSV