PREVIEW / stock_1hour / 2025-05-01
file: by_date/stock_1hour/2025/2025-05-01.parquet size: 1.4 MB rows: 61,566 symbols: 418
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-01 04:00:00 | AAPL | Stock | 209.58 | 209.86 | 209.05 | 209.72 | 41190.0 |
| 2025-05-01 05:00:00 | AAPL | Stock | 209.72 | 210.3 | 209.66 | 210.3 | 36715.0 |
| 2025-05-01 06:00:00 | AAPL | Stock | 210.21 | 210.35 | 209.67 | 209.99 | 28565.0 |
| 2025-05-01 07:00:00 | AAPL | Stock | 210.04 | 210.29 | 209.01 | 209.31 | 131804.0 |
| 2025-05-01 08:00:00 | AAPL | Stock | 209.31 | 212.5 | 209.0 | 209.13 | 425516.0 |
| 2025-05-01 09:00:00 | AAPL | Stock | 209.11 | 212.5 | 208.8 | 210.68 | 5368932.0 |
| 2025-05-01 10:00:00 | AAPL | Stock | 210.8 | 213.09 | 209.71 | 212.89 | 4796391.0 |
| 2025-05-01 11:00:00 | AAPL | Stock | 212.89 | 214.27 | 211.415 | 211.5844 | 3563930.0 |
| 2025-05-01 12:00:00 | AAPL | Stock | 211.6 | 212.85 | 211.53 | 212.135 | 2303726.0 |
| 2025-05-01 13:00:00 | AAPL | Stock | 212.12 | 212.8776 | 212.06 | 212.595 | 1856828.0 |
| 2025-05-01 14:00:00 | AAPL | Stock | 212.59 | 213.2 | 212.52 | 212.545 | 2154327.0 |
| 2025-05-01 15:00:00 | AAPL | Stock | 212.55 | 214.56 | 212.3 | 212.83 | 7050837.0 |
| 2025-05-01 16:00:00 | AAPL | Stock | 212.8 | 214.0 | 207.0 | 207.7001 | 9758017.0 |
| 2025-05-01 17:00:00 | AAPL | Stock | 207.7992 | 211.0 | 204.5807 | 205.21 | 2059524.0 |
| 2025-05-01 18:00:00 | AAPL | Stock | 205.25 | 205.25 | 203.84 | 204.55 | 484884.0 |
| 2025-05-01 19:00:00 | AAPL | Stock | 204.5 | 205.416 | 204.4 | 205.25 | 370526.0 |
| 2025-05-01 04:00:00 | MSFT | Stock | 423.3 | 428.68 | 421.0 | 427.62 | 126604.0 |
| 2025-05-01 05:00:00 | MSFT | Stock | 427.83 | 429.22 | 426.7 | 428.6 | 52970.0 |
| 2025-05-01 06:00:00 | MSFT | Stock | 428.69 | 432.1 | 428.69 | 431.24 | 123664.0 |
| 2025-05-01 07:00:00 | MSFT | Stock | 431.0 | 432.5 | 429.77 | 431.3 | 237725.0 |
| 2025-05-01 08:00:00 | MSFT | Stock | 431.2 | 432.2801 | 422.5 | 431.0 | 504059.0 |
| 2025-05-01 09:00:00 | MSFT | Stock | 431.0 | 436.99 | 427.1 | 430.5932 | 12296303.0 |
| 2025-05-01 10:00:00 | MSFT | Stock | 430.66 | 432.64 | 428.54 | 432.07 | 6547134.0 |
| 2025-05-01 11:00:00 | MSFT | Stock | 432.08 | 433.58 | 428.165 | 429.1 | 3618571.0 |
| 2025-05-01 12:00:00 | MSFT | Stock | 429.12 | 430.775 | 427.67 | 427.8101 | 2468473.0 |
| 2025-05-01 13:00:00 | MSFT | Stock | 427.83 | 430.0 | 427.64 | 429.68 | 2085795.0 |
| 2025-05-01 14:00:00 | MSFT | Stock | 429.65 | 431.9 | 429.33 | 430.6659 | 2057384.0 |
| 2025-05-01 15:00:00 | MSFT | Stock | 430.71 | 430.985 | 424.9 | 425.13 | 4546924.0 |
| 2025-05-01 16:00:00 | MSFT | Stock | 425.14 | 426.88 | 424.1124 | 424.66 | 5444101.0 |
| 2025-05-01 17:00:00 | MSFT | Stock | 425.33 | 426.4776 | 424.51 | 424.71 | 20794.0 |
| 2025-05-01 18:00:00 | MSFT | Stock | 424.9 | 426.979 | 424.9 | 426.745 | 22202.0 |
| 2025-05-01 19:00:00 | MSFT | Stock | 426.6 | 427.8719 | 426.4275 | 426.9391 | 15098.0 |
| 2025-05-01 04:00:00 | NVDA | Stock | 112.85 | 113.36 | 112.56 | 113.1 | 518505.0 |
| 2025-05-01 05:00:00 | NVDA | Stock | 113.1 | 113.71 | 113.02 | 113.55 | 461938.0 |
| 2025-05-01 06:00:00 | NVDA | Stock | 113.54 | 113.93 | 113.35 | 113.72 | 538026.0 |
| 2025-05-01 07:00:00 | NVDA | Stock | 113.72 | 114.47 | 113.57 | 114.22 | 1411590.0 |
| 2025-05-01 08:00:00 | NVDA | Stock | 113.7 | 114.4576 | 112.52 | 113.64 | 3368053.0 |
| 2025-05-01 09:00:00 | NVDA | Stock | 113.65 | 114.15 | 108.92 | 112.79 | 37999966.0 |
| 2025-05-01 10:00:00 | NVDA | Stock | 112.8 | 113.68 | 112.36 | 113.525 | 26098998.0 |
| 2025-05-01 11:00:00 | NVDA | Stock | 113.53 | 114.94 | 113.05 | 113.26 | 37113990.0 |
| 2025-05-01 12:00:00 | NVDA | Stock | 113.26 | 113.9 | 112.86 | 113.125 | 18548518.0 |
| 2025-05-01 13:00:00 | NVDA | Stock | 113.13 | 113.87 | 112.88 | 113.32 | 13439539.0 |
| 2025-05-01 14:00:00 | NVDA | Stock | 113.32 | 113.92 | 113.23 | 113.26 | 12539267.0 |
| 2025-05-01 15:00:00 | NVDA | Stock | 113.26 | 113.29 | 111.3 | 111.53 | 27106741.0 |
| 2025-05-01 16:00:00 | NVDA | Stock | 111.53 | 111.89 | 110.72 | 111.8 | 20147212.0 |
| 2025-05-01 17:00:00 | NVDA | Stock | 111.8 | 111.97 | 111.01 | 111.03 | 827194.0 |
| 2025-05-01 18:00:00 | NVDA | Stock | 111.03 | 111.3 | 110.51 | 111.0587 | 637786.0 |
| 2025-05-01 19:00:00 | NVDA | Stock | 111.0886 | 111.55 | 111.03 | 111.0999 | 339985.0 |
| 2025-05-01 04:00:00 | AMZN | Stock | 191.2 | 192.18 | 190.75 | 191.89 | 41423.0 |
| 2025-05-01 05:00:00 | AMZN | Stock | 191.84 | 192.0 | 191.01 | 191.65 | 65360.0 |
> showing 50 of 61,566 rows — these rows as CSV