PREVIEW / stock_1hour / 2024-05-23
file: by_date/stock_1hour/2024/2024-05-23.parquet size: 1.3 MB rows: 59,091 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-23 04:00:00 | AAPL | Stock | 190.65 | 191.12 | 190.65 | 190.78 | 8748.0 |
| 2024-05-23 05:00:00 | AAPL | Stock | 190.77 | 190.98 | 190.77 | 190.83 | 7277.0 |
| 2024-05-23 06:00:00 | AAPL | Stock | 190.83 | 190.9 | 190.78 | 190.85 | 4419.0 |
| 2024-05-23 07:00:00 | AAPL | Stock | 190.85 | 191.25 | 190.85 | 191.25 | 14888.0 |
| 2024-05-23 08:00:00 | AAPL | Stock | 190.85 | 191.46 | 190.85 | 191.32 | 129271.0 |
| 2024-05-23 09:00:00 | AAPL | Stock | 191.34 | 191.4 | 189.05 | 189.42 | 5441852.0 |
| 2024-05-23 10:00:00 | AAPL | Stock | 189.42 | 189.69 | 188.505 | 188.725 | 5168333.0 |
| 2024-05-23 11:00:00 | AAPL | Stock | 188.73 | 189.71 | 188.68 | 189.685 | 3032514.0 |
| 2024-05-23 12:00:00 | AAPL | Stock | 189.685 | 189.69 | 188.75 | 188.79 | 2555639.0 |
| 2024-05-23 13:00:00 | AAPL | Stock | 188.78 | 188.9691 | 187.56 | 187.595 | 3910098.0 |
| 2024-05-23 14:00:00 | AAPL | Stock | 187.59 | 187.87 | 187.16 | 187.27 | 3673161.0 |
| 2024-05-23 15:00:00 | AAPL | Stock | 187.27 | 187.83 | 186.625 | 186.91 | 6474594.0 |
| 2024-05-23 16:00:00 | AAPL | Stock | 186.86 | 187.1677 | 186.63 | 186.97 | 9255862.0 |
| 2024-05-23 17:00:00 | AAPL | Stock | 187.0 | 187.14 | 186.88 | 187.01 | 122917.0 |
| 2024-05-23 18:00:00 | AAPL | Stock | 187.08 | 187.3 | 187.06 | 187.2999 | 35552.0 |
| 2024-05-23 19:00:00 | AAPL | Stock | 187.17 | 187.29 | 187.09 | 187.28 | 19967.0 |
| 2024-05-23 04:00:00 | MSFT | Stock | 432.84 | 433.0 | 432.23 | 432.23 | 10941.0 |
| 2024-05-23 05:00:00 | MSFT | Stock | 432.22 | 432.79 | 432.22 | 432.79 | 1930.0 |
| 2024-05-23 06:00:00 | MSFT | Stock | 432.79 | 433.39 | 432.79 | 433.24 | 3849.0 |
| 2024-05-23 07:00:00 | MSFT | Stock | 433.28 | 434.69 | 432.81 | 433.8 | 39350.0 |
| 2024-05-23 08:00:00 | MSFT | Stock | 433.06 | 434.75 | 432.69 | 434.3 | 60527.0 |
| 2024-05-23 09:00:00 | MSFT | Stock | 434.12 | 434.2 | 429.79 | 430.15 | 1785189.0 |
| 2024-05-23 10:00:00 | MSFT | Stock | 430.165 | 432.75 | 430.16 | 430.639 | 1442128.0 |
| 2024-05-23 11:00:00 | MSFT | Stock | 430.67 | 432.12 | 430.6 | 431.775 | 733477.0 |
| 2024-05-23 12:00:00 | MSFT | Stock | 431.755 | 432.1 | 430.26 | 430.29 | 501244.0 |
| 2024-05-23 13:00:00 | MSFT | Stock | 430.29 | 430.62 | 427.19 | 427.39 | 832915.0 |
| 2024-05-23 14:00:00 | MSFT | Stock | 427.34 | 428.005 | 425.8 | 425.9509 | 750516.0 |
| 2024-05-23 15:00:00 | MSFT | Stock | 425.915 | 427.44 | 425.424 | 427.15 | 1236152.0 |
| 2024-05-23 16:00:00 | MSFT | Stock | 427.0 | 427.8 | 425.6 | 426.0 | 3488922.0 |
| 2024-05-23 17:00:00 | MSFT | Stock | 426.0 | 426.0 | 425.52 | 425.65 | 8410.0 |
| 2024-05-23 18:00:00 | MSFT | Stock | 425.75 | 426.83 | 425.7 | 426.83 | 8023.0 |
| 2024-05-23 19:00:00 | MSFT | Stock | 426.7 | 427.0 | 426.61 | 426.98 | 5260.0 |
| 2024-05-23 04:00:00 | NVDA | Stock | 100.771 | 101.95 | 100.724 | 101.296 | 1722190.0 |
| 2024-05-23 05:00:00 | NVDA | Stock | 101.319 | 101.384 | 100.873 | 101.259 | 533390.0 |
| 2024-05-23 06:00:00 | NVDA | Stock | 101.209 | 101.704 | 101.1 | 101.5 | 522250.0 |
| 2024-05-23 07:00:00 | NVDA | Stock | 101.5 | 102.13 | 101.33 | 101.55 | 3910300.0 |
| 2024-05-23 08:00:00 | NVDA | Stock | 101.401 | 102.133 | 100.604 | 101.495 | 6950760.0 |
| 2024-05-23 09:00:00 | NVDA | Stock | 101.494 | 104.26 | 101.136 | 102.759 | 124067180.0 |
| 2024-05-23 10:00:00 | NVDA | Stock | 102.759 | 104.727 | 102.657 | 103.573 | 91764040.0 |
| 2024-05-23 11:00:00 | NVDA | Stock | 103.56 | 105.196 | 103.52 | 104.6962 | 53739830.0 |
| 2024-05-23 12:00:00 | NVDA | Stock | 104.6735 | 105.498 | 104.411 | 105.358 | 36680770.0 |
| 2024-05-23 13:00:00 | NVDA | Stock | 105.358 | 106.32 | 104.636 | 104.7341 | 51842370.0 |
| 2024-05-23 14:00:00 | NVDA | Stock | 104.718 | 104.86 | 102.9 | 103.39 | 66604010.0 |
| 2024-05-23 15:00:00 | NVDA | Stock | 103.382 | 104.2 | 102.003 | 103.821 | 76804310.0 |
| 2024-05-23 16:00:00 | NVDA | Stock | 103.724 | 103.865 | 103.051 | 103.254 | 29064360.0 |
| 2024-05-23 17:00:00 | NVDA | Stock | 103.278 | 103.4 | 103.15 | 103.351 | 650000.0 |
| 2024-05-23 18:00:00 | NVDA | Stock | 103.351 | 103.688 | 103.26 | 103.6785 | 582130.0 |
| 2024-05-23 19:00:00 | NVDA | Stock | 103.632 | 103.687 | 103.51 | 103.51 | 649950.0 |
| 2024-05-23 04:00:00 | AMZN | Stock | 183.35 | 184.26 | 183.35 | 183.75 | 12431.0 |
| 2024-05-23 05:00:00 | AMZN | Stock | 183.75 | 183.83 | 183.59 | 183.72 | 6051.0 |
> showing 50 of 59,091 rows — these rows as CSV