PREVIEW / stock_1hour / 2024-01-24
file: by_date/stock_1hour/2024/2024-01-24.parquet size: 1.3 MB rows: 58,805 symbols: 1,167
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-01-24 04:00:00 | AAPL | Stock | 194.9 | 195.49 | 194.82 | 194.83 | 26985.0 |
| 2024-01-24 05:00:00 | AAPL | Stock | 194.85 | 194.9 | 194.73 | 194.8 | 4738.0 |
| 2024-01-24 06:00:00 | AAPL | Stock | 194.8 | 195.3 | 194.8 | 195.29 | 15246.0 |
| 2024-01-24 07:00:00 | AAPL | Stock | 195.0 | 195.55 | 195.0 | 195.41 | 48961.0 |
| 2024-01-24 08:00:00 | AAPL | Stock | 195.13 | 195.58 | 194.61 | 195.39 | 182461.0 |
| 2024-01-24 09:00:00 | AAPL | Stock | 195.42 | 196.38 | 194.91 | 195.08 | 5429816.0 |
| 2024-01-24 10:00:00 | AAPL | Stock | 195.08 | 196.34 | 194.66 | 195.91 | 6875831.0 |
| 2024-01-24 11:00:00 | AAPL | Stock | 195.91 | 195.99 | 195.27 | 195.86 | 4278300.0 |
| 2024-01-24 12:00:00 | AAPL | Stock | 195.86 | 196.08 | 195.51 | 195.745 | 3441634.0 |
| 2024-01-24 13:00:00 | AAPL | Stock | 195.74 | 195.74 | 195.14 | 195.2899 | 4226872.0 |
| 2024-01-24 14:00:00 | AAPL | Stock | 195.2818 | 195.39 | 194.69 | 194.91 | 3788237.0 |
| 2024-01-24 15:00:00 | AAPL | Stock | 194.91 | 195.13 | 194.34 | 194.51 | 6274048.0 |
| 2024-01-24 16:00:00 | AAPL | Stock | 194.5 | 194.54 | 193.91 | 194.26 | 7536139.0 |
| 2024-01-24 17:00:00 | AAPL | Stock | 194.18 | 194.2 | 194.03 | 194.07 | 22249.0 |
| 2024-01-24 18:00:00 | AAPL | Stock | 194.05 | 194.1 | 193.82 | 194.1 | 24120.0 |
| 2024-01-24 19:00:00 | AAPL | Stock | 194.1 | 194.15 | 193.9 | 193.91 | 20095.0 |
| 2024-01-24 04:00:00 | MSFT | Stock | 401.74 | 402.8 | 401.5 | 402.8 | 5946.0 |
| 2024-01-24 05:00:00 | MSFT | Stock | 402.55 | 402.55 | 402.22 | 402.5 | 3784.0 |
| 2024-01-24 06:00:00 | MSFT | Stock | 402.53 | 402.62 | 401.75 | 401.75 | 4224.0 |
| 2024-01-24 07:00:00 | MSFT | Stock | 401.99 | 402.32 | 401.5 | 401.82 | 23604.0 |
| 2024-01-24 08:00:00 | MSFT | Stock | 402.29 | 402.3 | 401.0 | 401.5 | 72738.0 |
| 2024-01-24 09:00:00 | MSFT | Stock | 401.5 | 402.7 | 400.45 | 402.67 | 2408038.0 |
| 2024-01-24 10:00:00 | MSFT | Stock | 402.67 | 404.72 | 402.12 | 403.4952 | 2365036.0 |
| 2024-01-24 11:00:00 | MSFT | Stock | 403.51 | 404.22 | 402.5 | 404.08 | 1622218.0 |
| 2024-01-24 12:00:00 | MSFT | Stock | 404.09 | 405.63 | 403.9447 | 405.332 | 1426809.0 |
| 2024-01-24 13:00:00 | MSFT | Stock | 405.32 | 405.52 | 403.935 | 404.288 | 1237326.0 |
| 2024-01-24 14:00:00 | MSFT | Stock | 404.2949 | 404.3997 | 402.5384 | 403.09 | 1050364.0 |
| 2024-01-24 15:00:00 | MSFT | Stock | 403.07 | 403.7786 | 402.0 | 402.57 | 2310911.0 |
| 2024-01-24 16:00:00 | MSFT | Stock | 402.57 | 402.79 | 402.01 | 402.7 | 3014013.0 |
| 2024-01-24 17:00:00 | MSFT | Stock | 402.82 | 403.1 | 402.7 | 402.7 | 22019.0 |
| 2024-01-24 18:00:00 | MSFT | Stock | 402.7 | 403.15 | 402.5 | 403.15 | 228109.0 |
| 2024-01-24 19:00:00 | MSFT | Stock | 403.2 | 403.71 | 403.13 | 403.71 | 5186.0 |
| 2024-01-24 04:00:00 | NVDA | Stock | 60.41 | 60.633 | 60.371 | 60.6 | 191350.0 |
| 2024-01-24 05:00:00 | NVDA | Stock | 60.601 | 60.615 | 60.416 | 60.55 | 64340.0 |
| 2024-01-24 06:00:00 | NVDA | Stock | 60.557 | 60.6 | 60.447 | 60.48 | 75920.0 |
| 2024-01-24 07:00:00 | NVDA | Stock | 60.475 | 60.543 | 60.38 | 60.42 | 598410.0 |
| 2024-01-24 08:00:00 | NVDA | Stock | 60.433 | 60.6 | 60.251 | 60.275 | 1951070.0 |
| 2024-01-24 09:00:00 | NVDA | Stock | 60.2836 | 61.305 | 59.938 | 61.279 | 56192460.0 |
| 2024-01-24 10:00:00 | NVDA | Stock | 61.2745 | 62.01 | 61.06 | 61.828 | 91500590.0 |
| 2024-01-24 11:00:00 | NVDA | Stock | 61.821 | 61.933 | 61.405 | 61.8865 | 38000000.0 |
| 2024-01-24 12:00:00 | NVDA | Stock | 61.891 | 62.8381 | 61.79 | 62.692 | 56688170.0 |
| 2024-01-24 13:00:00 | NVDA | Stock | 62.694 | 62.849 | 62.257 | 62.479 | 54426790.0 |
| 2024-01-24 14:00:00 | NVDA | Stock | 62.478 | 62.541 | 61.649 | 61.9365 | 55125170.0 |
| 2024-01-24 15:00:00 | NVDA | Stock | 61.933 | 62.025 | 61.171 | 61.357 | 58123480.0 |
| 2024-01-24 16:00:00 | NVDA | Stock | 61.371 | 61.658 | 61.14 | 61.6 | 15502950.0 |
| 2024-01-24 17:00:00 | NVDA | Stock | 61.6 | 61.6449 | 61.511 | 61.59 | 650320.0 |
| 2024-01-24 18:00:00 | NVDA | Stock | 61.5521 | 61.595 | 61.186 | 61.4 | 525210.0 |
| 2024-01-24 19:00:00 | NVDA | Stock | 61.41 | 61.62 | 61.403 | 61.617 | 385300.0 |
| 2024-01-24 04:00:00 | AMZN | Stock | 156.94 | 157.89 | 156.94 | 157.89 | 18568.0 |
| 2024-01-24 05:00:00 | AMZN | Stock | 157.89 | 157.99 | 157.79 | 157.79 | 13670.0 |
> showing 50 of 58,805 rows — these rows as CSV