PREVIEW / stock_1hour / 2024-01-17
file: by_date/stock_1hour/2024/2024-01-17.parquet size: 1.3 MB rows: 58,726 symbols: 1,169
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-01-17 04:00:00 | AAPL | Stock | 182.6 | 182.6 | 181.48 | 181.9 | 23534.0 |
| 2024-01-17 05:00:00 | AAPL | Stock | 181.93 | 181.96 | 181.67 | 181.67 | 21316.0 |
| 2024-01-17 06:00:00 | AAPL | Stock | 181.7 | 182.2 | 181.7 | 182.2 | 10342.0 |
| 2024-01-17 07:00:00 | AAPL | Stock | 182.19 | 182.5 | 182.0 | 182.25 | 44228.0 |
| 2024-01-17 08:00:00 | AAPL | Stock | 182.2928 | 183.63 | 181.2 | 181.33 | 309202.0 |
| 2024-01-17 09:00:00 | AAPL | Stock | 181.31 | 181.65 | 180.3 | 181.26 | 6637989.0 |
| 2024-01-17 10:00:00 | AAPL | Stock | 181.24 | 181.85 | 181.19 | 181.4997 | 5506533.0 |
| 2024-01-17 11:00:00 | AAPL | Stock | 181.495 | 182.065 | 181.485 | 181.73 | 4236394.0 |
| 2024-01-17 12:00:00 | AAPL | Stock | 181.74 | 182.33 | 181.74 | 182.24 | 3075732.0 |
| 2024-01-17 13:00:00 | AAPL | Stock | 182.2301 | 182.535 | 181.37 | 182.085 | 4574905.0 |
| 2024-01-17 14:00:00 | AAPL | Stock | 182.0899 | 182.6801 | 182.0025 | 182.195 | 3812712.0 |
| 2024-01-17 15:00:00 | AAPL | Stock | 182.2 | 182.93 | 182.0501 | 182.66 | 5282530.0 |
| 2024-01-17 16:00:00 | AAPL | Stock | 182.68 | 182.71 | 182.51 | 182.58 | 4997108.0 |
| 2024-01-17 17:00:00 | AAPL | Stock | 182.54 | 182.54 | 182.21 | 182.4 | 23375.0 |
| 2024-01-17 18:00:00 | AAPL | Stock | 182.45 | 182.5 | 182.3 | 182.45 | 22304.0 |
| 2024-01-17 19:00:00 | AAPL | Stock | 182.41 | 182.5 | 182.24 | 182.47 | 14056.0 |
| 2024-01-17 04:00:00 | MSFT | Stock | 389.98 | 389.98 | 387.7 | 389.2 | 6826.0 |
| 2024-01-17 05:00:00 | MSFT | Stock | 389.0 | 389.43 | 388.71 | 388.71 | 3248.0 |
| 2024-01-17 06:00:00 | MSFT | Stock | 388.7 | 390.93 | 388.7 | 390.93 | 5603.0 |
| 2024-01-17 07:00:00 | MSFT | Stock | 390.88 | 391.31 | 390.21 | 390.36 | 28525.0 |
| 2024-01-17 08:00:00 | MSFT | Stock | 390.99 | 391.3 | 388.0 | 388.54 | 146110.0 |
| 2024-01-17 09:00:00 | MSFT | Stock | 388.697 | 389.5 | 384.81 | 385.82 | 2220539.0 |
| 2024-01-17 10:00:00 | MSFT | Stock | 385.805 | 387.6 | 385.12 | 387.3673 | 1702976.0 |
| 2024-01-17 11:00:00 | MSFT | Stock | 387.36 | 390.11 | 387.35 | 389.75 | 1829926.0 |
| 2024-01-17 12:00:00 | MSFT | Stock | 389.75 | 390.02 | 388.48 | 389.51 | 975059.0 |
| 2024-01-17 13:00:00 | MSFT | Stock | 389.48 | 389.87 | 387.0495 | 387.61 | 1095136.0 |
| 2024-01-17 14:00:00 | MSFT | Stock | 387.62 | 388.7 | 387.19 | 388.5 | 1036428.0 |
| 2024-01-17 15:00:00 | MSFT | Stock | 388.51 | 389.82 | 387.76 | 389.4 | 1874623.0 |
| 2024-01-17 16:00:00 | MSFT | Stock | 389.47 | 389.7 | 389.03 | 389.6 | 2176709.0 |
| 2024-01-17 17:00:00 | MSFT | Stock | 389.35 | 389.35 | 389.11 | 389.21 | 6125.0 |
| 2024-01-17 18:00:00 | MSFT | Stock | 389.3 | 389.39 | 389.05 | 389.25 | 10484.0 |
| 2024-01-17 19:00:00 | MSFT | Stock | 389.2 | 389.37 | 389.1 | 389.33 | 5557.0 |
| 2024-01-17 04:00:00 | NVDA | Stock | 56.01 | 56.565 | 56.01 | 56.538 | 316420.0 |
| 2024-01-17 05:00:00 | NVDA | Stock | 56.538 | 56.538 | 56.325 | 56.475 | 103750.0 |
| 2024-01-17 06:00:00 | NVDA | Stock | 56.5 | 56.675 | 56.475 | 56.605 | 165440.0 |
| 2024-01-17 07:00:00 | NVDA | Stock | 56.582 | 56.78 | 56.575 | 56.691 | 890520.0 |
| 2024-01-17 08:00:00 | NVDA | Stock | 56.62 | 56.787 | 55.891 | 56.225 | 3918680.0 |
| 2024-01-17 09:00:00 | NVDA | Stock | 56.221 | 56.475 | 54.925 | 54.9887 | 75670140.0 |
| 2024-01-17 10:00:00 | NVDA | Stock | 54.9851 | 55.645 | 54.74 | 55.641 | 79635220.0 |
| 2024-01-17 11:00:00 | NVDA | Stock | 55.6386 | 56.016 | 55.614 | 55.7128 | 52310140.0 |
| 2024-01-17 12:00:00 | NVDA | Stock | 55.713 | 55.821 | 55.51 | 55.7688 | 31720780.0 |
| 2024-01-17 13:00:00 | NVDA | Stock | 55.762 | 55.844 | 55.53 | 55.7725 | 25804050.0 |
| 2024-01-17 14:00:00 | NVDA | Stock | 55.774 | 56.276 | 55.761 | 56.1065 | 37663080.0 |
| 2024-01-17 15:00:00 | NVDA | Stock | 56.119 | 56.191 | 55.679 | 56.051 | 45207800.0 |
| 2024-01-17 16:00:00 | NVDA | Stock | 56.053 | 56.053 | 55.831 | 56.012 | 13242070.0 |
| 2024-01-17 17:00:00 | NVDA | Stock | 56.0 | 56.036 | 55.908 | 55.93 | 268190.0 |
| 2024-01-17 18:00:00 | NVDA | Stock | 55.93 | 55.995 | 55.86 | 55.94 | 257760.0 |
| 2024-01-17 19:00:00 | NVDA | Stock | 55.92 | 55.948 | 55.857 | 55.948 | 331660.0 |
| 2024-01-17 04:00:00 | AMZN | Stock | 151.87 | 152.09 | 151.5 | 152.09 | 9078.0 |
| 2024-01-17 05:00:00 | AMZN | Stock | 152.13 | 152.15 | 151.92 | 151.92 | 4217.0 |
> showing 50 of 58,726 rows — these rows as CSV