PREVIEW / stock_1hour / 2024-02-20
file: by_date/stock_1hour/2024/2024-02-20.parquet size: 1.4 MB rows: 61,400 symbols: 1,124
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-20 04:00:00 | AAPL | Stock | 181.7 | 181.9 | 181.15 | 181.48 | 20035.0 |
| 2024-02-20 05:00:00 | AAPL | Stock | 181.32 | 181.44 | 181.15 | 181.38 | 6536.0 |
| 2024-02-20 06:00:00 | AAPL | Stock | 181.4 | 181.65 | 181.25 | 181.59 | 7738.0 |
| 2024-02-20 07:00:00 | AAPL | Stock | 181.65 | 182.05 | 181.5 | 181.89 | 28873.0 |
| 2024-02-20 08:00:00 | AAPL | Stock | 181.9 | 182.57 | 181.14 | 182.21 | 131431.0 |
| 2024-02-20 09:00:00 | AAPL | Stock | 182.24 | 182.55 | 180.68 | 180.835 | 6070022.0 |
| 2024-02-20 10:00:00 | AAPL | Stock | 180.83 | 180.835 | 180.0 | 180.735 | 6080567.0 |
| 2024-02-20 11:00:00 | AAPL | Stock | 180.73 | 181.37 | 180.7 | 181.085 | 4509634.0 |
| 2024-02-20 12:00:00 | AAPL | Stock | 181.1 | 181.1261 | 180.49 | 180.755 | 3576187.0 |
| 2024-02-20 13:00:00 | AAPL | Stock | 180.745 | 180.95 | 180.4 | 180.7302 | 2802171.0 |
| 2024-02-20 14:00:00 | AAPL | Stock | 180.73 | 180.91 | 180.41 | 180.9 | 2489837.0 |
| 2024-02-20 15:00:00 | AAPL | Stock | 180.91 | 181.66 | 180.86 | 181.62 | 6909880.0 |
| 2024-02-20 16:00:00 | AAPL | Stock | 181.63 | 181.8 | 181.31 | 181.68 | 5661543.0 |
| 2024-02-20 17:00:00 | AAPL | Stock | 181.68 | 181.77 | 181.52 | 181.55 | 24732.0 |
| 2024-02-20 18:00:00 | AAPL | Stock | 181.6 | 181.88 | 181.58 | 181.7 | 26894.0 |
| 2024-02-20 19:00:00 | AAPL | Stock | 181.66 | 181.9599 | 181.6401 | 181.7 | 20203.0 |
| 2024-02-20 04:00:00 | MSFT | Stock | 403.66 | 404.1 | 402.2 | 402.2 | 10890.0 |
| 2024-02-20 05:00:00 | MSFT | Stock | 402.0 | 402.0 | 400.11 | 400.53 | 10708.0 |
| 2024-02-20 06:00:00 | MSFT | Stock | 400.54 | 401.1 | 400.35 | 400.9 | 5015.0 |
| 2024-02-20 07:00:00 | MSFT | Stock | 401.0 | 403.88 | 401.0 | 401.96 | 18069.0 |
| 2024-02-20 08:00:00 | MSFT | Stock | 401.4 | 404.5 | 401.3 | 403.35 | 66361.0 |
| 2024-02-20 09:00:00 | MSFT | Stock | 403.15 | 404.49 | 399.55 | 399.75 | 2800915.0 |
| 2024-02-20 10:00:00 | MSFT | Stock | 399.725 | 400.55 | 398.01 | 400.55 | 2198101.0 |
| 2024-02-20 11:00:00 | MSFT | Stock | 400.58 | 402.18 | 399.8 | 399.81 | 1281381.0 |
| 2024-02-20 12:00:00 | MSFT | Stock | 399.785 | 399.98 | 398.48 | 399.58 | 1007694.0 |
| 2024-02-20 13:00:00 | MSFT | Stock | 399.6308 | 400.95 | 399.31 | 400.584 | 684467.0 |
| 2024-02-20 14:00:00 | MSFT | Stock | 400.59 | 401.63 | 400.15 | 401.58 | 787410.0 |
| 2024-02-20 15:00:00 | MSFT | Stock | 401.62 | 402.99 | 400.23 | 402.93 | 1987012.0 |
| 2024-02-20 16:00:00 | MSFT | Stock | 402.895 | 403.0 | 401.85 | 401.95 | 3254409.0 |
| 2024-02-20 17:00:00 | MSFT | Stock | 401.93 | 402.0 | 401.41 | 401.41 | 7843.0 |
| 2024-02-20 18:00:00 | MSFT | Stock | 401.46 | 401.75 | 401.06 | 401.08 | 13715.0 |
| 2024-02-20 19:00:00 | MSFT | Stock | 401.18 | 401.59 | 401.06 | 401.47 | 7384.0 |
| 2024-02-20 04:00:00 | NVDA | Stock | 72.79 | 72.79 | 70.711 | 71.231 | 1439210.0 |
| 2024-02-20 05:00:00 | NVDA | Stock | 71.126 | 71.29 | 70.73 | 70.84 | 709480.0 |
| 2024-02-20 06:00:00 | NVDA | Stock | 70.84 | 71.4 | 70.786 | 71.36 | 576630.0 |
| 2024-02-20 07:00:00 | NVDA | Stock | 71.387 | 72.08 | 71.36 | 71.898 | 2060280.0 |
| 2024-02-20 08:00:00 | NVDA | Stock | 71.497 | 72.79 | 71.1057 | 71.693 | 3770570.0 |
| 2024-02-20 09:00:00 | NVDA | Stock | 71.712 | 71.98 | 68.211 | 69.141 | 115993100.0 |
| 2024-02-20 10:00:00 | NVDA | Stock | 69.133 | 69.394 | 67.909 | 68.927 | 89946720.0 |
| 2024-02-20 11:00:00 | NVDA | Stock | 68.954 | 69.27 | 68.005 | 68.1 | 57960590.0 |
| 2024-02-20 12:00:00 | NVDA | Stock | 68.11 | 68.459 | 67.734 | 68.1736 | 50744320.0 |
| 2024-02-20 13:00:00 | NVDA | Stock | 68.191 | 68.77 | 67.8974 | 68.7284 | 39900720.0 |
| 2024-02-20 14:00:00 | NVDA | Stock | 68.7333 | 69.426 | 68.329 | 69.159 | 49568210.0 |
| 2024-02-20 15:00:00 | NVDA | Stock | 69.14 | 69.599 | 68.946 | 69.457 | 62982240.0 |
| 2024-02-20 16:00:00 | NVDA | Stock | 69.474 | 69.6 | 68.25 | 68.331 | 21507370.0 |
| 2024-02-20 17:00:00 | NVDA | Stock | 68.344 | 68.4743 | 68.053 | 68.2482 | 1660080.0 |
| 2024-02-20 18:00:00 | NVDA | Stock | 68.239 | 68.548 | 68.239 | 68.479 | 835620.0 |
| 2024-02-20 19:00:00 | NVDA | Stock | 68.452 | 68.47 | 68.061 | 68.09 | 1243360.0 |
| 2024-02-20 04:00:00 | AMZN | Stock | 168.57 | 168.57 | 168.07 | 168.29 | 15630.0 |
| 2024-02-20 05:00:00 | AMZN | Stock | 168.15 | 168.2 | 167.7 | 167.7 | 8673.0 |
> showing 50 of 61,400 rows — these rows as CSV