PREVIEW / stock_1hour / 2024-04-29
file: by_date/stock_1hour/2024/2024-04-29.parquet size: 1.3 MB rows: 58,273 symbols: 984
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-04-29 04:00:00 | AAPL | Stock | 170.49 | 172.22 | 170.49 | 172.13 | 70339.0 |
| 2024-04-29 05:00:00 | AAPL | Stock | 172.0 | 172.32 | 171.87 | 172.2 | 49083.0 |
| 2024-04-29 06:00:00 | AAPL | Stock | 172.2 | 173.0 | 172.18 | 172.7 | 69358.0 |
| 2024-04-29 07:00:00 | AAPL | Stock | 172.7 | 173.68 | 172.16 | 173.65 | 184602.0 |
| 2024-04-29 08:00:00 | AAPL | Stock | 173.65 | 173.75 | 170.25 | 173.47 | 354932.0 |
| 2024-04-29 09:00:00 | AAPL | Stock | 173.55 | 176.03 | 172.79 | 175.19 | 12652883.0 |
| 2024-04-29 10:00:00 | AAPL | Stock | 175.2 | 175.99 | 174.38 | 174.8625 | 7847510.0 |
| 2024-04-29 11:00:00 | AAPL | Stock | 174.87 | 175.13 | 173.98 | 174.6701 | 6032047.0 |
| 2024-04-29 12:00:00 | AAPL | Stock | 174.68 | 174.825 | 174.22 | 174.55 | 3492973.0 |
| 2024-04-29 13:00:00 | AAPL | Stock | 174.555 | 175.105 | 174.39 | 174.81 | 3633762.0 |
| 2024-04-29 14:00:00 | AAPL | Stock | 174.805 | 174.8064 | 173.945 | 174.62 | 3662899.0 |
| 2024-04-29 15:00:00 | AAPL | Stock | 174.62 | 174.62 | 173.1 | 173.53 | 7242498.0 |
| 2024-04-29 16:00:00 | AAPL | Stock | 173.5 | 173.75 | 173.49 | 173.5 | 7628531.0 |
| 2024-04-29 17:00:00 | AAPL | Stock | 173.67 | 173.7 | 173.5 | 173.6 | 32177.0 |
| 2024-04-29 18:00:00 | AAPL | Stock | 173.64 | 173.64 | 173.52 | 173.6 | 20817.0 |
| 2024-04-29 19:00:00 | AAPL | Stock | 173.57 | 173.77 | 173.52 | 173.52 | 19977.0 |
| 2024-04-29 04:00:00 | MSFT | Stock | 408.5 | 410.0 | 407.5 | 407.8 | 10548.0 |
| 2024-04-29 05:00:00 | MSFT | Stock | 407.48 | 407.87 | 407.3 | 407.3 | 7156.0 |
| 2024-04-29 06:00:00 | MSFT | Stock | 407.18 | 407.6 | 407.18 | 407.6 | 1342.0 |
| 2024-04-29 07:00:00 | MSFT | Stock | 407.09 | 407.2 | 405.54 | 405.61 | 24457.0 |
| 2024-04-29 08:00:00 | MSFT | Stock | 406.35 | 409.35 | 405.01 | 405.75 | 64931.0 |
| 2024-04-29 09:00:00 | MSFT | Stock | 405.75 | 406.32 | 399.19 | 401.3425 | 3031571.0 |
| 2024-04-29 10:00:00 | MSFT | Stock | 401.285 | 402.63 | 400.25 | 401.9278 | 2083925.0 |
| 2024-04-29 11:00:00 | MSFT | Stock | 401.9 | 402.1 | 400.1035 | 400.9 | 1238197.0 |
| 2024-04-29 12:00:00 | MSFT | Stock | 400.92 | 401.6796 | 400.6 | 401.41 | 772566.0 |
| 2024-04-29 13:00:00 | MSFT | Stock | 401.39 | 402.16 | 400.63 | 402.035 | 671302.0 |
| 2024-04-29 14:00:00 | MSFT | Stock | 402.025 | 402.07 | 400.27 | 400.995 | 710038.0 |
| 2024-04-29 15:00:00 | MSFT | Stock | 400.97 | 402.28 | 399.2 | 402.21 | 1926065.0 |
| 2024-04-29 16:00:00 | MSFT | Stock | 402.25 | 402.48 | 400.5 | 401.92 | 2651301.0 |
| 2024-04-29 17:00:00 | MSFT | Stock | 401.8712 | 402.0 | 401.7703 | 401.8639 | 2769.0 |
| 2024-04-29 18:00:00 | MSFT | Stock | 401.86 | 402.25 | 401.75 | 402.0 | 3179.0 |
| 2024-04-29 19:00:00 | MSFT | Stock | 402.01 | 402.17 | 401.9 | 402.05 | 4139.0 |
| 2024-04-29 04:00:00 | NVDA | Stock | 88.5 | 88.588 | 88.052 | 88.2 | 342770.0 |
| 2024-04-29 05:00:00 | NVDA | Stock | 88.2 | 88.3 | 87.345 | 87.362 | 337810.0 |
| 2024-04-29 06:00:00 | NVDA | Stock | 87.452 | 87.589 | 87.02 | 87.42 | 474700.0 |
| 2024-04-29 07:00:00 | NVDA | Stock | 87.347 | 88.1 | 87.33 | 87.88 | 1361890.0 |
| 2024-04-29 08:00:00 | NVDA | Stock | 87.447 | 88.7 | 87.3502 | 87.655 | 2807590.0 |
| 2024-04-29 09:00:00 | NVDA | Stock | 87.655 | 87.798 | 85.266 | 86.68 | 63730190.0 |
| 2024-04-29 10:00:00 | NVDA | Stock | 86.665 | 87.654 | 86.388 | 86.6895 | 63411190.0 |
| 2024-04-29 11:00:00 | NVDA | Stock | 86.685 | 87.298 | 86.45 | 86.652 | 28996960.0 |
| 2024-04-29 12:00:00 | NVDA | Stock | 86.6694 | 87.335 | 86.59 | 87.065 | 20658370.0 |
| 2024-04-29 13:00:00 | NVDA | Stock | 87.0801 | 87.992 | 86.88 | 87.4747 | 28210800.0 |
| 2024-04-29 14:00:00 | NVDA | Stock | 87.451 | 87.777 | 87.15 | 87.47 | 20517430.0 |
| 2024-04-29 15:00:00 | NVDA | Stock | 87.464 | 87.958 | 86.525 | 87.747 | 38630870.0 |
| 2024-04-29 16:00:00 | NVDA | Stock | 87.833 | 88.238 | 87.683 | 87.878 | 17581570.0 |
| 2024-04-29 17:00:00 | NVDA | Stock | 87.8142 | 87.896 | 87.515 | 87.865 | 349990.0 |
| 2024-04-29 18:00:00 | NVDA | Stock | 87.8796 | 87.927 | 87.75 | 87.9121 | 186490.0 |
| 2024-04-29 19:00:00 | NVDA | Stock | 87.92 | 88.0 | 87.875 | 87.956 | 374670.0 |
| 2024-04-29 04:00:00 | AMZN | Stock | 180.21 | 181.3 | 180.13 | 181.14 | 42619.0 |
| 2024-04-29 05:00:00 | AMZN | Stock | 181.14 | 181.5 | 180.79 | 181.5 | 26575.0 |
> showing 50 of 58,273 rows — these rows as CSV