PREVIEW / stock_1min / 2024-05-20
file: by_date/stock_1min/2024/2024-05-20.parquet size: 21.0 MB rows: 1,213,756 symbols: 967
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-20 04:00:00 | AAPL | Stock | 189.84 | 189.87 | 189.72 | 189.72 | 300.0 |
| 2024-05-20 04:01:00 | AAPL | Stock | 189.89 | 189.89 | 189.89 | 189.89 | 100.0 |
| 2024-05-20 04:02:00 | AAPL | Stock | 189.85 | 189.85 | 189.85 | 189.85 | 100.0 |
| 2024-05-20 04:05:00 | AAPL | Stock | 189.8 | 189.86 | 189.8 | 189.86 | 547.0 |
| 2024-05-20 04:06:00 | AAPL | Stock | 189.86 | 189.86 | 189.86 | 189.86 | 150.0 |
| 2024-05-20 04:10:00 | AAPL | Stock | 189.9 | 189.99 | 189.9 | 189.91 | 894.0 |
| 2024-05-20 04:11:00 | AAPL | Stock | 189.96 | 189.96 | 189.91 | 189.91 | 450.0 |
| 2024-05-20 04:12:00 | AAPL | Stock | 189.91 | 189.91 | 189.91 | 189.91 | 298.0 |
| 2024-05-20 04:13:00 | AAPL | Stock | 189.95 | 189.95 | 189.95 | 189.95 | 125.0 |
| 2024-05-20 04:16:00 | AAPL | Stock | 190.0 | 190.0 | 190.0 | 190.0 | 274.0 |
| 2024-05-20 04:18:00 | AAPL | Stock | 190.0 | 190.0 | 190.0 | 190.0 | 250.0 |
| 2024-05-20 04:19:00 | AAPL | Stock | 190.05 | 190.06 | 190.05 | 190.06 | 407.0 |
| 2024-05-20 04:24:00 | AAPL | Stock | 190.09 | 190.1 | 190.09 | 190.1 | 868.0 |
| 2024-05-20 04:28:00 | AAPL | Stock | 190.06 | 190.06 | 190.06 | 190.06 | 250.0 |
| 2024-05-20 04:34:00 | AAPL | Stock | 190.0 | 190.0 | 190.0 | 190.0 | 1347.0 |
| 2024-05-20 04:51:00 | AAPL | Stock | 189.87 | 189.87 | 189.87 | 189.87 | 100.0 |
| 2024-05-20 04:52:00 | AAPL | Stock | 189.88 | 189.88 | 189.88 | 189.88 | 112.0 |
| 2024-05-20 04:56:00 | AAPL | Stock | 189.9 | 189.9 | 189.9 | 189.9 | 537.0 |
| 2024-05-20 04:58:00 | AAPL | Stock | 189.9 | 189.9 | 189.9 | 189.9 | 100.0 |
| 2024-05-20 05:08:00 | AAPL | Stock | 189.79 | 189.79 | 189.79 | 189.79 | 154.0 |
| 2024-05-20 05:10:00 | AAPL | Stock | 189.79 | 189.79 | 189.79 | 189.79 | 788.0 |
| 2024-05-20 05:11:00 | AAPL | Stock | 189.65 | 189.65 | 189.65 | 189.65 | 100.0 |
| 2024-05-20 05:12:00 | AAPL | Stock | 189.62 | 189.62 | 189.62 | 189.62 | 100.0 |
| 2024-05-20 05:13:00 | AAPL | Stock | 189.75 | 189.75 | 189.75 | 189.75 | 190.0 |
| 2024-05-20 05:15:00 | AAPL | Stock | 189.77 | 189.77 | 189.69 | 189.69 | 2525.0 |
| 2024-05-20 05:16:00 | AAPL | Stock | 189.62 | 189.62 | 189.62 | 189.62 | 100.0 |
| 2024-05-20 05:20:00 | AAPL | Stock | 189.6 | 189.6 | 189.53 | 189.56 | 1005.0 |
| 2024-05-20 05:22:00 | AAPL | Stock | 189.52 | 189.52 | 189.52 | 189.52 | 201.0 |
| 2024-05-20 05:23:00 | AAPL | Stock | 189.37 | 189.37 | 189.37 | 189.37 | 475.0 |
| 2024-05-20 05:25:00 | AAPL | Stock | 189.43 | 189.43 | 189.43 | 189.43 | 500.0 |
| 2024-05-20 05:26:00 | AAPL | Stock | 189.43 | 189.43 | 189.43 | 189.43 | 550.0 |
| 2024-05-20 05:27:00 | AAPL | Stock | 189.4 | 189.4 | 189.4 | 189.4 | 178.0 |
| 2024-05-20 05:28:00 | AAPL | Stock | 189.35 | 189.35 | 189.3 | 189.3 | 250.0 |
| 2024-05-20 05:29:00 | AAPL | Stock | 189.32 | 189.32 | 189.32 | 189.32 | 100.0 |
| 2024-05-20 05:30:00 | AAPL | Stock | 189.3 | 189.3 | 189.2 | 189.2 | 1362.0 |
| 2024-05-20 05:31:00 | AAPL | Stock | 189.2 | 189.2 | 189.11 | 189.11 | 2387.0 |
| 2024-05-20 05:32:00 | AAPL | Stock | 189.07 | 189.1 | 189.05 | 189.1 | 800.0 |
| 2024-05-20 05:33:00 | AAPL | Stock | 189.12 | 189.2 | 189.1 | 189.1 | 1920.0 |
| 2024-05-20 05:34:00 | AAPL | Stock | 189.29 | 189.33 | 189.18 | 189.18 | 1175.0 |
| 2024-05-20 05:36:00 | AAPL | Stock | 189.12 | 189.17 | 189.1 | 189.14 | 1128.0 |
| 2024-05-20 05:39:00 | AAPL | Stock | 189.17 | 189.17 | 189.1 | 189.1 | 3149.0 |
| 2024-05-20 05:40:00 | AAPL | Stock | 189.01 | 189.02 | 188.93 | 188.93 | 2313.0 |
| 2024-05-20 05:41:00 | AAPL | Stock | 188.92 | 188.92 | 188.85 | 188.85 | 3561.0 |
| 2024-05-20 05:42:00 | AAPL | Stock | 188.8 | 188.8 | 188.79 | 188.79 | 434.0 |
| 2024-05-20 05:43:00 | AAPL | Stock | 188.75 | 188.78 | 188.71 | 188.75 | 775.0 |
| 2024-05-20 05:44:00 | AAPL | Stock | 188.66 | 188.68 | 188.53 | 188.61 | 1324.0 |
| 2024-05-20 05:46:00 | AAPL | Stock | 188.69 | 188.69 | 188.69 | 188.69 | 100.0 |
| 2024-05-20 05:47:00 | AAPL | Stock | 188.79 | 188.79 | 188.79 | 188.79 | 125.0 |
| 2024-05-20 05:48:00 | AAPL | Stock | 188.75 | 188.75 | 188.75 | 188.75 | 400.0 |
| 2024-05-20 05:49:00 | AAPL | Stock | 188.8 | 188.8 | 188.8 | 188.8 | 200.0 |
> showing 50 of 1,213,756 rows — these rows as CSV