PREVIEW / stock_1hour / 2024-11-04
file: by_date/stock_1hour/2024/2024-11-04.parquet size: 1.4 MB rows: 60,038 symbols: 728
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-11-04 04:00:00 | AAPL | Stock | 221.51 | 221.82 | 221.3 | 221.71 | 27096.0 |
| 2024-11-04 05:00:00 | AAPL | Stock | 221.7 | 222.05 | 221.64 | 222.01 | 13847.0 |
| 2024-11-04 06:00:00 | AAPL | Stock | 221.96 | 221.96 | 221.03 | 221.42 | 29965.0 |
| 2024-11-04 07:00:00 | AAPL | Stock | 221.45 | 222.0 | 221.2 | 221.51 | 66182.0 |
| 2024-11-04 08:00:00 | AAPL | Stock | 221.7714 | 222.3 | 221.1514 | 221.36 | 137005.0 |
| 2024-11-04 09:00:00 | AAPL | Stock | 221.33 | 222.41 | 219.71 | 222.065 | 5247489.0 |
| 2024-11-04 10:00:00 | AAPL | Stock | 222.06 | 222.54 | 221.35 | 221.61 | 3146715.0 |
| 2024-11-04 11:00:00 | AAPL | Stock | 221.62 | 222.01 | 220.81 | 221.08 | 2209446.0 |
| 2024-11-04 12:00:00 | AAPL | Stock | 221.071 | 222.15 | 220.41 | 221.79 | 2118814.0 |
| 2024-11-04 13:00:00 | AAPL | Stock | 221.77 | 222.62 | 221.46 | 222.4 | 1807108.0 |
| 2024-11-04 14:00:00 | AAPL | Stock | 222.43 | 222.76 | 222.2 | 222.625 | 1507998.0 |
| 2024-11-04 15:00:00 | AAPL | Stock | 222.625 | 222.79 | 221.52 | 222.12 | 3960670.0 |
| 2024-11-04 16:00:00 | AAPL | Stock | 222.06 | 222.2998 | 221.8018 | 221.98 | 8246087.0 |
| 2024-11-04 17:00:00 | AAPL | Stock | 221.91 | 222.01 | 221.6036 | 221.6132 | 1445568.0 |
| 2024-11-04 18:00:00 | AAPL | Stock | 221.68 | 222.0 | 221.61 | 221.7 | 25897.0 |
| 2024-11-04 19:00:00 | AAPL | Stock | 221.63 | 221.7696 | 221.5 | 221.53 | 11976.0 |
| 2024-11-04 04:00:00 | MSFT | Stock | 411.91 | 411.91 | 410.15 | 411.24 | 11090.0 |
| 2024-11-04 05:00:00 | MSFT | Stock | 411.37 | 411.95 | 411.37 | 411.95 | 1186.0 |
| 2024-11-04 06:00:00 | MSFT | Stock | 411.74 | 411.74 | 411.0 | 411.0 | 4057.0 |
| 2024-11-04 07:00:00 | MSFT | Stock | 411.03 | 411.03 | 409.27 | 410.01 | 20037.0 |
| 2024-11-04 08:00:00 | MSFT | Stock | 410.4 | 412.0 | 409.3 | 410.0 | 51919.0 |
| 2024-11-04 09:00:00 | MSFT | Stock | 409.85 | 410.22 | 405.5713 | 409.1 | 1905404.0 |
| 2024-11-04 10:00:00 | MSFT | Stock | 409.075 | 410.415 | 408.55 | 409.67 | 1045714.0 |
| 2024-11-04 11:00:00 | MSFT | Stock | 409.705 | 409.86 | 406.11 | 406.61 | 1125807.0 |
| 2024-11-04 12:00:00 | MSFT | Stock | 406.65 | 407.48 | 405.87 | 407.17 | 780231.0 |
| 2024-11-04 13:00:00 | MSFT | Stock | 407.11 | 408.23 | 406.55 | 407.7552 | 698754.0 |
| 2024-11-04 14:00:00 | MSFT | Stock | 407.76 | 408.4 | 407.76 | 408.12 | 594648.0 |
| 2024-11-04 15:00:00 | MSFT | Stock | 408.11 | 408.85 | 406.93 | 408.66 | 1627683.0 |
| 2024-11-04 16:00:00 | MSFT | Stock | 408.46 | 409.3 | 408.4 | 409.25 | 5415785.0 |
| 2024-11-04 17:00:00 | MSFT | Stock | 409.241 | 409.25 | 408.46 | 409.041 | 304473.0 |
| 2024-11-04 18:00:00 | MSFT | Stock | 409.25 | 409.4 | 408.65 | 408.65 | 12404.0 |
| 2024-11-04 19:00:00 | MSFT | Stock | 408.75 | 408.9074 | 408.59 | 408.65 | 4644.0 |
| 2024-11-04 04:00:00 | NVDA | Stock | 139.3 | 139.88 | 138.27 | 138.43 | 815737.0 |
| 2024-11-04 05:00:00 | NVDA | Stock | 138.41 | 138.77 | 138.41 | 138.51 | 189927.0 |
| 2024-11-04 06:00:00 | NVDA | Stock | 138.51 | 138.53 | 138.0 | 138.33 | 250203.0 |
| 2024-11-04 07:00:00 | NVDA | Stock | 138.33 | 138.75 | 137.37 | 137.83 | 1148603.0 |
| 2024-11-04 08:00:00 | NVDA | Stock | 138.5 | 139.99 | 137.31 | 137.898 | 2585726.0 |
| 2024-11-04 09:00:00 | NVDA | Stock | 137.88 | 138.0 | 135.57 | 137.36 | 32520521.0 |
| 2024-11-04 10:00:00 | NVDA | Stock | 137.36 | 137.93 | 136.53 | 137.72 | 25905277.0 |
| 2024-11-04 11:00:00 | NVDA | Stock | 137.724 | 138.96 | 137.555 | 137.8127 | 23571617.0 |
| 2024-11-04 12:00:00 | NVDA | Stock | 137.8382 | 138.08 | 137.03 | 137.7762 | 16789294.0 |
| 2024-11-04 13:00:00 | NVDA | Stock | 137.77 | 138.29 | 137.32 | 138.13 | 12332304.0 |
| 2024-11-04 14:00:00 | NVDA | Stock | 138.13 | 138.3899 | 137.72 | 137.78 | 10083703.0 |
| 2024-11-04 15:00:00 | NVDA | Stock | 137.785 | 137.86 | 136.0 | 136.08 | 22137025.0 |
| 2024-11-04 16:00:00 | NVDA | Stock | 136.14 | 137.4851 | 135.9 | 136.15 | 14606578.0 |
| 2024-11-04 17:00:00 | NVDA | Stock | 136.15 | 136.2 | 135.77 | 136.0 | 502853.0 |
| 2024-11-04 18:00:00 | NVDA | Stock | 136.1 | 136.2 | 135.85 | 136.01 | 304374.0 |
| 2024-11-04 19:00:00 | NVDA | Stock | 136.01 | 136.04 | 135.35 | 135.41 | 456947.0 |
| 2024-11-04 04:00:00 | AMZN | Stock | 197.29 | 197.49 | 195.99 | 196.38 | 65526.0 |
| 2024-11-04 05:00:00 | AMZN | Stock | 196.33 | 196.75 | 196.3 | 196.7 | 23323.0 |
> showing 50 of 60,038 rows — these rows as CSV