PREVIEW / stock_1hour / 2024-05-01
file: by_date/stock_1hour/2024/2024-05-01.parquet size: 1.3 MB rows: 57,728 symbols: 970
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-05-01 04:00:00 | AAPL | Stock | 170.5 | 170.5 | 169.51 | 169.79 | 13089.0 |
| 2024-05-01 05:00:00 | AAPL | Stock | 169.73 | 169.73 | 169.34 | 169.59 | 7025.0 |
| 2024-05-01 06:00:00 | AAPL | Stock | 169.5 | 170.3 | 169.5 | 170.1 | 14742.0 |
| 2024-05-01 07:00:00 | AAPL | Stock | 170.2 | 170.2 | 169.82 | 169.99 | 18629.0 |
| 2024-05-01 08:00:00 | AAPL | Stock | 170.15 | 170.6 | 169.5 | 169.9702 | 192673.0 |
| 2024-05-01 09:00:00 | AAPL | Stock | 169.96 | 170.6387 | 169.11 | 170.3299 | 3731253.0 |
| 2024-05-01 10:00:00 | AAPL | Stock | 170.32 | 171.35 | 170.17 | 171.105 | 4148626.0 |
| 2024-05-01 11:00:00 | AAPL | Stock | 171.1 | 171.6 | 170.645 | 171.52 | 3385465.0 |
| 2024-05-01 12:00:00 | AAPL | Stock | 171.52 | 171.72 | 171.06 | 171.06 | 2640380.0 |
| 2024-05-01 13:00:00 | AAPL | Stock | 171.055 | 171.249 | 170.61 | 171.23 | 2367558.0 |
| 2024-05-01 14:00:00 | AAPL | Stock | 171.24 | 172.635 | 170.83 | 172.48 | 5304063.0 |
| 2024-05-01 15:00:00 | AAPL | Stock | 172.49 | 172.705 | 169.25 | 169.31 | 9420222.0 |
| 2024-05-01 16:00:00 | AAPL | Stock | 169.3 | 170.34 | 169.1 | 170.06 | 7376472.0 |
| 2024-05-01 17:00:00 | AAPL | Stock | 170.03 | 170.39 | 169.3 | 170.35 | 70144.0 |
| 2024-05-01 18:00:00 | AAPL | Stock | 170.3 | 170.45 | 169.3 | 170.15 | 53035.0 |
| 2024-05-01 19:00:00 | AAPL | Stock | 170.29 | 170.49 | 170.08 | 170.35 | 39165.0 |
| 2024-05-01 04:00:00 | MSFT | Stock | 391.11 | 391.11 | 390.2 | 390.85 | 1155.0 |
| 2024-05-01 05:00:00 | MSFT | Stock | 390.88 | 390.88 | 390.0 | 390.35 | 3623.0 |
| 2024-05-01 06:00:00 | MSFT | Stock | 390.2 | 390.84 | 389.57 | 390.84 | 8139.0 |
| 2024-05-01 07:00:00 | MSFT | Stock | 390.9 | 391.25 | 390.39 | 390.4 | 13026.0 |
| 2024-05-01 08:00:00 | MSFT | Stock | 391.0 | 393.0 | 389.33 | 392.62 | 139699.0 |
| 2024-05-01 09:00:00 | MSFT | Stock | 392.42 | 394.35 | 390.31 | 391.9972 | 1897824.0 |
| 2024-05-01 10:00:00 | MSFT | Stock | 392.03 | 395.2435 | 391.28 | 394.675 | 1660439.0 |
| 2024-05-01 11:00:00 | MSFT | Stock | 394.61 | 395.626 | 393.15 | 393.17 | 1987871.0 |
| 2024-05-01 12:00:00 | MSFT | Stock | 393.19 | 394.57 | 392.66 | 394.475 | 768263.0 |
| 2024-05-01 13:00:00 | MSFT | Stock | 394.505 | 395.29 | 394.11 | 394.56 | 669782.0 |
| 2024-05-01 14:00:00 | MSFT | Stock | 394.66 | 400.7 | 394.51 | 400.59 | 1918625.0 |
| 2024-05-01 15:00:00 | MSFT | Stock | 400.63 | 401.7199 | 394.8 | 394.9 | 2939687.0 |
| 2024-05-01 16:00:00 | MSFT | Stock | 394.9 | 395.89 | 394.14 | 395.12 | 4068350.0 |
| 2024-05-01 17:00:00 | MSFT | Stock | 395.02 | 395.7 | 394.81 | 395.65 | 11911.0 |
| 2024-05-01 18:00:00 | MSFT | Stock | 395.6707 | 396.4645 | 395.65 | 396.0 | 14141.0 |
| 2024-05-01 19:00:00 | MSFT | Stock | 396.2 | 397.59 | 395.49 | 396.89 | 8172.0 |
| 2024-05-01 04:00:00 | NVDA | Stock | 84.697 | 85.028 | 84.662 | 84.85 | 80060.0 |
| 2024-05-01 05:00:00 | NVDA | Stock | 84.8 | 84.8 | 84.178 | 84.482 | 131680.0 |
| 2024-05-01 06:00:00 | NVDA | Stock | 84.427 | 84.635 | 84.34 | 84.635 | 38260.0 |
| 2024-05-01 07:00:00 | NVDA | Stock | 84.699 | 85.18 | 84.61 | 84.725 | 496910.0 |
| 2024-05-01 08:00:00 | NVDA | Stock | 84.775 | 86.402 | 84.6006 | 85.145 | 1858880.0 |
| 2024-05-01 09:00:00 | NVDA | Stock | 85.125 | 85.56 | 84.146 | 84.45 | 42283020.0 |
| 2024-05-01 10:00:00 | NVDA | Stock | 84.529 | 84.64 | 83.004 | 83.85 | 62345810.0 |
| 2024-05-01 11:00:00 | NVDA | Stock | 83.875 | 84.04 | 81.502 | 81.5104 | 59861460.0 |
| 2024-05-01 12:00:00 | NVDA | Stock | 81.516 | 82.36 | 81.2546 | 81.8005 | 41016990.0 |
| 2024-05-01 13:00:00 | NVDA | Stock | 81.784 | 83.073 | 81.42 | 82.31 | 37150980.0 |
| 2024-05-01 14:00:00 | NVDA | Stock | 82.376 | 85.458 | 82.155 | 85.398 | 75054770.0 |
| 2024-05-01 15:00:00 | NVDA | Stock | 85.419 | 86.0 | 83.0 | 83.024 | 73587330.0 |
| 2024-05-01 16:00:00 | NVDA | Stock | 83.041 | 83.186 | 82.3 | 82.66 | 20195790.0 |
| 2024-05-01 17:00:00 | NVDA | Stock | 82.7 | 83.16 | 82.655 | 83.16 | 599170.0 |
| 2024-05-01 18:00:00 | NVDA | Stock | 83.15 | 83.471 | 83.041 | 83.471 | 621280.0 |
| 2024-05-01 19:00:00 | NVDA | Stock | 83.472 | 84.047 | 83.472 | 83.86 | 774080.0 |
| 2024-05-01 04:00:00 | AMZN | Stock | 176.6 | 179.54 | 176.0 | 179.39 | 48654.0 |
| 2024-05-01 05:00:00 | AMZN | Stock | 179.2 | 179.74 | 178.37 | 179.15 | 17539.0 |
> showing 50 of 57,728 rows — these rows as CSV