PREVIEW / stock_1hour / 2024-02-06
file: by_date/stock_1hour/2024/2024-02-06.parquet size: 1.3 MB rows: 58,631 symbols: 1,151
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-02-06 04:00:00 | AAPL | Stock | 188.4 | 188.4 | 187.8 | 187.88 | 11810.0 |
| 2024-02-06 05:00:00 | AAPL | Stock | 187.86 | 187.92 | 187.67 | 187.89 | 8406.0 |
| 2024-02-06 06:00:00 | AAPL | Stock | 187.95 | 188.28 | 187.6 | 187.66 | 11832.0 |
| 2024-02-06 07:00:00 | AAPL | Stock | 187.8 | 187.83 | 187.33 | 187.55 | 25821.0 |
| 2024-02-06 08:00:00 | AAPL | Stock | 187.8 | 188.24 | 187.2703 | 187.69 | 73354.0 |
| 2024-02-06 09:00:00 | AAPL | Stock | 187.69 | 188.63 | 186.52 | 187.9571 | 4448653.0 |
| 2024-02-06 10:00:00 | AAPL | Stock | 187.96 | 188.31 | 187.27 | 187.725 | 5682795.0 |
| 2024-02-06 11:00:00 | AAPL | Stock | 187.71 | 189.02 | 187.7 | 188.815 | 4723041.0 |
| 2024-02-06 12:00:00 | AAPL | Stock | 188.82 | 189.14 | 188.43 | 188.53 | 3179917.0 |
| 2024-02-06 13:00:00 | AAPL | Stock | 188.54 | 189.0 | 188.512 | 188.775 | 3005779.0 |
| 2024-02-06 14:00:00 | AAPL | Stock | 188.775 | 188.8154 | 188.23 | 188.5701 | 2528395.0 |
| 2024-02-06 15:00:00 | AAPL | Stock | 188.58 | 189.31 | 188.17 | 189.29 | 5503158.0 |
| 2024-02-06 16:00:00 | AAPL | Stock | 189.17 | 189.32 | 189.08 | 189.18 | 5062248.0 |
| 2024-02-06 17:00:00 | AAPL | Stock | 189.18 | 189.39 | 189.16 | 189.26 | 49817.0 |
| 2024-02-06 18:00:00 | AAPL | Stock | 189.28 | 189.87 | 189.28 | 189.69 | 59780.0 |
| 2024-02-06 19:00:00 | AAPL | Stock | 189.68 | 190.0 | 189.26 | 190.0 | 95560.0 |
| 2024-02-06 04:00:00 | MSFT | Stock | 407.55 | 407.55 | 407.21 | 407.21 | 1759.0 |
| 2024-02-06 05:00:00 | MSFT | Stock | 407.21 | 407.22 | 406.56 | 406.95 | 3446.0 |
| 2024-02-06 06:00:00 | MSFT | Stock | 406.79 | 406.85 | 405.01 | 405.01 | 11841.0 |
| 2024-02-06 07:00:00 | MSFT | Stock | 405.2 | 405.46 | 404.7 | 404.83 | 12372.0 |
| 2024-02-06 08:00:00 | MSFT | Stock | 405.2 | 407.64 | 404.61 | 406.1 | 41125.0 |
| 2024-02-06 09:00:00 | MSFT | Stock | 406.19 | 407.97 | 405.03 | 405.03 | 2093717.0 |
| 2024-02-06 10:00:00 | MSFT | Stock | 405.01 | 405.37 | 403.56 | 404.72 | 1955933.0 |
| 2024-02-06 11:00:00 | MSFT | Stock | 404.71 | 405.16 | 403.22 | 403.93 | 1422937.0 |
| 2024-02-06 12:00:00 | MSFT | Stock | 403.97 | 404.48 | 403.5514 | 403.6201 | 1270943.0 |
| 2024-02-06 13:00:00 | MSFT | Stock | 403.596 | 404.81 | 403.56 | 404.7875 | 940691.0 |
| 2024-02-06 14:00:00 | MSFT | Stock | 404.785 | 404.81 | 402.91 | 403.81 | 1038139.0 |
| 2024-02-06 15:00:00 | MSFT | Stock | 403.84 | 405.61 | 403.32 | 405.47 | 1828387.0 |
| 2024-02-06 16:00:00 | MSFT | Stock | 405.53 | 405.98 | 405.05 | 405.2 | 2757287.0 |
| 2024-02-06 17:00:00 | MSFT | Stock | 405.15 | 405.4 | 404.9 | 404.99 | 16271.0 |
| 2024-02-06 18:00:00 | MSFT | Stock | 404.99 | 405.37 | 404.3725 | 404.51 | 10262.0 |
| 2024-02-06 19:00:00 | MSFT | Stock | 404.51 | 405.0 | 404.37 | 404.5501 | 4422.0 |
| 2024-02-06 04:00:00 | NVDA | Stock | 70.716 | 70.926 | 70.1 | 70.43 | 736190.0 |
| 2024-02-06 05:00:00 | NVDA | Stock | 70.43 | 70.578 | 70.121 | 70.163 | 363320.0 |
| 2024-02-06 06:00:00 | NVDA | Stock | 70.2 | 70.3 | 68.404 | 69.332 | 1264650.0 |
| 2024-02-06 07:00:00 | NVDA | Stock | 69.3 | 69.906 | 69.3 | 69.75 | 3060250.0 |
| 2024-02-06 08:00:00 | NVDA | Stock | 69.589 | 71.217 | 69.4 | 70.0666 | 6937080.0 |
| 2024-02-06 09:00:00 | NVDA | Stock | 70.051 | 70.118 | 68.1 | 68.308 | 80846160.0 |
| 2024-02-06 10:00:00 | NVDA | Stock | 68.294 | 68.389 | 67.385 | 67.878 | 81783340.0 |
| 2024-02-06 11:00:00 | NVDA | Stock | 67.8745 | 68.033 | 67.11 | 67.258 | 58312500.0 |
| 2024-02-06 12:00:00 | NVDA | Stock | 67.259 | 67.29 | 66.3 | 66.565 | 80557480.0 |
| 2024-02-06 13:00:00 | NVDA | Stock | 66.558 | 67.619 | 66.512 | 67.608 | 46378470.0 |
| 2024-02-06 14:00:00 | NVDA | Stock | 67.6012 | 68.06 | 67.07 | 67.9915 | 61461660.0 |
| 2024-02-06 15:00:00 | NVDA | Stock | 67.989 | 68.47 | 67.81 | 68.219 | 71755550.0 |
| 2024-02-06 16:00:00 | NVDA | Stock | 68.223 | 68.231 | 67.7 | 67.8 | 11549860.0 |
| 2024-02-06 17:00:00 | NVDA | Stock | 67.8 | 67.909 | 67.255 | 67.5533 | 1398170.0 |
| 2024-02-06 18:00:00 | NVDA | Stock | 67.55 | 67.749 | 67.42 | 67.452 | 980360.0 |
| 2024-02-06 19:00:00 | NVDA | Stock | 67.452 | 67.5 | 67.266 | 67.35 | 831150.0 |
| 2024-02-06 04:00:00 | AMZN | Stock | 169.95 | 169.95 | 169.49 | 169.53 | 12897.0 |
| 2024-02-06 05:00:00 | AMZN | Stock | 169.45 | 169.52 | 169.22 | 169.34 | 8966.0 |
> showing 50 of 58,631 rows — these rows as CSV