PREVIEW / stock_5min / 2023-01-11
file: by_date/stock_5min/2023/2023-01-11.parquet size: 6.9 MB rows: 425,140 symbols: 1,959
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-01-11 04:00:00 | AAPL | Stock | 130.95 | 131.15 | 130.8 | 131.09 | 5686.0 |
| 2023-01-11 04:05:00 | AAPL | Stock | 131.16 | 131.2 | 131.13 | 131.19 | 2174.0 |
| 2023-01-11 04:10:00 | AAPL | Stock | 131.18 | 131.18 | 131.1 | 131.15 | 2687.0 |
| 2023-01-11 04:15:00 | AAPL | Stock | 131.18 | 131.3 | 131.18 | 131.2 | 3021.0 |
| 2023-01-11 04:20:00 | AAPL | Stock | 131.18 | 131.26 | 131.17 | 131.2 | 1819.0 |
| 2023-01-11 04:25:00 | AAPL | Stock | 131.2 | 131.26 | 131.2 | 131.23 | 1791.0 |
| 2023-01-11 04:30:00 | AAPL | Stock | 131.24 | 131.24 | 131.18 | 131.18 | 570.0 |
| 2023-01-11 04:35:00 | AAPL | Stock | 131.18 | 131.19 | 131.1 | 131.11 | 1484.0 |
| 2023-01-11 04:45:00 | AAPL | Stock | 131.16 | 131.18 | 131.16 | 131.18 | 515.0 |
| 2023-01-11 04:50:00 | AAPL | Stock | 131.11 | 131.2 | 131.07 | 131.2 | 1788.0 |
| 2023-01-11 04:55:00 | AAPL | Stock | 131.2 | 131.2 | 131.05 | 131.05 | 1881.0 |
| 2023-01-11 05:05:00 | AAPL | Stock | 131.21 | 131.28 | 131.21 | 131.28 | 1178.0 |
| 2023-01-11 05:10:00 | AAPL | Stock | 131.25 | 131.32 | 131.25 | 131.32 | 574.0 |
| 2023-01-11 05:15:00 | AAPL | Stock | 131.25 | 131.29 | 131.1 | 131.1 | 6064.0 |
| 2023-01-11 05:20:00 | AAPL | Stock | 131.1 | 131.13 | 131.1 | 131.13 | 359.0 |
| 2023-01-11 05:30:00 | AAPL | Stock | 131.16 | 131.19 | 131.16 | 131.19 | 236.0 |
| 2023-01-11 05:35:00 | AAPL | Stock | 131.15 | 131.15 | 131.05 | 131.05 | 1518.0 |
| 2023-01-11 05:40:00 | AAPL | Stock | 131.05 | 131.05 | 131.0 | 131.01 | 4461.0 |
| 2023-01-11 05:45:00 | AAPL | Stock | 131.05 | 131.05 | 131.04 | 131.04 | 300.0 |
| 2023-01-11 05:50:00 | AAPL | Stock | 131.03 | 131.05 | 131.03 | 131.05 | 290.0 |
| 2023-01-11 05:55:00 | AAPL | Stock | 131.03 | 131.03 | 130.96 | 130.96 | 602.0 |
| 2023-01-11 06:00:00 | AAPL | Stock | 130.96 | 130.96 | 130.96 | 130.96 | 531.0 |
| 2023-01-11 06:05:00 | AAPL | Stock | 130.95 | 130.95 | 130.87 | 130.87 | 1455.0 |
| 2023-01-11 06:10:00 | AAPL | Stock | 130.96 | 130.96 | 130.85 | 130.85 | 1613.0 |
| 2023-01-11 06:20:00 | AAPL | Stock | 130.9 | 130.91 | 130.9 | 130.9 | 575.0 |
| 2023-01-11 06:25:00 | AAPL | Stock | 130.89 | 130.94 | 130.89 | 130.94 | 348.0 |
| 2023-01-11 06:30:00 | AAPL | Stock | 131.0 | 131.1 | 130.98 | 131.1 | 8653.0 |
| 2023-01-11 06:35:00 | AAPL | Stock | 131.0 | 131.05 | 130.95 | 131.05 | 2550.0 |
| 2023-01-11 06:40:00 | AAPL | Stock | 131.05 | 131.18 | 131.05 | 131.18 | 2050.0 |
| 2023-01-11 06:45:00 | AAPL | Stock | 131.15 | 131.16 | 130.92 | 130.92 | 4142.0 |
| 2023-01-11 06:50:00 | AAPL | Stock | 130.9 | 130.91 | 130.82 | 130.82 | 4099.0 |
| 2023-01-11 06:55:00 | AAPL | Stock | 130.82 | 130.82 | 130.8 | 130.8 | 1425.0 |
| 2023-01-11 07:00:00 | AAPL | Stock | 130.88 | 130.93 | 130.84 | 130.88 | 4522.0 |
| 2023-01-11 07:05:00 | AAPL | Stock | 130.9 | 130.94 | 130.9 | 130.94 | 1667.0 |
| 2023-01-11 07:10:00 | AAPL | Stock | 130.89 | 130.91 | 130.73 | 130.73 | 4794.0 |
| 2023-01-11 07:15:00 | AAPL | Stock | 130.74 | 130.74 | 130.61 | 130.62 | 4726.0 |
| 2023-01-11 07:20:00 | AAPL | Stock | 130.63 | 130.65 | 130.46 | 130.64 | 16471.0 |
| 2023-01-11 07:25:00 | AAPL | Stock | 130.63 | 130.63 | 130.57 | 130.6 | 3357.0 |
| 2023-01-11 07:30:00 | AAPL | Stock | 130.65 | 130.79 | 130.65 | 130.75 | 1310.0 |
| 2023-01-11 07:35:00 | AAPL | Stock | 130.75 | 130.81 | 130.72 | 130.72 | 5812.0 |
| 2023-01-11 07:40:00 | AAPL | Stock | 130.75 | 130.76 | 130.7 | 130.7 | 1482.0 |
| 2023-01-11 07:45:00 | AAPL | Stock | 130.7 | 130.84 | 130.7 | 130.84 | 1400.0 |
| 2023-01-11 07:50:00 | AAPL | Stock | 130.83 | 130.83 | 130.76 | 130.76 | 2980.0 |
| 2023-01-11 07:55:00 | AAPL | Stock | 130.71 | 130.71 | 130.63 | 130.7 | 5754.0 |
| 2023-01-11 08:00:00 | AAPL | Stock | 130.85 | 131.1015 | 130.404 | 130.76 | 47961.0 |
| 2023-01-11 08:05:00 | AAPL | Stock | 130.79 | 130.9 | 130.79 | 130.82 | 9658.0 |
| 2023-01-11 08:10:00 | AAPL | Stock | 130.8 | 130.87 | 130.75 | 130.85 | 12169.0 |
| 2023-01-11 08:15:00 | AAPL | Stock | 130.85 | 130.95 | 130.82 | 130.94 | 19472.0 |
| 2023-01-11 08:20:00 | AAPL | Stock | 130.92 | 131.0 | 130.86 | 131.0 | 14701.0 |
| 2023-01-11 08:25:00 | AAPL | Stock | 131.02 | 131.18 | 130.92 | 131.06 | 33013.0 |
> showing 50 of 425,140 rows — these rows as CSV