PREVIEW / stock_1hour / 2024-02-08
file: by_date/stock_1hour/2024/2024-02-08.parquet size: 1.3 MB rows: 59,140 symbols: 1,148
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-02-08 04:00:00 | AAPL | Stock | 189.41 | 189.5 | 189.39 | 189.45 | 4431.0 |
| 2024-02-08 05:00:00 | AAPL | Stock | 189.5 | 189.61 | 189.5 | 189.57 | 4272.0 |
| 2024-02-08 06:00:00 | AAPL | Stock | 189.59 | 189.59 | 189.33 | 189.41 | 5678.0 |
| 2024-02-08 07:00:00 | AAPL | Stock | 189.28 | 189.31 | 189.02 | 189.17 | 11284.0 |
| 2024-02-08 08:00:00 | AAPL | Stock | 189.2 | 189.64 | 189.02 | 189.39 | 46391.0 |
| 2024-02-08 09:00:00 | AAPL | Stock | 189.39 | 189.535 | 188.7 | 188.95 | 4164783.0 |
| 2024-02-08 10:00:00 | AAPL | Stock | 188.95 | 188.96 | 187.35 | 188.115 | 6438159.0 |
| 2024-02-08 11:00:00 | AAPL | Stock | 188.11 | 188.41 | 187.8301 | 188.4 | 3628913.0 |
| 2024-02-08 12:00:00 | AAPL | Stock | 188.4 | 188.75 | 188.06 | 188.085 | 2678287.0 |
| 2024-02-08 13:00:00 | AAPL | Stock | 188.085 | 188.36 | 188.0 | 188.14 | 2611096.0 |
| 2024-02-08 14:00:00 | AAPL | Stock | 188.15 | 188.3 | 187.99 | 188.1799 | 2478480.0 |
| 2024-02-08 15:00:00 | AAPL | Stock | 188.1768 | 188.445 | 188.07 | 188.34 | 5173309.0 |
| 2024-02-08 16:00:00 | AAPL | Stock | 188.25 | 188.32 | 188.13 | 188.2 | 4834396.0 |
| 2024-02-08 17:00:00 | AAPL | Stock | 188.2 | 188.32 | 188.12 | 188.15 | 41162.0 |
| 2024-02-08 18:00:00 | AAPL | Stock | 188.13 | 188.24 | 188.13 | 188.2 | 6450.0 |
| 2024-02-08 19:00:00 | AAPL | Stock | 188.23 | 188.29 | 188.15 | 188.2 | 18263.0 |
| 2024-02-08 04:00:00 | MSFT | Stock | 414.13 | 414.43 | 413.31 | 413.31 | 5124.0 |
| 2024-02-08 05:00:00 | MSFT | Stock | 413.25 | 413.35 | 411.88 | 412.2 | 3863.0 |
| 2024-02-08 06:00:00 | MSFT | Stock | 412.39 | 412.87 | 412.39 | 412.67 | 5419.0 |
| 2024-02-08 07:00:00 | MSFT | Stock | 412.77 | 415.0 | 412.77 | 412.85 | 14621.0 |
| 2024-02-08 08:00:00 | MSFT | Stock | 412.92 | 415.79 | 412.5219 | 413.21 | 64128.0 |
| 2024-02-08 09:00:00 | MSFT | Stock | 413.12 | 415.56 | 413.12 | 413.96 | 2000456.0 |
| 2024-02-08 10:00:00 | MSFT | Stock | 413.99 | 414.9 | 413.1 | 414.559 | 1205070.0 |
| 2024-02-08 11:00:00 | MSFT | Stock | 414.54 | 414.57 | 412.61 | 413.38 | 1283376.0 |
| 2024-02-08 12:00:00 | MSFT | Stock | 413.37 | 413.45 | 412.76 | 413.285 | 715640.0 |
| 2024-02-08 13:00:00 | MSFT | Stock | 413.3 | 414.14 | 413.155 | 413.5579 | 767932.0 |
| 2024-02-08 14:00:00 | MSFT | Stock | 413.56 | 413.644 | 412.53 | 413.45 | 824489.0 |
| 2024-02-08 15:00:00 | MSFT | Stock | 413.4296 | 414.25 | 413.3 | 414.15 | 1678618.0 |
| 2024-02-08 16:00:00 | MSFT | Stock | 414.11 | 414.25 | 413.71 | 414.0399 | 2218036.0 |
| 2024-02-08 17:00:00 | MSFT | Stock | 414.04 | 414.11 | 413.9 | 414.1 | 5027.0 |
| 2024-02-08 18:00:00 | MSFT | Stock | 413.89 | 414.1739 | 413.5398 | 414.01 | 5830.0 |
| 2024-02-08 19:00:00 | MSFT | Stock | 414.15 | 414.18 | 414.0 | 414.0 | 7154.0 |
| 2024-02-08 04:00:00 | NVDA | Stock | 70.6 | 70.689 | 70.1 | 70.3 | 314190.0 |
| 2024-02-08 05:00:00 | NVDA | Stock | 70.32 | 70.35 | 69.801 | 70.03 | 585770.0 |
| 2024-02-08 06:00:00 | NVDA | Stock | 70.0 | 70.0 | 69.437 | 69.639 | 533960.0 |
| 2024-02-08 07:00:00 | NVDA | Stock | 69.639 | 69.951 | 69.56 | 69.67 | 1048080.0 |
| 2024-02-08 08:00:00 | NVDA | Stock | 69.7 | 70.75 | 69.632 | 69.72 | 2506320.0 |
| 2024-02-08 09:00:00 | NVDA | Stock | 69.73 | 70.794 | 69.455 | 70.269 | 62232230.0 |
| 2024-02-08 10:00:00 | NVDA | Stock | 70.242 | 70.61 | 69.654 | 70.471 | 61831910.0 |
| 2024-02-08 11:00:00 | NVDA | Stock | 70.462 | 70.595 | 70.294 | 70.307 | 32135280.0 |
| 2024-02-08 12:00:00 | NVDA | Stock | 70.3135 | 70.433 | 69.972 | 70.0132 | 28889870.0 |
| 2024-02-08 13:00:00 | NVDA | Stock | 70.031 | 70.65 | 70.0 | 70.3837 | 28467810.0 |
| 2024-02-08 14:00:00 | NVDA | Stock | 70.39 | 70.471 | 69.705 | 70.0002 | 31329630.0 |
| 2024-02-08 15:00:00 | NVDA | Stock | 70.002 | 70.05 | 69.555 | 69.64 | 32745740.0 |
| 2024-02-08 16:00:00 | NVDA | Stock | 69.654 | 69.8 | 69.35 | 69.62 | 14042430.0 |
| 2024-02-08 17:00:00 | NVDA | Stock | 69.633 | 69.877 | 69.633 | 69.795 | 602470.0 |
| 2024-02-08 18:00:00 | NVDA | Stock | 69.774 | 69.776 | 69.7 | 69.748 | 220570.0 |
| 2024-02-08 19:00:00 | NVDA | Stock | 69.748 | 69.797 | 69.72 | 69.75 | 556540.0 |
| 2024-02-08 04:00:00 | AMZN | Stock | 170.28 | 170.95 | 170.28 | 170.82 | 4159.0 |
| 2024-02-08 05:00:00 | AMZN | Stock | 170.81 | 170.86 | 170.7 | 170.78 | 3973.0 |
> showing 50 of 59,140 rows — these rows as CSV