PREVIEW / stock_5min / 2024-04-12
file: by_date/stock_5min/2024/2024-04-12.parquet size: 6.6 MB rows: 397,698 symbols: 1,014
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-04-12 04:00:00 | AAPL | Stock | 174.96 | 175.5 | 174.96 | 175.11 | 7162.0 |
| 2024-04-12 04:05:00 | AAPL | Stock | 175.1 | 175.1 | 174.81 | 174.92 | 5069.0 |
| 2024-04-12 04:10:00 | AAPL | Stock | 174.9 | 174.92 | 174.8 | 174.8 | 5636.0 |
| 2024-04-12 04:15:00 | AAPL | Stock | 174.71 | 174.95 | 174.7 | 174.95 | 4294.0 |
| 2024-04-12 04:20:00 | AAPL | Stock | 174.97 | 175.04 | 174.97 | 175.0 | 3426.0 |
| 2024-04-12 04:25:00 | AAPL | Stock | 175.09 | 175.1 | 175.04 | 175.08 | 3312.0 |
| 2024-04-12 04:30:00 | AAPL | Stock | 175.05 | 175.05 | 175.05 | 175.05 | 200.0 |
| 2024-04-12 04:35:00 | AAPL | Stock | 175.02 | 175.06 | 175.02 | 175.06 | 220.0 |
| 2024-04-12 04:40:00 | AAPL | Stock | 175.14 | 175.16 | 175.13 | 175.13 | 3020.0 |
| 2024-04-12 04:45:00 | AAPL | Stock | 175.13 | 175.13 | 175.13 | 175.13 | 173.0 |
| 2024-04-12 04:50:00 | AAPL | Stock | 175.14 | 175.14 | 175.05 | 175.05 | 3925.0 |
| 2024-04-12 04:55:00 | AAPL | Stock | 175.07 | 175.07 | 174.83 | 174.84 | 6818.0 |
| 2024-04-12 05:00:00 | AAPL | Stock | 174.83 | 174.85 | 174.8 | 174.8 | 4262.0 |
| 2024-04-12 05:05:00 | AAPL | Stock | 174.82 | 174.82 | 174.75 | 174.75 | 4353.0 |
| 2024-04-12 05:10:00 | AAPL | Stock | 174.7 | 174.7 | 174.55 | 174.65 | 1893.0 |
| 2024-04-12 05:15:00 | AAPL | Stock | 174.62 | 174.73 | 174.6 | 174.6 | 1517.0 |
| 2024-04-12 05:20:00 | AAPL | Stock | 174.63 | 174.63 | 174.6 | 174.61 | 655.0 |
| 2024-04-12 05:25:00 | AAPL | Stock | 174.61 | 174.61 | 174.25 | 174.38 | 2878.0 |
| 2024-04-12 05:30:00 | AAPL | Stock | 174.32 | 174.32 | 174.17 | 174.29 | 2014.0 |
| 2024-04-12 05:35:00 | AAPL | Stock | 174.3 | 174.32 | 174.29 | 174.29 | 720.0 |
| 2024-04-12 05:40:00 | AAPL | Stock | 174.35 | 174.37 | 174.33 | 174.33 | 807.0 |
| 2024-04-12 05:45:00 | AAPL | Stock | 174.26 | 174.31 | 174.24 | 174.31 | 2690.0 |
| 2024-04-12 05:50:00 | AAPL | Stock | 174.34 | 174.45 | 174.23 | 174.38 | 1658.0 |
| 2024-04-12 05:55:00 | AAPL | Stock | 174.36 | 174.36 | 174.36 | 174.36 | 425.0 |
| 2024-04-12 06:00:00 | AAPL | Stock | 174.32 | 174.32 | 174.04 | 174.11 | 2476.0 |
| 2024-04-12 06:05:00 | AAPL | Stock | 174.06 | 174.18 | 174.06 | 174.14 | 1782.0 |
| 2024-04-12 06:10:00 | AAPL | Stock | 174.14 | 174.18 | 174.13 | 174.17 | 1179.0 |
| 2024-04-12 06:15:00 | AAPL | Stock | 174.2 | 174.2 | 174.2 | 174.2 | 155.0 |
| 2024-04-12 06:20:00 | AAPL | Stock | 174.24 | 174.34 | 174.2 | 174.25 | 5421.0 |
| 2024-04-12 06:25:00 | AAPL | Stock | 174.24 | 174.3 | 174.24 | 174.3 | 674.0 |
| 2024-04-12 06:30:00 | AAPL | Stock | 174.3 | 174.3 | 174.2 | 174.2 | 614.0 |
| 2024-04-12 06:35:00 | AAPL | Stock | 174.21 | 174.21 | 174.2 | 174.2 | 523.0 |
| 2024-04-12 06:40:00 | AAPL | Stock | 174.2 | 174.2 | 174.2 | 174.2 | 116.0 |
| 2024-04-12 06:45:00 | AAPL | Stock | 174.19 | 174.19 | 173.5 | 173.7 | 10305.0 |
| 2024-04-12 06:50:00 | AAPL | Stock | 173.65 | 173.77 | 173.49 | 173.76 | 18134.0 |
| 2024-04-12 06:55:00 | AAPL | Stock | 173.83 | 173.99 | 173.83 | 173.93 | 3359.0 |
| 2024-04-12 07:00:00 | AAPL | Stock | 173.97 | 174.09 | 173.92 | 173.96 | 9359.0 |
| 2024-04-12 07:05:00 | AAPL | Stock | 173.98 | 174.09 | 173.8 | 173.8 | 20805.0 |
| 2024-04-12 07:10:00 | AAPL | Stock | 173.82 | 174.08 | 173.8 | 174.02 | 5629.0 |
| 2024-04-12 07:15:00 | AAPL | Stock | 174.09 | 174.1 | 174.0 | 174.0 | 5578.0 |
| 2024-04-12 07:20:00 | AAPL | Stock | 174.08 | 174.09 | 174.07 | 174.07 | 2639.0 |
| 2024-04-12 07:25:00 | AAPL | Stock | 174.07 | 174.15 | 174.07 | 174.15 | 10588.0 |
| 2024-04-12 07:30:00 | AAPL | Stock | 174.19 | 174.39 | 174.15 | 174.39 | 21233.0 |
| 2024-04-12 07:35:00 | AAPL | Stock | 174.41 | 174.5 | 174.24 | 174.24 | 15841.0 |
| 2024-04-12 07:40:00 | AAPL | Stock | 174.3 | 174.3 | 174.18 | 174.3 | 7477.0 |
| 2024-04-12 07:45:00 | AAPL | Stock | 174.3 | 174.75 | 174.29 | 174.74 | 10117.0 |
| 2024-04-12 07:50:00 | AAPL | Stock | 174.74 | 174.79 | 174.55 | 174.78 | 11995.0 |
| 2024-04-12 07:55:00 | AAPL | Stock | 174.78 | 174.95 | 174.63 | 174.63 | 8068.0 |
| 2024-04-12 08:00:00 | AAPL | Stock | 174.05 | 175.4 | 173.7888 | 174.92 | 92286.0 |
| 2024-04-12 08:05:00 | AAPL | Stock | 175.25 | 175.38 | 174.51 | 174.55 | 14082.0 |
> showing 50 of 397,698 rows — these rows as CSV