PREVIEW / stock_1hour / 2024-10-25
file: by_date/stock_1hour/2024/2024-10-25.parquet size: 1.4 MB rows: 59,555 symbols: 738
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-10-25 04:00:00 | AAPL | Stock | 229.13 | 229.13 | 227.3 | 228.05 | 94346.0 |
| 2024-10-25 05:00:00 | AAPL | Stock | 228.18 | 228.94 | 228.18 | 228.61 | 21787.0 |
| 2024-10-25 06:00:00 | AAPL | Stock | 228.64 | 228.84 | 228.35 | 228.45 | 16030.0 |
| 2024-10-25 07:00:00 | AAPL | Stock | 228.4 | 228.88 | 228.01 | 228.68 | 64845.0 |
| 2024-10-25 08:00:00 | AAPL | Stock | 228.25 | 229.85 | 228.1 | 229.76 | 217418.0 |
| 2024-10-25 09:00:00 | AAPL | Stock | 229.74 | 232.09 | 229.33 | 231.9 | 4062491.0 |
| 2024-10-25 10:00:00 | AAPL | Stock | 231.96 | 232.91 | 231.7202 | 232.8446 | 3277663.0 |
| 2024-10-25 11:00:00 | AAPL | Stock | 232.86 | 233.22 | 231.76 | 232.05 | 2690421.0 |
| 2024-10-25 12:00:00 | AAPL | Stock | 232.03 | 232.95 | 231.9429 | 232.775 | 1763794.0 |
| 2024-10-25 13:00:00 | AAPL | Stock | 232.775 | 232.775 | 231.13 | 231.48 | 2024782.0 |
| 2024-10-25 14:00:00 | AAPL | Stock | 231.49 | 232.2 | 231.07 | 232.14 | 1774547.0 |
| 2024-10-25 15:00:00 | AAPL | Stock | 232.12 | 232.16 | 231.11 | 231.41 | 3836163.0 |
| 2024-10-25 16:00:00 | AAPL | Stock | 231.13 | 232.0 | 231.13 | 231.31 | 9078957.0 |
| 2024-10-25 17:00:00 | AAPL | Stock | 231.31 | 231.6 | 231.23 | 231.49 | 69443.0 |
| 2024-10-25 18:00:00 | AAPL | Stock | 231.57 | 231.57 | 231.22 | 231.25 | 5014.0 |
| 2024-10-25 19:00:00 | AAPL | Stock | 231.3 | 231.39 | 230.8 | 230.86 | 11531.0 |
| 2024-10-25 04:00:00 | MSFT | Stock | 425.25 | 426.5 | 425.25 | 426.5 | 4112.0 |
| 2024-10-25 05:00:00 | MSFT | Stock | 426.99 | 427.2 | 426.86 | 427.08 | 5134.0 |
| 2024-10-25 06:00:00 | MSFT | Stock | 426.9 | 427.0 | 426.9 | 426.9 | 976.0 |
| 2024-10-25 07:00:00 | MSFT | Stock | 426.82 | 426.9 | 426.11 | 426.5 | 6827.0 |
| 2024-10-25 08:00:00 | MSFT | Stock | 426.66 | 426.98 | 424.94 | 426.98 | 25844.0 |
| 2024-10-25 09:00:00 | MSFT | Stock | 426.98 | 432.52 | 426.19 | 431.47 | 1989933.0 |
| 2024-10-25 10:00:00 | MSFT | Stock | 431.5 | 432.1999 | 430.13 | 430.8218 | 1275170.0 |
| 2024-10-25 11:00:00 | MSFT | Stock | 430.92 | 431.81 | 429.4772 | 429.94 | 915599.0 |
| 2024-10-25 12:00:00 | MSFT | Stock | 429.84 | 430.785 | 429.55 | 430.41 | 507215.0 |
| 2024-10-25 13:00:00 | MSFT | Stock | 430.39 | 430.51 | 426.97 | 427.91 | 648490.0 |
| 2024-10-25 14:00:00 | MSFT | Stock | 428.0599 | 429.305 | 427.18 | 429.045 | 493955.0 |
| 2024-10-25 15:00:00 | MSFT | Stock | 429.02 | 429.02 | 427.42 | 428.32 | 1061212.0 |
| 2024-10-25 16:00:00 | MSFT | Stock | 428.15 | 428.49 | 428.0 | 428.21 | 2473919.0 |
| 2024-10-25 17:00:00 | MSFT | Stock | 428.0453 | 428.44 | 428.0001 | 428.44 | 88705.0 |
| 2024-10-25 18:00:00 | MSFT | Stock | 428.28 | 428.3001 | 428.0 | 428.05 | 1234.0 |
| 2024-10-25 19:00:00 | MSFT | Stock | 428.25 | 428.43 | 427.3301 | 427.5 | 3158.0 |
| 2024-10-25 04:00:00 | NVDA | Stock | 140.95 | 141.04 | 140.4 | 140.72 | 238634.0 |
| 2024-10-25 05:00:00 | NVDA | Stock | 140.75 | 140.92 | 140.55 | 140.67 | 94137.0 |
| 2024-10-25 06:00:00 | NVDA | Stock | 140.68 | 141.05 | 140.64 | 140.85 | 130631.0 |
| 2024-10-25 07:00:00 | NVDA | Stock | 140.82 | 141.08 | 140.63 | 141.01 | 463322.0 |
| 2024-10-25 08:00:00 | NVDA | Stock | 140.78 | 141.2499 | 140.0 | 141.09 | 1452072.0 |
| 2024-10-25 09:00:00 | NVDA | Stock | 141.1 | 143.27 | 140.8 | 142.7261 | 31190781.0 |
| 2024-10-25 10:00:00 | NVDA | Stock | 142.74 | 143.78 | 142.45 | 143.4196 | 31816302.0 |
| 2024-10-25 11:00:00 | NVDA | Stock | 143.41 | 144.13 | 143.307 | 143.72 | 23531749.0 |
| 2024-10-25 12:00:00 | NVDA | Stock | 143.715 | 143.79 | 143.185 | 143.299 | 13091643.0 |
| 2024-10-25 13:00:00 | NVDA | Stock | 143.3 | 143.5 | 141.43 | 141.705 | 24262926.0 |
| 2024-10-25 14:00:00 | NVDA | Stock | 141.71 | 142.2999 | 140.942 | 142.004 | 21681176.0 |
| 2024-10-25 15:00:00 | NVDA | Stock | 142.01 | 142.19 | 141.38 | 141.47 | 17679740.0 |
| 2024-10-25 16:00:00 | NVDA | Stock | 141.47 | 142.664 | 141.1 | 141.44 | 10862741.0 |
| 2024-10-25 17:00:00 | NVDA | Stock | 141.44 | 141.75 | 141.39 | 141.59 | 647350.0 |
| 2024-10-25 18:00:00 | NVDA | Stock | 141.6 | 141.64 | 141.49 | 141.54 | 165588.0 |
| 2024-10-25 19:00:00 | NVDA | Stock | 141.51 | 141.53 | 140.77 | 141.06 | 670612.0 |
| 2024-10-25 04:00:00 | AMZN | Stock | 186.71 | 187.3 | 186.71 | 187.3 | 12859.0 |
| 2024-10-25 05:00:00 | AMZN | Stock | 187.39 | 187.96 | 187.37 | 187.69 | 11046.0 |
> showing 50 of 59,555 rows — these rows as CSV