PREVIEW / stock_5min / 2023-02-08
file: by_date/stock_5min/2023/2023-02-08.parquet size: 6.9 MB rows: 419,729 symbols: 1,849
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-02-08 04:00:00 | AAPL | Stock | 154.15 | 154.38 | 154.13 | 154.15 | 5200.0 |
| 2023-02-08 04:05:00 | AAPL | Stock | 154.2 | 154.25 | 154.12 | 154.25 | 10855.0 |
| 2023-02-08 04:10:00 | AAPL | Stock | 154.27 | 154.27 | 154.18 | 154.2 | 4719.0 |
| 2023-02-08 04:15:00 | AAPL | Stock | 154.22 | 154.25 | 154.03 | 154.03 | 5839.0 |
| 2023-02-08 04:20:00 | AAPL | Stock | 154.03 | 154.08 | 153.87 | 153.9 | 1991.0 |
| 2023-02-08 04:25:00 | AAPL | Stock | 153.9 | 154.0 | 153.88 | 154.0 | 2662.0 |
| 2023-02-08 04:30:00 | AAPL | Stock | 154.0 | 154.0 | 153.8 | 153.87 | 4742.0 |
| 2023-02-08 04:35:00 | AAPL | Stock | 153.83 | 153.92 | 153.8 | 153.88 | 11656.0 |
| 2023-02-08 04:40:00 | AAPL | Stock | 153.9 | 153.92 | 153.78 | 153.79 | 1614.0 |
| 2023-02-08 04:45:00 | AAPL | Stock | 153.77 | 153.77 | 153.55 | 153.55 | 1444.0 |
| 2023-02-08 04:55:00 | AAPL | Stock | 153.71 | 153.73 | 153.64 | 153.68 | 1729.0 |
| 2023-02-08 05:00:00 | AAPL | Stock | 153.86 | 153.88 | 153.85 | 153.85 | 1217.0 |
| 2023-02-08 05:05:00 | AAPL | Stock | 153.67 | 153.72 | 153.64 | 153.64 | 1677.0 |
| 2023-02-08 05:10:00 | AAPL | Stock | 153.59 | 153.6 | 153.59 | 153.6 | 2299.0 |
| 2023-02-08 05:15:00 | AAPL | Stock | 153.6 | 153.69 | 153.57 | 153.69 | 3186.0 |
| 2023-02-08 05:20:00 | AAPL | Stock | 153.6 | 153.7 | 153.5 | 153.7 | 5748.0 |
| 2023-02-08 05:25:00 | AAPL | Stock | 153.7 | 153.83 | 153.68 | 153.68 | 681.0 |
| 2023-02-08 05:30:00 | AAPL | Stock | 153.68 | 153.68 | 153.51 | 153.53 | 12237.0 |
| 2023-02-08 05:35:00 | AAPL | Stock | 153.58 | 153.7 | 153.58 | 153.7 | 1651.0 |
| 2023-02-08 05:40:00 | AAPL | Stock | 153.69 | 153.75 | 153.68 | 153.75 | 3335.0 |
| 2023-02-08 05:45:00 | AAPL | Stock | 153.63 | 153.82 | 153.62 | 153.82 | 5925.0 |
| 2023-02-08 05:50:00 | AAPL | Stock | 153.66 | 153.74 | 153.66 | 153.72 | 5240.0 |
| 2023-02-08 05:55:00 | AAPL | Stock | 153.76 | 153.76 | 153.76 | 153.76 | 212.0 |
| 2023-02-08 06:00:00 | AAPL | Stock | 153.76 | 153.76 | 153.75 | 153.75 | 450.0 |
| 2023-02-08 06:05:00 | AAPL | Stock | 153.74 | 153.88 | 153.68 | 153.88 | 2016.0 |
| 2023-02-08 06:10:00 | AAPL | Stock | 153.76 | 153.76 | 153.67 | 153.67 | 2775.0 |
| 2023-02-08 06:15:00 | AAPL | Stock | 153.76 | 153.76 | 153.61 | 153.61 | 1398.0 |
| 2023-02-08 06:20:00 | AAPL | Stock | 153.62 | 153.62 | 153.6 | 153.6 | 2537.0 |
| 2023-02-08 06:25:00 | AAPL | Stock | 153.52 | 153.53 | 153.52 | 153.53 | 1100.0 |
| 2023-02-08 06:30:00 | AAPL | Stock | 153.66 | 153.76 | 153.66 | 153.67 | 880.0 |
| 2023-02-08 06:35:00 | AAPL | Stock | 153.65 | 153.65 | 153.65 | 153.65 | 190.0 |
| 2023-02-08 06:45:00 | AAPL | Stock | 153.7 | 153.7 | 153.52 | 153.66 | 3620.0 |
| 2023-02-08 06:50:00 | AAPL | Stock | 153.72 | 153.76 | 153.72 | 153.76 | 1728.0 |
| 2023-02-08 07:00:00 | AAPL | Stock | 153.74 | 154.24 | 153.74 | 154.2 | 13256.0 |
| 2023-02-08 07:05:00 | AAPL | Stock | 154.23 | 154.23 | 154.06 | 154.15 | 6496.0 |
| 2023-02-08 07:10:00 | AAPL | Stock | 154.18 | 154.18 | 153.9 | 153.97 | 3440.0 |
| 2023-02-08 07:15:00 | AAPL | Stock | 154.08 | 154.08 | 153.75 | 153.8 | 8400.0 |
| 2023-02-08 07:20:00 | AAPL | Stock | 153.88 | 154.0 | 153.88 | 154.0 | 2243.0 |
| 2023-02-08 07:25:00 | AAPL | Stock | 154.01 | 154.03 | 154.0 | 154.0 | 2890.0 |
| 2023-02-08 07:30:00 | AAPL | Stock | 153.97 | 154.19 | 153.97 | 154.15 | 2894.0 |
| 2023-02-08 07:35:00 | AAPL | Stock | 154.15 | 154.17 | 154.02 | 154.02 | 9762.0 |
| 2023-02-08 07:40:00 | AAPL | Stock | 154.01 | 154.02 | 154.0 | 154.02 | 990.0 |
| 2023-02-08 07:45:00 | AAPL | Stock | 154.05 | 154.07 | 153.9 | 153.99 | 2927.0 |
| 2023-02-08 07:50:00 | AAPL | Stock | 153.93 | 153.93 | 153.7 | 153.85 | 19176.0 |
| 2023-02-08 07:55:00 | AAPL | Stock | 153.83 | 153.89 | 153.81 | 153.83 | 6049.0 |
| 2023-02-08 08:00:00 | AAPL | Stock | 153.9108 | 154.5 | 153.5515 | 153.77 | 62883.0 |
| 2023-02-08 08:05:00 | AAPL | Stock | 154.264 | 154.264 | 153.76 | 153.78 | 7814.0 |
| 2023-02-08 08:10:00 | AAPL | Stock | 153.8 | 153.84 | 153.72 | 153.72 | 17850.0 |
| 2023-02-08 08:15:00 | AAPL | Stock | 153.72 | 153.85 | 153.7 | 153.85 | 19885.0 |
| 2023-02-08 08:20:00 | AAPL | Stock | 153.81 | 153.81 | 153.65 | 153.74 | 16837.0 |
> showing 50 of 419,729 rows — these rows as CSV