PREVIEW / stock_1hour / 2024-05-30
file: by_date/stock_1hour/2024/2024-05-30.parquet size: 1.3 MB rows: 58,404 symbols: 964
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-30 04:00:00 | AAPL | Stock | 190.01 | 190.68 | 189.89 | 190.5 | 15910.0 |
| 2024-05-30 05:00:00 | AAPL | Stock | 190.5 | 190.66 | 190.5 | 190.6 | 4219.0 |
| 2024-05-30 06:00:00 | AAPL | Stock | 190.66 | 190.76 | 190.49 | 190.76 | 5429.0 |
| 2024-05-30 07:00:00 | AAPL | Stock | 190.7 | 190.7 | 190.2 | 190.2 | 21191.0 |
| 2024-05-30 08:00:00 | AAPL | Stock | 190.51 | 190.87 | 189.86 | 190.46 | 121346.0 |
| 2024-05-30 09:00:00 | AAPL | Stock | 190.5 | 192.1 | 190.37 | 190.89 | 5806626.0 |
| 2024-05-30 10:00:00 | AAPL | Stock | 190.89 | 191.625 | 190.68 | 191.25 | 5819483.0 |
| 2024-05-30 11:00:00 | AAPL | Stock | 191.25 | 191.83 | 191.25 | 191.47 | 3221982.0 |
| 2024-05-30 12:00:00 | AAPL | Stock | 191.46 | 191.75 | 191.1 | 191.748 | 2323828.0 |
| 2024-05-30 13:00:00 | AAPL | Stock | 191.7483 | 192.18 | 191.71 | 191.94 | 3224557.0 |
| 2024-05-30 14:00:00 | AAPL | Stock | 191.925 | 192.0 | 191.36 | 191.74 | 3325274.0 |
| 2024-05-30 15:00:00 | AAPL | Stock | 191.74 | 191.84 | 190.85 | 191.29 | 7101042.0 |
| 2024-05-30 16:00:00 | AAPL | Stock | 191.32 | 191.49 | 190.8701 | 191.29 | 10255840.0 |
| 2024-05-30 17:00:00 | AAPL | Stock | 191.2903 | 191.6 | 191.29 | 191.38 | 78024.0 |
| 2024-05-30 18:00:00 | AAPL | Stock | 191.39 | 191.7 | 191.29 | 191.52 | 34740.0 |
| 2024-05-30 19:00:00 | AAPL | Stock | 191.54 | 191.65 | 191.41 | 191.41 | 30094.0 |
| 2024-05-30 04:00:00 | MSFT | Stock | 425.5 | 425.9 | 425.01 | 425.9 | 1844.0 |
| 2024-05-30 05:00:00 | MSFT | Stock | 425.95 | 425.95 | 425.95 | 425.95 | 375.0 |
| 2024-05-30 06:00:00 | MSFT | Stock | 425.76 | 425.76 | 425.37 | 425.75 | 2660.0 |
| 2024-05-30 07:00:00 | MSFT | Stock | 425.65 | 425.89 | 425.01 | 425.11 | 9016.0 |
| 2024-05-30 08:00:00 | MSFT | Stock | 425.9 | 425.9 | 423.9 | 424.1 | 48393.0 |
| 2024-05-30 09:00:00 | MSFT | Stock | 424.2212 | 425.0 | 420.63 | 421.6 | 2232424.0 |
| 2024-05-30 10:00:00 | MSFT | Stock | 421.65 | 421.75 | 417.6 | 418.06 | 3404666.0 |
| 2024-05-30 11:00:00 | MSFT | Stock | 418.045 | 420.27 | 417.93 | 419.05 | 2250000.0 |
| 2024-05-30 12:00:00 | MSFT | Stock | 419.075 | 419.92 | 419.02 | 419.67 | 969486.0 |
| 2024-05-30 13:00:00 | MSFT | Stock | 419.675 | 420.26 | 419.0 | 419.18 | 1152340.0 |
| 2024-05-30 14:00:00 | MSFT | Stock | 419.19 | 419.31 | 417.24 | 417.85 | 1809384.0 |
| 2024-05-30 15:00:00 | MSFT | Stock | 417.88 | 418.2 | 414.24 | 414.64 | 3304183.0 |
| 2024-05-30 16:00:00 | MSFT | Stock | 414.54 | 414.67 | 411.0 | 414.0 | 4311333.0 |
| 2024-05-30 17:00:00 | MSFT | Stock | 414.0 | 414.67 | 412.88 | 412.88 | 29482.0 |
| 2024-05-30 18:00:00 | MSFT | Stock | 413.25 | 414.67 | 412.6 | 413.22 | 10635.0 |
| 2024-05-30 19:00:00 | MSFT | Stock | 413.0 | 413.85 | 412.92 | 413.75 | 5532.0 |
| 2024-05-30 04:00:00 | NVDA | Stock | 113.57 | 113.93 | 113.0 | 113.93 | 225180.0 |
| 2024-05-30 05:00:00 | NVDA | Stock | 113.83 | 113.95 | 113.601 | 113.775 | 40410.0 |
| 2024-05-30 06:00:00 | NVDA | Stock | 113.73 | 114.188 | 113.436 | 114.188 | 121420.0 |
| 2024-05-30 07:00:00 | NVDA | Stock | 114.1 | 114.488 | 113.8 | 114.25 | 566870.0 |
| 2024-05-30 08:00:00 | NVDA | Stock | 114.285 | 114.47 | 112.9 | 114.2162 | 2007310.0 |
| 2024-05-30 09:00:00 | NVDA | Stock | 114.26 | 115.8192 | 114.021 | 115.1983 | 50203610.0 |
| 2024-05-30 10:00:00 | NVDA | Stock | 115.1915 | 115.456 | 112.75 | 113.322 | 65381960.0 |
| 2024-05-30 11:00:00 | NVDA | Stock | 113.336 | 113.92 | 112.561 | 113.4581 | 36612640.0 |
| 2024-05-30 12:00:00 | NVDA | Stock | 113.4615 | 114.25 | 113.403 | 113.621 | 21084450.0 |
| 2024-05-30 13:00:00 | NVDA | Stock | 113.616 | 114.19 | 113.402 | 113.834 | 18163140.0 |
| 2024-05-30 14:00:00 | NVDA | Stock | 113.82 | 114.001 | 112.945 | 113.0591 | 19317780.0 |
| 2024-05-30 15:00:00 | NVDA | Stock | 113.0555 | 113.18 | 109.663 | 110.52 | 74603680.0 |
| 2024-05-30 16:00:00 | NVDA | Stock | 110.558 | 110.92 | 108.7 | 110.35 | 26505800.0 |
| 2024-05-30 17:00:00 | NVDA | Stock | 110.404 | 110.5 | 109.4507 | 109.901 | 1838350.0 |
| 2024-05-30 18:00:00 | NVDA | Stock | 109.95 | 110.5 | 109.825 | 109.889 | 611050.0 |
| 2024-05-30 19:00:00 | NVDA | Stock | 109.83 | 109.894 | 109.301 | 109.373 | 1082820.0 |
| 2024-05-30 04:00:00 | AMZN | Stock | 181.25 | 181.39 | 181.15 | 181.35 | 894.0 |
| 2024-05-30 05:00:00 | AMZN | Stock | 181.46 | 181.46 | 181.35 | 181.35 | 2326.0 |
> showing 50 of 58,404 rows — these rows as CSV