PREVIEW / stock_1hour / 2024-08-08
file: by_date/stock_1hour/2024/2024-08-08.parquet size: 1.3 MB rows: 58,732 symbols: 864
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-08-08 04:00:00 | AAPL | Stock | 209.75 | 209.8 | 208.95 | 209.8 | 16527.0 |
| 2024-08-08 05:00:00 | AAPL | Stock | 209.8 | 210.05 | 209.2 | 209.37 | 4336.0 |
| 2024-08-08 06:00:00 | AAPL | Stock | 209.46 | 209.84 | 209.16 | 209.61 | 18235.0 |
| 2024-08-08 07:00:00 | AAPL | Stock | 209.4 | 210.18 | 209.4 | 209.76 | 22546.0 |
| 2024-08-08 08:00:00 | AAPL | Stock | 209.5 | 212.327 | 208.69 | 211.6 | 198482.0 |
| 2024-08-08 09:00:00 | AAPL | Stock | 211.54 | 213.21 | 208.83 | 210.73 | 4721895.0 |
| 2024-08-08 10:00:00 | AAPL | Stock | 210.67 | 212.99 | 210.5092 | 212.19 | 4709051.0 |
| 2024-08-08 11:00:00 | AAPL | Stock | 212.19 | 212.68 | 211.08 | 212.39 | 3480341.0 |
| 2024-08-08 12:00:00 | AAPL | Stock | 212.37 | 213.47 | 212.2325 | 213.175 | 3649195.0 |
| 2024-08-08 13:00:00 | AAPL | Stock | 213.22 | 214.2 | 212.6301 | 213.68 | 2894803.0 |
| 2024-08-08 14:00:00 | AAPL | Stock | 213.67 | 213.84 | 212.6 | 212.915 | 2458912.0 |
| 2024-08-08 15:00:00 | AAPL | Stock | 212.91 | 213.52 | 211.87 | 213.34 | 5446425.0 |
| 2024-08-08 16:00:00 | AAPL | Stock | 213.31 | 214.0 | 213.23 | 213.54 | 7271757.0 |
| 2024-08-08 17:00:00 | AAPL | Stock | 213.5016 | 213.54 | 213.2304 | 213.3534 | 445007.0 |
| 2024-08-08 18:00:00 | AAPL | Stock | 213.4 | 213.77 | 213.33 | 213.465 | 14570.0 |
| 2024-08-08 19:00:00 | AAPL | Stock | 213.5 | 214.0 | 213.5 | 213.9482 | 21446.0 |
| 2024-08-08 04:00:00 | MSFT | Stock | 397.28 | 398.99 | 396.99 | 398.77 | 4353.0 |
| 2024-08-08 05:00:00 | MSFT | Stock | 399.65 | 399.83 | 398.08 | 398.34 | 3939.0 |
| 2024-08-08 06:00:00 | MSFT | Stock | 398.89 | 399.73 | 398.41 | 399.1 | 3341.0 |
| 2024-08-08 07:00:00 | MSFT | Stock | 398.81 | 399.28 | 398.1 | 399.1 | 13931.0 |
| 2024-08-08 08:00:00 | MSFT | Stock | 399.02 | 403.39 | 397.58 | 402.45 | 91489.0 |
| 2024-08-08 09:00:00 | MSFT | Stock | 402.12 | 404.4604 | 399.9407 | 402.74 | 1174262.0 |
| 2024-08-08 10:00:00 | MSFT | Stock | 402.805 | 405.86 | 402.19 | 404.39 | 1506444.0 |
| 2024-08-08 11:00:00 | MSFT | Stock | 404.38 | 404.43 | 402.1 | 403.59 | 1241422.0 |
| 2024-08-08 12:00:00 | MSFT | Stock | 403.5 | 404.75 | 401.17 | 402.55 | 760119.0 |
| 2024-08-08 13:00:00 | MSFT | Stock | 402.64 | 404.505 | 401.42 | 404.475 | 719697.0 |
| 2024-08-08 14:00:00 | MSFT | Stock | 404.475 | 405.57 | 402.28 | 402.58 | 1173816.0 |
| 2024-08-08 15:00:00 | MSFT | Stock | 402.58 | 403.31 | 400.24 | 403.02 | 2127405.0 |
| 2024-08-08 16:00:00 | MSFT | Stock | 402.69 | 404.5 | 402.69 | 403.81 | 3772068.0 |
| 2024-08-08 17:00:00 | MSFT | Stock | 403.86 | 403.86 | 402.69 | 403.39 | 218423.0 |
| 2024-08-08 18:00:00 | MSFT | Stock | 403.6887 | 403.98 | 403.3 | 403.7 | 5943.0 |
| 2024-08-08 19:00:00 | MSFT | Stock | 403.935 | 404.9099 | 403.8 | 404.8495 | 2861.0 |
| 2024-08-08 04:00:00 | NVDA | Stock | 99.14 | 99.79 | 98.42 | 99.45 | 946889.0 |
| 2024-08-08 05:00:00 | NVDA | Stock | 99.48 | 99.7 | 98.46 | 98.65 | 463700.0 |
| 2024-08-08 06:00:00 | NVDA | Stock | 98.78 | 99.17 | 98.33 | 98.59 | 455484.0 |
| 2024-08-08 07:00:00 | NVDA | Stock | 98.51 | 99.39 | 98.3 | 99.03 | 1111503.0 |
| 2024-08-08 08:00:00 | NVDA | Stock | 98.56 | 101.78 | 97.32 | 100.64 | 8673789.0 |
| 2024-08-08 09:00:00 | NVDA | Stock | 100.62 | 102.28 | 97.52 | 100.24 | 55295344.0 |
| 2024-08-08 10:00:00 | NVDA | Stock | 100.25 | 103.0 | 99.9514 | 102.445 | 62742084.0 |
| 2024-08-08 11:00:00 | NVDA | Stock | 102.45 | 103.53 | 101.52 | 103.095 | 42192127.0 |
| 2024-08-08 12:00:00 | NVDA | Stock | 103.09 | 104.145 | 102.78 | 103.5745 | 37777053.0 |
| 2024-08-08 13:00:00 | NVDA | Stock | 103.58 | 105.46 | 102.92 | 105.015 | 34032190.0 |
| 2024-08-08 14:00:00 | NVDA | Stock | 105.0183 | 105.5 | 104.612 | 104.9801 | 27446634.0 |
| 2024-08-08 15:00:00 | NVDA | Stock | 104.98 | 105.25 | 103.6603 | 105.22 | 45971517.0 |
| 2024-08-08 16:00:00 | NVDA | Stock | 105.16 | 105.9 | 102.9206 | 105.8 | 25781937.0 |
| 2024-08-08 17:00:00 | NVDA | Stock | 105.8 | 105.8293 | 104.97 | 105.42 | 1327506.0 |
| 2024-08-08 18:00:00 | NVDA | Stock | 105.42 | 105.55 | 105.15 | 105.37 | 624350.0 |
| 2024-08-08 19:00:00 | NVDA | Stock | 105.39 | 106.2 | 105.36 | 106.2 | 923557.0 |
| 2024-08-08 04:00:00 | AMZN | Stock | 163.25 | 163.25 | 162.02 | 162.83 | 22189.0 |
| 2024-08-08 05:00:00 | AMZN | Stock | 163.15 | 163.2 | 162.3 | 162.75 | 8226.0 |
> showing 50 of 58,732 rows — these rows as CSV