PREVIEW / stock_1min / 2023-08-31
file: by_date/stock_1min/2023/2023-08-31.parquet size: 19.5 MB rows: 1,194,271 symbols: 1,411
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-08-31 04:00:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 100.0 |
| 2023-08-31 04:01:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 163.0 |
| 2023-08-31 04:03:00 | AAPL | Stock | 187.75 | 187.75 | 187.75 | 187.75 | 239.0 |
| 2023-08-31 04:05:00 | AAPL | Stock | 187.69 | 187.69 | 187.69 | 187.69 | 132.0 |
| 2023-08-31 04:13:00 | AAPL | Stock | 187.83 | 187.83 | 187.83 | 187.83 | 427.0 |
| 2023-08-31 04:14:00 | AAPL | Stock | 187.83 | 187.83 | 187.8 | 187.82 | 1217.0 |
| 2023-08-31 04:15:00 | AAPL | Stock | 187.83 | 187.83 | 187.83 | 187.83 | 198.0 |
| 2023-08-31 04:16:00 | AAPL | Stock | 187.82 | 187.82 | 187.82 | 187.82 | 211.0 |
| 2023-08-31 04:19:00 | AAPL | Stock | 187.81 | 187.81 | 187.81 | 187.81 | 100.0 |
| 2023-08-31 04:23:00 | AAPL | Stock | 187.79 | 187.79 | 187.78 | 187.78 | 235.0 |
| 2023-08-31 04:24:00 | AAPL | Stock | 187.78 | 187.8 | 187.78 | 187.8 | 528.0 |
| 2023-08-31 04:25:00 | AAPL | Stock | 187.81 | 187.81 | 187.81 | 187.81 | 200.0 |
| 2023-08-31 04:26:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 112.0 |
| 2023-08-31 04:33:00 | AAPL | Stock | 187.72 | 187.72 | 187.72 | 187.72 | 545.0 |
| 2023-08-31 04:35:00 | AAPL | Stock | 187.73 | 187.73 | 187.73 | 187.73 | 300.0 |
| 2023-08-31 04:36:00 | AAPL | Stock | 187.74 | 187.75 | 187.74 | 187.75 | 309.0 |
| 2023-08-31 04:38:00 | AAPL | Stock | 187.7 | 187.7 | 187.7 | 187.7 | 100.0 |
| 2023-08-31 04:41:00 | AAPL | Stock | 187.69 | 187.69 | 187.69 | 187.69 | 116.0 |
| 2023-08-31 04:48:00 | AAPL | Stock | 187.73 | 187.73 | 187.73 | 187.73 | 150.0 |
| 2023-08-31 04:49:00 | AAPL | Stock | 187.65 | 187.75 | 187.65 | 187.7 | 1864.0 |
| 2023-08-31 04:51:00 | AAPL | Stock | 187.7 | 187.7 | 187.7 | 187.7 | 568.0 |
| 2023-08-31 05:00:00 | AAPL | Stock | 187.71 | 187.71 | 187.71 | 187.71 | 100.0 |
| 2023-08-31 05:01:00 | AAPL | Stock | 187.74 | 187.74 | 187.7 | 187.7 | 586.0 |
| 2023-08-31 05:02:00 | AAPL | Stock | 187.68 | 187.68 | 187.65 | 187.65 | 1214.0 |
| 2023-08-31 05:03:00 | AAPL | Stock | 187.62 | 187.64 | 187.6 | 187.64 | 1109.0 |
| 2023-08-31 05:04:00 | AAPL | Stock | 187.66 | 187.66 | 187.66 | 187.66 | 309.0 |
| 2023-08-31 05:06:00 | AAPL | Stock | 187.64 | 187.64 | 187.6 | 187.6 | 2032.0 |
| 2023-08-31 05:07:00 | AAPL | Stock | 187.64 | 187.65 | 187.64 | 187.65 | 1059.0 |
| 2023-08-31 05:08:00 | AAPL | Stock | 187.59 | 187.59 | 187.59 | 187.59 | 100.0 |
| 2023-08-31 05:09:00 | AAPL | Stock | 187.52 | 187.52 | 187.5 | 187.51 | 1167.0 |
| 2023-08-31 05:10:00 | AAPL | Stock | 187.5 | 187.51 | 187.48 | 187.48 | 3131.0 |
| 2023-08-31 05:13:00 | AAPL | Stock | 187.32 | 187.35 | 187.32 | 187.35 | 200.0 |
| 2023-08-31 05:14:00 | AAPL | Stock | 187.4 | 187.4 | 187.36 | 187.36 | 200.0 |
| 2023-08-31 05:15:00 | AAPL | Stock | 187.31 | 187.4 | 187.29 | 187.33 | 3725.0 |
| 2023-08-31 05:16:00 | AAPL | Stock | 187.35 | 187.35 | 187.32 | 187.32 | 300.0 |
| 2023-08-31 05:17:00 | AAPL | Stock | 187.3 | 187.32 | 187.3 | 187.32 | 220.0 |
| 2023-08-31 05:19:00 | AAPL | Stock | 187.4 | 187.4 | 187.4 | 187.4 | 100.0 |
| 2023-08-31 05:20:00 | AAPL | Stock | 187.39 | 187.39 | 187.39 | 187.39 | 100.0 |
| 2023-08-31 05:21:00 | AAPL | Stock | 187.35 | 187.35 | 187.35 | 187.35 | 200.0 |
| 2023-08-31 05:24:00 | AAPL | Stock | 187.33 | 187.33 | 187.33 | 187.33 | 100.0 |
| 2023-08-31 05:26:00 | AAPL | Stock | 187.3 | 187.3 | 187.3 | 187.3 | 200.0 |
| 2023-08-31 05:28:00 | AAPL | Stock | 187.33 | 187.35 | 187.33 | 187.35 | 450.0 |
| 2023-08-31 05:36:00 | AAPL | Stock | 187.38 | 187.38 | 187.33 | 187.33 | 2104.0 |
| 2023-08-31 05:41:00 | AAPL | Stock | 187.33 | 187.34 | 187.33 | 187.34 | 450.0 |
| 2023-08-31 05:43:00 | AAPL | Stock | 187.37 | 187.37 | 187.37 | 187.37 | 200.0 |
| 2023-08-31 05:45:00 | AAPL | Stock | 187.38 | 187.39 | 187.38 | 187.38 | 462.0 |
| 2023-08-31 05:47:00 | AAPL | Stock | 187.4 | 187.4 | 187.34 | 187.34 | 564.0 |
| 2023-08-31 05:48:00 | AAPL | Stock | 187.31 | 187.31 | 187.31 | 187.31 | 100.0 |
| 2023-08-31 05:50:00 | AAPL | Stock | 187.31 | 187.31 | 187.31 | 187.31 | 100.0 |
| 2023-08-31 05:51:00 | AAPL | Stock | 187.29 | 187.29 | 187.29 | 187.29 | 200.0 |
> showing 50 of 1,194,271 rows — these rows as CSV