PREVIEW / stock_1hour / 2024-05-31
file: by_date/stock_1hour/2024/2024-05-31.parquet size: 1.3 MB rows: 59,075 symbols: 962
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-05-31 04:00:00 | AAPL | Stock | 191.0 | 191.6 | 190.66 | 191.15 | 11182.0 |
| 2024-05-31 05:00:00 | AAPL | Stock | 191.03 | 191.03 | 190.76 | 190.98 | 8967.0 |
| 2024-05-31 06:00:00 | AAPL | Stock | 190.99 | 191.04 | 190.53 | 190.68 | 16710.0 |
| 2024-05-31 07:00:00 | AAPL | Stock | 190.6 | 191.2 | 190.5 | 191.2 | 39029.0 |
| 2024-05-31 08:00:00 | AAPL | Stock | 190.84 | 192.0987 | 190.5 | 191.65 | 233056.0 |
| 2024-05-31 09:00:00 | AAPL | Stock | 191.78 | 192.57 | 190.99 | 191.71 | 5169455.0 |
| 2024-05-31 10:00:00 | AAPL | Stock | 191.71 | 192.4278 | 191.06 | 191.2001 | 5938454.0 |
| 2024-05-31 11:00:00 | AAPL | Stock | 191.205 | 191.3 | 190.08 | 190.335 | 4230532.0 |
| 2024-05-31 12:00:00 | AAPL | Stock | 190.33 | 190.3965 | 189.91 | 190.04 | 2781503.0 |
| 2024-05-31 13:00:00 | AAPL | Stock | 190.04 | 190.79 | 189.97 | 190.7701 | 2275701.0 |
| 2024-05-31 14:00:00 | AAPL | Stock | 190.78 | 190.82 | 190.33 | 190.76 | 2478980.0 |
| 2024-05-31 15:00:00 | AAPL | Stock | 190.763 | 192.5 | 190.64 | 192.47 | 11185035.0 |
| 2024-05-31 16:00:00 | AAPL | Stock | 192.42 | 192.63 | 191.1 | 192.34 | 26364554.0 |
| 2024-05-31 17:00:00 | AAPL | Stock | 192.35 | 192.5 | 192.25 | 192.46 | 91074.0 |
| 2024-05-31 18:00:00 | AAPL | Stock | 192.4435 | 192.49 | 192.25 | 192.47 | 28922.0 |
| 2024-05-31 19:00:00 | AAPL | Stock | 192.4509 | 192.49 | 192.42 | 192.48 | 11276.0 |
| 2024-05-31 04:00:00 | MSFT | Stock | 413.45 | 416.0 | 413.45 | 415.5 | 6753.0 |
| 2024-05-31 05:00:00 | MSFT | Stock | 415.12 | 416.17 | 414.95 | 415.6 | 6493.0 |
| 2024-05-31 06:00:00 | MSFT | Stock | 415.5 | 415.5 | 414.0 | 414.01 | 5798.0 |
| 2024-05-31 07:00:00 | MSFT | Stock | 414.48 | 415.95 | 414.1 | 415.95 | 18651.0 |
| 2024-05-31 08:00:00 | MSFT | Stock | 414.595 | 418.11 | 412.96 | 417.14 | 80116.0 |
| 2024-05-31 09:00:00 | MSFT | Stock | 417.2 | 417.67 | 411.29 | 412.258 | 2048480.0 |
| 2024-05-31 10:00:00 | MSFT | Stock | 412.25 | 412.73 | 406.06 | 407.66 | 4920861.0 |
| 2024-05-31 11:00:00 | MSFT | Stock | 407.66 | 407.8937 | 406.3 | 406.44 | 1463411.0 |
| 2024-05-31 12:00:00 | MSFT | Stock | 406.46 | 406.64 | 404.51 | 405.5064 | 1910892.0 |
| 2024-05-31 13:00:00 | MSFT | Stock | 405.51 | 407.08 | 405.3 | 406.51 | 1205355.0 |
| 2024-05-31 14:00:00 | MSFT | Stock | 406.54 | 406.77 | 405.21 | 406.4 | 1104228.0 |
| 2024-05-31 15:00:00 | MSFT | Stock | 406.4 | 415.75 | 406.09 | 415.3075 | 5934826.0 |
| 2024-05-31 16:00:00 | MSFT | Stock | 415.05 | 415.605 | 411.9653 | 415.1 | 13942570.0 |
| 2024-05-31 17:00:00 | MSFT | Stock | 415.1 | 415.39 | 414.91 | 415.2 | 42434.0 |
| 2024-05-31 18:00:00 | MSFT | Stock | 415.2 | 415.69 | 415.1 | 415.1 | 15211.0 |
| 2024-05-31 19:00:00 | MSFT | Stock | 415.15 | 415.19 | 415.1 | 415.19 | 5077.0 |
| 2024-05-31 04:00:00 | NVDA | Stock | 110.346 | 111.829 | 109.81 | 110.812 | 602420.0 |
| 2024-05-31 05:00:00 | NVDA | Stock | 110.884 | 111.273 | 110.6 | 111.037 | 392470.0 |
| 2024-05-31 06:00:00 | NVDA | Stock | 111.05 | 111.1 | 110.5 | 110.7 | 166960.0 |
| 2024-05-31 07:00:00 | NVDA | Stock | 110.687 | 111.749 | 110.35 | 111.635 | 1404400.0 |
| 2024-05-31 08:00:00 | NVDA | Stock | 110.54 | 113.5 | 109.49 | 113.006 | 8163230.0 |
| 2024-05-31 09:00:00 | NVDA | Stock | 113.001 | 113.2 | 110.753 | 111.7578 | 46666470.0 |
| 2024-05-31 10:00:00 | NVDA | Stock | 111.747 | 111.944 | 108.287 | 109.6022 | 76184280.0 |
| 2024-05-31 11:00:00 | NVDA | Stock | 109.6015 | 109.822 | 108.419 | 108.7315 | 37373450.0 |
| 2024-05-31 12:00:00 | NVDA | Stock | 108.735 | 109.1962 | 106.94 | 107.993 | 46008550.0 |
| 2024-05-31 13:00:00 | NVDA | Stock | 107.976 | 109.05 | 107.9 | 108.281 | 30222290.0 |
| 2024-05-31 14:00:00 | NVDA | Stock | 108.266 | 108.96 | 107.933 | 108.374 | 23129940.0 |
| 2024-05-31 15:00:00 | NVDA | Stock | 108.339 | 110.375 | 108.114 | 109.746 | 57706050.0 |
| 2024-05-31 16:00:00 | NVDA | Stock | 109.789 | 109.9 | 109.27 | 109.55 | 68761770.0 |
| 2024-05-31 17:00:00 | NVDA | Stock | 109.55 | 109.9 | 109.5 | 109.848 | 777610.0 |
| 2024-05-31 18:00:00 | NVDA | Stock | 109.825 | 109.89 | 109.65 | 109.873 | 209550.0 |
| 2024-05-31 19:00:00 | NVDA | Stock | 109.859 | 110.247 | 109.855 | 110.194 | 578780.0 |
| 2024-05-31 04:00:00 | AMZN | Stock | 178.41 | 178.5 | 178.17 | 178.37 | 5373.0 |
| 2024-05-31 05:00:00 | AMZN | Stock | 178.3 | 178.36 | 178.25 | 178.25 | 3202.0 |
> showing 50 of 59,075 rows — these rows as CSV