PREVIEW / stock_1hour / 2024-08-27
file: by_date/stock_1hour/2024/2024-08-27.parquet size: 1.3 MB rows: 57,723 symbols: 845
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-27 04:00:00 | AAPL | Stock | 226.09 | 227.34 | 226.09 | 226.73 | 12329.0 |
| 2024-08-27 05:00:00 | AAPL | Stock | 226.66 | 227.19 | 226.64 | 226.83 | 7519.0 |
| 2024-08-27 06:00:00 | AAPL | Stock | 226.89 | 226.89 | 226.34 | 226.38 | 11162.0 |
| 2024-08-27 07:00:00 | AAPL | Stock | 226.44 | 226.7 | 225.5 | 226.0 | 30795.0 |
| 2024-08-27 08:00:00 | AAPL | Stock | 226.54 | 226.68 | 225.51 | 225.7 | 92497.0 |
| 2024-08-27 09:00:00 | AAPL | Stock | 225.7 | 226.84 | 224.89 | 226.745 | 3373542.0 |
| 2024-08-27 10:00:00 | AAPL | Stock | 226.745 | 228.32 | 226.745 | 228.3067 | 5209590.0 |
| 2024-08-27 11:00:00 | AAPL | Stock | 228.32 | 228.85 | 227.977 | 228.165 | 2827434.0 |
| 2024-08-27 12:00:00 | AAPL | Stock | 228.145 | 228.49 | 227.55 | 228.09 | 1961336.0 |
| 2024-08-27 13:00:00 | AAPL | Stock | 228.0804 | 228.664 | 227.83 | 228.525 | 1553778.0 |
| 2024-08-27 14:00:00 | AAPL | Stock | 228.53 | 228.585 | 228.26 | 228.43 | 1364627.0 |
| 2024-08-27 15:00:00 | AAPL | Stock | 228.43 | 228.445 | 227.75 | 228.14 | 3348720.0 |
| 2024-08-27 16:00:00 | AAPL | Stock | 228.02 | 228.2 | 227.91 | 228.05 | 7852006.0 |
| 2024-08-27 17:00:00 | AAPL | Stock | 228.09 | 228.09 | 227.81 | 227.85 | 23044.0 |
| 2024-08-27 18:00:00 | AAPL | Stock | 227.8503 | 227.98 | 227.45 | 227.73 | 17555.0 |
| 2024-08-27 19:00:00 | AAPL | Stock | 227.62 | 227.8 | 227.3 | 227.3 | 20492.0 |
| 2024-08-27 04:00:00 | MSFT | Stock | 414.15 | 414.9 | 414.15 | 414.5 | 6916.0 |
| 2024-08-27 05:00:00 | MSFT | Stock | 414.65 | 414.65 | 414.34 | 414.41 | 1265.0 |
| 2024-08-27 06:00:00 | MSFT | Stock | 414.32 | 414.32 | 413.27 | 413.27 | 609.0 |
| 2024-08-27 07:00:00 | MSFT | Stock | 412.8 | 413.95 | 412.8 | 413.85 | 4483.0 |
| 2024-08-27 08:00:00 | MSFT | Stock | 413.3 | 414.523 | 412.22 | 412.3481 | 22649.0 |
| 2024-08-27 09:00:00 | MSFT | Stock | 412.71 | 413.12 | 410.25 | 412.0 | 1234466.0 |
| 2024-08-27 10:00:00 | MSFT | Stock | 412.05 | 414.36 | 411.69 | 412.9 | 885859.0 |
| 2024-08-27 11:00:00 | MSFT | Stock | 412.9 | 413.48 | 410.47 | 411.09 | 763593.0 |
| 2024-08-27 12:00:00 | MSFT | Stock | 411.04 | 412.27 | 410.91 | 411.785 | 599679.0 |
| 2024-08-27 13:00:00 | MSFT | Stock | 411.82 | 413.5 | 411.58 | 413.375 | 482226.0 |
| 2024-08-27 14:00:00 | MSFT | Stock | 413.33 | 414.21 | 413.29 | 413.8 | 540287.0 |
| 2024-08-27 15:00:00 | MSFT | Stock | 413.8212 | 414.08 | 413.0 | 413.83 | 942603.0 |
| 2024-08-27 16:00:00 | MSFT | Stock | 413.83 | 413.93 | 413.01 | 413.84 | 3560660.0 |
| 2024-08-27 17:00:00 | MSFT | Stock | 413.84 | 413.84 | 413.56 | 413.84 | 6881.0 |
| 2024-08-27 18:00:00 | MSFT | Stock | 413.65 | 413.65 | 412.2 | 412.75 | 7094.0 |
| 2024-08-27 19:00:00 | MSFT | Stock | 412.84 | 413.53 | 412.23 | 412.26 | 4106.0 |
| 2024-08-27 04:00:00 | NVDA | Stock | 126.7 | 127.31 | 126.25 | 126.98 | 494186.0 |
| 2024-08-27 05:00:00 | NVDA | Stock | 126.98 | 127.17 | 126.9 | 127.12 | 106778.0 |
| 2024-08-27 06:00:00 | NVDA | Stock | 127.13 | 127.14 | 126.4 | 126.51 | 304155.0 |
| 2024-08-27 07:00:00 | NVDA | Stock | 126.56 | 126.86 | 126.11 | 126.36 | 600590.0 |
| 2024-08-27 08:00:00 | NVDA | Stock | 126.7 | 127.3383 | 124.72 | 125.04 | 3593805.0 |
| 2024-08-27 09:00:00 | NVDA | Stock | 125.04 | 127.6 | 123.88 | 126.8397 | 49750033.0 |
| 2024-08-27 10:00:00 | NVDA | Stock | 126.8219 | 128.49 | 126.03 | 128.47 | 52127314.0 |
| 2024-08-27 11:00:00 | NVDA | Stock | 128.4799 | 128.98 | 127.33 | 128.025 | 36772039.0 |
| 2024-08-27 12:00:00 | NVDA | Stock | 128.02 | 128.48 | 127.52 | 128.186 | 23149038.0 |
| 2024-08-27 13:00:00 | NVDA | Stock | 128.185 | 129.2 | 128.16 | 129.0 | 23493724.0 |
| 2024-08-27 14:00:00 | NVDA | Stock | 128.99 | 129.18 | 128.12 | 128.6092 | 25137979.0 |
| 2024-08-27 15:00:00 | NVDA | Stock | 128.61 | 128.75 | 128.2 | 128.34 | 28008372.0 |
| 2024-08-27 16:00:00 | NVDA | Stock | 128.34 | 128.41 | 128.11 | 128.29 | 17989039.0 |
| 2024-08-27 17:00:00 | NVDA | Stock | 128.29 | 128.32 | 128.04 | 128.21 | 520322.0 |
| 2024-08-27 18:00:00 | NVDA | Stock | 128.22 | 128.24 | 127.78 | 127.93 | 676914.0 |
| 2024-08-27 19:00:00 | NVDA | Stock | 127.95 | 128.09 | 127.67 | 127.71 | 684615.0 |
| 2024-08-27 04:00:00 | AMZN | Stock | 175.5 | 176.0 | 175.5 | 175.86 | 6067.0 |
| 2024-08-27 05:00:00 | AMZN | Stock | 175.94 | 176.08 | 175.94 | 176.05 | 4667.0 |
> showing 50 of 57,723 rows — these rows as CSV