PREVIEW / stock_1hour / 2024-09-10
file: by_date/stock_1hour/2024/2024-09-10.parquet size: 1.3 MB rows: 57,344 symbols: 860
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-09-10 04:00:00 | AAPL | Stock | 219.69 | 219.8 | 217.63 | 218.43 | 59021.0 |
| 2024-09-10 05:00:00 | AAPL | Stock | 218.22 | 218.37 | 217.75 | 218.25 | 27995.0 |
| 2024-09-10 06:00:00 | AAPL | Stock | 218.14 | 218.95 | 218.0 | 218.49 | 15528.0 |
| 2024-09-10 07:00:00 | AAPL | Stock | 218.5 | 218.95 | 217.98 | 218.74 | 87595.0 |
| 2024-09-10 08:00:00 | AAPL | Stock | 218.525 | 220.01 | 217.82 | 219.2 | 184350.0 |
| 2024-09-10 09:00:00 | AAPL | Stock | 219.2 | 220.02 | 216.73 | 217.515 | 6457139.0 |
| 2024-09-10 10:00:00 | AAPL | Stock | 217.5 | 219.975 | 217.46 | 219.1599 | 6877223.0 |
| 2024-09-10 11:00:00 | AAPL | Stock | 219.15 | 220.41 | 218.26 | 218.34 | 3922385.0 |
| 2024-09-10 12:00:00 | AAPL | Stock | 218.32 | 219.94 | 218.0404 | 219.5461 | 2985396.0 |
| 2024-09-10 13:00:00 | AAPL | Stock | 219.555 | 220.9401 | 219.5301 | 220.81 | 2757705.0 |
| 2024-09-10 14:00:00 | AAPL | Stock | 220.81 | 221.48 | 220.21 | 220.3756 | 3038591.0 |
| 2024-09-10 15:00:00 | AAPL | Stock | 220.37 | 221.13 | 219.68 | 220.17 | 5268822.0 |
| 2024-09-10 16:00:00 | AAPL | Stock | 220.15 | 220.2 | 219.56 | 219.9 | 8532887.0 |
| 2024-09-10 17:00:00 | AAPL | Stock | 219.84 | 219.98 | 219.65 | 219.98 | 12354.0 |
| 2024-09-10 18:00:00 | AAPL | Stock | 219.88 | 219.98 | 219.7537 | 219.96 | 12935.0 |
| 2024-09-10 19:00:00 | AAPL | Stock | 219.93 | 220.0 | 219.64 | 219.74 | 15854.0 |
| 2024-09-10 04:00:00 | MSFT | Stock | 407.2 | 407.2 | 406.58 | 406.59 | 2646.0 |
| 2024-09-10 05:00:00 | MSFT | Stock | 406.08 | 407.11 | 406.08 | 407.1 | 2056.0 |
| 2024-09-10 06:00:00 | MSFT | Stock | 407.25 | 407.9 | 406.98 | 407.9 | 8091.0 |
| 2024-09-10 07:00:00 | MSFT | Stock | 407.38 | 408.14 | 407.11 | 408.08 | 6338.0 |
| 2024-09-10 08:00:00 | MSFT | Stock | 407.78 | 409.1537 | 405.07 | 408.9 | 18653.0 |
| 2024-09-10 09:00:00 | MSFT | Stock | 408.75 | 415.35 | 407.3545 | 414.27 | 1882426.0 |
| 2024-09-10 10:00:00 | MSFT | Stock | 414.28 | 416.33 | 412.3 | 412.735 | 1726553.0 |
| 2024-09-10 11:00:00 | MSFT | Stock | 412.69 | 414.065 | 409.58 | 409.71 | 841660.0 |
| 2024-09-10 12:00:00 | MSFT | Stock | 409.68 | 411.34 | 408.8 | 410.62 | 697296.0 |
| 2024-09-10 13:00:00 | MSFT | Stock | 410.6 | 412.57 | 410.43 | 412.04 | 734652.0 |
| 2024-09-10 14:00:00 | MSFT | Stock | 412.045 | 412.82 | 411.835 | 412.28 | 816701.0 |
| 2024-09-10 15:00:00 | MSFT | Stock | 412.26 | 414.74 | 411.8503 | 414.23 | 2037589.0 |
| 2024-09-10 16:00:00 | MSFT | Stock | 414.2 | 415.35 | 413.37 | 414.65 | 4981849.0 |
| 2024-09-10 17:00:00 | MSFT | Stock | 414.61 | 414.85 | 414.2705 | 414.85 | 4933.0 |
| 2024-09-10 18:00:00 | MSFT | Stock | 414.77 | 415.0 | 414.2784 | 414.9982 | 12280.0 |
| 2024-09-10 19:00:00 | MSFT | Stock | 414.7 | 415.229 | 414.56 | 414.9 | 2984.0 |
| 2024-09-10 04:00:00 | NVDA | Stock | 106.87 | 106.87 | 106.05 | 106.14 | 326306.0 |
| 2024-09-10 05:00:00 | NVDA | Stock | 106.12 | 106.3 | 105.58 | 106.15 | 305916.0 |
| 2024-09-10 06:00:00 | NVDA | Stock | 106.19 | 106.49 | 105.95 | 106.35 | 156340.0 |
| 2024-09-10 07:00:00 | NVDA | Stock | 106.35 | 107.2 | 106.25 | 107.02 | 991856.0 |
| 2024-09-10 08:00:00 | NVDA | Stock | 106.39 | 107.95 | 105.7047 | 107.88 | 2921629.0 |
| 2024-09-10 09:00:00 | NVDA | Stock | 107.88 | 109.4 | 106.53 | 106.9919 | 46254718.0 |
| 2024-09-10 10:00:00 | NVDA | Stock | 106.99 | 107.8 | 105.96 | 106.8701 | 44534726.0 |
| 2024-09-10 11:00:00 | NVDA | Stock | 106.87 | 107.44 | 105.25 | 105.28 | 29628565.0 |
| 2024-09-10 12:00:00 | NVDA | Stock | 105.285 | 106.25 | 104.95 | 105.8109 | 26865860.0 |
| 2024-09-10 13:00:00 | NVDA | Stock | 105.8101 | 106.72 | 105.76 | 106.545 | 19489763.0 |
| 2024-09-10 14:00:00 | NVDA | Stock | 106.55 | 107.58 | 106.55 | 107.134 | 20399639.0 |
| 2024-09-10 15:00:00 | NVDA | Stock | 107.13 | 108.18 | 107.03 | 108.02 | 26924743.0 |
| 2024-09-10 16:00:00 | NVDA | Stock | 108.02 | 108.14 | 106.894 | 107.81 | 13647699.0 |
| 2024-09-10 17:00:00 | NVDA | Stock | 107.8 | 107.9 | 107.67 | 107.9 | 322155.0 |
| 2024-09-10 18:00:00 | NVDA | Stock | 107.87 | 107.87 | 107.7 | 107.7799 | 222937.0 |
| 2024-09-10 19:00:00 | NVDA | Stock | 107.75 | 107.81 | 107.5 | 107.6 | 363647.0 |
| 2024-09-10 04:00:00 | AMZN | Stock | 175.74 | 176.0 | 175.5 | 175.76 | 6606.0 |
| 2024-09-10 05:00:00 | AMZN | Stock | 175.34 | 175.69 | 175.0 | 175.69 | 6644.0 |
> showing 50 of 57,344 rows — these rows as CSV