PREVIEW / stock_1hour / 2024-04-24
file: by_date/stock_1hour/2024/2024-04-24.parquet size: 1.3 MB rows: 57,796 symbols: 993
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-04-24 04:00:00 | AAPL | Stock | 167.19 | 167.77 | 167.15 | 167.28 | 22378.0 |
| 2024-04-24 05:00:00 | AAPL | Stock | 167.19 | 167.36 | 167.06 | 167.25 | 9821.0 |
| 2024-04-24 06:00:00 | AAPL | Stock | 167.2 | 167.23 | 166.92 | 166.95 | 14045.0 |
| 2024-04-24 07:00:00 | AAPL | Stock | 167.01 | 167.03 | 166.32 | 166.8 | 74034.0 |
| 2024-04-24 08:00:00 | AAPL | Stock | 166.96 | 167.72 | 166.48 | 166.58 | 104980.0 |
| 2024-04-24 09:00:00 | AAPL | Stock | 166.55 | 167.93 | 166.13 | 167.53 | 4771585.0 |
| 2024-04-24 10:00:00 | AAPL | Stock | 167.54 | 168.3 | 167.519 | 167.73 | 4852351.0 |
| 2024-04-24 11:00:00 | AAPL | Stock | 167.72 | 168.73 | 167.715 | 168.59 | 4637601.0 |
| 2024-04-24 12:00:00 | AAPL | Stock | 168.5903 | 169.28 | 168.11 | 168.355 | 4761863.0 |
| 2024-04-24 13:00:00 | AAPL | Stock | 168.3599 | 169.29 | 168.25 | 169.1085 | 2850006.0 |
| 2024-04-24 14:00:00 | AAPL | Stock | 169.105 | 169.12 | 168.28 | 168.45 | 2862442.0 |
| 2024-04-24 15:00:00 | AAPL | Stock | 168.45 | 169.3 | 168.3413 | 168.95 | 6438613.0 |
| 2024-04-24 16:00:00 | AAPL | Stock | 169.02 | 169.26 | 168.03 | 168.91 | 7500996.0 |
| 2024-04-24 17:00:00 | AAPL | Stock | 168.91 | 169.34 | 168.61 | 169.07 | 289216.0 |
| 2024-04-24 18:00:00 | AAPL | Stock | 169.16 | 169.5 | 169.02 | 169.14 | 65130.0 |
| 2024-04-24 19:00:00 | AAPL | Stock | 169.11 | 169.34 | 169.05 | 169.1 | 46446.0 |
| 2024-04-24 04:00:00 | MSFT | Stock | 410.13 | 410.13 | 409.05 | 409.1 | 16830.0 |
| 2024-04-24 05:00:00 | MSFT | Stock | 409.1 | 409.51 | 408.74 | 408.75 | 5121.0 |
| 2024-04-24 06:00:00 | MSFT | Stock | 408.75 | 409.8 | 408.75 | 409.66 | 6950.0 |
| 2024-04-24 07:00:00 | MSFT | Stock | 409.73 | 410.15 | 409.13 | 409.47 | 33730.0 |
| 2024-04-24 08:00:00 | MSFT | Stock | 409.85 | 411.94 | 409.0043 | 409.9 | 51463.0 |
| 2024-04-24 09:00:00 | MSFT | Stock | 409.8 | 412.47 | 408.7 | 409.44 | 1478342.0 |
| 2024-04-24 10:00:00 | MSFT | Stock | 409.48 | 410.81 | 408.72 | 409.0 | 1241269.0 |
| 2024-04-24 11:00:00 | MSFT | Stock | 409.0 | 409.295 | 407.07 | 407.185 | 777600.0 |
| 2024-04-24 12:00:00 | MSFT | Stock | 407.14 | 408.09 | 406.78 | 407.925 | 695857.0 |
| 2024-04-24 13:00:00 | MSFT | Stock | 407.94 | 410.12 | 407.5401 | 409.92 | 541375.0 |
| 2024-04-24 14:00:00 | MSFT | Stock | 409.93 | 410.0475 | 407.98 | 408.185 | 499772.0 |
| 2024-04-24 15:00:00 | MSFT | Stock | 408.17 | 409.6407 | 407.54 | 408.86 | 1000224.0 |
| 2024-04-24 16:00:00 | MSFT | Stock | 409.06 | 409.8399 | 402.0 | 402.31 | 2745682.0 |
| 2024-04-24 17:00:00 | MSFT | Stock | 402.36 | 402.4896 | 399.9 | 400.2 | 119888.0 |
| 2024-04-24 18:00:00 | MSFT | Stock | 400.5 | 402.0 | 400.2617 | 401.0518 | 26986.0 |
| 2024-04-24 19:00:00 | MSFT | Stock | 401.25 | 401.8 | 401.05 | 401.25 | 17936.0 |
| 2024-04-24 04:00:00 | NVDA | Stock | 84.052 | 84.5 | 83.5 | 83.8 | 455450.0 |
| 2024-04-24 05:00:00 | NVDA | Stock | 83.8 | 84.0 | 83.63 | 83.77 | 156920.0 |
| 2024-04-24 06:00:00 | NVDA | Stock | 83.798 | 84.215 | 83.798 | 84.168 | 455230.0 |
| 2024-04-24 07:00:00 | NVDA | Stock | 84.18 | 84.4 | 83.98 | 83.991 | 1314210.0 |
| 2024-04-24 08:00:00 | NVDA | Stock | 84.29 | 84.607 | 83.7 | 83.727 | 2205490.0 |
| 2024-04-24 09:00:00 | NVDA | Stock | 83.74 | 84.082 | 82.213 | 82.6658 | 52948860.0 |
| 2024-04-24 10:00:00 | NVDA | Stock | 82.668 | 83.448 | 82.455 | 82.8165 | 45437160.0 |
| 2024-04-24 11:00:00 | NVDA | Stock | 82.8021 | 82.874 | 80.752 | 80.834 | 50064540.0 |
| 2024-04-24 12:00:00 | NVDA | Stock | 80.8561 | 81.331 | 80.066 | 81.309 | 51277160.0 |
| 2024-04-24 13:00:00 | NVDA | Stock | 81.312 | 81.886 | 80.825 | 80.9947 | 36538920.0 |
| 2024-04-24 14:00:00 | NVDA | Stock | 80.9945 | 81.05 | 79.225 | 79.231 | 46583090.0 |
| 2024-04-24 15:00:00 | NVDA | Stock | 79.223 | 80.244 | 79.183 | 79.7 | 56517890.0 |
| 2024-04-24 16:00:00 | NVDA | Stock | 79.677 | 81.144 | 78.0979 | 78.378 | 19795510.0 |
| 2024-04-24 17:00:00 | NVDA | Stock | 78.4 | 78.614 | 77.7 | 78.429 | 2047210.0 |
| 2024-04-24 18:00:00 | NVDA | Stock | 78.448 | 78.96 | 78.407 | 78.407 | 939630.0 |
| 2024-04-24 19:00:00 | NVDA | Stock | 78.46 | 78.665 | 78.312 | 78.36 | 817190.0 |
| 2024-04-24 04:00:00 | AMZN | Stock | 180.22 | 180.57 | 180.1 | 180.3 | 26368.0 |
| 2024-04-24 05:00:00 | AMZN | Stock | 180.11 | 180.15 | 180.0 | 180.0 | 6983.0 |
> showing 50 of 57,796 rows — these rows as CSV