PREVIEW / stock_1hour / 2024-08-02
file: by_date/stock_1hour/2024/2024-08-02.parquet size: 1.4 MB rows: 61,112 symbols: 880
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-08-02 04:00:00 | AAPL | Stock | 217.9 | 218.82 | 216.55 | 218.15 | 40092.0 |
| 2024-08-02 05:00:00 | AAPL | Stock | 218.0 | 218.12 | 217.6 | 218.01 | 22922.0 |
| 2024-08-02 06:00:00 | AAPL | Stock | 218.05 | 220.57 | 217.51 | 220.47 | 49467.0 |
| 2024-08-02 07:00:00 | AAPL | Stock | 220.1 | 220.48 | 217.28 | 217.5 | 181536.0 |
| 2024-08-02 08:00:00 | AAPL | Stock | 220.02 | 220.5 | 214.0 | 215.3 | 870785.0 |
| 2024-08-02 09:00:00 | AAPL | Stock | 215.36 | 224.43 | 213.7 | 223.24 | 14212819.0 |
| 2024-08-02 10:00:00 | AAPL | Stock | 223.205 | 224.3799 | 220.67 | 222.4 | 12190746.0 |
| 2024-08-02 11:00:00 | AAPL | Stock | 222.41 | 223.67 | 221.4101 | 223.205 | 7514178.0 |
| 2024-08-02 12:00:00 | AAPL | Stock | 223.205 | 225.6 | 222.73 | 224.235 | 6920122.0 |
| 2024-08-02 13:00:00 | AAPL | Stock | 224.215 | 225.28 | 223.3 | 224.19 | 5230222.0 |
| 2024-08-02 14:00:00 | AAPL | Stock | 224.2 | 224.23 | 221.91 | 222.7 | 5136282.0 |
| 2024-08-02 15:00:00 | AAPL | Stock | 222.7 | 223.37 | 219.05 | 219.8 | 12016167.0 |
| 2024-08-02 16:00:00 | AAPL | Stock | 219.86 | 220.25 | 219.41 | 219.82 | 8694960.0 |
| 2024-08-02 17:00:00 | AAPL | Stock | 219.82 | 220.11 | 219.2513 | 219.34 | 369534.0 |
| 2024-08-02 18:00:00 | AAPL | Stock | 219.5493 | 219.86 | 219.35 | 219.5 | 6997925.0 |
| 2024-08-02 19:00:00 | AAPL | Stock | 219.53 | 219.53 | 219.15 | 219.25 | 34182.0 |
| 2024-08-02 04:00:00 | MSFT | Stock | 411.7 | 413.0 | 410.95 | 412.0 | 7164.0 |
| 2024-08-02 05:00:00 | MSFT | Stock | 411.61 | 411.98 | 409.0 | 409.45 | 14640.0 |
| 2024-08-02 06:00:00 | MSFT | Stock | 409.0 | 410.5 | 408.61 | 409.13 | 11331.0 |
| 2024-08-02 07:00:00 | MSFT | Stock | 409.72 | 410.0 | 408.15 | 408.5 | 24458.0 |
| 2024-08-02 08:00:00 | MSFT | Stock | 409.99 | 418.152 | 406.05 | 409.22 | 122632.0 |
| 2024-08-02 09:00:00 | MSFT | Stock | 408.6599 | 415.0 | 406.15 | 407.465 | 2462864.0 |
| 2024-08-02 10:00:00 | MSFT | Stock | 407.57 | 408.4 | 404.34 | 406.12 | 2464472.0 |
| 2024-08-02 11:00:00 | MSFT | Stock | 406.09 | 408.0132 | 404.68 | 406.83 | 1897790.0 |
| 2024-08-02 12:00:00 | MSFT | Stock | 406.88 | 408.65 | 405.0 | 405.5 | 1338447.0 |
| 2024-08-02 13:00:00 | MSFT | Stock | 405.45 | 406.73 | 404.98 | 405.9796 | 968744.0 |
| 2024-08-02 14:00:00 | MSFT | Stock | 405.93 | 407.85 | 404.68 | 405.59 | 1284104.0 |
| 2024-08-02 15:00:00 | MSFT | Stock | 405.63 | 409.02 | 405.52 | 408.49 | 2835012.0 |
| 2024-08-02 16:00:00 | MSFT | Stock | 408.46 | 408.73 | 406.5 | 406.6 | 5160693.0 |
| 2024-08-02 17:00:00 | MSFT | Stock | 406.62 | 408.49 | 406.05 | 407.0 | 71900.0 |
| 2024-08-02 18:00:00 | MSFT | Stock | 407.0 | 407.08 | 406.83 | 407.08 | 4319.0 |
| 2024-08-02 19:00:00 | MSFT | Stock | 407.01 | 407.1597 | 406.5 | 406.741 | 11216.0 |
| 2024-08-02 04:00:00 | NVDA | Stock | 106.7 | 107.36 | 105.0 | 105.6 | 1855733.0 |
| 2024-08-02 05:00:00 | NVDA | Stock | 105.6 | 105.6 | 105.0 | 105.35 | 591465.0 |
| 2024-08-02 06:00:00 | NVDA | Stock | 105.37 | 106.69 | 104.43 | 106.06 | 1458437.0 |
| 2024-08-02 07:00:00 | NVDA | Stock | 106.12 | 106.24 | 103.79 | 104.3 | 2421612.0 |
| 2024-08-02 08:00:00 | NVDA | Stock | 104.35 | 107.2 | 101.42 | 104.0 | 11316386.0 |
| 2024-08-02 09:00:00 | NVDA | Stock | 104.02 | 107.5 | 102.7 | 104.06 | 66476000.0 |
| 2024-08-02 10:00:00 | NVDA | Stock | 104.06 | 105.36 | 101.37 | 103.834 | 76883120.0 |
| 2024-08-02 11:00:00 | NVDA | Stock | 103.835 | 108.72 | 103.4 | 107.82 | 62956989.0 |
| 2024-08-02 12:00:00 | NVDA | Stock | 107.83 | 107.97 | 105.2 | 105.3923 | 44600373.0 |
| 2024-08-02 13:00:00 | NVDA | Stock | 105.4 | 106.5 | 104.55 | 105.69 | 32366571.0 |
| 2024-08-02 14:00:00 | NVDA | Stock | 105.695 | 106.45 | 104.72 | 105.18 | 31733171.0 |
| 2024-08-02 15:00:00 | NVDA | Stock | 105.19 | 107.6 | 105.19 | 107.28 | 44390731.0 |
| 2024-08-02 16:00:00 | NVDA | Stock | 107.31 | 107.75 | 103.73 | 107.11 | 24988132.0 |
| 2024-08-02 17:00:00 | NVDA | Stock | 107.11 | 107.27 | 106.61 | 106.91 | 777416.0 |
| 2024-08-02 18:00:00 | NVDA | Stock | 106.9199 | 107.27 | 106.73 | 106.73 | 3971393.0 |
| 2024-08-02 19:00:00 | NVDA | Stock | 106.7398 | 106.98 | 106.65 | 106.73 | 669015.0 |
| 2024-08-02 04:00:00 | AMZN | Stock | 169.97 | 169.97 | 167.14 | 168.79 | 143062.0 |
| 2024-08-02 05:00:00 | AMZN | Stock | 168.72 | 168.76 | 167.69 | 168.45 | 62798.0 |
> showing 50 of 61,112 rows — these rows as CSV