PREVIEW / stock_1hour / 2024-09-06
file: by_date/stock_1hour/2024/2024-09-06.parquet size: 1.3 MB rows: 58,042 symbols: 802
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-06 04:00:00 | AAPL | Stock | 219.0 | 221.87 | 219.0 | 221.22 | 8326.0 |
| 2024-09-06 05:00:00 | AAPL | Stock | 221.17 | 221.24 | 220.71 | 221.24 | 2869.0 |
| 2024-09-06 06:00:00 | AAPL | Stock | 221.25 | 221.3 | 220.95 | 220.95 | 1844.0 |
| 2024-09-06 07:00:00 | AAPL | Stock | 221.09 | 222.1 | 220.9 | 221.35 | 38721.0 |
| 2024-09-06 08:00:00 | AAPL | Stock | 221.8256 | 223.652 | 220.85 | 223.4 | 259579.0 |
| 2024-09-06 09:00:00 | AAPL | Stock | 223.38 | 225.24 | 222.8 | 224.045 | 5112625.0 |
| 2024-09-06 10:00:00 | AAPL | Stock | 224.045 | 224.75 | 220.93 | 221.4 | 5485996.0 |
| 2024-09-06 11:00:00 | AAPL | Stock | 221.41 | 222.57 | 220.82 | 220.96 | 3465086.0 |
| 2024-09-06 12:00:00 | AAPL | Stock | 220.955 | 221.35 | 220.46 | 220.68 | 2508163.0 |
| 2024-09-06 13:00:00 | AAPL | Stock | 220.68 | 221.64 | 220.08 | 220.265 | 2396775.0 |
| 2024-09-06 14:00:00 | AAPL | Stock | 220.3079 | 220.68 | 219.77 | 220.54 | 2270910.0 |
| 2024-09-06 15:00:00 | AAPL | Stock | 220.545 | 221.55 | 220.14 | 220.95 | 4973448.0 |
| 2024-09-06 16:00:00 | AAPL | Stock | 220.82 | 221.82 | 219.77 | 219.93 | 9362129.0 |
| 2024-09-06 17:00:00 | AAPL | Stock | 220.03 | 220.82 | 219.87 | 219.9 | 162871.0 |
| 2024-09-06 18:00:00 | AAPL | Stock | 219.9 | 220.2925 | 219.8 | 220.1128 | 24414.0 |
| 2024-09-06 19:00:00 | AAPL | Stock | 220.2 | 220.39 | 220.01 | 220.1434 | 12686.0 |
| 2024-09-06 04:00:00 | MSFT | Stock | 407.78 | 407.78 | 405.0 | 405.8 | 2905.0 |
| 2024-09-06 05:00:00 | MSFT | Stock | 405.61 | 405.7 | 404.89 | 405.5 | 5496.0 |
| 2024-09-06 06:00:00 | MSFT | Stock | 405.27 | 405.27 | 400.66 | 403.28 | 18172.0 |
| 2024-09-06 07:00:00 | MSFT | Stock | 403.69 | 406.35 | 403.69 | 406.25 | 10748.0 |
| 2024-09-06 08:00:00 | MSFT | Stock | 404.0042 | 409.45 | 404.0 | 408.98 | 65502.0 |
| 2024-09-06 09:00:00 | MSFT | Stock | 409.1711 | 410.65 | 407.2 | 407.57 | 1016170.0 |
| 2024-09-06 10:00:00 | MSFT | Stock | 407.565 | 408.42 | 401.98 | 402.7 | 1399364.0 |
| 2024-09-06 11:00:00 | MSFT | Stock | 402.65 | 405.23 | 401.69 | 401.7025 | 1159871.0 |
| 2024-09-06 12:00:00 | MSFT | Stock | 401.74 | 403.04 | 401.462 | 402.485 | 944878.0 |
| 2024-09-06 13:00:00 | MSFT | Stock | 402.475 | 403.9 | 401.1 | 401.695 | 454752.0 |
| 2024-09-06 14:00:00 | MSFT | Stock | 401.67 | 401.8399 | 400.8 | 401.38 | 771941.0 |
| 2024-09-06 15:00:00 | MSFT | Stock | 401.35 | 402.66 | 400.99 | 401.74 | 1742206.0 |
| 2024-09-06 16:00:00 | MSFT | Stock | 401.81 | 402.42 | 400.01 | 400.24 | 5639690.0 |
| 2024-09-06 17:00:00 | MSFT | Stock | 401.7 | 401.7 | 400.01 | 400.21 | 17368.0 |
| 2024-09-06 18:00:00 | MSFT | Stock | 400.08 | 400.15 | 400.0 | 400.07 | 3963.0 |
| 2024-09-06 19:00:00 | MSFT | Stock | 400.07 | 400.3 | 400.0 | 400.07 | 11148.0 |
| 2024-09-06 04:00:00 | NVDA | Stock | 105.49 | 106.17 | 104.43 | 104.54 | 715393.0 |
| 2024-09-06 05:00:00 | NVDA | Stock | 104.52 | 105.26 | 104.38 | 105.21 | 353868.0 |
| 2024-09-06 06:00:00 | NVDA | Stock | 105.2 | 106.0 | 104.96 | 105.32 | 314165.0 |
| 2024-09-06 07:00:00 | NVDA | Stock | 105.49 | 105.95 | 105.08 | 105.73 | 809624.0 |
| 2024-09-06 08:00:00 | NVDA | Stock | 105.45 | 108.33 | 104.4 | 108.08 | 7147517.0 |
| 2024-09-06 09:00:00 | NVDA | Stock | 108.08 | 108.97 | 104.13 | 104.165 | 51487845.0 |
| 2024-09-06 10:00:00 | NVDA | Stock | 104.17 | 105.33 | 101.95 | 102.645 | 73471488.0 |
| 2024-09-06 11:00:00 | NVDA | Stock | 102.64 | 103.75 | 101.39 | 101.663 | 52986354.0 |
| 2024-09-06 12:00:00 | NVDA | Stock | 101.66 | 102.6 | 100.95 | 102.01 | 37587439.0 |
| 2024-09-06 13:00:00 | NVDA | Stock | 102.01 | 103.27 | 101.852 | 102.3802 | 31461427.0 |
| 2024-09-06 14:00:00 | NVDA | Stock | 102.39 | 102.96 | 101.78 | 102.7892 | 25156892.0 |
| 2024-09-06 15:00:00 | NVDA | Stock | 102.78 | 103.6677 | 102.49 | 102.81 | 43070716.0 |
| 2024-09-06 16:00:00 | NVDA | Stock | 102.86 | 103.09 | 102.15 | 102.34 | 27572130.0 |
| 2024-09-06 17:00:00 | NVDA | Stock | 102.3 | 102.83 | 102.22 | 102.44 | 861536.0 |
| 2024-09-06 18:00:00 | NVDA | Stock | 102.43 | 102.66 | 102.3897 | 102.5 | 438144.0 |
| 2024-09-06 19:00:00 | NVDA | Stock | 102.5 | 102.67 | 102.41 | 102.49 | 416324.0 |
| 2024-09-06 04:00:00 | AMZN | Stock | 176.84 | 176.84 | 174.47 | 174.6 | 15606.0 |
| 2024-09-06 05:00:00 | AMZN | Stock | 174.65 | 175.49 | 174.45 | 175.44 | 19130.0 |
> showing 50 of 58,042 rows — these rows as CSV