PREVIEW / stock_1hour / 2024-07-22
file: by_date/stock_1hour/2024/2024-07-22.parquet size: 1.3 MB rows: 59,492 symbols: 893
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-22 04:00:00 | AAPL | Stock | 224.35 | 225.55 | 224.35 | 225.4 | 9695.0 |
| 2024-07-22 05:00:00 | AAPL | Stock | 225.4 | 225.65 | 225.4 | 225.65 | 4926.0 |
| 2024-07-22 06:00:00 | AAPL | Stock | 225.62 | 226.8 | 225.61 | 226.5 | 14781.0 |
| 2024-07-22 07:00:00 | AAPL | Stock | 226.5 | 226.83 | 226.29 | 226.78 | 33665.0 |
| 2024-07-22 08:00:00 | AAPL | Stock | 226.4091 | 227.55 | 224.72 | 226.8 | 214876.0 |
| 2024-07-22 09:00:00 | AAPL | Stock | 226.8 | 227.75 | 225.58 | 226.71 | 4951411.0 |
| 2024-07-22 10:00:00 | AAPL | Stock | 226.7 | 227.78 | 225.77 | 225.96 | 4933353.0 |
| 2024-07-22 11:00:00 | AAPL | Stock | 225.96 | 226.23 | 223.22 | 224.0007 | 5483391.0 |
| 2024-07-22 12:00:00 | AAPL | Stock | 224.0 | 224.34 | 223.09 | 224.28 | 3054417.0 |
| 2024-07-22 13:00:00 | AAPL | Stock | 224.31 | 225.24 | 224.0002 | 225.19 | 2702392.0 |
| 2024-07-22 14:00:00 | AAPL | Stock | 225.21 | 225.63 | 224.92 | 225.14 | 2297337.0 |
| 2024-07-22 15:00:00 | AAPL | Stock | 225.14 | 225.21 | 223.78 | 223.93 | 4835932.0 |
| 2024-07-22 16:00:00 | AAPL | Stock | 223.95 | 224.1493 | 223.51 | 224.03 | 8007500.0 |
| 2024-07-22 17:00:00 | AAPL | Stock | 224.02 | 224.19 | 224.0 | 224.02 | 12363.0 |
| 2024-07-22 18:00:00 | AAPL | Stock | 224.1 | 224.24 | 224.02 | 224.16 | 10421.0 |
| 2024-07-22 19:00:00 | AAPL | Stock | 224.1597 | 224.2 | 223.8 | 223.89 | 18302.0 |
| 2024-07-22 04:00:00 | MSFT | Stock | 437.61 | 440.7 | 437.61 | 440.38 | 4853.0 |
| 2024-07-22 05:00:00 | MSFT | Stock | 440.31 | 440.51 | 440.05 | 440.19 | 2262.0 |
| 2024-07-22 06:00:00 | MSFT | Stock | 440.25 | 440.39 | 439.9 | 440.3 | 5406.0 |
| 2024-07-22 07:00:00 | MSFT | Stock | 440.13 | 440.4 | 439.12 | 440.2 | 15123.0 |
| 2024-07-22 08:00:00 | MSFT | Stock | 440.25 | 440.42 | 437.67 | 440.1498 | 30151.0 |
| 2024-07-22 09:00:00 | MSFT | Stock | 440.11 | 443.9 | 439.99 | 443.3127 | 1537417.0 |
| 2024-07-22 10:00:00 | MSFT | Stock | 443.315 | 444.6 | 441.8301 | 442.56 | 1208096.0 |
| 2024-07-22 11:00:00 | MSFT | Stock | 442.57 | 443.56 | 438.9125 | 440.08 | 860765.0 |
| 2024-07-22 12:00:00 | MSFT | Stock | 440.01 | 442.73 | 439.27 | 442.4 | 511161.0 |
| 2024-07-22 13:00:00 | MSFT | Stock | 442.43 | 443.5289 | 442.27 | 443.445 | 505811.0 |
| 2024-07-22 14:00:00 | MSFT | Stock | 443.48 | 444.57 | 443.25 | 443.41 | 581066.0 |
| 2024-07-22 15:00:00 | MSFT | Stock | 443.44 | 444.05 | 442.585 | 442.86 | 1450581.0 |
| 2024-07-22 16:00:00 | MSFT | Stock | 442.86 | 443.03 | 442.44 | 442.94 | 3997088.0 |
| 2024-07-22 17:00:00 | MSFT | Stock | 442.3412 | 442.44 | 442.05 | 442.4 | 3072.0 |
| 2024-07-22 18:00:00 | MSFT | Stock | 442.4 | 442.86 | 442.4 | 442.62 | 4413.0 |
| 2024-07-22 19:00:00 | MSFT | Stock | 442.77 | 442.8 | 442.3 | 442.5 | 3082.0 |
| 2024-07-22 04:00:00 | NVDA | Stock | 119.3 | 119.74 | 118.81 | 119.48 | 371324.0 |
| 2024-07-22 05:00:00 | NVDA | Stock | 119.54 | 120.4 | 119.46 | 120.38 | 289901.0 |
| 2024-07-22 06:00:00 | NVDA | Stock | 120.39 | 120.7 | 120.26 | 120.35 | 405817.0 |
| 2024-07-22 07:00:00 | NVDA | Stock | 120.31 | 120.48 | 119.84 | 120.41 | 993662.0 |
| 2024-07-22 08:00:00 | NVDA | Stock | 119.91 | 120.63 | 117.95 | 120.51 | 2502098.0 |
| 2024-07-22 09:00:00 | NVDA | Stock | 120.51 | 123.28 | 119.86 | 122.475 | 41603919.0 |
| 2024-07-22 10:00:00 | NVDA | Stock | 122.47 | 123.17 | 121.17 | 122.09 | 35732868.0 |
| 2024-07-22 11:00:00 | NVDA | Stock | 122.1 | 122.66 | 120.35 | 121.23 | 26105568.0 |
| 2024-07-22 12:00:00 | NVDA | Stock | 121.23 | 122.74 | 120.9 | 122.4802 | 18887615.0 |
| 2024-07-22 13:00:00 | NVDA | Stock | 122.5 | 123.23 | 122.31 | 123.0644 | 18352222.0 |
| 2024-07-22 14:00:00 | NVDA | Stock | 123.065 | 124.07 | 123.035 | 123.45 | 24285174.0 |
| 2024-07-22 15:00:00 | NVDA | Stock | 123.45 | 123.75 | 122.61 | 123.74 | 27418807.0 |
| 2024-07-22 16:00:00 | NVDA | Stock | 123.74 | 123.83 | 122.1434 | 123.429 | 23090831.0 |
| 2024-07-22 17:00:00 | NVDA | Stock | 123.41 | 123.52 | 123.33 | 123.37 | 243423.0 |
| 2024-07-22 18:00:00 | NVDA | Stock | 123.38 | 123.68 | 123.36 | 123.64 | 314241.0 |
| 2024-07-22 19:00:00 | NVDA | Stock | 123.65 | 123.77 | 123.22 | 123.33 | 447572.0 |
| 2024-07-22 04:00:00 | AMZN | Stock | 183.7 | 184.26 | 183.7 | 184.1 | 9325.0 |
| 2024-07-22 05:00:00 | AMZN | Stock | 184.19 | 184.87 | 184.18 | 184.87 | 10473.0 |
> showing 50 of 59,492 rows — these rows as CSV