PREVIEW / stock_1hour / 2024-07-31
file: by_date/stock_1hour/2024/2024-07-31.parquet size: 1.4 MB rows: 60,445 symbols: 898
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-07-31 04:00:00 | AAPL | Stock | 219.67 | 220.24 | 219.29 | 220.24 | 24866.0 |
| 2024-07-31 05:00:00 | AAPL | Stock | 220.33 | 220.68 | 220.02 | 220.49 | 10411.0 |
| 2024-07-31 06:00:00 | AAPL | Stock | 220.26 | 220.42 | 219.95 | 220.42 | 10840.0 |
| 2024-07-31 07:00:00 | AAPL | Stock | 220.32 | 220.6 | 220.01 | 220.25 | 55820.0 |
| 2024-07-31 08:00:00 | AAPL | Stock | 220.0 | 221.3 | 218.7 | 221.3 | 270364.0 |
| 2024-07-31 09:00:00 | AAPL | Stock | 221.28 | 222.66 | 220.63 | 221.98 | 4964265.0 |
| 2024-07-31 10:00:00 | AAPL | Stock | 221.98 | 223.82 | 221.83 | 222.61 | 5313025.0 |
| 2024-07-31 11:00:00 | AAPL | Stock | 222.605 | 223.37 | 222.3 | 222.55 | 2869202.0 |
| 2024-07-31 12:00:00 | AAPL | Stock | 222.57 | 222.76 | 222.0801 | 222.54 | 1977272.0 |
| 2024-07-31 13:00:00 | AAPL | Stock | 222.54 | 223.01 | 221.31 | 222.17 | 3283336.0 |
| 2024-07-31 14:00:00 | AAPL | Stock | 222.19 | 223.37 | 221.92 | 222.665 | 2791675.0 |
| 2024-07-31 15:00:00 | AAPL | Stock | 222.665 | 223.03 | 221.285 | 221.99 | 6765804.0 |
| 2024-07-31 16:00:00 | AAPL | Stock | 222.08 | 223.39 | 221.77 | 222.32 | 11231363.0 |
| 2024-07-31 17:00:00 | AAPL | Stock | 222.401 | 222.8976 | 222.08 | 222.83 | 101053.0 |
| 2024-07-31 18:00:00 | AAPL | Stock | 222.85 | 223.33 | 222.08 | 223.3 | 345545.0 |
| 2024-07-31 19:00:00 | AAPL | Stock | 223.25 | 223.9245 | 223.0682 | 223.8 | 69716.0 |
| 2024-07-31 04:00:00 | MSFT | Stock | 412.15 | 414.87 | 409.32 | 413.1 | 49335.0 |
| 2024-07-31 05:00:00 | MSFT | Stock | 412.59 | 412.8 | 409.89 | 410.69 | 20958.0 |
| 2024-07-31 06:00:00 | MSFT | Stock | 411.0 | 412.68 | 411.0 | 412.26 | 25325.0 |
| 2024-07-31 07:00:00 | MSFT | Stock | 412.13 | 412.2 | 406.71 | 409.6 | 162798.0 |
| 2024-07-31 08:00:00 | MSFT | Stock | 409.74 | 418.0 | 406.6 | 415.65 | 457546.0 |
| 2024-07-31 09:00:00 | MSFT | Stock | 415.63 | 423.09 | 412.21 | 418.73 | 5976193.0 |
| 2024-07-31 10:00:00 | MSFT | Stock | 418.74 | 420.1953 | 414.93 | 417.3875 | 3691945.0 |
| 2024-07-31 11:00:00 | MSFT | Stock | 417.39 | 418.67 | 415.75 | 416.075 | 1814573.0 |
| 2024-07-31 12:00:00 | MSFT | Stock | 416.11 | 416.81 | 413.86 | 414.55 | 1987194.0 |
| 2024-07-31 13:00:00 | MSFT | Stock | 414.63 | 419.23 | 414.52 | 418.87 | 1829299.0 |
| 2024-07-31 14:00:00 | MSFT | Stock | 418.92 | 420.12 | 417.2 | 418.71 | 2303093.0 |
| 2024-07-31 15:00:00 | MSFT | Stock | 418.75 | 421.3 | 415.55 | 418.36 | 4470327.0 |
| 2024-07-31 16:00:00 | MSFT | Stock | 418.22 | 419.68 | 416.6 | 417.81 | 6490056.0 |
| 2024-07-31 17:00:00 | MSFT | Stock | 417.98 | 418.8482 | 417.98 | 418.62 | 20065.0 |
| 2024-07-31 18:00:00 | MSFT | Stock | 418.5 | 418.8 | 418.2901 | 418.76 | 211165.0 |
| 2024-07-31 19:00:00 | MSFT | Stock | 418.8 | 419.2 | 418.702 | 419.2 | 39710.0 |
| 2024-07-31 04:00:00 | NVDA | Stock | 109.88 | 110.5 | 108.41 | 109.0 | 1238396.0 |
| 2024-07-31 05:00:00 | NVDA | Stock | 108.99 | 109.3 | 108.88 | 109.02 | 406332.0 |
| 2024-07-31 06:00:00 | NVDA | Stock | 109.0 | 110.36 | 109.0 | 110.3 | 1253777.0 |
| 2024-07-31 07:00:00 | NVDA | Stock | 110.31 | 111.21 | 109.77 | 110.85 | 2662803.0 |
| 2024-07-31 08:00:00 | NVDA | Stock | 110.85 | 111.21 | 108.63 | 111.0498 | 5838759.0 |
| 2024-07-31 09:00:00 | NVDA | Stock | 111.0 | 114.87 | 110.88 | 114.4291 | 76178366.0 |
| 2024-07-31 10:00:00 | NVDA | Stock | 114.42 | 115.77 | 113.81 | 114.765 | 61652521.0 |
| 2024-07-31 11:00:00 | NVDA | Stock | 114.76 | 116.47 | 114.44 | 115.63 | 41694761.0 |
| 2024-07-31 12:00:00 | NVDA | Stock | 115.62 | 116.46 | 114.74 | 114.945 | 31221127.0 |
| 2024-07-31 13:00:00 | NVDA | Stock | 114.9405 | 116.03 | 114.25 | 114.88 | 30031420.0 |
| 2024-07-31 14:00:00 | NVDA | Stock | 114.9 | 118.34 | 114.42 | 117.9099 | 48910649.0 |
| 2024-07-31 15:00:00 | NVDA | Stock | 117.91 | 117.94 | 115.92 | 117.18 | 56815104.0 |
| 2024-07-31 16:00:00 | NVDA | Stock | 117.02 | 119.88 | 115.9358 | 119.0 | 53461648.0 |
| 2024-07-31 17:00:00 | NVDA | Stock | 119.02 | 120.25 | 117.02 | 120.01 | 2782196.0 |
| 2024-07-31 18:00:00 | NVDA | Stock | 120.09 | 121.29 | 119.81 | 120.99 | 2715482.0 |
| 2024-07-31 19:00:00 | NVDA | Stock | 120.99 | 121.62 | 120.93 | 121.3199 | 1805390.0 |
| 2024-07-31 04:00:00 | AMZN | Stock | 182.0 | 182.7 | 181.3 | 182.1 | 34171.0 |
| 2024-07-31 05:00:00 | AMZN | Stock | 182.01 | 182.25 | 181.75 | 181.8 | 6509.0 |
> showing 50 of 60,445 rows — these rows as CSV