PREVIEW / stock_1hour / 2024-03-11
file: by_date/stock_1hour/2024/2024-03-11.parquet size: 1.4 MB rows: 60,415 symbols: 1,097
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-03-11 04:00:00 | AAPL | Stock | 171.0 | 171.67 | 170.76 | 170.96 | 26783.0 |
| 2024-03-11 05:00:00 | AAPL | Stock | 171.01 | 171.5 | 171.0 | 171.25 | 50978.0 |
| 2024-03-11 06:00:00 | AAPL | Stock | 171.29 | 171.4 | 170.94 | 171.27 | 9643.0 |
| 2024-03-11 07:00:00 | AAPL | Stock | 171.19 | 171.75 | 171.0 | 171.5 | 67884.0 |
| 2024-03-11 08:00:00 | AAPL | Stock | 171.01 | 172.0 | 170.91 | 171.8976 | 256728.0 |
| 2024-03-11 09:00:00 | AAPL | Stock | 171.9 | 174.38 | 171.6311 | 173.8 | 8963543.0 |
| 2024-03-11 10:00:00 | AAPL | Stock | 173.81 | 173.99 | 172.29 | 172.48 | 8010822.0 |
| 2024-03-11 11:00:00 | AAPL | Stock | 172.47 | 173.3296 | 172.295 | 173.06 | 5037616.0 |
| 2024-03-11 12:00:00 | AAPL | Stock | 173.06 | 173.15 | 172.55 | 172.61 | 3440808.0 |
| 2024-03-11 13:00:00 | AAPL | Stock | 172.606 | 173.42 | 172.05 | 172.62 | 4963235.0 |
| 2024-03-11 14:00:00 | AAPL | Stock | 172.62 | 172.9 | 172.3649 | 172.87 | 2948207.0 |
| 2024-03-11 15:00:00 | AAPL | Stock | 172.87 | 173.0699 | 172.435 | 172.79 | 6636342.0 |
| 2024-03-11 16:00:00 | AAPL | Stock | 172.75 | 173.08 | 172.68 | 172.94 | 6873638.0 |
| 2024-03-11 17:00:00 | AAPL | Stock | 172.94 | 173.08 | 172.75 | 173.01 | 60031.0 |
| 2024-03-11 18:00:00 | AAPL | Stock | 173.02 | 173.45 | 172.97 | 173.23 | 38387.0 |
| 2024-03-11 19:00:00 | AAPL | Stock | 173.23 | 173.35 | 173.2 | 173.29 | 18503.0 |
| 2024-03-11 04:00:00 | MSFT | Stock | 405.01 | 405.44 | 403.97 | 403.97 | 1795.0 |
| 2024-03-11 05:00:00 | MSFT | Stock | 404.37 | 404.73 | 402.52 | 403.2 | 5470.0 |
| 2024-03-11 06:00:00 | MSFT | Stock | 403.42 | 404.02 | 403.24 | 403.97 | 5482.0 |
| 2024-03-11 07:00:00 | MSFT | Stock | 404.16 | 405.22 | 404.0 | 404.2 | 9092.0 |
| 2024-03-11 08:00:00 | MSFT | Stock | 405.04 | 406.94 | 403.2 | 403.7 | 38854.0 |
| 2024-03-11 09:00:00 | MSFT | Stock | 403.98 | 404.5 | 401.75 | 401.95 | 1595662.0 |
| 2024-03-11 10:00:00 | MSFT | Stock | 401.965 | 404.59 | 401.26 | 403.82 | 1539433.0 |
| 2024-03-11 11:00:00 | MSFT | Stock | 403.77 | 404.115 | 402.09 | 403.88 | 1073454.0 |
| 2024-03-11 12:00:00 | MSFT | Stock | 403.885 | 404.29 | 402.77 | 404.07 | 817583.0 |
| 2024-03-11 13:00:00 | MSFT | Stock | 404.07 | 405.0 | 403.34 | 404.485 | 867624.0 |
| 2024-03-11 14:00:00 | MSFT | Stock | 404.485 | 405.68 | 404.18 | 405.1907 | 757769.0 |
| 2024-03-11 15:00:00 | MSFT | Stock | 405.19 | 405.39 | 404.09 | 404.58 | 1592765.0 |
| 2024-03-11 16:00:00 | MSFT | Stock | 404.52 | 405.22 | 403.86 | 404.88 | 2211192.0 |
| 2024-03-11 17:00:00 | MSFT | Stock | 404.83 | 405.83 | 404.52 | 405.7 | 15982.0 |
| 2024-03-11 18:00:00 | MSFT | Stock | 405.79 | 406.5465 | 405.69 | 406.1 | 15872.0 |
| 2024-03-11 19:00:00 | MSFT | Stock | 405.95 | 406.25 | 405.5 | 406.06 | 4378.0 |
| 2024-03-11 04:00:00 | NVDA | Stock | 85.8 | 88.6 | 85.101 | 88.6 | 1606070.0 |
| 2024-03-11 05:00:00 | NVDA | Stock | 88.6 | 89.701 | 88.276 | 89.37 | 1698180.0 |
| 2024-03-11 06:00:00 | NVDA | Stock | 89.497 | 89.65 | 88.41 | 88.801 | 696270.0 |
| 2024-03-11 07:00:00 | NVDA | Stock | 88.8 | 88.916 | 86.175 | 86.3 | 3469480.0 |
| 2024-03-11 08:00:00 | NVDA | Stock | 88.8205 | 89.372 | 85.016 | 86.566 | 7789410.0 |
| 2024-03-11 09:00:00 | NVDA | Stock | 86.551 | 87.9 | 84.166 | 85.551 | 89663020.0 |
| 2024-03-11 10:00:00 | NVDA | Stock | 85.553 | 88.797 | 85.138 | 88.294 | 92334890.0 |
| 2024-03-11 11:00:00 | NVDA | Stock | 88.263 | 88.495 | 86.502 | 87.4391 | 57094250.0 |
| 2024-03-11 12:00:00 | NVDA | Stock | 87.425 | 87.5 | 86.548 | 87.2194 | 36158920.0 |
| 2024-03-11 13:00:00 | NVDA | Stock | 87.207 | 87.285 | 85.705 | 86.238 | 40468230.0 |
| 2024-03-11 14:00:00 | NVDA | Stock | 86.2502 | 86.887 | 85.876 | 86.4195 | 34260140.0 |
| 2024-03-11 15:00:00 | NVDA | Stock | 86.4 | 86.4 | 85.18 | 85.792 | 53474820.0 |
| 2024-03-11 16:00:00 | NVDA | Stock | 85.799 | 86.6044 | 85.547 | 85.825 | 32313600.0 |
| 2024-03-11 17:00:00 | NVDA | Stock | 85.825 | 85.899 | 85.6 | 85.712 | 588130.0 |
| 2024-03-11 18:00:00 | NVDA | Stock | 85.734 | 86.78 | 85.734 | 86.65 | 1824650.0 |
| 2024-03-11 19:00:00 | NVDA | Stock | 86.676 | 87.004 | 86.504 | 86.98 | 1665230.0 |
| 2024-03-11 04:00:00 | AMZN | Stock | 174.97 | 175.0 | 174.28 | 174.63 | 14600.0 |
| 2024-03-11 05:00:00 | AMZN | Stock | 174.77 | 174.9 | 174.39 | 174.57 | 10385.0 |
> showing 50 of 60,415 rows — these rows as CSV