PREVIEW / stock_1min / 2024-03-28
file: by_date/stock_1min/2024/2024-03-28.parquet size: 20.6 MB rows: 1,258,407 symbols: 1,061
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-03-28 04:00:00 | AAPL | Stock | 173.17 | 173.17 | 173.17 | 173.17 | 486.0 |
| 2024-03-28 04:01:00 | AAPL | Stock | 173.24 | 173.24 | 173.24 | 173.24 | 153.0 |
| 2024-03-28 04:03:00 | AAPL | Stock | 173.36 | 173.38 | 173.15 | 173.15 | 595.0 |
| 2024-03-28 04:04:00 | AAPL | Stock | 173.07 | 173.07 | 173.06 | 173.06 | 200.0 |
| 2024-03-28 04:05:00 | AAPL | Stock | 173.07 | 173.07 | 172.8 | 172.8 | 2484.0 |
| 2024-03-28 04:07:00 | AAPL | Stock | 172.8 | 172.81 | 172.7 | 172.7 | 1629.0 |
| 2024-03-28 04:08:00 | AAPL | Stock | 172.7 | 172.71 | 172.7 | 172.7 | 316.0 |
| 2024-03-28 04:09:00 | AAPL | Stock | 172.91 | 172.92 | 172.91 | 172.92 | 345.0 |
| 2024-03-28 04:10:00 | AAPL | Stock | 172.82 | 172.83 | 172.82 | 172.83 | 250.0 |
| 2024-03-28 04:11:00 | AAPL | Stock | 172.83 | 172.83 | 172.83 | 172.83 | 100.0 |
| 2024-03-28 04:13:00 | AAPL | Stock | 172.8 | 172.8 | 172.8 | 172.8 | 100.0 |
| 2024-03-28 04:15:00 | AAPL | Stock | 172.92 | 172.92 | 172.92 | 172.92 | 300.0 |
| 2024-03-28 04:19:00 | AAPL | Stock | 173.04 | 173.04 | 173.04 | 173.04 | 200.0 |
| 2024-03-28 04:28:00 | AAPL | Stock | 172.96 | 172.96 | 172.96 | 172.96 | 439.0 |
| 2024-03-28 04:32:00 | AAPL | Stock | 172.99 | 172.99 | 172.99 | 172.99 | 100.0 |
| 2024-03-28 04:40:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 100.0 |
| 2024-03-28 04:45:00 | AAPL | Stock | 173.0 | 173.0 | 173.0 | 173.0 | 216.0 |
| 2024-03-28 04:52:00 | AAPL | Stock | 172.97 | 172.97 | 172.97 | 172.97 | 142.0 |
| 2024-03-28 04:56:00 | AAPL | Stock | 172.89 | 172.89 | 172.79 | 172.79 | 742.0 |
| 2024-03-28 04:58:00 | AAPL | Stock | 172.79 | 172.79 | 172.77 | 172.77 | 619.0 |
| 2024-03-28 05:00:00 | AAPL | Stock | 172.74 | 172.74 | 172.74 | 172.74 | 2913.0 |
| 2024-03-28 05:02:00 | AAPL | Stock | 172.8 | 172.8 | 172.8 | 172.8 | 200.0 |
| 2024-03-28 05:13:00 | AAPL | Stock | 172.74 | 172.74 | 172.74 | 172.74 | 365.0 |
| 2024-03-28 05:15:00 | AAPL | Stock | 172.75 | 172.75 | 172.75 | 172.75 | 100.0 |
| 2024-03-28 05:16:00 | AAPL | Stock | 172.72 | 172.72 | 172.72 | 172.72 | 150.0 |
| 2024-03-28 05:18:00 | AAPL | Stock | 172.65 | 172.65 | 172.65 | 172.65 | 443.0 |
| 2024-03-28 05:19:00 | AAPL | Stock | 172.6 | 172.6 | 172.52 | 172.52 | 495.0 |
| 2024-03-28 05:20:00 | AAPL | Stock | 172.53 | 172.53 | 172.53 | 172.53 | 100.0 |
| 2024-03-28 05:21:00 | AAPL | Stock | 172.53 | 172.54 | 172.53 | 172.54 | 615.0 |
| 2024-03-28 05:31:00 | AAPL | Stock | 172.6 | 172.6 | 172.6 | 172.6 | 494.0 |
| 2024-03-28 05:39:00 | AAPL | Stock | 172.68 | 172.68 | 172.68 | 172.68 | 137.0 |
| 2024-03-28 05:48:00 | AAPL | Stock | 172.6 | 172.6 | 172.6 | 172.6 | 100.0 |
| 2024-03-28 05:50:00 | AAPL | Stock | 172.62 | 172.62 | 172.62 | 172.62 | 200.0 |
| 2024-03-28 05:51:00 | AAPL | Stock | 172.57 | 172.57 | 172.57 | 172.57 | 359.0 |
| 2024-03-28 05:54:00 | AAPL | Stock | 172.61 | 172.61 | 172.61 | 172.61 | 159.0 |
| 2024-03-28 05:59:00 | AAPL | Stock | 172.65 | 172.65 | 172.63 | 172.63 | 1045.0 |
| 2024-03-28 06:04:00 | AAPL | Stock | 172.72 | 172.72 | 172.72 | 172.72 | 100.0 |
| 2024-03-28 06:10:00 | AAPL | Stock | 172.74 | 172.74 | 172.74 | 172.74 | 104.0 |
| 2024-03-28 06:12:00 | AAPL | Stock | 172.75 | 172.77 | 172.75 | 172.77 | 880.0 |
| 2024-03-28 06:24:00 | AAPL | Stock | 172.74 | 172.74 | 172.74 | 172.74 | 100.0 |
| 2024-03-28 06:26:00 | AAPL | Stock | 172.77 | 172.77 | 172.77 | 172.77 | 185.0 |
| 2024-03-28 06:30:00 | AAPL | Stock | 172.89 | 172.89 | 172.89 | 172.89 | 228.0 |
| 2024-03-28 06:35:00 | AAPL | Stock | 172.88 | 172.88 | 172.88 | 172.88 | 155.0 |
| 2024-03-28 06:38:00 | AAPL | Stock | 172.83 | 172.85 | 172.83 | 172.85 | 428.0 |
| 2024-03-28 06:45:00 | AAPL | Stock | 172.73 | 172.73 | 172.7 | 172.7 | 320.0 |
| 2024-03-28 06:46:00 | AAPL | Stock | 172.69 | 172.69 | 172.69 | 172.69 | 119.0 |
| 2024-03-28 06:49:00 | AAPL | Stock | 172.7 | 172.7 | 172.65 | 172.65 | 624.0 |
| 2024-03-28 06:50:00 | AAPL | Stock | 172.73 | 172.73 | 172.73 | 172.73 | 600.0 |
| 2024-03-28 06:51:00 | AAPL | Stock | 172.73 | 172.73 | 172.73 | 172.73 | 300.0 |
| 2024-03-28 06:54:00 | AAPL | Stock | 172.82 | 172.82 | 172.82 | 172.82 | 148.0 |
> showing 50 of 1,258,407 rows — these rows as CSV