PREVIEW / stock_1min / 2023-05-12
file: by_date/stock_1min/2023/2023-05-12.parquet size: 20.1 MB rows: 1,247,112 symbols: 1,545
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-05-12 04:00:00 | AAPL | Stock | 174.0 | 174.0 | 173.93 | 173.93 | 563.0 |
| 2023-05-12 04:02:00 | AAPL | Stock | 173.91 | 173.91 | 173.77 | 173.77 | 1944.0 |
| 2023-05-12 04:05:00 | AAPL | Stock | 173.86 | 173.86 | 173.78 | 173.78 | 349.0 |
| 2023-05-12 04:08:00 | AAPL | Stock | 173.8 | 173.87 | 173.8 | 173.87 | 810.0 |
| 2023-05-12 04:13:00 | AAPL | Stock | 173.95 | 173.95 | 173.95 | 173.95 | 200.0 |
| 2023-05-12 04:14:00 | AAPL | Stock | 173.9 | 173.93 | 173.9 | 173.9 | 907.0 |
| 2023-05-12 04:16:00 | AAPL | Stock | 173.95 | 173.99 | 173.95 | 173.99 | 988.0 |
| 2023-05-12 04:19:00 | AAPL | Stock | 173.99 | 174.0 | 173.99 | 174.0 | 847.0 |
| 2023-05-12 04:21:00 | AAPL | Stock | 174.0 | 174.0 | 174.0 | 174.0 | 200.0 |
| 2023-05-12 04:22:00 | AAPL | Stock | 174.0 | 174.0 | 174.0 | 174.0 | 500.0 |
| 2023-05-12 04:23:00 | AAPL | Stock | 174.05 | 174.05 | 174.05 | 174.05 | 229.0 |
| 2023-05-12 04:24:00 | AAPL | Stock | 174.05 | 174.05 | 174.05 | 174.05 | 700.0 |
| 2023-05-12 04:25:00 | AAPL | Stock | 174.05 | 174.05 | 174.05 | 174.05 | 349.0 |
| 2023-05-12 04:27:00 | AAPL | Stock | 174.0 | 174.0 | 174.0 | 174.0 | 200.0 |
| 2023-05-12 04:36:00 | AAPL | Stock | 173.94 | 173.94 | 173.94 | 173.94 | 113.0 |
| 2023-05-12 04:37:00 | AAPL | Stock | 173.82 | 173.82 | 173.8 | 173.8 | 1700.0 |
| 2023-05-12 04:38:00 | AAPL | Stock | 173.8 | 173.8 | 173.79 | 173.8 | 544.0 |
| 2023-05-12 04:46:00 | AAPL | Stock | 173.82 | 173.82 | 173.82 | 173.82 | 153.0 |
| 2023-05-12 04:53:00 | AAPL | Stock | 173.85 | 173.85 | 173.82 | 173.82 | 550.0 |
| 2023-05-12 04:54:00 | AAPL | Stock | 173.82 | 173.82 | 173.82 | 173.82 | 535.0 |
| 2023-05-12 04:58:00 | AAPL | Stock | 173.86 | 173.86 | 173.86 | 173.86 | 400.0 |
| 2023-05-12 05:03:00 | AAPL | Stock | 173.86 | 173.86 | 173.86 | 173.86 | 381.0 |
| 2023-05-12 05:05:00 | AAPL | Stock | 173.86 | 173.87 | 173.86 | 173.87 | 200.0 |
| 2023-05-12 05:08:00 | AAPL | Stock | 173.92 | 173.92 | 173.92 | 173.92 | 530.0 |
| 2023-05-12 05:09:00 | AAPL | Stock | 173.95 | 173.95 | 173.95 | 173.95 | 100.0 |
| 2023-05-12 05:29:00 | AAPL | Stock | 173.78 | 173.81 | 173.78 | 173.81 | 200.0 |
| 2023-05-12 05:32:00 | AAPL | Stock | 173.81 | 173.81 | 173.8 | 173.81 | 300.0 |
| 2023-05-12 05:37:00 | AAPL | Stock | 173.8 | 173.8 | 173.8 | 173.8 | 593.0 |
| 2023-05-12 05:38:00 | AAPL | Stock | 173.81 | 173.81 | 173.8 | 173.8 | 350.0 |
| 2023-05-12 05:39:00 | AAPL | Stock | 173.8 | 173.8 | 173.8 | 173.8 | 269.0 |
| 2023-05-12 05:41:00 | AAPL | Stock | 173.75 | 173.8 | 173.75 | 173.8 | 720.0 |
| 2023-05-12 05:47:00 | AAPL | Stock | 173.72 | 173.72 | 173.6 | 173.6 | 1357.0 |
| 2023-05-12 05:56:00 | AAPL | Stock | 173.55 | 173.56 | 173.55 | 173.56 | 588.0 |
| 2023-05-12 05:57:00 | AAPL | Stock | 173.5 | 173.51 | 173.5 | 173.5 | 778.0 |
| 2023-05-12 06:02:00 | AAPL | Stock | 173.57 | 173.59 | 173.57 | 173.59 | 489.0 |
| 2023-05-12 06:03:00 | AAPL | Stock | 173.59 | 173.59 | 173.59 | 173.59 | 100.0 |
| 2023-05-12 06:23:00 | AAPL | Stock | 173.58 | 173.58 | 173.58 | 173.58 | 100.0 |
| 2023-05-12 06:29:00 | AAPL | Stock | 173.54 | 173.54 | 173.54 | 173.54 | 500.0 |
| 2023-05-12 06:32:00 | AAPL | Stock | 173.59 | 173.65 | 173.59 | 173.6 | 1567.0 |
| 2023-05-12 06:33:00 | AAPL | Stock | 173.59 | 173.59 | 173.59 | 173.59 | 184.0 |
| 2023-05-12 06:45:00 | AAPL | Stock | 173.6 | 173.6 | 173.6 | 173.6 | 100.0 |
| 2023-05-12 06:46:00 | AAPL | Stock | 173.66 | 173.66 | 173.66 | 173.66 | 175.0 |
| 2023-05-12 06:47:00 | AAPL | Stock | 173.8 | 173.8 | 173.8 | 173.8 | 225.0 |
| 2023-05-12 06:49:00 | AAPL | Stock | 173.81 | 173.81 | 173.81 | 173.81 | 150.0 |
| 2023-05-12 06:53:00 | AAPL | Stock | 173.69 | 173.69 | 173.69 | 173.69 | 239.0 |
| 2023-05-12 06:54:00 | AAPL | Stock | 173.69 | 173.69 | 173.69 | 173.69 | 100.0 |
| 2023-05-12 07:01:00 | AAPL | Stock | 173.83 | 173.85 | 173.83 | 173.85 | 3705.0 |
| 2023-05-12 07:02:00 | AAPL | Stock | 173.87 | 173.87 | 173.83 | 173.84 | 943.0 |
| 2023-05-12 07:03:00 | AAPL | Stock | 173.84 | 173.84 | 173.83 | 173.83 | 1200.0 |
| 2023-05-12 07:04:00 | AAPL | Stock | 173.83 | 173.83 | 173.8 | 173.8 | 1230.0 |
> showing 50 of 1,247,112 rows — these rows as CSV