PREVIEW / stock_1min / 2023-01-27
file: by_date/stock_1min/2023/2023-01-27.parquet size: 22.2 MB rows: 1,283,926 symbols: 1,744
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-27 04:00:00 | AAPL | Stock | 143.48 | 143.48 | 143.22 | 143.44 | 1255.0 |
| 2023-01-27 04:01:00 | AAPL | Stock | 143.33 | 143.33 | 143.3 | 143.3 | 930.0 |
| 2023-01-27 04:03:00 | AAPL | Stock | 143.34 | 143.34 | 143.33 | 143.33 | 586.0 |
| 2023-01-27 04:05:00 | AAPL | Stock | 143.33 | 143.33 | 143.32 | 143.33 | 481.0 |
| 2023-01-27 04:06:00 | AAPL | Stock | 143.32 | 143.32 | 143.3 | 143.3 | 485.0 |
| 2023-01-27 04:08:00 | AAPL | Stock | 143.2 | 143.2 | 143.2 | 143.2 | 100.0 |
| 2023-01-27 04:09:00 | AAPL | Stock | 143.1 | 143.1 | 143.1 | 143.1 | 100.0 |
| 2023-01-27 04:11:00 | AAPL | Stock | 143.23 | 143.24 | 143.17 | 143.17 | 483.0 |
| 2023-01-27 04:12:00 | AAPL | Stock | 143.17 | 143.17 | 143.17 | 143.17 | 485.0 |
| 2023-01-27 04:13:00 | AAPL | Stock | 143.2 | 143.25 | 143.2 | 143.24 | 708.0 |
| 2023-01-27 04:15:00 | AAPL | Stock | 143.52 | 143.53 | 143.46 | 143.46 | 1156.0 |
| 2023-01-27 04:18:00 | AAPL | Stock | 143.5 | 143.5 | 143.46 | 143.46 | 817.0 |
| 2023-01-27 04:21:00 | AAPL | Stock | 143.52 | 143.52 | 143.52 | 143.52 | 237.0 |
| 2023-01-27 04:22:00 | AAPL | Stock | 143.56 | 143.56 | 143.56 | 143.56 | 1085.0 |
| 2023-01-27 04:25:00 | AAPL | Stock | 143.47 | 143.47 | 143.47 | 143.47 | 100.0 |
| 2023-01-27 04:29:00 | AAPL | Stock | 143.36 | 143.36 | 143.36 | 143.36 | 200.0 |
| 2023-01-27 04:32:00 | AAPL | Stock | 143.3 | 143.3 | 143.3 | 143.3 | 100.0 |
| 2023-01-27 04:34:00 | AAPL | Stock | 143.35 | 143.35 | 143.35 | 143.35 | 110.0 |
| 2023-01-27 04:39:00 | AAPL | Stock | 143.48 | 143.48 | 143.48 | 143.48 | 300.0 |
| 2023-01-27 04:40:00 | AAPL | Stock | 143.48 | 143.48 | 143.43 | 143.43 | 313.0 |
| 2023-01-27 04:43:00 | AAPL | Stock | 143.36 | 143.36 | 143.35 | 143.36 | 847.0 |
| 2023-01-27 04:44:00 | AAPL | Stock | 143.38 | 143.38 | 143.38 | 143.38 | 150.0 |
| 2023-01-27 04:45:00 | AAPL | Stock | 143.4 | 143.4 | 143.4 | 143.4 | 1300.0 |
| 2023-01-27 04:46:00 | AAPL | Stock | 143.43 | 143.43 | 143.42 | 143.42 | 657.0 |
| 2023-01-27 04:47:00 | AAPL | Stock | 143.42 | 143.42 | 143.37 | 143.37 | 658.0 |
| 2023-01-27 04:49:00 | AAPL | Stock | 143.43 | 143.5 | 143.43 | 143.5 | 2532.0 |
| 2023-01-27 04:51:00 | AAPL | Stock | 143.47 | 143.47 | 143.47 | 143.47 | 229.0 |
| 2023-01-27 04:53:00 | AAPL | Stock | 143.57 | 143.57 | 143.53 | 143.53 | 489.0 |
| 2023-01-27 04:54:00 | AAPL | Stock | 143.53 | 143.53 | 143.47 | 143.47 | 628.0 |
| 2023-01-27 04:57:00 | AAPL | Stock | 143.4 | 143.4 | 143.4 | 143.4 | 500.0 |
| 2023-01-27 05:10:00 | AAPL | Stock | 143.48 | 143.48 | 143.48 | 143.48 | 100.0 |
| 2023-01-27 05:12:00 | AAPL | Stock | 143.43 | 143.43 | 143.43 | 143.43 | 139.0 |
| 2023-01-27 05:15:00 | AAPL | Stock | 143.35 | 143.35 | 143.34 | 143.34 | 899.0 |
| 2023-01-27 05:19:00 | AAPL | Stock | 143.3 | 143.3 | 143.29 | 143.29 | 300.0 |
| 2023-01-27 05:24:00 | AAPL | Stock | 143.49 | 143.49 | 143.49 | 143.49 | 139.0 |
| 2023-01-27 05:33:00 | AAPL | Stock | 143.42 | 143.42 | 143.42 | 143.42 | 100.0 |
| 2023-01-27 05:37:00 | AAPL | Stock | 143.43 | 143.43 | 143.43 | 143.43 | 300.0 |
| 2023-01-27 05:41:00 | AAPL | Stock | 143.43 | 143.43 | 143.43 | 143.43 | 266.0 |
| 2023-01-27 05:46:00 | AAPL | Stock | 143.42 | 143.42 | 143.42 | 143.42 | 144.0 |
| 2023-01-27 05:49:00 | AAPL | Stock | 143.39 | 143.39 | 143.39 | 143.39 | 139.0 |
| 2023-01-27 05:51:00 | AAPL | Stock | 143.38 | 143.39 | 143.38 | 143.39 | 289.0 |
| 2023-01-27 06:04:00 | AAPL | Stock | 143.48 | 143.49 | 143.48 | 143.49 | 299.0 |
| 2023-01-27 06:05:00 | AAPL | Stock | 143.48 | 143.5 | 143.48 | 143.5 | 1718.0 |
| 2023-01-27 06:06:00 | AAPL | Stock | 143.5 | 143.5 | 143.5 | 143.5 | 199.0 |
| 2023-01-27 06:11:00 | AAPL | Stock | 143.43 | 143.43 | 143.43 | 143.43 | 100.0 |
| 2023-01-27 06:13:00 | AAPL | Stock | 143.43 | 143.43 | 143.42 | 143.42 | 352.0 |
| 2023-01-27 06:14:00 | AAPL | Stock | 143.42 | 143.42 | 143.42 | 143.42 | 116.0 |
| 2023-01-27 06:15:00 | AAPL | Stock | 143.43 | 143.44 | 143.43 | 143.44 | 925.0 |
| 2023-01-27 06:16:00 | AAPL | Stock | 143.41 | 143.41 | 143.41 | 143.41 | 260.0 |
| 2023-01-27 06:17:00 | AAPL | Stock | 143.41 | 143.41 | 143.41 | 143.41 | 100.0 |
> showing 50 of 1,283,926 rows — these rows as CSV