PREVIEW / stock_1hour / 2002-12-02
file: by_date/stock_1hour/2002/2002-12-02.parquet size: 432 KB rows: 20,393 symbols: 1,525
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-02 08:00:00 | AAPL | Stock | 0.283 | 0.2848 | 0.283 | 0.2832 | 428456.0 |
| 2002-12-02 09:00:00 | AAPL | Stock | 0.2832 | 0.2875 | 0.283 | 0.2857 | 45257856.0 |
| 2002-12-02 10:00:00 | AAPL | Stock | 0.2861 | 0.2864 | 0.2718 | 0.2725 | 80237192.0 |
| 2002-12-02 11:00:00 | AAPL | Stock | 0.2725 | 0.276 | 0.2695 | 0.2732 | 56094752.0 |
| 2002-12-02 12:00:00 | AAPL | Stock | 0.2732 | 0.276 | 0.273 | 0.2748 | 20252904.0 |
| 2002-12-02 13:00:00 | AAPL | Stock | 0.2745 | 0.275 | 0.2725 | 0.2727 | 26968648.0 |
| 2002-12-02 14:00:00 | AAPL | Stock | 0.2727 | 0.2731 | 0.2691 | 0.2711 | 52443272.0 |
| 2002-12-02 15:00:00 | AAPL | Stock | 0.2714 | 0.2721 | 0.268 | 0.2707 | 71208088.0 |
| 2002-12-02 16:00:00 | AAPL | Stock | 0.2713 | 0.2759 | 0.2682 | 0.2721 | 6372800.0 |
| 2002-12-02 17:00:00 | AAPL | Stock | 0.2721 | 0.2729 | 0.2706 | 0.2714 | 2783200.0 |
| 2002-12-02 08:00:00 | MSFT | Stock | 29.15 | 29.35 | 28.91 | 29.3 | 228542.0 |
| 2002-12-02 09:00:00 | MSFT | Stock | 29.3 | 29.45 | 29.1555 | 29.42 | 7287694.0 |
| 2002-12-02 10:00:00 | MSFT | Stock | 29.415 | 29.48 | 28.955 | 28.97 | 13156432.0 |
| 2002-12-02 11:00:00 | MSFT | Stock | 28.975 | 29.16 | 28.875 | 29.12 | 6828700.0 |
| 2002-12-02 12:00:00 | MSFT | Stock | 29.105 | 29.21 | 29.015 | 29.165 | 4772398.0 |
| 2002-12-02 13:00:00 | MSFT | Stock | 29.165 | 29.2 | 28.775 | 28.855 | 5882094.0 |
| 2002-12-02 14:00:00 | MSFT | Stock | 28.86 | 28.9 | 28.625 | 28.83 | 8474306.0 |
| 2002-12-02 15:00:00 | MSFT | Stock | 28.825 | 28.905 | 28.64 | 28.855 | 7792192.0 |
| 2002-12-02 16:00:00 | MSFT | Stock | 28.845 | 29.285 | 28.755 | 28.92 | 1758252.0 |
| 2002-12-02 17:00:00 | MSFT | Stock | 28.905 | 29.0483 | 28.7941 | 28.925 | 1349190.0 |
| 2002-12-02 18:00:00 | MSFT | Stock | 28.925 | 28.925 | 28.925 | 28.925 | 1000.0 |
| 2002-12-02 08:00:00 | NVDA | Stock | 0.1471 | 0.1499 | 0.1471 | 0.1492 | 5419920.0 |
| 2002-12-02 09:00:00 | NVDA | Stock | 0.1495 | 0.1522 | 0.1492 | 0.1504 | 202676160.0 |
| 2002-12-02 10:00:00 | NVDA | Stock | 0.1505 | 0.1507 | 0.1439 | 0.146 | 229835760.0 |
| 2002-12-02 11:00:00 | NVDA | Stock | 0.1461 | 0.1479 | 0.144 | 0.1468 | 123601320.0 |
| 2002-12-02 12:00:00 | NVDA | Stock | 0.1468 | 0.1487 | 0.1458 | 0.1482 | 72907200.0 |
| 2002-12-02 13:00:00 | NVDA | Stock | 0.1481 | 0.1483 | 0.1452 | 0.1456 | 78846840.0 |
| 2002-12-02 14:00:00 | NVDA | Stock | 0.1456 | 0.146 | 0.1427 | 0.1435 | 157340880.0 |
| 2002-12-02 15:00:00 | NVDA | Stock | 0.1435 | 0.1436 | 0.141 | 0.1422 | 179011440.0 |
| 2002-12-02 16:00:00 | NVDA | Stock | 0.1423 | 0.1492 | 0.1414 | 0.1492 | 12780240.0 |
| 2002-12-02 17:00:00 | NVDA | Stock | 0.1429 | 0.1448 | 0.1414 | 0.1448 | 3973560.0 |
| 2002-12-02 18:00:00 | NVDA | Stock | 0.1442 | 0.1442 | 0.1437 | 0.1442 | 794400.0 |
| 2002-12-02 08:00:00 | AMZN | Stock | 1.1925 | 1.2125 | 1.166 | 1.202 | 895200.0 |
| 2002-12-02 09:00:00 | AMZN | Stock | 1.2 | 1.245 | 1.1925 | 1.2435 | 30785360.0 |
| 2002-12-02 10:00:00 | AMZN | Stock | 1.2435 | 1.25 | 1.215 | 1.2235 | 45551980.0 |
| 2002-12-02 11:00:00 | AMZN | Stock | 1.2228 | 1.223 | 1.2 | 1.208 | 25658340.0 |
| 2002-12-02 12:00:00 | AMZN | Stock | 1.2085 | 1.219 | 1.2025 | 1.2155 | 13878640.0 |
| 2002-12-02 13:00:00 | AMZN | Stock | 1.2155 | 1.225 | 1.21 | 1.215 | 19328420.0 |
| 2002-12-02 14:00:00 | AMZN | Stock | 1.2155 | 1.221 | 1.2075 | 1.217 | 24627940.0 |
| 2002-12-02 15:00:00 | AMZN | Stock | 1.2165 | 1.218 | 1.204 | 1.2055 | 32362920.0 |
| 2002-12-02 16:00:00 | AMZN | Stock | 1.207 | 1.2202 | 1.1925 | 1.207 | 2477900.0 |
| 2002-12-02 17:00:00 | AMZN | Stock | 1.212 | 1.212 | 1.2034 | 1.2055 | 912000.0 |
| 2002-12-02 09:00:00 | CL | Stock | 25.7 | 25.725 | 25.5 | 25.725 | 399000.0 |
| 2002-12-02 10:00:00 | CL | Stock | 25.725 | 25.75 | 25.5 | 25.705 | 744000.0 |
| 2002-12-02 11:00:00 | CL | Stock | 25.705 | 25.715 | 25.615 | 25.65 | 397800.0 |
| 2002-12-02 12:00:00 | CL | Stock | 25.655 | 25.7 | 25.62 | 25.655 | 197200.0 |
| 2002-12-02 13:00:00 | CL | Stock | 25.635 | 25.73 | 25.615 | 25.695 | 258400.0 |
| 2002-12-02 14:00:00 | CL | Stock | 25.69 | 25.695 | 25.575 | 25.69 | 383200.0 |
| 2002-12-02 15:00:00 | CL | Stock | 25.67 | 25.705 | 25.63 | 25.63 | 367000.0 |
| 2002-12-02 16:00:00 | CL | Stock | 25.655 | 25.7 | 25.65 | 25.7 | 182200.0 |
> showing 50 of 20,393 rows — these rows as CSV