PREVIEW / stock_1hour / 2024-03-07
file: by_date/stock_1hour/2024/2024-03-07.parquet size: 1.4 MB rows: 60,556 symbols: 1,108
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-07 04:00:00 | AAPL | Stock | 168.19 | 168.76 | 167.9 | 168.49 | 29752.0 |
| 2024-03-07 05:00:00 | AAPL | Stock | 168.65 | 169.1 | 168.65 | 169.03 | 53344.0 |
| 2024-03-07 06:00:00 | AAPL | Stock | 169.0 | 169.0 | 168.7 | 168.83 | 20033.0 |
| 2024-03-07 07:00:00 | AAPL | Stock | 168.83 | 169.92 | 168.75 | 169.79 | 128052.0 |
| 2024-03-07 08:00:00 | AAPL | Stock | 168.83 | 170.0 | 167.35 | 169.855 | 261165.0 |
| 2024-03-07 09:00:00 | AAPL | Stock | 169.9 | 169.99 | 168.49 | 169.7225 | 8624067.0 |
| 2024-03-07 10:00:00 | AAPL | Stock | 169.727 | 169.73 | 168.61 | 168.78 | 6648107.0 |
| 2024-03-07 11:00:00 | AAPL | Stock | 168.775 | 169.53 | 168.62 | 169.22 | 5915444.0 |
| 2024-03-07 12:00:00 | AAPL | Stock | 169.225 | 169.6 | 168.9917 | 169.115 | 5230269.0 |
| 2024-03-07 13:00:00 | AAPL | Stock | 169.11 | 170.6 | 168.99 | 170.56 | 7209352.0 |
| 2024-03-07 14:00:00 | AAPL | Stock | 170.57 | 170.73 | 169.77 | 170.2399 | 5909153.0 |
| 2024-03-07 15:00:00 | AAPL | Stock | 170.235 | 170.235 | 168.9 | 168.98 | 9223830.0 |
| 2024-03-07 16:00:00 | AAPL | Stock | 168.985 | 169.02 | 168.5 | 168.78 | 6459223.0 |
| 2024-03-07 17:00:00 | AAPL | Stock | 168.78 | 169.0 | 168.66 | 168.76 | 95563.0 |
| 2024-03-07 18:00:00 | AAPL | Stock | 168.75 | 169.0 | 168.5322 | 168.7 | 241854.0 |
| 2024-03-07 19:00:00 | AAPL | Stock | 168.73 | 168.96 | 168.67 | 168.96 | 63426.0 |
| 2024-03-07 04:00:00 | MSFT | Stock | 401.4 | 404.55 | 401.22 | 404.36 | 10860.0 |
| 2024-03-07 05:00:00 | MSFT | Stock | 404.37 | 405.69 | 404.36 | 405.69 | 9069.0 |
| 2024-03-07 06:00:00 | MSFT | Stock | 405.85 | 406.5 | 405.44 | 405.59 | 11056.0 |
| 2024-03-07 07:00:00 | MSFT | Stock | 405.59 | 405.68 | 404.3 | 404.9 | 23977.0 |
| 2024-03-07 08:00:00 | MSFT | Stock | 405.2 | 406.15 | 399.6 | 405.75 | 62748.0 |
| 2024-03-07 09:00:00 | MSFT | Stock | 405.78 | 406.76 | 402.24 | 404.3199 | 1995445.0 |
| 2024-03-07 10:00:00 | MSFT | Stock | 404.32 | 408.21 | 403.9 | 407.57 | 2114268.0 |
| 2024-03-07 11:00:00 | MSFT | Stock | 407.54 | 408.56 | 406.87 | 408.02 | 1044962.0 |
| 2024-03-07 12:00:00 | MSFT | Stock | 408.03 | 408.81 | 407.76 | 408.21 | 856378.0 |
| 2024-03-07 13:00:00 | MSFT | Stock | 408.22 | 409.78 | 407.68 | 409.22 | 807681.0 |
| 2024-03-07 14:00:00 | MSFT | Stock | 409.24 | 409.63 | 408.39 | 408.51 | 737629.0 |
| 2024-03-07 15:00:00 | MSFT | Stock | 408.5 | 409.5 | 407.66 | 409.0 | 1854685.0 |
| 2024-03-07 16:00:00 | MSFT | Stock | 409.01 | 409.14 | 406.86 | 408.36 | 3291908.0 |
| 2024-03-07 17:00:00 | MSFT | Stock | 407.9861 | 409.14 | 407.35 | 407.8 | 28738.0 |
| 2024-03-07 18:00:00 | MSFT | Stock | 407.63 | 409.14 | 407.0 | 407.86 | 199535.0 |
| 2024-03-07 19:00:00 | MSFT | Stock | 407.55 | 407.9 | 407.5 | 407.8999 | 3235.0 |
| 2024-03-07 04:00:00 | NVDA | Stock | 88.917 | 90.1 | 88.784 | 90.1 | 669200.0 |
| 2024-03-07 05:00:00 | NVDA | Stock | 90.122 | 90.349 | 89.9 | 90.32 | 383770.0 |
| 2024-03-07 06:00:00 | NVDA | Stock | 90.323 | 90.461 | 90.172 | 90.25 | 451300.0 |
| 2024-03-07 07:00:00 | NVDA | Stock | 90.3 | 90.37 | 90.061 | 90.172 | 1882470.0 |
| 2024-03-07 08:00:00 | NVDA | Stock | 90.1939 | 90.6 | 88.6 | 90.3363 | 4740260.0 |
| 2024-03-07 09:00:00 | NVDA | Stock | 90.326 | 90.999 | 89.602 | 90.4677 | 77744250.0 |
| 2024-03-07 10:00:00 | NVDA | Stock | 90.465 | 91.988 | 90.435 | 91.7135 | 81397130.0 |
| 2024-03-07 11:00:00 | NVDA | Stock | 91.729 | 92.275 | 91.55 | 91.806 | 50618650.0 |
| 2024-03-07 12:00:00 | NVDA | Stock | 91.8105 | 92.1 | 91.314 | 91.8886 | 37954780.0 |
| 2024-03-07 13:00:00 | NVDA | Stock | 91.88 | 91.98 | 91.735 | 91.9265 | 21404400.0 |
| 2024-03-07 14:00:00 | NVDA | Stock | 91.939 | 92.499 | 91.73 | 92.019 | 48207300.0 |
| 2024-03-07 15:00:00 | NVDA | Stock | 92.016 | 92.767 | 91.646 | 92.674 | 61674740.0 |
| 2024-03-07 16:00:00 | NVDA | Stock | 92.669 | 92.865 | 91.4 | 92.6 | 26717810.0 |
| 2024-03-07 17:00:00 | NVDA | Stock | 92.63 | 94.08 | 92.48 | 94.007 | 5477540.0 |
| 2024-03-07 18:00:00 | NVDA | Stock | 94.025 | 94.278 | 92.669 | 94.25 | 2922300.0 |
| 2024-03-07 19:00:00 | NVDA | Stock | 94.255 | 94.669 | 94.255 | 94.66 | 2554640.0 |
| 2024-03-07 04:00:00 | AMZN | Stock | 172.5 | 173.53 | 172.5 | 173.49 | 8740.0 |
| 2024-03-07 05:00:00 | AMZN | Stock | 173.48 | 174.3 | 173.48 | 174.17 | 4512.0 |
> showing 50 of 60,556 rows — these rows as CSV