PREVIEW / stock_5min / 2024-07-15
file: by_date/stock_5min/2024/2024-07-15.parquet size: 6.8 MB rows: 414,209 symbols: 907
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-07-15 04:00:00 | AAPL | Stock | 232.22 | 234.0 | 232.0 | 233.44 | 43769.0 |
| 2024-07-15 04:05:00 | AAPL | Stock | 233.29 | 233.5 | 233.29 | 233.39 | 15448.0 |
| 2024-07-15 04:10:00 | AAPL | Stock | 233.36 | 233.49 | 233.35 | 233.36 | 13688.0 |
| 2024-07-15 04:15:00 | AAPL | Stock | 233.36 | 233.36 | 233.01 | 233.1 | 4481.0 |
| 2024-07-15 04:20:00 | AAPL | Stock | 233.16 | 233.39 | 233.16 | 233.39 | 1171.0 |
| 2024-07-15 04:25:00 | AAPL | Stock | 233.38 | 233.39 | 233.35 | 233.39 | 7116.0 |
| 2024-07-15 04:30:00 | AAPL | Stock | 233.38 | 233.67 | 233.38 | 233.67 | 24320.0 |
| 2024-07-15 04:35:00 | AAPL | Stock | 233.88 | 233.9 | 233.8 | 233.88 | 5724.0 |
| 2024-07-15 04:40:00 | AAPL | Stock | 233.81 | 234.21 | 233.81 | 234.21 | 23578.0 |
| 2024-07-15 04:45:00 | AAPL | Stock | 234.2 | 234.27 | 234.1 | 234.1 | 3025.0 |
| 2024-07-15 04:50:00 | AAPL | Stock | 234.01 | 234.77 | 234.0 | 234.32 | 10926.0 |
| 2024-07-15 04:55:00 | AAPL | Stock | 234.28 | 234.42 | 234.23 | 234.4 | 850.0 |
| 2024-07-15 05:00:00 | AAPL | Stock | 234.5 | 234.6 | 234.08 | 234.1 | 11274.0 |
| 2024-07-15 05:05:00 | AAPL | Stock | 234.11 | 234.5 | 234.11 | 234.46 | 7743.0 |
| 2024-07-15 05:10:00 | AAPL | Stock | 234.5 | 234.8 | 234.5 | 234.68 | 14686.0 |
| 2024-07-15 05:40:00 | AAPL | Stock | 235.1 | 235.21 | 235.1 | 235.21 | 500.0 |
| 2024-07-15 05:45:00 | AAPL | Stock | 235.21 | 235.21 | 235.0 | 235.02 | 3338.0 |
| 2024-07-15 05:50:00 | AAPL | Stock | 235.05 | 235.05 | 234.64 | 234.87 | 5158.0 |
| 2024-07-15 05:55:00 | AAPL | Stock | 234.87 | 235.07 | 234.87 | 235.07 | 714.0 |
| 2024-07-15 06:00:00 | AAPL | Stock | 235.0 | 235.22 | 234.89 | 235.22 | 6755.0 |
| 2024-07-15 06:05:00 | AAPL | Stock | 235.22 | 235.56 | 235.22 | 235.42 | 7286.0 |
| 2024-07-15 06:10:00 | AAPL | Stock | 235.47 | 235.47 | 235.41 | 235.42 | 704.0 |
| 2024-07-15 06:15:00 | AAPL | Stock | 235.5 | 235.51 | 235.49 | 235.51 | 815.0 |
| 2024-07-15 06:20:00 | AAPL | Stock | 235.47 | 235.51 | 235.4 | 235.4 | 1202.0 |
| 2024-07-15 06:25:00 | AAPL | Stock | 235.37 | 235.4 | 235.33 | 235.33 | 5836.0 |
| 2024-07-15 06:30:00 | AAPL | Stock | 235.4 | 235.48 | 235.4 | 235.43 | 1833.0 |
| 2024-07-15 06:35:00 | AAPL | Stock | 235.44 | 235.44 | 235.4 | 235.42 | 1638.0 |
| 2024-07-15 06:40:00 | AAPL | Stock | 235.4 | 235.4 | 235.23 | 235.4 | 1204.0 |
| 2024-07-15 06:45:00 | AAPL | Stock | 235.34 | 235.35 | 235.25 | 235.31 | 3466.0 |
| 2024-07-15 06:50:00 | AAPL | Stock | 235.25 | 235.26 | 235.25 | 235.25 | 654.0 |
| 2024-07-15 06:55:00 | AAPL | Stock | 235.22 | 235.22 | 235.09 | 235.09 | 1593.0 |
| 2024-07-15 07:00:00 | AAPL | Stock | 235.03 | 235.03 | 234.83 | 234.83 | 35186.0 |
| 2024-07-15 07:05:00 | AAPL | Stock | 234.85 | 235.25 | 234.85 | 235.2 | 12382.0 |
| 2024-07-15 07:10:00 | AAPL | Stock | 235.2 | 235.3 | 235.0 | 235.0 | 6516.0 |
| 2024-07-15 07:15:00 | AAPL | Stock | 235.0 | 235.09 | 234.89 | 235.01 | 5180.0 |
| 2024-07-15 07:20:00 | AAPL | Stock | 235.0 | 235.0 | 234.81 | 234.99 | 2018.0 |
| 2024-07-15 07:25:00 | AAPL | Stock | 234.95 | 235.14 | 234.85 | 235.14 | 5392.0 |
| 2024-07-15 07:30:00 | AAPL | Stock | 235.16 | 235.25 | 235.15 | 235.24 | 8688.0 |
| 2024-07-15 07:35:00 | AAPL | Stock | 235.3 | 235.38 | 235.09 | 235.15 | 9245.0 |
| 2024-07-15 07:40:00 | AAPL | Stock | 235.11 | 235.11 | 234.901 | 234.901 | 21692.0 |
| 2024-07-15 07:45:00 | AAPL | Stock | 235.0 | 235.01 | 234.95 | 234.98 | 6857.0 |
| 2024-07-15 07:50:00 | AAPL | Stock | 235.01 | 235.05 | 235.0 | 235.02 | 8382.0 |
| 2024-07-15 07:55:00 | AAPL | Stock | 235.03 | 235.03 | 234.7 | 234.7 | 13908.0 |
| 2024-07-15 08:00:00 | AAPL | Stock | 234.9101 | 235.41 | 231.26 | 231.75 | 148573.0 |
| 2024-07-15 08:05:00 | AAPL | Stock | 231.77 | 234.87 | 231.0 | 234.8284 | 22358.0 |
| 2024-07-15 08:10:00 | AAPL | Stock | 234.87 | 235.18 | 234.81 | 235.18 | 33678.0 |
| 2024-07-15 08:15:00 | AAPL | Stock | 235.18 | 235.4 | 235.18 | 235.3 | 45396.0 |
| 2024-07-15 08:20:00 | AAPL | Stock | 235.2033 | 235.4777 | 235.2033 | 235.44 | 18455.0 |
| 2024-07-15 08:25:00 | AAPL | Stock | 235.43 | 235.48 | 235.0 | 235.06 | 31608.0 |
| 2024-07-15 08:30:00 | AAPL | Stock | 235.05 | 235.06 | 234.92 | 234.92 | 25990.0 |
> showing 50 of 414,209 rows — these rows as CSV