PREVIEW / stock_1hour / 2024-07-12
file: by_date/stock_1hour/2024/2024-07-12.parquet size: 1.3 MB rows: 59,775 symbols: 900
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-07-12 04:00:00 | AAPL | Stock | 228.0 | 228.5 | 227.29 | 228.37 | 18046.0 |
| 2024-07-12 05:00:00 | AAPL | Stock | 228.47 | 228.69 | 228.09 | 228.44 | 11384.0 |
| 2024-07-12 06:00:00 | AAPL | Stock | 228.47 | 228.47 | 228.17 | 228.3 | 9315.0 |
| 2024-07-12 07:00:00 | AAPL | Stock | 228.3 | 228.76 | 227.88 | 228.58 | 37851.0 |
| 2024-07-12 08:00:00 | AAPL | Stock | 228.31 | 228.77 | 227.44 | 228.2 | 173382.0 |
| 2024-07-12 09:00:00 | AAPL | Stock | 228.27 | 231.39 | 227.8379 | 231.35 | 6759255.0 |
| 2024-07-12 10:00:00 | AAPL | Stock | 231.36 | 232.15 | 230.3 | 231.85 | 7133796.0 |
| 2024-07-12 11:00:00 | AAPL | Stock | 231.84 | 232.398 | 230.84 | 230.9001 | 5275544.0 |
| 2024-07-12 12:00:00 | AAPL | Stock | 230.9 | 231.4601 | 230.51 | 231.445 | 2992587.0 |
| 2024-07-12 13:00:00 | AAPL | Stock | 231.45 | 232.64 | 231.335 | 232.295 | 3727917.0 |
| 2024-07-12 14:00:00 | AAPL | Stock | 232.28 | 232.4809 | 231.87 | 232.22 | 2576109.0 |
| 2024-07-12 15:00:00 | AAPL | Stock | 232.215 | 232.25 | 229.91 | 230.56 | 6400053.0 |
| 2024-07-12 16:00:00 | AAPL | Stock | 230.63 | 230.63 | 229.51 | 230.18 | 6635569.0 |
| 2024-07-12 17:00:00 | AAPL | Stock | 230.18 | 230.54 | 230.17 | 230.28 | 162500.0 |
| 2024-07-12 18:00:00 | AAPL | Stock | 230.27 | 230.29 | 230.19 | 230.23 | 8753.0 |
| 2024-07-12 19:00:00 | AAPL | Stock | 230.23 | 230.5 | 230.2 | 230.427 | 19341.0 |
| 2024-07-12 04:00:00 | MSFT | Stock | 454.47 | 455.94 | 454.47 | 455.94 | 1689.0 |
| 2024-07-12 05:00:00 | MSFT | Stock | 455.59 | 455.84 | 455.0 | 455.33 | 1963.0 |
| 2024-07-12 06:00:00 | MSFT | Stock | 455.53 | 455.66 | 454.73 | 454.8 | 3134.0 |
| 2024-07-12 07:00:00 | MSFT | Stock | 454.35 | 455.26 | 454.12 | 455.14 | 5379.0 |
| 2024-07-12 08:00:00 | MSFT | Stock | 454.92 | 456.2166 | 452.52 | 454.84 | 33990.0 |
| 2024-07-12 09:00:00 | MSFT | Stock | 455.41 | 455.87 | 450.645 | 453.35 | 1515541.0 |
| 2024-07-12 10:00:00 | MSFT | Stock | 453.37 | 454.865 | 452.41 | 454.1 | 1182827.0 |
| 2024-07-12 11:00:00 | MSFT | Stock | 454.08 | 454.96 | 453.57 | 453.66 | 829844.0 |
| 2024-07-12 12:00:00 | MSFT | Stock | 453.6 | 454.16 | 452.75 | 453.7 | 638582.0 |
| 2024-07-12 13:00:00 | MSFT | Stock | 453.68 | 456.36 | 453.6 | 455.73 | 679354.0 |
| 2024-07-12 14:00:00 | MSFT | Stock | 455.73 | 455.9042 | 454.94 | 455.835 | 568550.0 |
| 2024-07-12 15:00:00 | MSFT | Stock | 455.775 | 456.31 | 452.1 | 453.76 | 1479880.0 |
| 2024-07-12 16:00:00 | MSFT | Stock | 453.55 | 453.705 | 452.17 | 452.52 | 3604944.0 |
| 2024-07-12 17:00:00 | MSFT | Stock | 452.52 | 453.55 | 452.39 | 452.7708 | 73098.0 |
| 2024-07-12 18:00:00 | MSFT | Stock | 452.88 | 452.98 | 452.5 | 452.75 | 4181.0 |
| 2024-07-12 19:00:00 | MSFT | Stock | 452.91 | 453.1 | 452.61 | 452.9301 | 3443.0 |
| 2024-07-12 04:00:00 | NVDA | Stock | 126.68 | 128.44 | 126.25 | 128.28 | 594072.0 |
| 2024-07-12 05:00:00 | NVDA | Stock | 128.26 | 128.88 | 128.02 | 128.22 | 488173.0 |
| 2024-07-12 06:00:00 | NVDA | Stock | 128.29 | 128.67 | 127.36 | 127.62 | 339062.0 |
| 2024-07-12 07:00:00 | NVDA | Stock | 127.62 | 128.19 | 126.74 | 128.08 | 1173304.0 |
| 2024-07-12 08:00:00 | NVDA | Stock | 127.31 | 128.7648 | 125.02 | 127.39 | 3816484.0 |
| 2024-07-12 09:00:00 | NVDA | Stock | 127.37 | 130.05 | 126.9 | 129.915 | 37825025.0 |
| 2024-07-12 10:00:00 | NVDA | Stock | 129.93 | 131.05 | 128.51 | 130.83 | 40849940.0 |
| 2024-07-12 11:00:00 | NVDA | Stock | 130.82 | 131.03 | 129.71 | 129.8 | 22801240.0 |
| 2024-07-12 12:00:00 | NVDA | Stock | 129.78 | 130.55 | 129.34 | 130.43 | 18957194.0 |
| 2024-07-12 13:00:00 | NVDA | Stock | 130.43 | 131.34 | 130.25 | 131.07 | 18342184.0 |
| 2024-07-12 14:00:00 | NVDA | Stock | 131.07 | 131.92 | 130.83 | 131.88 | 18631598.0 |
| 2024-07-12 15:00:00 | NVDA | Stock | 131.87 | 131.8799 | 128.84 | 129.17 | 40734573.0 |
| 2024-07-12 16:00:00 | NVDA | Stock | 129.17 | 129.8911 | 128.68 | 129.81 | 16417690.0 |
| 2024-07-12 17:00:00 | NVDA | Stock | 129.82 | 130.0695 | 129.24 | 129.77 | 1069664.0 |
| 2024-07-12 18:00:00 | NVDA | Stock | 129.77 | 129.85 | 129.6801 | 129.8 | 204967.0 |
| 2024-07-12 19:00:00 | NVDA | Stock | 129.81 | 129.99 | 129.64 | 129.89 | 367700.0 |
| 2024-07-12 04:00:00 | AMZN | Stock | 195.0 | 195.3 | 195.0 | 195.3 | 10318.0 |
| 2024-07-12 05:00:00 | AMZN | Stock | 195.31 | 195.63 | 195.31 | 195.56 | 9495.0 |
> showing 50 of 59,775 rows — these rows as CSV