PREVIEW / stock_1hour / 2024-08-28
file: by_date/stock_1hour/2024/2024-08-28.parquet size: 1.3 MB rows: 58,217 symbols: 823
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-28 04:00:00 | AAPL | Stock | 228.0 | 229.0 | 228.0 | 228.9 | 14614.0 |
| 2024-08-28 05:00:00 | AAPL | Stock | 228.9 | 228.97 | 228.58 | 228.58 | 4643.0 |
| 2024-08-28 06:00:00 | AAPL | Stock | 228.61 | 228.66 | 228.5 | 228.65 | 5036.0 |
| 2024-08-28 07:00:00 | AAPL | Stock | 228.54 | 228.68 | 228.23 | 228.25 | 9844.0 |
| 2024-08-28 08:00:00 | AAPL | Stock | 228.6 | 228.6 | 227.84 | 228.28 | 62417.0 |
| 2024-08-28 09:00:00 | AAPL | Stock | 228.3 | 229.64 | 227.58 | 228.6 | 3939034.0 |
| 2024-08-28 10:00:00 | AAPL | Stock | 228.6 | 229.86 | 227.43 | 227.48 | 5046490.0 |
| 2024-08-28 11:00:00 | AAPL | Stock | 227.45 | 227.71 | 226.26 | 226.83 | 3320184.0 |
| 2024-08-28 12:00:00 | AAPL | Stock | 226.82 | 227.572 | 226.65 | 227.519 | 2151989.0 |
| 2024-08-28 13:00:00 | AAPL | Stock | 227.515 | 227.76 | 225.8079 | 225.895 | 1757943.0 |
| 2024-08-28 14:00:00 | AAPL | Stock | 225.895 | 227.2299 | 225.68 | 227.1639 | 1875526.0 |
| 2024-08-28 15:00:00 | AAPL | Stock | 227.16 | 227.64 | 226.25 | 226.51 | 4171593.0 |
| 2024-08-28 16:00:00 | AAPL | Stock | 226.49 | 226.49 | 225.59 | 225.7 | 5960016.0 |
| 2024-08-28 17:00:00 | AAPL | Stock | 225.8 | 226.5 | 225.75 | 226.25 | 94457.0 |
| 2024-08-28 18:00:00 | AAPL | Stock | 226.41 | 226.99 | 225.53 | 225.6396 | 76244.0 |
| 2024-08-28 19:00:00 | AAPL | Stock | 225.63 | 226.4 | 225.63 | 225.7 | 32824.0 |
| 2024-08-28 04:00:00 | MSFT | Stock | 413.93 | 414.74 | 413.93 | 414.74 | 3796.0 |
| 2024-08-28 05:00:00 | MSFT | Stock | 414.79 | 414.79 | 414.18 | 414.29 | 2292.0 |
| 2024-08-28 06:00:00 | MSFT | Stock | 414.32 | 414.32 | 414.17 | 414.29 | 875.0 |
| 2024-08-28 07:00:00 | MSFT | Stock | 414.21 | 414.21 | 413.48 | 413.48 | 4861.0 |
| 2024-08-28 08:00:00 | MSFT | Stock | 414.2119 | 414.3 | 412.83 | 413.97 | 10515.0 |
| 2024-08-28 09:00:00 | MSFT | Stock | 414.06 | 415.16 | 411.51 | 412.47 | 864514.0 |
| 2024-08-28 10:00:00 | MSFT | Stock | 412.575 | 412.72 | 409.6 | 409.72 | 920303.0 |
| 2024-08-28 11:00:00 | MSFT | Stock | 409.74 | 409.94 | 407.72 | 408.95 | 976842.0 |
| 2024-08-28 12:00:00 | MSFT | Stock | 408.95 | 410.44 | 408.39 | 410.25 | 512922.0 |
| 2024-08-28 13:00:00 | MSFT | Stock | 410.25 | 410.55 | 407.8 | 407.85 | 567190.0 |
| 2024-08-28 14:00:00 | MSFT | Stock | 407.855 | 409.98 | 407.31 | 409.91 | 719437.0 |
| 2024-08-28 15:00:00 | MSFT | Stock | 409.87 | 411.8 | 409.52 | 410.61 | 1547319.0 |
| 2024-08-28 16:00:00 | MSFT | Stock | 410.6 | 410.64 | 407.8 | 408.01 | 3094563.0 |
| 2024-08-28 17:00:00 | MSFT | Stock | 408.0 | 410.6 | 405.57 | 407.5132 | 68318.0 |
| 2024-08-28 18:00:00 | MSFT | Stock | 407.51 | 408.89 | 406.85 | 407.7886 | 23838.0 |
| 2024-08-28 19:00:00 | MSFT | Stock | 408.13 | 408.7 | 407.5361 | 408.56 | 6676.0 |
| 2024-08-28 04:00:00 | NVDA | Stock | 128.18 | 129.0 | 127.88 | 128.91 | 590233.0 |
| 2024-08-28 05:00:00 | NVDA | Stock | 128.93 | 129.14 | 128.7 | 128.98 | 308374.0 |
| 2024-08-28 06:00:00 | NVDA | Stock | 128.99 | 129.03 | 128.54 | 128.95 | 222982.0 |
| 2024-08-28 07:00:00 | NVDA | Stock | 128.91 | 129.0 | 128.29 | 128.35 | 798896.0 |
| 2024-08-28 08:00:00 | NVDA | Stock | 128.9 | 129.0 | 127.98 | 128.58 | 2004945.0 |
| 2024-08-28 09:00:00 | NVDA | Stock | 128.58 | 128.62 | 126.08 | 126.84 | 37937106.0 |
| 2024-08-28 10:00:00 | NVDA | Stock | 126.845 | 127.57 | 125.1 | 125.1 | 48228569.0 |
| 2024-08-28 11:00:00 | NVDA | Stock | 125.11 | 125.64 | 122.64 | 125.5372 | 67110526.0 |
| 2024-08-28 12:00:00 | NVDA | Stock | 125.51 | 126.03 | 124.68 | 125.8899 | 36723906.0 |
| 2024-08-28 13:00:00 | NVDA | Stock | 125.88 | 126.01 | 123.88 | 124.065 | 31318661.0 |
| 2024-08-28 14:00:00 | NVDA | Stock | 124.075 | 125.965 | 123.95 | 125.87 | 31420809.0 |
| 2024-08-28 15:00:00 | NVDA | Stock | 125.86 | 126.68 | 125.4 | 125.66 | 54717992.0 |
| 2024-08-28 16:00:00 | NVDA | Stock | 125.66 | 128.56 | 115.01 | 120.464 | 51100717.0 |
| 2024-08-28 17:00:00 | NVDA | Stock | 120.58 | 121.0 | 115.5 | 115.5 | 18563115.0 |
| 2024-08-28 18:00:00 | NVDA | Stock | 115.5 | 118.0 | 115.01 | 117.2 | 9154142.0 |
| 2024-08-28 19:00:00 | NVDA | Stock | 117.19 | 117.2 | 115.91 | 116.95 | 4542051.0 |
| 2024-08-28 04:00:00 | AMZN | Stock | 172.99 | 173.57 | 172.99 | 173.56 | 18853.0 |
| 2024-08-28 05:00:00 | AMZN | Stock | 173.57 | 173.57 | 173.28 | 173.3 | 3786.0 |
> showing 50 of 58,217 rows — these rows as CSV