PREVIEW / stock_5min / 2024-04-03
file: by_date/stock_5min/2024/2024-04-03.parquet size: 6.7 MB rows: 405,122 symbols: 1,038
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-04-03 04:00:00 | AAPL | Stock | 169.3 | 169.3 | 168.87 | 168.9 | 5059.0 |
| 2024-04-03 04:05:00 | AAPL | Stock | 168.89 | 168.89 | 168.89 | 168.89 | 400.0 |
| 2024-04-03 04:10:00 | AAPL | Stock | 168.81 | 168.89 | 168.81 | 168.89 | 515.0 |
| 2024-04-03 04:15:00 | AAPL | Stock | 168.85 | 168.89 | 168.85 | 168.89 | 354.0 |
| 2024-04-03 04:20:00 | AAPL | Stock | 168.85 | 168.9 | 168.85 | 168.9 | 759.0 |
| 2024-04-03 04:25:00 | AAPL | Stock | 168.85 | 168.94 | 168.85 | 168.87 | 1643.0 |
| 2024-04-03 04:30:00 | AAPL | Stock | 169.0 | 169.0 | 169.0 | 169.0 | 100.0 |
| 2024-04-03 04:40:00 | AAPL | Stock | 168.89 | 168.89 | 168.89 | 168.89 | 248.0 |
| 2024-04-03 04:45:00 | AAPL | Stock | 168.94 | 168.99 | 168.9 | 168.9 | 2882.0 |
| 2024-04-03 04:50:00 | AAPL | Stock | 168.9 | 168.9 | 168.86 | 168.86 | 2570.0 |
| 2024-04-03 05:00:00 | AAPL | Stock | 168.86 | 168.86 | 168.86 | 168.86 | 140.0 |
| 2024-04-03 05:05:00 | AAPL | Stock | 168.85 | 168.85 | 168.85 | 168.85 | 118.0 |
| 2024-04-03 05:10:00 | AAPL | Stock | 168.9 | 168.9 | 168.9 | 168.9 | 797.0 |
| 2024-04-03 05:20:00 | AAPL | Stock | 168.8 | 168.8 | 168.68 | 168.69 | 520.0 |
| 2024-04-03 05:25:00 | AAPL | Stock | 168.66 | 168.66 | 168.54 | 168.54 | 1024.0 |
| 2024-04-03 05:30:00 | AAPL | Stock | 168.61 | 168.61 | 168.61 | 168.61 | 100.0 |
| 2024-04-03 05:35:00 | AAPL | Stock | 168.61 | 168.62 | 168.61 | 168.62 | 293.0 |
| 2024-04-03 05:50:00 | AAPL | Stock | 168.65 | 168.65 | 168.64 | 168.64 | 727.0 |
| 2024-04-03 05:55:00 | AAPL | Stock | 168.61 | 168.61 | 168.6 | 168.6 | 394.0 |
| 2024-04-03 06:00:00 | AAPL | Stock | 168.6 | 168.6 | 168.5 | 168.51 | 1789.0 |
| 2024-04-03 06:05:00 | AAPL | Stock | 168.57 | 168.57 | 168.57 | 168.57 | 627.0 |
| 2024-04-03 06:15:00 | AAPL | Stock | 168.7 | 168.7 | 168.7 | 168.7 | 397.0 |
| 2024-04-03 06:20:00 | AAPL | Stock | 168.7 | 168.75 | 168.7 | 168.75 | 548.0 |
| 2024-04-03 06:25:00 | AAPL | Stock | 168.73 | 168.73 | 168.7 | 168.7 | 271.0 |
| 2024-04-03 06:30:00 | AAPL | Stock | 168.7 | 168.7 | 168.7 | 168.7 | 800.0 |
| 2024-04-03 06:40:00 | AAPL | Stock | 168.63 | 168.65 | 168.6 | 168.6 | 1705.0 |
| 2024-04-03 06:50:00 | AAPL | Stock | 168.68 | 168.68 | 168.68 | 168.68 | 100.0 |
| 2024-04-03 06:55:00 | AAPL | Stock | 168.68 | 168.68 | 168.68 | 168.68 | 100.0 |
| 2024-04-03 07:00:00 | AAPL | Stock | 168.72 | 168.84 | 168.72 | 168.84 | 1710.0 |
| 2024-04-03 07:05:00 | AAPL | Stock | 168.81 | 168.86 | 168.81 | 168.86 | 524.0 |
| 2024-04-03 07:10:00 | AAPL | Stock | 168.81 | 168.83 | 168.76 | 168.83 | 3246.0 |
| 2024-04-03 07:15:00 | AAPL | Stock | 168.91 | 168.96 | 168.9 | 168.95 | 2304.0 |
| 2024-04-03 07:20:00 | AAPL | Stock | 168.96 | 169.09 | 168.96 | 169.09 | 3550.0 |
| 2024-04-03 07:25:00 | AAPL | Stock | 169.0 | 169.0 | 168.97 | 168.97 | 830.0 |
| 2024-04-03 07:30:00 | AAPL | Stock | 168.9 | 169.06 | 168.9 | 169.06 | 1840.0 |
| 2024-04-03 07:35:00 | AAPL | Stock | 169.0 | 169.0 | 169.0 | 169.0 | 221.0 |
| 2024-04-03 07:40:00 | AAPL | Stock | 169.0 | 169.0 | 168.97 | 168.97 | 608.0 |
| 2024-04-03 07:45:00 | AAPL | Stock | 168.94 | 168.95 | 168.89 | 168.89 | 951.0 |
| 2024-04-03 07:50:00 | AAPL | Stock | 168.87 | 169.09 | 168.85 | 169.09 | 4411.0 |
| 2024-04-03 07:55:00 | AAPL | Stock | 169.09 | 169.1 | 169.06 | 169.06 | 936.0 |
| 2024-04-03 08:00:00 | AAPL | Stock | 168.74 | 169.18 | 168.72 | 169.15 | 38629.0 |
| 2024-04-03 08:05:00 | AAPL | Stock | 169.15 | 169.18 | 169.11 | 169.11 | 7128.0 |
| 2024-04-03 08:10:00 | AAPL | Stock | 169.17 | 169.17 | 169.1 | 169.15 | 7719.0 |
| 2024-04-03 08:15:00 | AAPL | Stock | 169.1 | 169.27 | 169.01 | 169.27 | 14075.0 |
| 2024-04-03 08:20:00 | AAPL | Stock | 169.29 | 169.35 | 169.12 | 169.12 | 23251.0 |
| 2024-04-03 08:25:00 | AAPL | Stock | 169.17 | 169.17 | 168.9 | 168.9124 | 6060.0 |
| 2024-04-03 08:30:00 | AAPL | Stock | 168.91 | 169.06 | 168.91 | 169.06 | 9049.0 |
| 2024-04-03 08:35:00 | AAPL | Stock | 169.03 | 169.05 | 168.85 | 168.91 | 4558.0 |
| 2024-04-03 08:40:00 | AAPL | Stock | 168.96 | 168.96 | 168.905 | 168.905 | 2688.0 |
| 2024-04-03 08:45:00 | AAPL | Stock | 168.93 | 169.0 | 168.9 | 168.91 | 3405.0 |
> showing 50 of 405,122 rows — these rows as CSV