PREVIEW / stock_5min / 2023-03-08
file: by_date/stock_5min/2023/2023-03-08.parquet size: 6.6 MB rows: 404,836 symbols: 1,840
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-03-08 04:00:00 | AAPL | Stock | 151.5 | 151.94 | 151.5 | 151.82 | 998.0 |
| 2023-03-08 04:05:00 | AAPL | Stock | 151.62 | 151.64 | 151.6 | 151.61 | 974.0 |
| 2023-03-08 04:10:00 | AAPL | Stock | 151.61 | 151.62 | 151.61 | 151.61 | 600.0 |
| 2023-03-08 04:15:00 | AAPL | Stock | 151.61 | 151.62 | 151.61 | 151.62 | 500.0 |
| 2023-03-08 04:20:00 | AAPL | Stock | 151.51 | 151.51 | 151.5 | 151.5 | 500.0 |
| 2023-03-08 04:25:00 | AAPL | Stock | 151.51 | 151.6 | 151.51 | 151.56 | 1462.0 |
| 2023-03-08 04:35:00 | AAPL | Stock | 151.6 | 151.6 | 151.6 | 151.6 | 399.0 |
| 2023-03-08 04:40:00 | AAPL | Stock | 151.6 | 151.61 | 151.6 | 151.61 | 428.0 |
| 2023-03-08 04:45:00 | AAPL | Stock | 151.66 | 151.66 | 151.61 | 151.61 | 789.0 |
| 2023-03-08 04:55:00 | AAPL | Stock | 151.6 | 151.6 | 151.6 | 151.6 | 121.0 |
| 2023-03-08 05:00:00 | AAPL | Stock | 151.7 | 151.7 | 151.7 | 151.7 | 500.0 |
| 2023-03-08 05:10:00 | AAPL | Stock | 151.67 | 151.67 | 151.67 | 151.67 | 200.0 |
| 2023-03-08 05:15:00 | AAPL | Stock | 151.65 | 151.65 | 151.65 | 151.65 | 100.0 |
| 2023-03-08 05:25:00 | AAPL | Stock | 151.62 | 151.62 | 151.62 | 151.62 | 603.0 |
| 2023-03-08 05:35:00 | AAPL | Stock | 151.63 | 151.71 | 151.63 | 151.71 | 300.0 |
| 2023-03-08 05:50:00 | AAPL | Stock | 151.73 | 151.8 | 151.71 | 151.8 | 1708.0 |
| 2023-03-08 05:55:00 | AAPL | Stock | 151.87 | 151.89 | 151.79 | 151.79 | 1134.0 |
| 2023-03-08 06:00:00 | AAPL | Stock | 151.87 | 151.89 | 151.84 | 151.89 | 769.0 |
| 2023-03-08 06:05:00 | AAPL | Stock | 151.9 | 151.94 | 151.89 | 151.94 | 1284.0 |
| 2023-03-08 06:10:00 | AAPL | Stock | 151.95 | 152.13 | 151.95 | 152.13 | 2362.0 |
| 2023-03-08 06:15:00 | AAPL | Stock | 152.04 | 152.14 | 152.01 | 152.05 | 1004.0 |
| 2023-03-08 06:20:00 | AAPL | Stock | 152.09 | 152.2 | 152.09 | 152.18 | 16364.0 |
| 2023-03-08 06:25:00 | AAPL | Stock | 152.18 | 152.18 | 152.11 | 152.11 | 1615.0 |
| 2023-03-08 06:30:00 | AAPL | Stock | 152.12 | 152.17 | 151.95 | 151.95 | 9154.0 |
| 2023-03-08 06:35:00 | AAPL | Stock | 152.0 | 152.03 | 151.98 | 152.01 | 3185.0 |
| 2023-03-08 06:40:00 | AAPL | Stock | 152.05 | 152.07 | 152.05 | 152.07 | 612.0 |
| 2023-03-08 06:45:00 | AAPL | Stock | 152.04 | 152.04 | 152.04 | 152.04 | 472.0 |
| 2023-03-08 06:55:00 | AAPL | Stock | 152.0 | 152.0 | 152.0 | 152.0 | 100.0 |
| 2023-03-08 07:00:00 | AAPL | Stock | 151.92 | 151.95 | 151.9 | 151.9 | 6672.0 |
| 2023-03-08 07:05:00 | AAPL | Stock | 151.98 | 151.99 | 151.97 | 151.97 | 976.0 |
| 2023-03-08 07:10:00 | AAPL | Stock | 151.99 | 152.05 | 151.91 | 151.91 | 2008.0 |
| 2023-03-08 07:15:00 | AAPL | Stock | 151.95 | 151.95 | 151.95 | 151.95 | 860.0 |
| 2023-03-08 07:20:00 | AAPL | Stock | 152.0 | 152.1 | 151.8 | 151.8 | 8580.0 |
| 2023-03-08 07:25:00 | AAPL | Stock | 151.78 | 152.0 | 151.78 | 151.88 | 5849.0 |
| 2023-03-08 07:30:00 | AAPL | Stock | 151.9 | 151.9 | 151.87 | 151.88 | 497.0 |
| 2023-03-08 07:35:00 | AAPL | Stock | 151.95 | 151.95 | 151.63 | 151.7 | 4967.0 |
| 2023-03-08 07:40:00 | AAPL | Stock | 151.68 | 151.75 | 151.68 | 151.75 | 1156.0 |
| 2023-03-08 07:45:00 | AAPL | Stock | 151.75 | 151.85 | 151.75 | 151.81 | 3526.0 |
| 2023-03-08 07:50:00 | AAPL | Stock | 151.84 | 152.0 | 151.84 | 151.92 | 3831.0 |
| 2023-03-08 07:55:00 | AAPL | Stock | 151.95 | 151.95 | 151.9 | 151.94 | 1050.0 |
| 2023-03-08 08:00:00 | AAPL | Stock | 152.0212 | 152.08 | 151.06 | 151.95 | 50526.0 |
| 2023-03-08 08:05:00 | AAPL | Stock | 151.95 | 152.22 | 151.95 | 152.11 | 13033.0 |
| 2023-03-08 08:10:00 | AAPL | Stock | 152.15 | 152.18 | 151.8542 | 151.93 | 16993.0 |
| 2023-03-08 08:15:00 | AAPL | Stock | 151.9 | 151.9 | 151.65 | 151.81 | 11636.0 |
| 2023-03-08 08:20:00 | AAPL | Stock | 151.81 | 152.18 | 151.72 | 151.99 | 11651.0 |
| 2023-03-08 08:25:00 | AAPL | Stock | 152.08 | 152.2 | 151.99 | 152.105 | 19002.0 |
| 2023-03-08 08:30:00 | AAPL | Stock | 152.18 | 152.28 | 152.15 | 152.27 | 17600.0 |
| 2023-03-08 08:35:00 | AAPL | Stock | 152.2 | 152.25 | 152.1 | 152.16 | 10313.0 |
| 2023-03-08 08:40:00 | AAPL | Stock | 152.15 | 152.34 | 152.15 | 152.25 | 13859.0 |
| 2023-03-08 08:45:00 | AAPL | Stock | 152.25 | 152.26 | 152.05 | 152.08 | 22353.0 |
> showing 50 of 404,836 rows — these rows as CSV