PREVIEW / stock_5min / 2024-03-07
file: by_date/stock_5min/2024/2024-03-07.parquet size: 6.9 MB rows: 411,768 symbols: 1,108
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-03-07 04:00:00 | AAPL | Stock | 168.19 | 168.26 | 167.9 | 168.17 | 7611.0 |
| 2024-03-07 04:05:00 | AAPL | Stock | 168.18 | 168.51 | 168.18 | 168.51 | 4697.0 |
| 2024-03-07 04:10:00 | AAPL | Stock | 168.5 | 168.67 | 168.5 | 168.67 | 1740.0 |
| 2024-03-07 04:15:00 | AAPL | Stock | 168.69 | 168.76 | 168.69 | 168.71 | 883.0 |
| 2024-03-07 04:20:00 | AAPL | Stock | 168.7 | 168.72 | 168.6 | 168.6 | 3719.0 |
| 2024-03-07 04:25:00 | AAPL | Stock | 168.55 | 168.55 | 168.5 | 168.5 | 2441.0 |
| 2024-03-07 04:30:00 | AAPL | Stock | 168.5 | 168.5 | 168.3 | 168.3 | 3037.0 |
| 2024-03-07 04:35:00 | AAPL | Stock | 168.3 | 168.3 | 168.22 | 168.23 | 1370.0 |
| 2024-03-07 04:40:00 | AAPL | Stock | 168.28 | 168.31 | 168.28 | 168.31 | 456.0 |
| 2024-03-07 04:45:00 | AAPL | Stock | 168.31 | 168.45 | 168.31 | 168.44 | 1804.0 |
| 2024-03-07 04:50:00 | AAPL | Stock | 168.45 | 168.69 | 168.45 | 168.69 | 1619.0 |
| 2024-03-07 04:55:00 | AAPL | Stock | 168.49 | 168.49 | 168.49 | 168.49 | 375.0 |
| 2024-03-07 05:00:00 | AAPL | Stock | 168.65 | 168.78 | 168.65 | 168.76 | 6554.0 |
| 2024-03-07 05:05:00 | AAPL | Stock | 168.78 | 169.0 | 168.78 | 169.0 | 6240.0 |
| 2024-03-07 05:10:00 | AAPL | Stock | 169.0 | 169.0 | 168.9 | 168.98 | 2644.0 |
| 2024-03-07 05:15:00 | AAPL | Stock | 169.0 | 169.0 | 168.9 | 168.9 | 6889.0 |
| 2024-03-07 05:20:00 | AAPL | Stock | 168.9 | 168.94 | 168.86 | 168.86 | 2958.0 |
| 2024-03-07 05:25:00 | AAPL | Stock | 168.77 | 169.0 | 168.77 | 168.97 | 9695.0 |
| 2024-03-07 05:30:00 | AAPL | Stock | 168.98 | 169.0 | 168.98 | 168.99 | 2319.0 |
| 2024-03-07 05:35:00 | AAPL | Stock | 169.0 | 169.1 | 168.96 | 168.96 | 8350.0 |
| 2024-03-07 05:40:00 | AAPL | Stock | 169.0 | 169.0 | 168.97 | 168.97 | 505.0 |
| 2024-03-07 05:45:00 | AAPL | Stock | 169.0 | 169.1 | 169.0 | 169.0 | 4855.0 |
| 2024-03-07 05:50:00 | AAPL | Stock | 169.05 | 169.05 | 169.05 | 169.05 | 120.0 |
| 2024-03-07 05:55:00 | AAPL | Stock | 169.05 | 169.05 | 168.99 | 169.03 | 2215.0 |
| 2024-03-07 06:00:00 | AAPL | Stock | 169.0 | 169.0 | 168.82 | 168.82 | 760.0 |
| 2024-03-07 06:05:00 | AAPL | Stock | 168.83 | 168.83 | 168.7 | 168.7 | 1677.0 |
| 2024-03-07 06:10:00 | AAPL | Stock | 168.71 | 168.75 | 168.7 | 168.75 | 1201.0 |
| 2024-03-07 06:15:00 | AAPL | Stock | 168.7 | 168.78 | 168.7 | 168.7 | 1013.0 |
| 2024-03-07 06:20:00 | AAPL | Stock | 168.77 | 168.84 | 168.71 | 168.84 | 1281.0 |
| 2024-03-07 06:25:00 | AAPL | Stock | 168.87 | 168.87 | 168.87 | 168.87 | 100.0 |
| 2024-03-07 06:30:00 | AAPL | Stock | 168.83 | 168.83 | 168.83 | 168.83 | 100.0 |
| 2024-03-07 06:35:00 | AAPL | Stock | 168.83 | 168.83 | 168.83 | 168.83 | 375.0 |
| 2024-03-07 06:40:00 | AAPL | Stock | 168.84 | 168.87 | 168.8 | 168.8 | 778.0 |
| 2024-03-07 06:45:00 | AAPL | Stock | 168.81 | 168.87 | 168.8 | 168.85 | 2553.0 |
| 2024-03-07 06:50:00 | AAPL | Stock | 168.87 | 168.9 | 168.84 | 168.9 | 3887.0 |
| 2024-03-07 06:55:00 | AAPL | Stock | 168.83 | 168.86 | 168.83 | 168.83 | 6308.0 |
| 2024-03-07 07:00:00 | AAPL | Stock | 168.83 | 169.0 | 168.75 | 168.91 | 22076.0 |
| 2024-03-07 07:05:00 | AAPL | Stock | 168.88 | 168.94 | 168.87 | 168.94 | 1323.0 |
| 2024-03-07 07:10:00 | AAPL | Stock | 168.95 | 169.2 | 168.95 | 169.2 | 8818.0 |
| 2024-03-07 07:15:00 | AAPL | Stock | 169.28 | 169.64 | 169.28 | 169.64 | 10263.0 |
| 2024-03-07 07:20:00 | AAPL | Stock | 169.57 | 169.92 | 169.57 | 169.88 | 17388.0 |
| 2024-03-07 07:25:00 | AAPL | Stock | 169.9 | 169.9 | 169.68 | 169.75 | 8742.0 |
| 2024-03-07 07:30:00 | AAPL | Stock | 169.73 | 169.8 | 169.73 | 169.79 | 26659.0 |
| 2024-03-07 07:35:00 | AAPL | Stock | 169.76 | 169.78 | 169.73 | 169.73 | 3025.0 |
| 2024-03-07 07:40:00 | AAPL | Stock | 169.77 | 169.8 | 169.73 | 169.77 | 11648.0 |
| 2024-03-07 07:45:00 | AAPL | Stock | 169.78 | 169.89 | 169.78 | 169.89 | 3844.0 |
| 2024-03-07 07:50:00 | AAPL | Stock | 169.86 | 169.87 | 169.61 | 169.67 | 7035.0 |
| 2024-03-07 07:55:00 | AAPL | Stock | 169.7 | 169.85 | 169.7 | 169.79 | 7231.0 |
| 2024-03-07 08:00:00 | AAPL | Stock | 168.83 | 169.91 | 167.38 | 169.69 | 105755.0 |
| 2024-03-07 08:05:00 | AAPL | Stock | 167.78 | 169.69 | 167.35 | 169.4301 | 13575.0 |
> showing 50 of 411,768 rows — these rows as CSV