PREVIEW / stock_1hour / 2024-09-09
file: by_date/stock_1hour/2024/2024-09-09.parquet size: 1.3 MB rows: 58,814 symbols: 877
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-09-09 04:00:00 | AAPL | Stock | 221.95 | 223.0 | 221.59 | 222.95 | 24316.0 |
| 2024-09-09 05:00:00 | AAPL | Stock | 222.74 | 222.75 | 222.42 | 222.49 | 11659.0 |
| 2024-09-09 06:00:00 | AAPL | Stock | 222.49 | 222.62 | 221.71 | 221.79 | 38151.0 |
| 2024-09-09 07:00:00 | AAPL | Stock | 221.9 | 222.19 | 220.68 | 221.2 | 56638.0 |
| 2024-09-09 08:00:00 | AAPL | Stock | 222.0019 | 222.82 | 220.56 | 221.0 | 172969.0 |
| 2024-09-09 09:00:00 | AAPL | Stock | 220.86 | 221.27 | 217.82 | 219.24 | 6826059.0 |
| 2024-09-09 10:00:00 | AAPL | Stock | 219.2 | 220.2 | 217.1 | 217.2 | 6317546.0 |
| 2024-09-09 11:00:00 | AAPL | Stock | 217.2 | 219.91 | 217.05 | 219.91 | 3474315.0 |
| 2024-09-09 12:00:00 | AAPL | Stock | 219.89 | 220.61 | 219.6483 | 220.15 | 3005258.0 |
| 2024-09-09 13:00:00 | AAPL | Stock | 220.16 | 220.93 | 218.4843 | 219.1694 | 6045698.0 |
| 2024-09-09 14:00:00 | AAPL | Stock | 219.155 | 219.155 | 216.71 | 217.88 | 9588007.0 |
| 2024-09-09 15:00:00 | AAPL | Stock | 217.87 | 221.06 | 217.782 | 220.99 | 9695420.0 |
| 2024-09-09 16:00:00 | AAPL | Stock | 220.95 | 221.7901 | 220.88 | 221.0449 | 6830666.0 |
| 2024-09-09 17:00:00 | AAPL | Stock | 221.05 | 221.2464 | 221.0 | 221.12 | 51962.0 |
| 2024-09-09 18:00:00 | AAPL | Stock | 221.15 | 221.15 | 220.3928 | 220.4205 | 43434.0 |
| 2024-09-09 19:00:00 | AAPL | Stock | 220.5 | 220.8797 | 220.5 | 220.8797 | 52328.0 |
| 2024-09-09 04:00:00 | MSFT | Stock | 404.58 | 406.0 | 404.58 | 405.7 | 4337.0 |
| 2024-09-09 05:00:00 | MSFT | Stock | 405.98 | 407.0 | 405.98 | 406.55 | 2534.0 |
| 2024-09-09 06:00:00 | MSFT | Stock | 406.79 | 406.95 | 406.51 | 406.6 | 4100.0 |
| 2024-09-09 07:00:00 | MSFT | Stock | 406.2 | 406.8 | 406.0 | 406.0 | 7222.0 |
| 2024-09-09 08:00:00 | MSFT | Stock | 406.5 | 406.68 | 402.704 | 405.6 | 30486.0 |
| 2024-09-09 09:00:00 | MSFT | Stock | 405.54 | 408.65 | 405.3635 | 406.8 | 1594630.0 |
| 2024-09-09 10:00:00 | MSFT | Stock | 406.76 | 406.8138 | 402.3 | 402.31 | 1205871.0 |
| 2024-09-09 11:00:00 | MSFT | Stock | 402.355 | 404.615 | 402.15 | 404.59 | 791662.0 |
| 2024-09-09 12:00:00 | MSFT | Stock | 404.615 | 405.945 | 404.4 | 404.9 | 693325.0 |
| 2024-09-09 13:00:00 | MSFT | Stock | 404.93 | 405.6 | 403.9901 | 404.09 | 660349.0 |
| 2024-09-09 14:00:00 | MSFT | Stock | 404.09 | 404.179 | 402.97 | 403.4472 | 596215.0 |
| 2024-09-09 15:00:00 | MSFT | Stock | 403.41 | 405.91 | 402.83 | 405.72 | 1861778.0 |
| 2024-09-09 16:00:00 | MSFT | Stock | 405.72 | 407.99 | 405.29 | 407.76 | 3076443.0 |
| 2024-09-09 17:00:00 | MSFT | Stock | 407.85 | 408.5 | 407.85 | 408.15 | 9932.0 |
| 2024-09-09 18:00:00 | MSFT | Stock | 408.15 | 408.7 | 407.01 | 407.0914 | 12691.0 |
| 2024-09-09 19:00:00 | MSFT | Stock | 407.66 | 407.6919 | 407.0275 | 407.0275 | 1795.0 |
| 2024-09-09 04:00:00 | NVDA | Stock | 104.89 | 104.9 | 103.72 | 104.06 | 737918.0 |
| 2024-09-09 05:00:00 | NVDA | Stock | 104.08 | 104.37 | 103.93 | 104.1 | 312133.0 |
| 2024-09-09 06:00:00 | NVDA | Stock | 104.12 | 104.13 | 102.78 | 103.31 | 559058.0 |
| 2024-09-09 07:00:00 | NVDA | Stock | 103.325 | 104.23 | 103.27 | 104.02 | 1032874.0 |
| 2024-09-09 08:00:00 | NVDA | Stock | 104.03 | 105.05 | 103.0036 | 104.07 | 2196924.0 |
| 2024-09-09 09:00:00 | NVDA | Stock | 104.08 | 106.55 | 103.86 | 106.12 | 45705296.0 |
| 2024-09-09 10:00:00 | NVDA | Stock | 106.12 | 106.3 | 103.69 | 103.8391 | 46116823.0 |
| 2024-09-09 11:00:00 | NVDA | Stock | 103.8499 | 105.39 | 103.75 | 105.39 | 28967418.0 |
| 2024-09-09 12:00:00 | NVDA | Stock | 105.388 | 105.97 | 105.05 | 105.785 | 20608809.0 |
| 2024-09-09 13:00:00 | NVDA | Stock | 105.785 | 106.2 | 104.97 | 105.28 | 21674058.0 |
| 2024-09-09 14:00:00 | NVDA | Stock | 105.28 | 105.51 | 104.68 | 105.3794 | 19498344.0 |
| 2024-09-09 15:00:00 | NVDA | Stock | 105.37 | 106.55 | 104.99 | 106.48 | 27388825.0 |
| 2024-09-09 16:00:00 | NVDA | Stock | 106.46 | 107.13 | 106.23 | 106.8 | 22338727.0 |
| 2024-09-09 17:00:00 | NVDA | Stock | 106.81 | 107.15 | 106.8 | 106.88 | 636949.0 |
| 2024-09-09 18:00:00 | NVDA | Stock | 106.88 | 107.1 | 106.81 | 106.85 | 457827.0 |
| 2024-09-09 19:00:00 | NVDA | Stock | 106.85 | 107.13 | 106.83 | 107.1001 | 462995.0 |
| 2024-09-09 04:00:00 | AMZN | Stock | 172.12 | 173.49 | 172.12 | 173.12 | 12766.0 |
| 2024-09-09 05:00:00 | AMZN | Stock | 173.11 | 173.57 | 173.11 | 173.4 | 10873.0 |
> showing 50 of 58,814 rows — these rows as CSV