PREVIEW / stock_1hour / 2024-07-01
file: by_date/stock_1hour/2024/2024-07-01.parquet size: 1.3 MB rows: 59,208 symbols: 905
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-07-01 04:00:00 | AAPL | Stock | 211.89 | 211.89 | 211.04 | 211.09 | 26935.0 |
| 2024-07-01 05:00:00 | AAPL | Stock | 211.09 | 211.39 | 210.5 | 210.99 | 16786.0 |
| 2024-07-01 06:00:00 | AAPL | Stock | 211.19 | 211.51 | 211.15 | 211.15 | 4596.0 |
| 2024-07-01 07:00:00 | AAPL | Stock | 211.14 | 211.66 | 211.14 | 211.65 | 29337.0 |
| 2024-07-01 08:00:00 | AAPL | Stock | 211.32 | 212.2 | 210.62 | 211.45 | 131510.0 |
| 2024-07-01 09:00:00 | AAPL | Stock | 211.51 | 214.04 | 211.4 | 213.15 | 6735776.0 |
| 2024-07-01 10:00:00 | AAPL | Stock | 213.15 | 215.59 | 212.78 | 215.36 | 9132321.0 |
| 2024-07-01 11:00:00 | AAPL | Stock | 215.36 | 215.73 | 214.34 | 215.69 | 5093589.0 |
| 2024-07-01 12:00:00 | AAPL | Stock | 215.685 | 217.5 | 215.33 | 216.9824 | 7726924.0 |
| 2024-07-01 13:00:00 | AAPL | Stock | 216.9999 | 217.51 | 216.32 | 216.72 | 4676363.0 |
| 2024-07-01 14:00:00 | AAPL | Stock | 216.72 | 216.9 | 215.41 | 215.75 | 3717687.0 |
| 2024-07-01 15:00:00 | AAPL | Stock | 215.74 | 217.0 | 215.14 | 216.73 | 6529085.0 |
| 2024-07-01 16:00:00 | AAPL | Stock | 216.75 | 217.36 | 216.62 | 216.95 | 6197891.0 |
| 2024-07-01 17:00:00 | AAPL | Stock | 216.93 | 217.1 | 216.75 | 217.05 | 155127.0 |
| 2024-07-01 18:00:00 | AAPL | Stock | 217.05 | 217.1 | 216.8006 | 216.8006 | 29653.0 |
| 2024-07-01 19:00:00 | AAPL | Stock | 216.9267 | 216.9267 | 216.54 | 216.66 | 40302.0 |
| 2024-07-01 04:00:00 | MSFT | Stock | 448.4 | 449.24 | 447.85 | 448.61 | 5097.0 |
| 2024-07-01 05:00:00 | MSFT | Stock | 448.33 | 448.47 | 448.05 | 448.47 | 1569.0 |
| 2024-07-01 06:00:00 | MSFT | Stock | 448.59 | 449.52 | 448.59 | 449.35 | 4984.0 |
| 2024-07-01 07:00:00 | MSFT | Stock | 449.2 | 449.4 | 448.53 | 448.53 | 12069.0 |
| 2024-07-01 08:00:00 | MSFT | Stock | 448.75 | 449.5 | 446.95 | 449.24 | 53638.0 |
| 2024-07-01 09:00:00 | MSFT | Stock | 449.45 | 449.455 | 445.66 | 447.87 | 1793269.0 |
| 2024-07-01 10:00:00 | MSFT | Stock | 448.1 | 452.3099 | 447.98 | 451.105 | 1422067.0 |
| 2024-07-01 11:00:00 | MSFT | Stock | 451.05 | 452.8296 | 450.19 | 452.8 | 886343.0 |
| 2024-07-01 12:00:00 | MSFT | Stock | 452.825 | 454.77 | 452.6201 | 454.421 | 886789.0 |
| 2024-07-01 13:00:00 | MSFT | Stock | 454.4 | 454.69 | 452.9201 | 453.725 | 634207.0 |
| 2024-07-01 14:00:00 | MSFT | Stock | 453.72 | 454.37 | 452.56 | 453.83 | 714884.0 |
| 2024-07-01 15:00:00 | MSFT | Stock | 453.82 | 457.37 | 453.38 | 456.64 | 2439482.0 |
| 2024-07-01 16:00:00 | MSFT | Stock | 456.73 | 457.2 | 456.35 | 456.73 | 3455764.0 |
| 2024-07-01 17:00:00 | MSFT | Stock | 456.92 | 457.1 | 456.72 | 457.02 | 9127.0 |
| 2024-07-01 18:00:00 | MSFT | Stock | 457.02 | 457.25 | 456.97 | 456.97 | 13666.0 |
| 2024-07-01 19:00:00 | MSFT | Stock | 456.96 | 456.98 | 456.51 | 456.68 | 14552.0 |
| 2024-07-01 04:00:00 | NVDA | Stock | 123.75 | 124.49 | 120.58 | 121.43 | 1086581.0 |
| 2024-07-01 05:00:00 | NVDA | Stock | 121.35 | 121.73 | 120.01 | 121.24 | 1072997.0 |
| 2024-07-01 06:00:00 | NVDA | Stock | 121.26 | 121.85 | 121.0 | 121.73 | 534131.0 |
| 2024-07-01 07:00:00 | NVDA | Stock | 121.74 | 122.64 | 121.62 | 122.22 | 1365802.0 |
| 2024-07-01 08:00:00 | NVDA | Stock | 122.19 | 124.39 | 120.0236 | 123.64 | 3410185.0 |
| 2024-07-01 09:00:00 | NVDA | Stock | 123.64 | 123.78 | 118.83 | 120.59 | 51781481.0 |
| 2024-07-01 10:00:00 | NVDA | Stock | 120.6 | 122.77 | 119.59 | 122.0 | 52159231.0 |
| 2024-07-01 11:00:00 | NVDA | Stock | 122.0 | 124.25 | 121.64 | 123.793 | 33711394.0 |
| 2024-07-01 12:00:00 | NVDA | Stock | 123.795 | 124.84 | 123.57 | 123.801 | 26631652.0 |
| 2024-07-01 13:00:00 | NVDA | Stock | 123.8 | 123.94 | 122.85 | 123.42 | 19953987.0 |
| 2024-07-01 14:00:00 | NVDA | Stock | 123.4399 | 124.5 | 123.14 | 124.139 | 20405240.0 |
| 2024-07-01 15:00:00 | NVDA | Stock | 124.136 | 124.71 | 123.544 | 124.18 | 26075341.0 |
| 2024-07-01 16:00:00 | NVDA | Stock | 124.18 | 124.49 | 124.06 | 124.12 | 12097615.0 |
| 2024-07-01 17:00:00 | NVDA | Stock | 124.12 | 124.34 | 124.06 | 124.2 | 239500.0 |
| 2024-07-01 18:00:00 | NVDA | Stock | 124.2 | 124.22 | 123.85 | 123.85 | 326310.0 |
| 2024-07-01 19:00:00 | NVDA | Stock | 123.8594 | 124.09 | 123.71 | 123.8801 | 502823.0 |
| 2024-07-01 04:00:00 | AMZN | Stock | 194.39 | 194.89 | 194.09 | 194.22 | 72967.0 |
| 2024-07-01 05:00:00 | AMZN | Stock | 194.03 | 194.54 | 193.9 | 194.54 | 7687.0 |
> showing 50 of 59,208 rows — these rows as CSV