PREVIEW / stock_1hour / 2024-05-02
file: by_date/stock_1hour/2024/2024-05-02.parquet size: 1.3 MB rows: 58,177 symbols: 974
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-05-02 04:00:00 | AAPL | Stock | 170.5 | 171.5 | 170.5 | 171.12 | 30034.0 |
| 2024-05-02 05:00:00 | AAPL | Stock | 171.14 | 171.2 | 170.92 | 171.17 | 9072.0 |
| 2024-05-02 06:00:00 | AAPL | Stock | 171.18 | 171.38 | 171.02 | 171.2 | 7953.0 |
| 2024-05-02 07:00:00 | AAPL | Stock | 171.15 | 171.27 | 170.8 | 170.89 | 37397.0 |
| 2024-05-02 08:00:00 | AAPL | Stock | 171.15 | 173.1197 | 170.7 | 171.95 | 427263.0 |
| 2024-05-02 09:00:00 | AAPL | Stock | 171.9 | 172.94 | 171.21 | 171.44 | 7253665.0 |
| 2024-05-02 10:00:00 | AAPL | Stock | 171.425 | 172.08 | 170.89 | 171.5602 | 5606660.0 |
| 2024-05-02 11:00:00 | AAPL | Stock | 171.568 | 172.19 | 171.44 | 172.1 | 4536048.0 |
| 2024-05-02 12:00:00 | AAPL | Stock | 172.105 | 172.505 | 171.93 | 172.1589 | 5279427.0 |
| 2024-05-02 13:00:00 | AAPL | Stock | 172.16 | 172.78 | 172.16 | 172.6 | 4133587.0 |
| 2024-05-02 14:00:00 | AAPL | Stock | 172.595 | 173.1 | 172.41 | 172.94 | 6828309.0 |
| 2024-05-02 15:00:00 | AAPL | Stock | 172.94 | 173.415 | 172.54 | 173.08 | 11839989.0 |
| 2024-05-02 16:00:00 | AAPL | Stock | 173.11 | 185.95 | 172.66 | 185.3 | 18764374.0 |
| 2024-05-02 17:00:00 | AAPL | Stock | 185.3005 | 186.6453 | 183.93 | 184.1 | 4662717.0 |
| 2024-05-02 18:00:00 | AAPL | Stock | 184.09 | 184.34 | 173.03 | 183.52 | 1048426.0 |
| 2024-05-02 19:00:00 | AAPL | Stock | 183.52 | 183.95 | 183.4 | 183.46 | 399045.0 |
| 2024-05-02 04:00:00 | MSFT | Stock | 397.9 | 398.17 | 397.9 | 398.07 | 5066.0 |
| 2024-05-02 05:00:00 | MSFT | Stock | 397.78 | 398.17 | 397.69 | 398.17 | 2036.0 |
| 2024-05-02 06:00:00 | MSFT | Stock | 398.35 | 399.0 | 398.35 | 399.0 | 2935.0 |
| 2024-05-02 07:00:00 | MSFT | Stock | 399.0 | 399.0 | 397.48 | 397.7 | 22447.0 |
| 2024-05-02 08:00:00 | MSFT | Stock | 398.58 | 398.9199 | 397.5966 | 398.0 | 48726.0 |
| 2024-05-02 09:00:00 | MSFT | Stock | 398.0 | 399.93 | 395.4613 | 397.72 | 1613374.0 |
| 2024-05-02 10:00:00 | MSFT | Stock | 397.79 | 398.1731 | 394.89 | 396.46 | 1274103.0 |
| 2024-05-02 11:00:00 | MSFT | Stock | 396.49 | 397.61 | 395.9495 | 396.99 | 830719.0 |
| 2024-05-02 12:00:00 | MSFT | Stock | 397.05 | 397.25 | 394.6515 | 395.38 | 706183.0 |
| 2024-05-02 13:00:00 | MSFT | Stock | 395.41 | 397.4 | 395.4 | 396.4686 | 715879.0 |
| 2024-05-02 14:00:00 | MSFT | Stock | 396.475 | 398.64 | 396.36 | 398.5 | 819583.0 |
| 2024-05-02 15:00:00 | MSFT | Stock | 398.535 | 398.72 | 397.13 | 397.94 | 1531929.0 |
| 2024-05-02 16:00:00 | MSFT | Stock | 397.96 | 398.8 | 396.8838 | 397.21 | 3779699.0 |
| 2024-05-02 17:00:00 | MSFT | Stock | 397.11 | 397.49 | 395.8 | 396.5 | 27638.0 |
| 2024-05-02 18:00:00 | MSFT | Stock | 396.39 | 398.64 | 396.39 | 397.64 | 15482.0 |
| 2024-05-02 19:00:00 | MSFT | Stock | 397.63 | 398.15 | 397.05 | 397.65 | 7222.0 |
| 2024-05-02 04:00:00 | NVDA | Stock | 84.102 | 84.56 | 83.86 | 84.121 | 467460.0 |
| 2024-05-02 05:00:00 | NVDA | Stock | 84.102 | 84.46 | 84.094 | 84.46 | 64420.0 |
| 2024-05-02 06:00:00 | NVDA | Stock | 84.46 | 84.531 | 84.37 | 84.4 | 109420.0 |
| 2024-05-02 07:00:00 | NVDA | Stock | 84.4 | 84.874 | 84.35 | 84.351 | 944620.0 |
| 2024-05-02 08:00:00 | NVDA | Stock | 84.598 | 84.8798 | 84.0315 | 84.05 | 1687820.0 |
| 2024-05-02 09:00:00 | NVDA | Stock | 84.0368 | 85.66 | 84.0 | 84.216 | 53795090.0 |
| 2024-05-02 10:00:00 | NVDA | Stock | 84.2479 | 84.745 | 83.2 | 84.651 | 53415270.0 |
| 2024-05-02 11:00:00 | NVDA | Stock | 84.658 | 85.18 | 84.464 | 85.033 | 30930350.0 |
| 2024-05-02 12:00:00 | NVDA | Stock | 85.0455 | 85.08 | 84.225 | 84.709 | 21613390.0 |
| 2024-05-02 13:00:00 | NVDA | Stock | 84.7326 | 85.596 | 84.7326 | 85.378 | 26697090.0 |
| 2024-05-02 14:00:00 | NVDA | Stock | 85.39 | 85.769 | 85.205 | 85.619 | 26175180.0 |
| 2024-05-02 15:00:00 | NVDA | Stock | 85.645 | 86.237 | 85.4681 | 85.816 | 40683840.0 |
| 2024-05-02 16:00:00 | NVDA | Stock | 85.817 | 86.58 | 85.68 | 86.4 | 15099440.0 |
| 2024-05-02 17:00:00 | NVDA | Stock | 86.424 | 86.684 | 86.3 | 86.335 | 1028090.0 |
| 2024-05-02 18:00:00 | NVDA | Stock | 86.4 | 86.566 | 86.31 | 86.451 | 673420.0 |
| 2024-05-02 19:00:00 | NVDA | Stock | 86.456 | 86.548 | 86.45 | 86.545 | 328220.0 |
| 2024-05-02 04:00:00 | AMZN | Stock | 180.95 | 181.57 | 180.68 | 181.31 | 49564.0 |
| 2024-05-02 05:00:00 | AMZN | Stock | 181.28 | 181.66 | 181.19 | 181.64 | 24385.0 |
> showing 50 of 58,177 rows — these rows as CSV