PREVIEW / stock_1hour / 2024-08-26
file: by_date/stock_1hour/2024/2024-08-26.parquet size: 1.3 MB rows: 59,448 symbols: 874
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-08-26 04:00:00 | AAPL | Stock | 226.75 | 227.38 | 226.75 | 227.31 | 8342.0 |
| 2024-08-26 05:00:00 | AAPL | Stock | 227.39 | 227.53 | 227.35 | 227.43 | 4666.0 |
| 2024-08-26 06:00:00 | AAPL | Stock | 227.44 | 227.49 | 227.24 | 227.25 | 2664.0 |
| 2024-08-26 07:00:00 | AAPL | Stock | 227.24 | 227.35 | 226.0 | 226.64 | 18391.0 |
| 2024-08-26 08:00:00 | AAPL | Stock | 227.3 | 227.36 | 226.273 | 227.0 | 61461.0 |
| 2024-08-26 09:00:00 | AAPL | Stock | 227.04 | 227.22 | 226.03 | 226.34 | 2524073.0 |
| 2024-08-26 10:00:00 | AAPL | Stock | 226.35 | 226.72 | 223.8905 | 224.82 | 3760891.0 |
| 2024-08-26 11:00:00 | AAPL | Stock | 224.8066 | 225.4 | 224.54 | 224.87 | 2047439.0 |
| 2024-08-26 12:00:00 | AAPL | Stock | 224.84 | 226.24 | 224.64 | 226.185 | 1644301.0 |
| 2024-08-26 13:00:00 | AAPL | Stock | 226.1887 | 226.425 | 225.443 | 225.6 | 1693984.0 |
| 2024-08-26 14:00:00 | AAPL | Stock | 225.61 | 226.34 | 225.46 | 226.325 | 1520446.0 |
| 2024-08-26 15:00:00 | AAPL | Stock | 226.32 | 227.28 | 226.115 | 227.22 | 3909195.0 |
| 2024-08-26 16:00:00 | AAPL | Stock | 227.18 | 227.21 | 223.3 | 225.67 | 3555678.0 |
| 2024-08-26 17:00:00 | AAPL | Stock | 225.71 | 226.32 | 225.5 | 226.1 | 70750.0 |
| 2024-08-26 18:00:00 | AAPL | Stock | 226.08 | 226.14 | 225.51 | 225.97 | 28420.0 |
| 2024-08-26 19:00:00 | AAPL | Stock | 225.9 | 226.5 | 225.86 | 226.5 | 22738.0 |
| 2024-08-26 04:00:00 | MSFT | Stock | 417.17 | 417.44 | 417.12 | 417.43 | 3977.0 |
| 2024-08-26 05:00:00 | MSFT | Stock | 417.29 | 417.43 | 417.12 | 417.4 | 1468.0 |
| 2024-08-26 06:00:00 | MSFT | Stock | 417.47 | 417.48 | 417.2 | 417.2 | 1304.0 |
| 2024-08-26 07:00:00 | MSFT | Stock | 417.12 | 417.17 | 416.29 | 416.29 | 4024.0 |
| 2024-08-26 08:00:00 | MSFT | Stock | 416.59 | 417.2869 | 415.6 | 416.02 | 20903.0 |
| 2024-08-26 09:00:00 | MSFT | Stock | 416.0 | 417.2799 | 414.68 | 415.64 | 853587.0 |
| 2024-08-26 10:00:00 | MSFT | Stock | 415.73 | 416.0512 | 412.14 | 414.04 | 958028.0 |
| 2024-08-26 11:00:00 | MSFT | Stock | 414.05 | 415.14 | 413.08 | 413.24 | 684949.0 |
| 2024-08-26 12:00:00 | MSFT | Stock | 413.21 | 414.35 | 412.995 | 413.9 | 418022.0 |
| 2024-08-26 13:00:00 | MSFT | Stock | 413.93 | 414.14 | 411.59 | 411.87 | 558950.0 |
| 2024-08-26 14:00:00 | MSFT | Stock | 411.915 | 413.59 | 411.34 | 413.5 | 493171.0 |
| 2024-08-26 15:00:00 | MSFT | Stock | 413.47 | 413.63 | 412.325 | 413.61 | 1237078.0 |
| 2024-08-26 16:00:00 | MSFT | Stock | 413.49 | 413.722 | 413.22 | 413.24 | 2136872.0 |
| 2024-08-26 17:00:00 | MSFT | Stock | 413.25 | 413.25 | 413.01 | 413.01 | 3456.0 |
| 2024-08-26 18:00:00 | MSFT | Stock | 413.2 | 413.2 | 412.01 | 412.01 | 3779.0 |
| 2024-08-26 19:00:00 | MSFT | Stock | 412.02 | 413.28 | 412.02 | 412.607 | 3714.0 |
| 2024-08-26 04:00:00 | NVDA | Stock | 130.13 | 130.7 | 129.75 | 130.47 | 626788.0 |
| 2024-08-26 05:00:00 | NVDA | Stock | 130.47 | 130.66 | 130.41 | 130.58 | 333394.0 |
| 2024-08-26 06:00:00 | NVDA | Stock | 130.58 | 130.93 | 130.5 | 130.55 | 395086.0 |
| 2024-08-26 07:00:00 | NVDA | Stock | 130.55 | 130.71 | 129.52 | 129.9 | 1602928.0 |
| 2024-08-26 08:00:00 | NVDA | Stock | 129.9 | 130.8496 | 129.09 | 129.54 | 3741293.0 |
| 2024-08-26 09:00:00 | NVDA | Stock | 129.57 | 131.26 | 128.59 | 128.7 | 48007418.0 |
| 2024-08-26 10:00:00 | NVDA | Stock | 128.7 | 128.87 | 124.37 | 126.695 | 73100778.0 |
| 2024-08-26 11:00:00 | NVDA | Stock | 126.69 | 127.44 | 126.12 | 126.44 | 36169644.0 |
| 2024-08-26 12:00:00 | NVDA | Stock | 126.44 | 127.54 | 125.93 | 126.985 | 26717105.0 |
| 2024-08-26 13:00:00 | NVDA | Stock | 126.98 | 127.0196 | 125.76 | 126.02 | 24625714.0 |
| 2024-08-26 14:00:00 | NVDA | Stock | 126.03 | 126.99 | 125.55 | 126.9857 | 23626316.0 |
| 2024-08-26 15:00:00 | NVDA | Stock | 126.98 | 126.99 | 126.12 | 126.46 | 30568524.0 |
| 2024-08-26 16:00:00 | NVDA | Stock | 126.47 | 126.6933 | 126.3108 | 126.56 | 21451653.0 |
| 2024-08-26 17:00:00 | NVDA | Stock | 126.57 | 126.809 | 126.52 | 126.75 | 406116.0 |
| 2024-08-26 18:00:00 | NVDA | Stock | 126.74 | 126.87 | 126.51 | 126.55 | 444841.0 |
| 2024-08-26 19:00:00 | NVDA | Stock | 126.5887 | 126.7499 | 126.51 | 126.58 | 460352.0 |
| 2024-08-26 04:00:00 | AMZN | Stock | 177.0 | 177.62 | 177.0 | 177.27 | 12830.0 |
| 2024-08-26 05:00:00 | AMZN | Stock | 177.41 | 177.47 | 177.24 | 177.47 | 5537.0 |
> showing 50 of 59,448 rows — these rows as CSV