PREVIEW / stock_1hour / 2024-07-02
file: by_date/stock_1hour/2024/2024-07-02.parquet size: 1.3 MB rows: 57,899 symbols: 917
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-02 04:00:00 | AAPL | Stock | 216.5 | 216.5 | 215.99 | 216.1 | 22692.0 |
| 2024-07-02 05:00:00 | AAPL | Stock | 216.07 | 216.11 | 215.57 | 215.9 | 10493.0 |
| 2024-07-02 06:00:00 | AAPL | Stock | 215.9 | 216.15 | 215.89 | 215.99 | 3658.0 |
| 2024-07-02 07:00:00 | AAPL | Stock | 216.05 | 216.09 | 215.5 | 215.7 | 24172.0 |
| 2024-07-02 08:00:00 | AAPL | Stock | 215.92 | 216.49 | 215.51 | 215.7 | 129344.0 |
| 2024-07-02 09:00:00 | AAPL | Stock | 215.76 | 218.01 | 215.1 | 217.985 | 6892083.0 |
| 2024-07-02 10:00:00 | AAPL | Stock | 218.0 | 219.86 | 217.67 | 219.5398 | 9691429.0 |
| 2024-07-02 11:00:00 | AAPL | Stock | 219.54 | 220.34 | 218.99 | 219.27 | 7337094.0 |
| 2024-07-02 12:00:00 | AAPL | Stock | 219.26 | 219.44 | 218.76 | 219.17 | 3276053.0 |
| 2024-07-02 13:00:00 | AAPL | Stock | 219.1601 | 219.87 | 218.8308 | 219.5998 | 2653124.0 |
| 2024-07-02 14:00:00 | AAPL | Stock | 219.59 | 220.33 | 219.47 | 219.78 | 3715062.0 |
| 2024-07-02 15:00:00 | AAPL | Stock | 219.78 | 220.38 | 219.36 | 220.37 | 5514692.0 |
| 2024-07-02 16:00:00 | AAPL | Stock | 220.34 | 220.39 | 219.44 | 219.68 | 8712783.0 |
| 2024-07-02 17:00:00 | AAPL | Stock | 219.68 | 219.7 | 219.43 | 219.55 | 59322.0 |
| 2024-07-02 18:00:00 | AAPL | Stock | 219.6 | 219.7 | 219.51 | 219.5915 | 30544.0 |
| 2024-07-02 19:00:00 | AAPL | Stock | 219.6 | 219.6 | 219.35 | 219.41 | 33490.0 |
| 2024-07-02 04:00:00 | MSFT | Stock | 456.2 | 456.2 | 455.15 | 455.94 | 6241.0 |
| 2024-07-02 05:00:00 | MSFT | Stock | 456.07 | 456.5 | 455.45 | 455.45 | 3500.0 |
| 2024-07-02 06:00:00 | MSFT | Stock | 455.34 | 455.56 | 455.34 | 455.56 | 442.0 |
| 2024-07-02 07:00:00 | MSFT | Stock | 455.4 | 455.4 | 454.38 | 454.38 | 6292.0 |
| 2024-07-02 08:00:00 | MSFT | Stock | 455.4986 | 456.4 | 454.29 | 455.3039 | 24484.0 |
| 2024-07-02 09:00:00 | MSFT | Stock | 455.25 | 456.78 | 453.113 | 455.755 | 1357634.0 |
| 2024-07-02 10:00:00 | MSFT | Stock | 455.81 | 457.9499 | 455.53 | 456.975 | 1140513.0 |
| 2024-07-02 11:00:00 | MSFT | Stock | 456.99 | 457.06 | 455.58 | 455.615 | 804499.0 |
| 2024-07-02 12:00:00 | MSFT | Stock | 455.62 | 456.53 | 454.85 | 456.4899 | 511709.0 |
| 2024-07-02 13:00:00 | MSFT | Stock | 456.4692 | 459.19 | 456.38 | 458.8531 | 666451.0 |
| 2024-07-02 14:00:00 | MSFT | Stock | 458.82 | 459.08 | 458.08 | 458.72 | 654685.0 |
| 2024-07-02 15:00:00 | MSFT | Stock | 458.68 | 459.59 | 458.5 | 459.42 | 935742.0 |
| 2024-07-02 16:00:00 | MSFT | Stock | 459.28 | 459.37 | 458.75 | 459.0 | 3531283.0 |
| 2024-07-02 17:00:00 | MSFT | Stock | 458.98 | 459.25 | 458.98 | 459.18 | 7246.0 |
| 2024-07-02 18:00:00 | MSFT | Stock | 459.0 | 459.0 | 458.98 | 459.0 | 4723.0 |
| 2024-07-02 19:00:00 | MSFT | Stock | 459.05 | 459.13 | 459.0 | 459.1 | 5159.0 |
| 2024-07-02 04:00:00 | NVDA | Stock | 123.1 | 123.5 | 122.34 | 122.75 | 408319.0 |
| 2024-07-02 05:00:00 | NVDA | Stock | 122.76 | 122.97 | 122.53 | 122.75 | 108029.0 |
| 2024-07-02 06:00:00 | NVDA | Stock | 122.76 | 123.44 | 122.66 | 123.2 | 157708.0 |
| 2024-07-02 07:00:00 | NVDA | Stock | 123.2 | 123.42 | 122.43 | 122.74 | 641681.0 |
| 2024-07-02 08:00:00 | NVDA | Stock | 123.12 | 123.57 | 122.4118 | 122.53 | 1788708.0 |
| 2024-07-02 09:00:00 | NVDA | Stock | 122.52 | 123.41 | 120.7 | 122.5855 | 36408194.0 |
| 2024-07-02 10:00:00 | NVDA | Stock | 122.615 | 122.69 | 121.1 | 121.72 | 37109429.0 |
| 2024-07-02 11:00:00 | NVDA | Stock | 121.73 | 122.42 | 121.27 | 121.6801 | 22543964.0 |
| 2024-07-02 12:00:00 | NVDA | Stock | 121.7 | 123.07 | 121.56 | 122.93 | 18179227.0 |
| 2024-07-02 13:00:00 | NVDA | Stock | 122.92 | 123.36 | 122.32 | 122.84 | 17285048.0 |
| 2024-07-02 14:00:00 | NVDA | Stock | 122.83 | 122.95 | 122.35 | 122.6002 | 12878122.0 |
| 2024-07-02 15:00:00 | NVDA | Stock | 122.6 | 122.7539 | 121.78 | 122.66 | 22394361.0 |
| 2024-07-02 16:00:00 | NVDA | Stock | 122.66 | 122.67 | 122.01 | 122.09 | 16913288.0 |
| 2024-07-02 17:00:00 | NVDA | Stock | 122.1 | 122.32 | 121.84 | 122.02 | 416166.0 |
| 2024-07-02 18:00:00 | NVDA | Stock | 122.0 | 122.15 | 121.88 | 122.09 | 310623.0 |
| 2024-07-02 19:00:00 | NVDA | Stock | 122.08 | 122.19 | 122.0 | 122.09 | 379564.0 |
| 2024-07-02 04:00:00 | AMZN | Stock | 196.5 | 197.08 | 196.32 | 197.08 | 8638.0 |
| 2024-07-02 05:00:00 | AMZN | Stock | 196.85 | 196.85 | 196.67 | 196.67 | 2942.0 |
> showing 50 of 57,899 rows — these rows as CSV