PREVIEW / stock_1min / 2023-08-14
file: by_date/stock_1min/2023/2023-08-14.parquet size: 20.3 MB rows: 1,239,042 symbols: 1,462
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-14 04:00:00 | AAPL | Stock | 177.82 | 178.62 | 177.73 | 178.55 | 7218.0 |
| 2023-08-14 04:01:00 | AAPL | Stock | 178.62 | 179.45 | 178.41 | 179.0 | 6490.0 |
| 2023-08-14 04:02:00 | AAPL | Stock | 178.87 | 179.0 | 178.87 | 179.0 | 779.0 |
| 2023-08-14 04:03:00 | AAPL | Stock | 179.0 | 179.19 | 179.0 | 179.08 | 2634.0 |
| 2023-08-14 04:04:00 | AAPL | Stock | 179.05 | 179.07 | 178.9 | 178.92 | 2354.0 |
| 2023-08-14 04:05:00 | AAPL | Stock | 178.9 | 179.0 | 178.9 | 178.98 | 2117.0 |
| 2023-08-14 04:07:00 | AAPL | Stock | 178.91 | 178.92 | 178.91 | 178.92 | 763.0 |
| 2023-08-14 04:08:00 | AAPL | Stock | 178.89 | 178.89 | 178.85 | 178.85 | 3407.0 |
| 2023-08-14 04:09:00 | AAPL | Stock | 178.78 | 178.85 | 178.78 | 178.85 | 456.0 |
| 2023-08-14 04:10:00 | AAPL | Stock | 178.89 | 178.89 | 178.85 | 178.85 | 800.0 |
| 2023-08-14 04:12:00 | AAPL | Stock | 178.75 | 178.75 | 178.75 | 178.75 | 3372.0 |
| 2023-08-14 04:13:00 | AAPL | Stock | 178.7 | 178.7 | 178.7 | 178.7 | 500.0 |
| 2023-08-14 04:14:00 | AAPL | Stock | 178.59 | 178.6 | 178.59 | 178.6 | 600.0 |
| 2023-08-14 04:15:00 | AAPL | Stock | 178.51 | 178.6 | 178.51 | 178.6 | 1036.0 |
| 2023-08-14 04:16:00 | AAPL | Stock | 178.56 | 178.6 | 178.56 | 178.6 | 1674.0 |
| 2023-08-14 04:17:00 | AAPL | Stock | 178.55 | 178.56 | 178.55 | 178.55 | 4035.0 |
| 2023-08-14 04:18:00 | AAPL | Stock | 178.57 | 178.57 | 178.51 | 178.51 | 1518.0 |
| 2023-08-14 04:19:00 | AAPL | Stock | 178.51 | 178.55 | 178.5 | 178.51 | 641.0 |
| 2023-08-14 04:20:00 | AAPL | Stock | 178.59 | 178.6 | 178.59 | 178.6 | 300.0 |
| 2023-08-14 04:21:00 | AAPL | Stock | 178.6 | 178.62 | 178.6 | 178.62 | 931.0 |
| 2023-08-14 04:22:00 | AAPL | Stock | 178.68 | 178.8 | 178.68 | 178.8 | 1982.0 |
| 2023-08-14 04:23:00 | AAPL | Stock | 178.85 | 178.85 | 178.83 | 178.85 | 3900.0 |
| 2023-08-14 04:24:00 | AAPL | Stock | 178.8 | 178.8 | 178.79 | 178.79 | 405.0 |
| 2023-08-14 04:25:00 | AAPL | Stock | 178.64 | 178.8 | 178.62 | 178.8 | 9398.0 |
| 2023-08-14 04:26:00 | AAPL | Stock | 178.63 | 178.63 | 178.63 | 178.63 | 3000.0 |
| 2023-08-14 04:27:00 | AAPL | Stock | 178.6 | 178.61 | 178.6 | 178.6 | 3718.0 |
| 2023-08-14 04:28:00 | AAPL | Stock | 178.6 | 178.61 | 178.6 | 178.61 | 7911.0 |
| 2023-08-14 04:29:00 | AAPL | Stock | 178.6 | 178.6 | 178.55 | 178.55 | 3057.0 |
| 2023-08-14 04:30:00 | AAPL | Stock | 178.56 | 178.56 | 178.55 | 178.55 | 3817.0 |
| 2023-08-14 04:31:00 | AAPL | Stock | 178.55 | 178.55 | 178.5 | 178.5 | 700.0 |
| 2023-08-14 04:32:00 | AAPL | Stock | 178.55 | 178.55 | 178.55 | 178.55 | 200.0 |
| 2023-08-14 04:34:00 | AAPL | Stock | 178.6 | 178.6 | 178.56 | 178.56 | 3033.0 |
| 2023-08-14 04:35:00 | AAPL | Stock | 178.63 | 178.63 | 178.63 | 178.63 | 200.0 |
| 2023-08-14 04:36:00 | AAPL | Stock | 178.62 | 178.62 | 178.62 | 178.62 | 198.0 |
| 2023-08-14 04:37:00 | AAPL | Stock | 178.65 | 178.75 | 178.65 | 178.75 | 619.0 |
| 2023-08-14 04:38:00 | AAPL | Stock | 178.76 | 178.84 | 178.76 | 178.84 | 2519.0 |
| 2023-08-14 04:46:00 | AAPL | Stock | 178.74 | 178.74 | 178.74 | 178.74 | 412.0 |
| 2023-08-14 04:48:00 | AAPL | Stock | 178.72 | 178.72 | 178.72 | 178.72 | 480.0 |
| 2023-08-14 04:50:00 | AAPL | Stock | 178.69 | 178.69 | 178.69 | 178.69 | 869.0 |
| 2023-08-14 04:54:00 | AAPL | Stock | 178.71 | 178.79 | 178.71 | 178.79 | 1218.0 |
| 2023-08-14 04:55:00 | AAPL | Stock | 178.79 | 178.79 | 178.79 | 178.79 | 400.0 |
| 2023-08-14 04:56:00 | AAPL | Stock | 178.63 | 178.63 | 178.63 | 178.63 | 400.0 |
| 2023-08-14 05:00:00 | AAPL | Stock | 178.55 | 178.55 | 178.55 | 178.55 | 576.0 |
| 2023-08-14 05:01:00 | AAPL | Stock | 178.5 | 178.5 | 178.5 | 178.5 | 368.0 |
| 2023-08-14 05:05:00 | AAPL | Stock | 178.5 | 178.5 | 178.5 | 178.5 | 324.0 |
| 2023-08-14 05:06:00 | AAPL | Stock | 178.61 | 178.61 | 178.61 | 178.61 | 176.0 |
| 2023-08-14 05:10:00 | AAPL | Stock | 178.36 | 178.36 | 178.36 | 178.36 | 215.0 |
| 2023-08-14 05:11:00 | AAPL | Stock | 178.29 | 178.4 | 178.29 | 178.4 | 560.0 |
| 2023-08-14 05:12:00 | AAPL | Stock | 178.56 | 178.56 | 178.56 | 178.56 | 105.0 |
| 2023-08-14 05:15:00 | AAPL | Stock | 178.49 | 178.6 | 178.49 | 178.6 | 895.0 |
> showing 50 of 1,239,042 rows — these rows as CSV