PREVIEW / stock_5min / 2023-06-06
file: by_date/stock_5min/2023/2023-06-06.parquet size: 6.8 MB rows: 416,226 symbols: 1,603
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-06-06 04:00:00 | AAPL | Stock | 179.05 | 179.51 | 178.51 | 178.75 | 35453.0 |
| 2023-06-06 04:05:00 | AAPL | Stock | 178.84 | 179.12 | 178.84 | 179.12 | 5993.0 |
| 2023-06-06 04:10:00 | AAPL | Stock | 179.18 | 179.18 | 178.75 | 178.75 | 4856.0 |
| 2023-06-06 04:15:00 | AAPL | Stock | 178.7 | 178.95 | 178.7 | 178.95 | 801.0 |
| 2023-06-06 04:20:00 | AAPL | Stock | 178.88 | 178.9 | 178.84 | 178.87 | 1348.0 |
| 2023-06-06 04:25:00 | AAPL | Stock | 178.88 | 178.88 | 178.8 | 178.8 | 699.0 |
| 2023-06-06 04:30:00 | AAPL | Stock | 178.81 | 178.81 | 178.53 | 178.53 | 6373.0 |
| 2023-06-06 04:35:00 | AAPL | Stock | 178.53 | 178.8 | 178.49 | 178.8 | 9823.0 |
| 2023-06-06 04:40:00 | AAPL | Stock | 178.75 | 178.75 | 178.59 | 178.65 | 1769.0 |
| 2023-06-06 04:45:00 | AAPL | Stock | 178.65 | 178.75 | 178.65 | 178.75 | 1652.0 |
| 2023-06-06 04:50:00 | AAPL | Stock | 178.78 | 178.82 | 178.77 | 178.77 | 1346.0 |
| 2023-06-06 04:55:00 | AAPL | Stock | 178.78 | 178.87 | 178.78 | 178.87 | 3310.0 |
| 2023-06-06 05:00:00 | AAPL | Stock | 178.86 | 178.9 | 178.86 | 178.88 | 2661.0 |
| 2023-06-06 05:05:00 | AAPL | Stock | 178.88 | 178.88 | 178.73 | 178.73 | 2938.0 |
| 2023-06-06 05:10:00 | AAPL | Stock | 178.74 | 178.85 | 178.7 | 178.85 | 819.0 |
| 2023-06-06 05:15:00 | AAPL | Stock | 178.8 | 178.8 | 178.7 | 178.7 | 4006.0 |
| 2023-06-06 05:20:00 | AAPL | Stock | 178.75 | 178.78 | 178.66 | 178.78 | 1326.0 |
| 2023-06-06 05:25:00 | AAPL | Stock | 178.74 | 178.74 | 178.61 | 178.61 | 2856.0 |
| 2023-06-06 05:30:00 | AAPL | Stock | 178.74 | 178.74 | 178.74 | 178.74 | 687.0 |
| 2023-06-06 05:35:00 | AAPL | Stock | 178.7 | 178.73 | 178.7 | 178.73 | 1664.0 |
| 2023-06-06 05:40:00 | AAPL | Stock | 178.69 | 178.69 | 178.6 | 178.6 | 1795.0 |
| 2023-06-06 05:45:00 | AAPL | Stock | 178.58 | 178.58 | 178.2 | 178.5 | 15995.0 |
| 2023-06-06 05:50:00 | AAPL | Stock | 178.4 | 178.47 | 178.17 | 178.45 | 7067.0 |
| 2023-06-06 05:55:00 | AAPL | Stock | 178.43 | 178.43 | 178.2 | 178.22 | 4060.0 |
| 2023-06-06 06:00:00 | AAPL | Stock | 178.27 | 178.27 | 178.2 | 178.2 | 2627.0 |
| 2023-06-06 06:05:00 | AAPL | Stock | 178.24 | 178.25 | 178.2 | 178.25 | 2051.0 |
| 2023-06-06 06:10:00 | AAPL | Stock | 178.28 | 178.45 | 178.28 | 178.4 | 5047.0 |
| 2023-06-06 06:15:00 | AAPL | Stock | 178.36 | 178.36 | 178.25 | 178.25 | 665.0 |
| 2023-06-06 06:20:00 | AAPL | Stock | 178.31 | 178.32 | 178.25 | 178.25 | 3907.0 |
| 2023-06-06 06:25:00 | AAPL | Stock | 178.3 | 178.31 | 178.3 | 178.31 | 616.0 |
| 2023-06-06 06:30:00 | AAPL | Stock | 178.38 | 178.4 | 178.38 | 178.4 | 3230.0 |
| 2023-06-06 06:35:00 | AAPL | Stock | 178.41 | 178.47 | 178.36 | 178.4 | 2673.0 |
| 2023-06-06 06:40:00 | AAPL | Stock | 178.4 | 178.4 | 178.4 | 178.4 | 1059.0 |
| 2023-06-06 06:45:00 | AAPL | Stock | 178.4 | 178.4 | 178.34 | 178.34 | 3907.0 |
| 2023-06-06 06:50:00 | AAPL | Stock | 178.53 | 178.53 | 178.45 | 178.45 | 600.0 |
| 2023-06-06 06:55:00 | AAPL | Stock | 178.43 | 178.45 | 178.4 | 178.45 | 2540.0 |
| 2023-06-06 07:00:00 | AAPL | Stock | 178.45 | 178.7 | 178.33 | 178.7 | 50096.0 |
| 2023-06-06 07:05:00 | AAPL | Stock | 178.72 | 178.88 | 178.68 | 178.8 | 5691.0 |
| 2023-06-06 07:10:00 | AAPL | Stock | 178.81 | 178.85 | 178.81 | 178.84 | 9856.0 |
| 2023-06-06 07:15:00 | AAPL | Stock | 178.84 | 178.93 | 178.8 | 178.86 | 6353.0 |
| 2023-06-06 07:20:00 | AAPL | Stock | 178.85 | 178.86 | 178.71 | 178.71 | 7011.0 |
| 2023-06-06 07:25:00 | AAPL | Stock | 178.74 | 178.74 | 178.66 | 178.74 | 4501.0 |
| 2023-06-06 07:30:00 | AAPL | Stock | 178.74 | 178.74 | 178.72 | 178.74 | 475.0 |
| 2023-06-06 07:35:00 | AAPL | Stock | 178.81 | 178.85 | 178.81 | 178.85 | 4177.0 |
| 2023-06-06 07:40:00 | AAPL | Stock | 178.85 | 178.85 | 178.7 | 178.7 | 12332.0 |
| 2023-06-06 07:45:00 | AAPL | Stock | 178.8 | 179.0 | 178.74 | 178.74 | 6464.0 |
| 2023-06-06 07:50:00 | AAPL | Stock | 178.77 | 178.8 | 178.7 | 178.72 | 5885.0 |
| 2023-06-06 07:55:00 | AAPL | Stock | 178.79 | 178.79 | 178.77 | 178.77 | 559.0 |
| 2023-06-06 08:00:00 | AAPL | Stock | 178.4393 | 180.21 | 178.4393 | 178.83 | 56163.0 |
| 2023-06-06 08:05:00 | AAPL | Stock | 178.86 | 178.87 | 178.81 | 178.85 | 8387.0 |
> showing 50 of 416,226 rows — these rows as CSV