PREVIEW / stock_1hour / 2024-04-25
file: by_date/stock_1hour/2024/2024-04-25.parquet size: 1.3 MB rows: 57,653 symbols: 986
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-25 04:00:00 | AAPL | Stock | 168.83 | 169.14 | 168.62 | 168.85 | 19707.0 |
| 2024-04-25 05:00:00 | AAPL | Stock | 168.82 | 169.15 | 168.82 | 169.13 | 3338.0 |
| 2024-04-25 06:00:00 | AAPL | Stock | 169.0 | 169.09 | 168.81 | 168.81 | 3657.0 |
| 2024-04-25 07:00:00 | AAPL | Stock | 168.74 | 169.31 | 168.63 | 169.15 | 23339.0 |
| 2024-04-25 08:00:00 | AAPL | Stock | 168.7966 | 169.96 | 168.14 | 168.34 | 174538.0 |
| 2024-04-25 09:00:00 | AAPL | Stock | 168.35 | 170.61 | 167.89 | 169.01 | 7109297.0 |
| 2024-04-25 10:00:00 | AAPL | Stock | 169.02 | 169.49 | 168.47 | 168.575 | 5366532.0 |
| 2024-04-25 11:00:00 | AAPL | Stock | 168.57 | 168.87 | 168.1511 | 168.55 | 3551096.0 |
| 2024-04-25 12:00:00 | AAPL | Stock | 168.54 | 169.5383 | 168.5 | 169.3599 | 3281436.0 |
| 2024-04-25 13:00:00 | AAPL | Stock | 169.36 | 169.61 | 168.86 | 169.5501 | 3022056.0 |
| 2024-04-25 14:00:00 | AAPL | Stock | 169.56 | 169.7499 | 168.9601 | 169.565 | 3317186.0 |
| 2024-04-25 15:00:00 | AAPL | Stock | 169.56 | 170.04 | 169.41 | 169.9 | 8119391.0 |
| 2024-04-25 16:00:00 | AAPL | Stock | 169.89 | 170.84 | 169.75 | 170.04 | 6764048.0 |
| 2024-04-25 17:00:00 | AAPL | Stock | 170.01 | 170.46 | 170.0 | 170.14 | 74304.0 |
| 2024-04-25 18:00:00 | AAPL | Stock | 170.14 | 170.29 | 169.89 | 170.0114 | 82735.0 |
| 2024-04-25 19:00:00 | AAPL | Stock | 170.01 | 170.14 | 169.65 | 169.74 | 68611.0 |
| 2024-04-25 04:00:00 | MSFT | Stock | 402.45 | 402.45 | 401.55 | 402.0 | 7083.0 |
| 2024-04-25 05:00:00 | MSFT | Stock | 401.96 | 402.99 | 401.96 | 402.47 | 10397.0 |
| 2024-04-25 06:00:00 | MSFT | Stock | 402.49 | 402.49 | 401.0 | 401.0 | 8203.0 |
| 2024-04-25 07:00:00 | MSFT | Stock | 401.55 | 401.55 | 400.0 | 401.0 | 25916.0 |
| 2024-04-25 08:00:00 | MSFT | Stock | 401.0 | 402.77 | 397.5 | 398.21 | 130440.0 |
| 2024-04-25 09:00:00 | MSFT | Stock | 398.35 | 398.4 | 388.03 | 391.43 | 5901635.0 |
| 2024-04-25 10:00:00 | MSFT | Stock | 391.57 | 394.54 | 390.4 | 390.59 | 3696157.0 |
| 2024-04-25 11:00:00 | MSFT | Stock | 390.57 | 393.17 | 390.56 | 393.1296 | 2638751.0 |
| 2024-04-25 12:00:00 | MSFT | Stock | 393.07 | 395.69 | 392.64 | 395.23 | 1665037.0 |
| 2024-04-25 13:00:00 | MSFT | Stock | 395.25 | 398.2 | 394.94 | 397.82 | 1995294.0 |
| 2024-04-25 14:00:00 | MSFT | Stock | 397.83 | 399.69 | 396.0101 | 396.56 | 1836257.0 |
| 2024-04-25 15:00:00 | MSFT | Stock | 396.56 | 399.8899 | 396.49 | 399.51 | 3477319.0 |
| 2024-04-25 16:00:00 | MSFT | Stock | 399.04 | 424.0 | 398.33 | 417.3363 | 4931979.0 |
| 2024-04-25 17:00:00 | MSFT | Stock | 417.5 | 422.0 | 410.29 | 421.825 | 693529.0 |
| 2024-04-25 18:00:00 | MSFT | Stock | 421.06 | 422.0 | 399.04 | 417.0 | 703933.0 |
| 2024-04-25 19:00:00 | MSFT | Stock | 417.0 | 417.5 | 415.65 | 416.25 | 77599.0 |
| 2024-04-25 04:00:00 | NVDA | Stock | 78.8 | 80.189 | 78.7 | 79.579 | 281450.0 |
| 2024-04-25 05:00:00 | NVDA | Stock | 79.7 | 80.452 | 79.62 | 80.2 | 230170.0 |
| 2024-04-25 06:00:00 | NVDA | Stock | 80.21 | 80.425 | 79.99 | 80.1 | 238900.0 |
| 2024-04-25 07:00:00 | NVDA | Stock | 80.064 | 80.347 | 79.738 | 80.2 | 862980.0 |
| 2024-04-25 08:00:00 | NVDA | Stock | 79.943 | 80.3448 | 78.3 | 78.5 | 5003950.0 |
| 2024-04-25 09:00:00 | NVDA | Stock | 78.51 | 81.433 | 77.68 | 80.988 | 60907450.0 |
| 2024-04-25 10:00:00 | NVDA | Stock | 81.0394 | 82.415 | 80.524 | 81.627 | 57852330.0 |
| 2024-04-25 11:00:00 | NVDA | Stock | 81.65 | 82.102 | 81.011 | 81.62 | 28631450.0 |
| 2024-04-25 12:00:00 | NVDA | Stock | 81.593 | 82.409 | 81.424 | 82.266 | 26000570.0 |
| 2024-04-25 13:00:00 | NVDA | Stock | 82.264 | 83.2 | 82.16 | 82.8434 | 32484900.0 |
| 2024-04-25 14:00:00 | NVDA | Stock | 82.853 | 83.12 | 82.32 | 82.874 | 28477900.0 |
| 2024-04-25 15:00:00 | NVDA | Stock | 82.866 | 83.323 | 82.386 | 82.601 | 32997300.0 |
| 2024-04-25 16:00:00 | NVDA | Stock | 82.632 | 84.7 | 82.632 | 84.281 | 23020840.0 |
| 2024-04-25 17:00:00 | NVDA | Stock | 84.308 | 84.42 | 81.5177 | 84.2008 | 1380720.0 |
| 2024-04-25 18:00:00 | NVDA | Stock | 84.264 | 84.8 | 84.22 | 84.6 | 1582840.0 |
| 2024-04-25 19:00:00 | NVDA | Stock | 84.612 | 84.64 | 84.43 | 84.6 | 845380.0 |
| 2024-04-25 04:00:00 | AMZN | Stock | 172.39 | 172.8 | 171.87 | 172.59 | 27538.0 |
| 2024-04-25 05:00:00 | AMZN | Stock | 172.43 | 173.3 | 172.42 | 173.2 | 17320.0 |
> showing 50 of 57,653 rows — these rows as CSV