PREVIEW / stock_1min / 2023-09-21
file: by_date/stock_1min/2023/2023-09-21.parquet size: 19.7 MB rows: 1,221,321 symbols: 1,350
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-09-21 04:05:00 | AAPL | Stock | 175.01 | 175.01 | 175.01 | 175.01 | 275.0 |
| 2023-09-21 04:07:00 | AAPL | Stock | 175.03 | 175.03 | 174.92 | 174.92 | 1227.0 |
| 2023-09-21 04:08:00 | AAPL | Stock | 174.83 | 174.83 | 174.8 | 174.8 | 2167.0 |
| 2023-09-21 04:09:00 | AAPL | Stock | 174.79 | 174.79 | 174.79 | 174.79 | 150.0 |
| 2023-09-21 04:12:00 | AAPL | Stock | 174.89 | 174.89 | 174.8 | 174.82 | 723.0 |
| 2023-09-21 04:13:00 | AAPL | Stock | 174.86 | 174.86 | 174.86 | 174.86 | 280.0 |
| 2023-09-21 04:14:00 | AAPL | Stock | 174.77 | 174.85 | 174.77 | 174.85 | 434.0 |
| 2023-09-21 04:15:00 | AAPL | Stock | 174.77 | 174.77 | 174.76 | 174.76 | 600.0 |
| 2023-09-21 04:16:00 | AAPL | Stock | 174.77 | 174.77 | 174.77 | 174.77 | 150.0 |
| 2023-09-21 04:17:00 | AAPL | Stock | 174.77 | 174.77 | 174.77 | 174.77 | 1948.0 |
| 2023-09-21 04:19:00 | AAPL | Stock | 174.75 | 174.77 | 174.75 | 174.77 | 297.0 |
| 2023-09-21 04:20:00 | AAPL | Stock | 174.73 | 174.75 | 174.73 | 174.75 | 220.0 |
| 2023-09-21 04:21:00 | AAPL | Stock | 174.75 | 174.75 | 174.75 | 174.75 | 1490.0 |
| 2023-09-21 04:25:00 | AAPL | Stock | 174.75 | 174.75 | 174.72 | 174.72 | 956.0 |
| 2023-09-21 04:27:00 | AAPL | Stock | 174.75 | 174.75 | 174.75 | 174.75 | 885.0 |
| 2023-09-21 04:29:00 | AAPL | Stock | 174.8 | 174.83 | 174.8 | 174.83 | 710.0 |
| 2023-09-21 04:30:00 | AAPL | Stock | 174.76 | 174.76 | 174.76 | 174.76 | 400.0 |
| 2023-09-21 04:31:00 | AAPL | Stock | 174.76 | 174.76 | 174.76 | 174.76 | 390.0 |
| 2023-09-21 04:32:00 | AAPL | Stock | 174.78 | 174.78 | 174.75 | 174.75 | 2610.0 |
| 2023-09-21 04:33:00 | AAPL | Stock | 174.75 | 174.75 | 174.75 | 174.75 | 200.0 |
| 2023-09-21 04:34:00 | AAPL | Stock | 174.68 | 174.68 | 174.68 | 174.68 | 450.0 |
| 2023-09-21 04:37:00 | AAPL | Stock | 174.68 | 174.68 | 174.65 | 174.66 | 3892.0 |
| 2023-09-21 04:38:00 | AAPL | Stock | 174.65 | 174.65 | 174.65 | 174.65 | 1547.0 |
| 2023-09-21 04:39:00 | AAPL | Stock | 174.56 | 174.56 | 174.56 | 174.56 | 153.0 |
| 2023-09-21 04:41:00 | AAPL | Stock | 174.6 | 174.6 | 174.6 | 174.6 | 200.0 |
| 2023-09-21 04:42:00 | AAPL | Stock | 174.6 | 174.6 | 174.6 | 174.6 | 330.0 |
| 2023-09-21 04:44:00 | AAPL | Stock | 174.65 | 174.65 | 174.65 | 174.65 | 103.0 |
| 2023-09-21 04:45:00 | AAPL | Stock | 174.65 | 174.65 | 174.65 | 174.65 | 385.0 |
| 2023-09-21 04:48:00 | AAPL | Stock | 174.65 | 174.65 | 174.65 | 174.65 | 200.0 |
| 2023-09-21 04:51:00 | AAPL | Stock | 174.69 | 174.69 | 174.69 | 174.69 | 199.0 |
| 2023-09-21 04:54:00 | AAPL | Stock | 174.63 | 174.63 | 174.63 | 174.63 | 100.0 |
| 2023-09-21 04:55:00 | AAPL | Stock | 174.6 | 174.6 | 174.6 | 174.6 | 100.0 |
| 2023-09-21 04:56:00 | AAPL | Stock | 174.56 | 174.56 | 174.56 | 174.56 | 150.0 |
| 2023-09-21 04:57:00 | AAPL | Stock | 174.56 | 174.56 | 174.55 | 174.55 | 205.0 |
| 2023-09-21 04:59:00 | AAPL | Stock | 174.6 | 174.61 | 174.6 | 174.61 | 500.0 |
| 2023-09-21 05:00:00 | AAPL | Stock | 174.6 | 174.6 | 174.6 | 174.6 | 477.0 |
| 2023-09-21 05:01:00 | AAPL | Stock | 174.63 | 174.64 | 174.6 | 174.64 | 1893.0 |
| 2023-09-21 05:02:00 | AAPL | Stock | 174.64 | 174.64 | 174.64 | 174.64 | 181.0 |
| 2023-09-21 05:03:00 | AAPL | Stock | 174.69 | 174.69 | 174.69 | 174.69 | 100.0 |
| 2023-09-21 05:07:00 | AAPL | Stock | 174.71 | 174.71 | 174.71 | 174.71 | 112.0 |
| 2023-09-21 05:09:00 | AAPL | Stock | 174.71 | 174.71 | 174.71 | 174.71 | 500.0 |
| 2023-09-21 05:13:00 | AAPL | Stock | 174.72 | 174.72 | 174.72 | 174.72 | 100.0 |
| 2023-09-21 05:17:00 | AAPL | Stock | 174.72 | 174.72 | 174.7 | 174.7 | 325.0 |
| 2023-09-21 05:18:00 | AAPL | Stock | 174.7 | 174.7 | 174.7 | 174.7 | 1691.0 |
| 2023-09-21 05:19:00 | AAPL | Stock | 174.7 | 174.7 | 174.7 | 174.7 | 409.0 |
| 2023-09-21 05:24:00 | AAPL | Stock | 174.64 | 174.64 | 174.63 | 174.63 | 200.0 |
| 2023-09-21 05:26:00 | AAPL | Stock | 174.63 | 174.63 | 174.62 | 174.63 | 1949.0 |
| 2023-09-21 05:30:00 | AAPL | Stock | 174.64 | 174.65 | 174.64 | 174.65 | 648.0 |
| 2023-09-21 05:31:00 | AAPL | Stock | 174.65 | 174.65 | 174.65 | 174.65 | 966.0 |
| 2023-09-21 05:39:00 | AAPL | Stock | 174.62 | 174.62 | 174.62 | 174.62 | 100.0 |
> showing 50 of 1,221,321 rows — these rows as CSV