PREVIEW / stock_1hour / 2024-04-22
file: by_date/stock_1hour/2024/2024-04-22.parquet size: 1.3 MB rows: 58,114 symbols: 978
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-22 04:00:00 | AAPL | Stock | 165.5 | 165.8 | 165.4 | 165.59 | 12710.0 |
| 2024-04-22 05:00:00 | AAPL | Stock | 165.53 | 166.2 | 165.5 | 166.0 | 16715.0 |
| 2024-04-22 06:00:00 | AAPL | Stock | 165.96 | 166.33 | 165.5 | 165.51 | 14831.0 |
| 2024-04-22 07:00:00 | AAPL | Stock | 165.7 | 165.92 | 165.46 | 165.81 | 67608.0 |
| 2024-04-22 08:00:00 | AAPL | Stock | 165.61 | 166.36 | 164.588 | 166.13 | 170536.0 |
| 2024-04-22 09:00:00 | AAPL | Stock | 166.13 | 166.23 | 165.3 | 165.835 | 5016240.0 |
| 2024-04-22 10:00:00 | AAPL | Stock | 165.84 | 166.03 | 165.1 | 165.2254 | 4351958.0 |
| 2024-04-22 11:00:00 | AAPL | Stock | 165.22 | 165.7 | 164.77 | 165.655 | 3933739.0 |
| 2024-04-22 12:00:00 | AAPL | Stock | 165.6624 | 165.87 | 165.43 | 165.81 | 2997708.0 |
| 2024-04-22 13:00:00 | AAPL | Stock | 165.82 | 167.26 | 165.8 | 167.19 | 3934683.0 |
| 2024-04-22 14:00:00 | AAPL | Stock | 167.185 | 167.25 | 166.255 | 166.6256 | 3656675.0 |
| 2024-04-22 15:00:00 | AAPL | Stock | 166.625 | 166.89 | 165.64 | 165.84 | 5688470.0 |
| 2024-04-22 16:00:00 | AAPL | Stock | 165.99 | 165.99 | 165.51 | 165.69 | 7411641.0 |
| 2024-04-22 17:00:00 | AAPL | Stock | 165.71 | 166.0786 | 165.64 | 166.05 | 33682.0 |
| 2024-04-22 18:00:00 | AAPL | Stock | 166.05 | 166.05 | 165.65 | 165.82 | 15446.0 |
| 2024-04-22 19:00:00 | AAPL | Stock | 165.8 | 165.84 | 165.56 | 165.77 | 12591.0 |
| 2024-04-22 04:00:00 | MSFT | Stock | 400.0 | 400.79 | 396.85 | 400.47 | 7003.0 |
| 2024-04-22 05:00:00 | MSFT | Stock | 400.6 | 401.35 | 400.56 | 400.81 | 4897.0 |
| 2024-04-22 06:00:00 | MSFT | Stock | 401.0 | 401.37 | 400.75 | 400.88 | 2619.0 |
| 2024-04-22 07:00:00 | MSFT | Stock | 400.81 | 400.81 | 399.13 | 399.41 | 21609.0 |
| 2024-04-22 08:00:00 | MSFT | Stock | 400.22 | 401.34 | 397.97 | 399.7201 | 70993.0 |
| 2024-04-22 09:00:00 | MSFT | Stock | 399.98 | 402.5 | 398.37 | 399.51 | 1785310.0 |
| 2024-04-22 10:00:00 | MSFT | Stock | 399.66 | 401.29 | 396.67 | 396.92 | 1722449.0 |
| 2024-04-22 11:00:00 | MSFT | Stock | 396.9 | 398.93 | 395.75 | 398.83 | 1192709.0 |
| 2024-04-22 12:00:00 | MSFT | Stock | 398.85 | 399.37 | 398.26 | 399.14 | 741007.0 |
| 2024-04-22 13:00:00 | MSFT | Stock | 399.18 | 401.58 | 399.0801 | 400.98 | 865246.0 |
| 2024-04-22 14:00:00 | MSFT | Stock | 400.95 | 402.85 | 400.6 | 402.05 | 999225.0 |
| 2024-04-22 15:00:00 | MSFT | Stock | 402.06 | 402.21 | 399.97 | 400.82 | 1549962.0 |
| 2024-04-22 16:00:00 | MSFT | Stock | 400.96 | 401.32 | 400.21 | 401.1 | 3609315.0 |
| 2024-04-22 17:00:00 | MSFT | Stock | 401.12 | 401.82 | 401.12 | 401.75 | 5670.0 |
| 2024-04-22 18:00:00 | MSFT | Stock | 401.75 | 401.78 | 400.94 | 401.583 | 4044.0 |
| 2024-04-22 19:00:00 | MSFT | Stock | 400.93 | 400.93 | 400.13 | 400.6 | 4666.0 |
| 2024-04-22 04:00:00 | NVDA | Stock | 77.978 | 77.978 | 76.78 | 77.42 | 702680.0 |
| 2024-04-22 05:00:00 | NVDA | Stock | 77.438 | 78.388 | 77.402 | 78.3 | 616610.0 |
| 2024-04-22 06:00:00 | NVDA | Stock | 78.338 | 78.47 | 77.725 | 77.725 | 618130.0 |
| 2024-04-22 07:00:00 | NVDA | Stock | 77.701 | 77.826 | 76.89 | 77.065 | 2713560.0 |
| 2024-04-22 08:00:00 | NVDA | Stock | 77.3 | 78.282 | 76.537 | 77.1502 | 4886420.0 |
| 2024-04-22 09:00:00 | NVDA | Stock | 77.15 | 79.639 | 77.1 | 78.6552 | 87038980.0 |
| 2024-04-22 10:00:00 | NVDA | Stock | 78.6385 | 79.1 | 76.4 | 77.633 | 81169340.0 |
| 2024-04-22 11:00:00 | NVDA | Stock | 77.606 | 78.636 | 76.93 | 78.6138 | 51621530.0 |
| 2024-04-22 12:00:00 | NVDA | Stock | 78.627 | 78.9 | 78.157 | 78.69 | 34153640.0 |
| 2024-04-22 13:00:00 | NVDA | Stock | 78.652 | 79.688 | 78.485 | 79.462 | 44035710.0 |
| 2024-04-22 14:00:00 | NVDA | Stock | 79.472 | 80.073 | 79.126 | 79.8335 | 45904210.0 |
| 2024-04-22 15:00:00 | NVDA | Stock | 79.823 | 79.956 | 78.873 | 79.51 | 50993790.0 |
| 2024-04-22 16:00:00 | NVDA | Stock | 79.518 | 79.518 | 79.016 | 79.243 | 20224720.0 |
| 2024-04-22 17:00:00 | NVDA | Stock | 79.25 | 79.55 | 79.21 | 79.55 | 433980.0 |
| 2024-04-22 18:00:00 | NVDA | Stock | 79.576 | 79.6 | 79.2205 | 79.299 | 537220.0 |
| 2024-04-22 19:00:00 | NVDA | Stock | 79.318 | 79.399 | 79.15 | 79.344 | 421510.0 |
| 2024-04-22 04:00:00 | AMZN | Stock | 175.16 | 175.86 | 175.16 | 175.77 | 10964.0 |
| 2024-04-22 05:00:00 | AMZN | Stock | 175.83 | 176.1 | 175.73 | 175.73 | 11330.0 |
> showing 50 of 58,114 rows — these rows as CSV