PREVIEW / stock_1hour / 2024-07-18
file: by_date/stock_1hour/2024/2024-07-18.parquet size: 1.3 MB rows: 58,595 symbols: 912
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-18 04:00:00 | AAPL | Stock | 229.34 | 231.17 | 229.34 | 231.04 | 30562.0 |
| 2024-07-18 05:00:00 | AAPL | Stock | 231.1 | 231.14 | 229.71 | 230.48 | 20777.0 |
| 2024-07-18 06:00:00 | AAPL | Stock | 230.34 | 230.45 | 229.76 | 230.07 | 17589.0 |
| 2024-07-18 07:00:00 | AAPL | Stock | 230.09 | 230.25 | 229.8 | 230.0 | 33640.0 |
| 2024-07-18 08:00:00 | AAPL | Stock | 229.85 | 231.8 | 228.92 | 230.94 | 199725.0 |
| 2024-07-18 09:00:00 | AAPL | Stock | 230.912 | 231.23 | 226.59 | 227.03 | 5729527.0 |
| 2024-07-18 10:00:00 | AAPL | Stock | 227.005 | 228.67 | 225.13 | 226.59 | 7394454.0 |
| 2024-07-18 11:00:00 | AAPL | Stock | 226.59 | 226.69 | 222.27 | 223.49 | 9033034.0 |
| 2024-07-18 12:00:00 | AAPL | Stock | 223.49 | 224.23 | 222.4 | 224.21 | 5581547.0 |
| 2024-07-18 13:00:00 | AAPL | Stock | 224.2 | 225.2 | 223.47 | 224.7 | 3944198.0 |
| 2024-07-18 14:00:00 | AAPL | Stock | 224.71 | 225.03 | 224.15 | 224.785 | 2789834.0 |
| 2024-07-18 15:00:00 | AAPL | Stock | 224.78 | 225.15 | 223.4509 | 224.19 | 6245735.0 |
| 2024-07-18 16:00:00 | AAPL | Stock | 224.17 | 224.84 | 223.98 | 224.74 | 9075543.0 |
| 2024-07-18 17:00:00 | AAPL | Stock | 224.73 | 225.185 | 224.18 | 225.17 | 56062.0 |
| 2024-07-18 18:00:00 | AAPL | Stock | 225.17 | 225.31 | 224.85 | 225.26 | 37011.0 |
| 2024-07-18 19:00:00 | AAPL | Stock | 225.25 | 225.39 | 224.7 | 224.9887 | 13106.0 |
| 2024-07-18 04:00:00 | MSFT | Stock | 445.0 | 445.57 | 443.87 | 445.57 | 3340.0 |
| 2024-07-18 05:00:00 | MSFT | Stock | 445.3 | 445.3 | 444.5 | 444.88 | 1840.0 |
| 2024-07-18 06:00:00 | MSFT | Stock | 444.8 | 444.81 | 444.1 | 444.81 | 1960.0 |
| 2024-07-18 07:00:00 | MSFT | Stock | 445.36 | 445.57 | 444.8 | 445.33 | 7435.0 |
| 2024-07-18 08:00:00 | MSFT | Stock | 445.4935 | 446.43 | 444.31 | 446.2 | 27300.0 |
| 2024-07-18 09:00:00 | MSFT | Stock | 446.14 | 447.0 | 439.22 | 439.44 | 1870990.0 |
| 2024-07-18 10:00:00 | MSFT | Stock | 439.42 | 440.65 | 436.46 | 438.91 | 1986565.0 |
| 2024-07-18 11:00:00 | MSFT | Stock | 438.95 | 439.345 | 434.72 | 434.9 | 1760611.0 |
| 2024-07-18 12:00:00 | MSFT | Stock | 434.91 | 436.94 | 434.4 | 436.59 | 1130319.0 |
| 2024-07-18 13:00:00 | MSFT | Stock | 436.6 | 438.1662 | 435.88 | 437.53 | 940427.0 |
| 2024-07-18 14:00:00 | MSFT | Stock | 437.57 | 438.87 | 436.76 | 438.22 | 1064446.0 |
| 2024-07-18 15:00:00 | MSFT | Stock | 438.15 | 441.01 | 436.74 | 440.43 | 2131288.0 |
| 2024-07-18 16:00:00 | MSFT | Stock | 440.37 | 441.38 | 440.0 | 441.19 | 2664113.0 |
| 2024-07-18 17:00:00 | MSFT | Stock | 441.15 | 442.1 | 440.37 | 442.1 | 12027.0 |
| 2024-07-18 18:00:00 | MSFT | Stock | 442.1 | 444.0 | 442.07 | 442.52 | 19236.0 |
| 2024-07-18 19:00:00 | MSFT | Stock | 442.7941 | 442.7941 | 441.59 | 441.59 | 7363.0 |
| 2024-07-18 04:00:00 | NVDA | Stock | 120.9 | 122.15 | 120.31 | 121.93 | 1234753.0 |
| 2024-07-18 05:00:00 | NVDA | Stock | 121.94 | 122.0 | 120.22 | 120.87 | 699691.0 |
| 2024-07-18 06:00:00 | NVDA | Stock | 120.87 | 121.09 | 119.37 | 120.81 | 863665.0 |
| 2024-07-18 07:00:00 | NVDA | Stock | 120.73 | 120.99 | 120.2 | 120.5 | 1194363.0 |
| 2024-07-18 08:00:00 | NVDA | Stock | 120.7 | 123.49 | 119.37 | 121.53 | 4814866.0 |
| 2024-07-18 09:00:00 | NVDA | Stock | 121.55 | 122.4 | 118.83 | 120.4096 | 44622226.0 |
| 2024-07-18 10:00:00 | NVDA | Stock | 120.395 | 121.45 | 117.58 | 118.8725 | 51080873.0 |
| 2024-07-18 11:00:00 | NVDA | Stock | 118.8753 | 119.1 | 116.56 | 118.04 | 44027029.0 |
| 2024-07-18 12:00:00 | NVDA | Stock | 118.045 | 120.73 | 117.74 | 120.7149 | 31094608.0 |
| 2024-07-18 13:00:00 | NVDA | Stock | 120.71 | 121.38 | 119.65 | 119.8591 | 26807237.0 |
| 2024-07-18 14:00:00 | NVDA | Stock | 119.87 | 120.81 | 119.5 | 120.32 | 20393048.0 |
| 2024-07-18 15:00:00 | NVDA | Stock | 120.31 | 121.5 | 118.95 | 121.11 | 34947985.0 |
| 2024-07-18 16:00:00 | NVDA | Stock | 121.16 | 122.0 | 119.9936 | 121.92 | 15133661.0 |
| 2024-07-18 17:00:00 | NVDA | Stock | 121.92 | 122.28 | 121.09 | 121.9 | 1014614.0 |
| 2024-07-18 18:00:00 | NVDA | Stock | 121.93 | 122.12 | 121.65 | 121.92 | 480495.0 |
| 2024-07-18 19:00:00 | NVDA | Stock | 121.94 | 122.07 | 121.82 | 121.94 | 408396.0 |
| 2024-07-18 04:00:00 | AMZN | Stock | 188.95 | 188.95 | 188.56 | 188.71 | 13813.0 |
| 2024-07-18 05:00:00 | AMZN | Stock | 188.86 | 189.06 | 188.6 | 188.6 | 6014.0 |
> showing 50 of 58,595 rows — these rows as CSV