PREVIEW / stock_1hour / 2024-02-12
file: by_date/stock_1hour/2024/2024-02-12.parquet size: 1.4 MB rows: 60,444 symbols: 1,151
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-02-12 04:00:00 | AAPL | Stock | 188.8 | 189.9 | 188.71 | 189.05 | 27302.0 |
| 2024-02-12 05:00:00 | AAPL | Stock | 188.89 | 189.05 | 188.8 | 189.05 | 7059.0 |
| 2024-02-12 06:00:00 | AAPL | Stock | 189.05 | 189.37 | 188.08 | 188.48 | 51102.0 |
| 2024-02-12 07:00:00 | AAPL | Stock | 188.48 | 188.81 | 188.1 | 188.66 | 14909.0 |
| 2024-02-12 08:00:00 | AAPL | Stock | 188.4 | 188.9 | 188.18 | 188.4 | 92918.0 |
| 2024-02-12 09:00:00 | AAPL | Stock | 188.346 | 188.85 | 187.44 | 187.985 | 5137862.0 |
| 2024-02-12 10:00:00 | AAPL | Stock | 187.985 | 188.0599 | 187.3801 | 187.79 | 5013764.0 |
| 2024-02-12 11:00:00 | AAPL | Stock | 187.795 | 188.18 | 187.69 | 188.005 | 2695834.0 |
| 2024-02-12 12:00:00 | AAPL | Stock | 188.015 | 188.21 | 187.7 | 188.16 | 2363813.0 |
| 2024-02-12 13:00:00 | AAPL | Stock | 188.16 | 188.37 | 187.55 | 187.99 | 2737407.0 |
| 2024-02-12 14:00:00 | AAPL | Stock | 187.985 | 188.0376 | 186.92 | 186.99 | 2978698.0 |
| 2024-02-12 15:00:00 | AAPL | Stock | 186.98 | 187.45 | 186.79 | 187.18 | 5479809.0 |
| 2024-02-12 16:00:00 | AAPL | Stock | 187.19 | 187.21 | 186.58 | 187.0 | 6572816.0 |
| 2024-02-12 17:00:00 | AAPL | Stock | 187.0 | 187.0 | 186.74 | 186.7556 | 15077.0 |
| 2024-02-12 18:00:00 | AAPL | Stock | 186.86 | 186.92 | 186.66 | 186.92 | 17731.0 |
| 2024-02-12 19:00:00 | AAPL | Stock | 186.92 | 186.99 | 186.6 | 186.68 | 11083.0 |
| 2024-02-12 04:00:00 | MSFT | Stock | 421.0 | 421.33 | 418.75 | 420.72 | 17265.0 |
| 2024-02-12 05:00:00 | MSFT | Stock | 420.99 | 421.26 | 420.0 | 420.05 | 13519.0 |
| 2024-02-12 06:00:00 | MSFT | Stock | 420.61 | 421.0 | 420.61 | 420.69 | 1901.0 |
| 2024-02-12 07:00:00 | MSFT | Stock | 420.75 | 421.18 | 420.65 | 420.65 | 6793.0 |
| 2024-02-12 08:00:00 | MSFT | Stock | 421.0 | 421.2099 | 420.08 | 420.31 | 51031.0 |
| 2024-02-12 09:00:00 | MSFT | Stock | 420.12 | 420.74 | 417.12 | 417.13 | 1870703.0 |
| 2024-02-12 10:00:00 | MSFT | Stock | 417.15 | 419.23 | 416.77 | 419.0696 | 2001108.0 |
| 2024-02-12 11:00:00 | MSFT | Stock | 419.0576 | 419.69 | 418.03 | 419.176 | 1018855.0 |
| 2024-02-12 12:00:00 | MSFT | Stock | 419.2 | 419.36 | 418.27 | 419.12 | 650185.0 |
| 2024-02-12 13:00:00 | MSFT | Stock | 419.11 | 419.18 | 416.5 | 417.23 | 1147202.0 |
| 2024-02-12 14:00:00 | MSFT | Stock | 417.21 | 417.29 | 414.83 | 414.97 | 1171720.0 |
| 2024-02-12 15:00:00 | MSFT | Stock | 414.97 | 416.16 | 414.75 | 415.25 | 2162187.0 |
| 2024-02-12 16:00:00 | MSFT | Stock | 415.33 | 415.33 | 414.45 | 414.85 | 3847458.0 |
| 2024-02-12 17:00:00 | MSFT | Stock | 414.7527 | 414.8 | 414.49 | 414.51 | 4903.0 |
| 2024-02-12 18:00:00 | MSFT | Stock | 414.59 | 414.99 | 414.5 | 414.99 | 6174.0 |
| 2024-02-12 19:00:00 | MSFT | Stock | 414.87 | 414.93 | 414.51 | 414.51 | 3772.0 |
| 2024-02-12 04:00:00 | NVDA | Stock | 72.4 | 72.97 | 72.4 | 72.899 | 588930.0 |
| 2024-02-12 05:00:00 | NVDA | Stock | 72.899 | 72.9 | 72.655 | 72.781 | 350570.0 |
| 2024-02-12 06:00:00 | NVDA | Stock | 72.77 | 72.8 | 72.722 | 72.786 | 175510.0 |
| 2024-02-12 07:00:00 | NVDA | Stock | 72.774 | 72.85 | 72.479 | 72.73 | 1149090.0 |
| 2024-02-12 08:00:00 | NVDA | Stock | 72.7 | 72.848 | 72.2 | 72.568 | 3274170.0 |
| 2024-02-12 09:00:00 | NVDA | Stock | 72.57 | 73.496 | 72.14 | 72.739 | 74612500.0 |
| 2024-02-12 10:00:00 | NVDA | Stock | 72.7369 | 74.1 | 72.411 | 74.1 | 70212760.0 |
| 2024-02-12 11:00:00 | NVDA | Stock | 74.0916 | 74.611 | 73.585 | 73.928 | 59901580.0 |
| 2024-02-12 12:00:00 | NVDA | Stock | 73.94 | 74.05 | 73.32 | 73.6615 | 37829080.0 |
| 2024-02-12 13:00:00 | NVDA | Stock | 73.6617 | 73.6829 | 71.86 | 72.363 | 72191440.0 |
| 2024-02-12 14:00:00 | NVDA | Stock | 72.3575 | 72.555 | 71.25 | 72.075 | 64302100.0 |
| 2024-02-12 15:00:00 | NVDA | Stock | 72.0928 | 72.763 | 72.061 | 72.292 | 48448900.0 |
| 2024-02-12 16:00:00 | NVDA | Stock | 72.248 | 72.296 | 71.725 | 72.027 | 19259790.0 |
| 2024-02-12 17:00:00 | NVDA | Stock | 72.01 | 72.0276 | 71.872 | 71.957 | 486310.0 |
| 2024-02-12 18:00:00 | NVDA | Stock | 71.92 | 72.02 | 71.8112 | 72.02 | 475000.0 |
| 2024-02-12 19:00:00 | NVDA | Stock | 72.03 | 72.05 | 71.86 | 72.025 | 454320.0 |
| 2024-02-12 04:00:00 | AMZN | Stock | 174.29 | 174.62 | 174.07 | 174.6 | 20797.0 |
| 2024-02-12 05:00:00 | AMZN | Stock | 174.69 | 174.8 | 174.57 | 174.8 | 12549.0 |
> showing 50 of 60,444 rows — these rows as CSV