PREVIEW / stock_1hour / 2024-09-25
file: by_date/stock_1hour/2024/2024-09-25.parquet size: 1.3 MB rows: 58,688 symbols: 793
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-09-25 04:00:00 | AAPL | Stock | 226.98 | 226.98 | 225.51 | 225.88 | 28085.0 |
| 2024-09-25 05:00:00 | AAPL | Stock | 225.98 | 226.05 | 225.78 | 225.84 | 14817.0 |
| 2024-09-25 06:00:00 | AAPL | Stock | 225.97 | 226.18 | 224.78 | 225.0 | 67624.0 |
| 2024-09-25 07:00:00 | AAPL | Stock | 225.0 | 225.4 | 224.99 | 225.22 | 80586.0 |
| 2024-09-25 08:00:00 | AAPL | Stock | 225.05 | 227.31 | 224.85 | 225.1 | 170286.0 |
| 2024-09-25 09:00:00 | AAPL | Stock | 225.17 | 226.97 | 224.61 | 226.89 | 4212511.0 |
| 2024-09-25 10:00:00 | AAPL | Stock | 226.895 | 227.29 | 226.12 | 226.371 | 3277216.0 |
| 2024-09-25 11:00:00 | AAPL | Stock | 226.3799 | 226.65 | 225.3 | 225.51 | 2664226.0 |
| 2024-09-25 12:00:00 | AAPL | Stock | 225.53 | 226.02 | 225.39 | 225.7999 | 1550746.0 |
| 2024-09-25 13:00:00 | AAPL | Stock | 225.8 | 225.8817 | 224.82 | 224.96 | 2450931.0 |
| 2024-09-25 14:00:00 | AAPL | Stock | 224.965 | 225.1 | 224.02 | 224.9355 | 3280659.0 |
| 2024-09-25 15:00:00 | AAPL | Stock | 224.93 | 226.45 | 224.91 | 226.31 | 4129818.0 |
| 2024-09-25 16:00:00 | AAPL | Stock | 226.37 | 226.4 | 224.8013 | 226.03 | 9671845.0 |
| 2024-09-25 17:00:00 | AAPL | Stock | 226.03 | 226.1947 | 225.8325 | 226.11 | 34299.0 |
| 2024-09-25 18:00:00 | AAPL | Stock | 226.03 | 226.03 | 225.82 | 225.95 | 31503.0 |
| 2024-09-25 19:00:00 | AAPL | Stock | 225.94 | 226.15 | 225.425 | 226.15 | 18167.0 |
| 2024-09-25 04:00:00 | MSFT | Stock | 429.21 | 429.8 | 429.18 | 429.18 | 2087.0 |
| 2024-09-25 05:00:00 | MSFT | Stock | 429.14 | 429.3 | 429.14 | 429.24 | 864.0 |
| 2024-09-25 06:00:00 | MSFT | Stock | 429.4 | 429.52 | 429.4 | 429.48 | 1151.0 |
| 2024-09-25 07:00:00 | MSFT | Stock | 429.95 | 430.0 | 429.55 | 429.61 | 2610.0 |
| 2024-09-25 08:00:00 | MSFT | Stock | 429.88 | 430.35 | 429.25 | 430.0 | 14376.0 |
| 2024-09-25 09:00:00 | MSFT | Stock | 429.92 | 431.68 | 428.57 | 430.4 | 1158646.0 |
| 2024-09-25 10:00:00 | MSFT | Stock | 430.305 | 431.66 | 430.1818 | 431.47 | 1094313.0 |
| 2024-09-25 11:00:00 | MSFT | Stock | 431.415 | 433.119 | 430.86 | 431.735 | 829810.0 |
| 2024-09-25 12:00:00 | MSFT | Stock | 431.735 | 432.22 | 431.18 | 431.8 | 447498.0 |
| 2024-09-25 13:00:00 | MSFT | Stock | 431.84 | 432.4 | 430.71 | 432.335 | 505581.0 |
| 2024-09-25 14:00:00 | MSFT | Stock | 432.35 | 432.56 | 430.95 | 431.92 | 459399.0 |
| 2024-09-25 15:00:00 | MSFT | Stock | 431.92 | 432.3 | 431.42 | 432.04 | 996054.0 |
| 2024-09-25 16:00:00 | MSFT | Stock | 432.11 | 432.11 | 430.5 | 431.12 | 3000929.0 |
| 2024-09-25 17:00:00 | MSFT | Stock | 432.11 | 432.11 | 430.84 | 431.0 | 42348.0 |
| 2024-09-25 18:00:00 | MSFT | Stock | 430.79 | 432.0 | 430.6 | 431.5 | 12769.0 |
| 2024-09-25 19:00:00 | MSFT | Stock | 431.43 | 431.9 | 431.11 | 431.8705 | 5020.0 |
| 2024-09-25 04:00:00 | NVDA | Stock | 120.28 | 121.18 | 119.73 | 119.99 | 612433.0 |
| 2024-09-25 05:00:00 | NVDA | Stock | 119.95 | 120.28 | 119.78 | 120.17 | 362713.0 |
| 2024-09-25 06:00:00 | NVDA | Stock | 120.17 | 120.53 | 120.17 | 120.51 | 275261.0 |
| 2024-09-25 07:00:00 | NVDA | Stock | 120.5 | 121.35 | 120.44 | 121.34 | 1400177.0 |
| 2024-09-25 08:00:00 | NVDA | Stock | 121.34 | 122.0 | 120.1 | 121.97 | 3718291.0 |
| 2024-09-25 09:00:00 | NVDA | Stock | 121.95 | 124.19 | 121.61 | 124.16 | 50913150.0 |
| 2024-09-25 10:00:00 | NVDA | Stock | 124.15 | 124.94 | 123.95 | 124.6 | 50958781.0 |
| 2024-09-25 11:00:00 | NVDA | Stock | 124.58 | 124.8699 | 123.12 | 123.58 | 36336877.0 |
| 2024-09-25 12:00:00 | NVDA | Stock | 123.5793 | 123.89 | 123.06 | 123.205 | 24846969.0 |
| 2024-09-25 13:00:00 | NVDA | Stock | 123.21 | 123.39 | 122.62 | 123.22 | 25975117.0 |
| 2024-09-25 14:00:00 | NVDA | Stock | 123.215 | 123.6 | 122.86 | 123.4673 | 16126453.0 |
| 2024-09-25 15:00:00 | NVDA | Stock | 123.46 | 123.59 | 123.21 | 123.56 | 20292909.0 |
| 2024-09-25 16:00:00 | NVDA | Stock | 123.51 | 124.81 | 123.26 | 124.418 | 19314214.0 |
| 2024-09-25 17:00:00 | NVDA | Stock | 124.4 | 124.53 | 123.51 | 124.49 | 864297.0 |
| 2024-09-25 18:00:00 | NVDA | Stock | 124.48 | 124.6 | 124.37 | 124.5 | 430000.0 |
| 2024-09-25 19:00:00 | NVDA | Stock | 124.51 | 124.64 | 124.47 | 124.6 | 520964.0 |
| 2024-09-25 04:00:00 | AMZN | Stock | 192.91 | 193.0 | 192.58 | 192.93 | 6664.0 |
| 2024-09-25 05:00:00 | AMZN | Stock | 192.93 | 193.25 | 192.93 | 193.25 | 5724.0 |
> showing 50 of 58,688 rows — these rows as CSV