PREVIEW / stock_1hour / 2023-04-13
file: by_date/stock_1hour/2023/2023-04-13.parquet size: 1.3 MB rows: 59,608 symbols: 1,700
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-13 04:00:00 | AAPL | Stock | 160.05 | 160.82 | 160.05 | 160.5 | 15719.0 |
| 2023-04-13 05:00:00 | AAPL | Stock | 160.55 | 161.27 | 160.55 | 160.86 | 14581.0 |
| 2023-04-13 06:00:00 | AAPL | Stock | 160.89 | 161.0 | 160.53 | 160.8 | 10901.0 |
| 2023-04-13 07:00:00 | AAPL | Stock | 160.67 | 160.98 | 160.45 | 160.5 | 33101.0 |
| 2023-04-13 08:00:00 | AAPL | Stock | 160.9087 | 161.5 | 159.7 | 161.45 | 217555.0 |
| 2023-04-13 09:00:00 | AAPL | Stock | 161.3644 | 163.24 | 160.99 | 162.8847 | 8770408.0 |
| 2023-04-13 10:00:00 | AAPL | Stock | 162.89 | 163.68 | 162.71 | 163.175 | 6895701.0 |
| 2023-04-13 11:00:00 | AAPL | Stock | 163.18 | 163.79 | 163.14 | 163.7711 | 4396215.0 |
| 2023-04-13 12:00:00 | AAPL | Stock | 163.78 | 164.19 | 163.55 | 164.1185 | 4525620.0 |
| 2023-04-13 13:00:00 | AAPL | Stock | 164.11 | 164.93 | 163.89 | 164.8825 | 5974423.0 |
| 2023-04-13 14:00:00 | AAPL | Stock | 164.89 | 165.38 | 164.8 | 165.18 | 6352846.0 |
| 2023-04-13 15:00:00 | AAPL | Stock | 165.19 | 165.8 | 165.11 | 165.59 | 11592206.0 |
| 2023-04-13 16:00:00 | AAPL | Stock | 165.6 | 165.6 | 165.05 | 165.07 | 10655917.0 |
| 2023-04-13 17:00:00 | AAPL | Stock | 165.07 | 165.35 | 165.07 | 165.19 | 29735.0 |
| 2023-04-13 18:00:00 | AAPL | Stock | 165.19 | 165.3 | 165.11 | 165.2 | 41265.0 |
| 2023-04-13 19:00:00 | AAPL | Stock | 165.19 | 165.3499 | 165.15 | 165.34 | 35263.0 |
| 2023-04-13 04:00:00 | MSFT | Stock | 283.99 | 284.7 | 283.49 | 283.62 | 4084.0 |
| 2023-04-13 05:00:00 | MSFT | Stock | 283.8 | 284.98 | 283.8 | 284.49 | 3254.0 |
| 2023-04-13 06:00:00 | MSFT | Stock | 284.43 | 284.43 | 283.66 | 283.66 | 1336.0 |
| 2023-04-13 07:00:00 | MSFT | Stock | 283.67 | 283.96 | 283.15 | 283.15 | 12098.0 |
| 2023-04-13 08:00:00 | MSFT | Stock | 283.804 | 284.23 | 282.6904 | 283.5058 | 60559.0 |
| 2023-04-13 09:00:00 | MSFT | Stock | 283.66 | 286.2 | 282.58 | 285.7756 | 2328595.0 |
| 2023-04-13 10:00:00 | MSFT | Stock | 285.79 | 288.04 | 285.7301 | 287.6 | 2961625.0 |
| 2023-04-13 11:00:00 | MSFT | Stock | 287.615 | 288.19 | 287.09 | 287.51 | 1597858.0 |
| 2023-04-13 12:00:00 | MSFT | Stock | 287.5 | 288.02 | 287.35 | 287.8915 | 996648.0 |
| 2023-04-13 13:00:00 | MSFT | Stock | 287.9 | 288.5778 | 287.57 | 288.495 | 1723357.0 |
| 2023-04-13 14:00:00 | MSFT | Stock | 288.52 | 288.9 | 288.25 | 288.76 | 1424731.0 |
| 2023-04-13 15:00:00 | MSFT | Stock | 288.7701 | 289.9 | 288.6 | 289.87 | 3721550.0 |
| 2023-04-13 16:00:00 | MSFT | Stock | 289.83 | 290.32 | 289.34 | 289.35 | 4709443.0 |
| 2023-04-13 17:00:00 | MSFT | Stock | 289.33 | 289.84 | 289.33 | 289.7194 | 10782.0 |
| 2023-04-13 18:00:00 | MSFT | Stock | 289.57 | 289.6535 | 289.36 | 289.62 | 6350.0 |
| 2023-04-13 19:00:00 | MSFT | Stock | 289.72 | 289.8 | 289.66 | 289.71 | 7947.0 |
| 2023-04-13 04:00:00 | NVDA | Stock | 26.33 | 26.495 | 26.29 | 26.34 | 297630.0 |
| 2023-04-13 05:00:00 | NVDA | Stock | 26.303 | 26.537 | 26.3 | 26.43 | 124150.0 |
| 2023-04-13 06:00:00 | NVDA | Stock | 26.41 | 26.41 | 26.348 | 26.377 | 22340.0 |
| 2023-04-13 07:00:00 | NVDA | Stock | 26.389 | 26.485 | 26.386 | 26.438 | 447780.0 |
| 2023-04-13 08:00:00 | NVDA | Stock | 26.485 | 26.64 | 26.3092 | 26.55 | 1269010.0 |
| 2023-04-13 09:00:00 | NVDA | Stock | 26.55 | 26.81 | 26.329 | 26.542 | 47887440.0 |
| 2023-04-13 10:00:00 | NVDA | Stock | 26.546 | 26.802 | 26.453 | 26.655 | 45992240.0 |
| 2023-04-13 11:00:00 | NVDA | Stock | 26.6555 | 26.777 | 26.553 | 26.743 | 33511250.0 |
| 2023-04-13 12:00:00 | NVDA | Stock | 26.742 | 26.8869 | 26.704 | 26.727 | 33285580.0 |
| 2023-04-13 13:00:00 | NVDA | Stock | 26.729 | 26.866 | 26.685 | 26.832 | 22515790.0 |
| 2023-04-13 14:00:00 | NVDA | Stock | 26.8318 | 26.851 | 26.735 | 26.7452 | 24500200.0 |
| 2023-04-13 15:00:00 | NVDA | Stock | 26.747 | 26.769 | 26.414 | 26.459 | 45045410.0 |
| 2023-04-13 16:00:00 | NVDA | Stock | 26.463 | 26.4716 | 26.389 | 26.42 | 25393430.0 |
| 2023-04-13 17:00:00 | NVDA | Stock | 26.42 | 26.4558 | 26.415 | 26.4558 | 164990.0 |
| 2023-04-13 18:00:00 | NVDA | Stock | 26.445 | 26.516 | 26.437 | 26.483 | 333750.0 |
| 2023-04-13 19:00:00 | NVDA | Stock | 26.487 | 26.499 | 26.45 | 26.45 | 219690.0 |
| 2023-04-13 04:00:00 | AMZN | Stock | 98.02 | 98.53 | 98.02 | 98.15 | 13464.0 |
| 2023-04-13 05:00:00 | AMZN | Stock | 98.27 | 98.68 | 98.27 | 98.39 | 11606.0 |
> showing 50 of 59,608 rows — these rows as CSV