PREVIEW / stock_1min / 2023-10-12
file: by_date/stock_1min/2023/2023-10-12.parquet size: 20.3 MB rows: 1,232,050 symbols: 1,342
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-10-12 04:01:00 | AAPL | Stock | 180.24 | 180.24 | 180.24 | 180.24 | 374.0 |
| 2023-10-12 04:03:00 | AAPL | Stock | 180.2 | 180.2 | 180.2 | 180.2 | 964.0 |
| 2023-10-12 04:04:00 | AAPL | Stock | 180.21 | 180.21 | 180.21 | 180.21 | 115.0 |
| 2023-10-12 04:05:00 | AAPL | Stock | 180.22 | 180.22 | 180.22 | 180.22 | 110.0 |
| 2023-10-12 04:06:00 | AAPL | Stock | 180.2 | 180.23 | 180.2 | 180.23 | 383.0 |
| 2023-10-12 04:12:00 | AAPL | Stock | 180.3 | 180.3 | 180.3 | 180.3 | 1000.0 |
| 2023-10-12 04:13:00 | AAPL | Stock | 180.35 | 180.35 | 180.35 | 180.35 | 100.0 |
| 2023-10-12 04:18:00 | AAPL | Stock | 180.37 | 180.37 | 180.37 | 180.37 | 100.0 |
| 2023-10-12 04:19:00 | AAPL | Stock | 180.41 | 180.41 | 180.41 | 180.41 | 209.0 |
| 2023-10-12 04:20:00 | AAPL | Stock | 180.42 | 180.47 | 180.42 | 180.46 | 1525.0 |
| 2023-10-12 04:24:00 | AAPL | Stock | 180.45 | 180.45 | 180.45 | 180.45 | 110.0 |
| 2023-10-12 04:25:00 | AAPL | Stock | 180.43 | 180.44 | 180.4 | 180.4 | 3471.0 |
| 2023-10-12 04:26:00 | AAPL | Stock | 180.4 | 180.4 | 180.4 | 180.4 | 400.0 |
| 2023-10-12 04:27:00 | AAPL | Stock | 180.41 | 180.41 | 180.41 | 180.41 | 400.0 |
| 2023-10-12 04:33:00 | AAPL | Stock | 180.41 | 180.41 | 180.41 | 180.41 | 822.0 |
| 2023-10-12 04:39:00 | AAPL | Stock | 180.43 | 180.44 | 180.43 | 180.44 | 300.0 |
| 2023-10-12 04:46:00 | AAPL | Stock | 180.45 | 180.45 | 180.45 | 180.45 | 100.0 |
| 2023-10-12 04:50:00 | AAPL | Stock | 180.47 | 180.47 | 180.47 | 180.47 | 200.0 |
| 2023-10-12 04:52:00 | AAPL | Stock | 180.48 | 180.48 | 180.48 | 180.48 | 200.0 |
| 2023-10-12 04:54:00 | AAPL | Stock | 180.5 | 180.5 | 180.5 | 180.5 | 1882.0 |
| 2023-10-12 04:58:00 | AAPL | Stock | 180.5 | 180.5 | 180.46 | 180.46 | 883.0 |
| 2023-10-12 05:02:00 | AAPL | Stock | 180.53 | 180.53 | 180.51 | 180.51 | 500.0 |
| 2023-10-12 05:03:00 | AAPL | Stock | 180.51 | 180.51 | 180.51 | 180.51 | 100.0 |
| 2023-10-12 05:07:00 | AAPL | Stock | 180.56 | 180.56 | 180.56 | 180.56 | 129.0 |
| 2023-10-12 05:17:00 | AAPL | Stock | 180.58 | 180.6 | 180.58 | 180.6 | 396.0 |
| 2023-10-12 05:19:00 | AAPL | Stock | 180.6 | 180.61 | 180.6 | 180.6 | 1000.0 |
| 2023-10-12 05:26:00 | AAPL | Stock | 180.6 | 180.6 | 180.6 | 180.6 | 271.0 |
| 2023-10-12 05:28:00 | AAPL | Stock | 180.6 | 180.6 | 180.6 | 180.6 | 225.0 |
| 2023-10-12 05:35:00 | AAPL | Stock | 180.59 | 180.59 | 180.59 | 180.59 | 100.0 |
| 2023-10-12 05:38:00 | AAPL | Stock | 180.56 | 180.56 | 180.5 | 180.5 | 603.0 |
| 2023-10-12 05:39:00 | AAPL | Stock | 180.64 | 180.64 | 180.64 | 180.64 | 750.0 |
| 2023-10-12 05:45:00 | AAPL | Stock | 180.58 | 180.6 | 180.58 | 180.58 | 716.0 |
| 2023-10-12 05:46:00 | AAPL | Stock | 180.59 | 180.59 | 180.59 | 180.59 | 1000.0 |
| 2023-10-12 05:47:00 | AAPL | Stock | 180.59 | 180.59 | 180.59 | 180.59 | 120.0 |
| 2023-10-12 05:48:00 | AAPL | Stock | 180.55 | 180.55 | 180.49 | 180.5 | 4131.0 |
| 2023-10-12 05:49:00 | AAPL | Stock | 180.5 | 180.5 | 180.5 | 180.5 | 3611.0 |
| 2023-10-12 05:51:00 | AAPL | Stock | 180.5 | 180.5 | 180.49 | 180.49 | 800.0 |
| 2023-10-12 05:53:00 | AAPL | Stock | 180.46 | 180.46 | 180.46 | 180.46 | 207.0 |
| 2023-10-12 05:57:00 | AAPL | Stock | 180.47 | 180.47 | 180.46 | 180.46 | 462.0 |
| 2023-10-12 05:59:00 | AAPL | Stock | 180.46 | 180.46 | 180.46 | 180.46 | 200.0 |
| 2023-10-12 06:00:00 | AAPL | Stock | 180.48 | 180.48 | 180.45 | 180.45 | 288.0 |
| 2023-10-12 06:02:00 | AAPL | Stock | 180.48 | 180.48 | 180.48 | 180.48 | 400.0 |
| 2023-10-12 06:03:00 | AAPL | Stock | 180.48 | 180.5 | 180.48 | 180.5 | 200.0 |
| 2023-10-12 06:05:00 | AAPL | Stock | 180.5 | 180.54 | 180.5 | 180.54 | 6050.0 |
| 2023-10-12 06:09:00 | AAPL | Stock | 180.55 | 180.55 | 180.55 | 180.55 | 375.0 |
| 2023-10-12 06:11:00 | AAPL | Stock | 180.56 | 180.56 | 180.56 | 180.56 | 113.0 |
| 2023-10-12 06:12:00 | AAPL | Stock | 180.57 | 180.57 | 180.5 | 180.5 | 3800.0 |
| 2023-10-12 06:14:00 | AAPL | Stock | 180.5 | 180.5 | 180.5 | 180.5 | 175.0 |
| 2023-10-12 06:15:00 | AAPL | Stock | 180.52 | 180.52 | 180.52 | 180.52 | 458.0 |
| 2023-10-12 06:19:00 | AAPL | Stock | 180.58 | 180.58 | 180.58 | 180.58 | 209.0 |
> showing 50 of 1,232,050 rows — these rows as CSV