PREVIEW / stock_1hour / 2003-12-08
file: by_date/stock_1hour/2003/2003-12-08.parquet size: 502 KB rows: 23,292 symbols: 1,682
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-08 09:00:00 | AAPL | Stock | 0.3723 | 0.3732 | 0.3695 | 0.3702 | 10680488.0 |
| 2003-12-08 10:00:00 | AAPL | Stock | 0.37 | 0.3704 | 0.3664 | 0.3668 | 19280352.0 |
| 2003-12-08 11:00:00 | AAPL | Stock | 0.367 | 0.3683 | 0.3664 | 0.367 | 11712568.0 |
| 2003-12-08 12:00:00 | AAPL | Stock | 0.3668 | 0.3679 | 0.3645 | 0.3677 | 16160816.0 |
| 2003-12-08 13:00:00 | AAPL | Stock | 0.3677 | 0.3711 | 0.3668 | 0.3696 | 9011576.0 |
| 2003-12-08 14:00:00 | AAPL | Stock | 0.3696 | 0.3702 | 0.368 | 0.3689 | 16784096.0 |
| 2003-12-08 15:00:00 | AAPL | Stock | 0.3688 | 0.3764 | 0.3686 | 0.3757 | 47123496.0 |
| 2003-12-08 16:00:00 | AAPL | Stock | 0.3757 | 0.3759 | 0.3736 | 0.3753 | 1135064.0 |
| 2003-12-08 17:00:00 | AAPL | Stock | 0.3759 | 0.3759 | 0.3702 | 0.3739 | 94472.0 |
| 2003-12-08 08:00:00 | MSFT | Stock | 26.16 | 26.3 | 25.98 | 26.11 | 704562.0 |
| 2003-12-08 09:00:00 | MSFT | Stock | 26.11 | 26.19 | 26.0 | 26.14 | 11912284.0 |
| 2003-12-08 10:00:00 | MSFT | Stock | 26.14 | 26.16 | 25.87 | 25.9 | 18918030.0 |
| 2003-12-08 11:00:00 | MSFT | Stock | 25.9 | 25.99 | 25.81 | 25.979 | 12896325.0 |
| 2003-12-08 12:00:00 | MSFT | Stock | 25.98 | 26.02 | 25.82 | 26.01 | 6999220.0 |
| 2003-12-08 13:00:00 | MSFT | Stock | 26.0 | 26.03 | 25.96 | 26.0 | 8559789.0 |
| 2003-12-08 14:00:00 | MSFT | Stock | 26.0 | 26.13 | 25.96 | 26.08 | 7702266.0 |
| 2003-12-08 15:00:00 | MSFT | Stock | 26.08 | 26.34 | 26.07 | 26.24 | 19284508.0 |
| 2003-12-08 16:00:00 | MSFT | Stock | 26.25 | 26.37 | 26.059 | 26.25 | 700556.0 |
| 2003-12-08 17:00:00 | MSFT | Stock | 26.29 | 26.29 | 26.03 | 26.27 | 145028.0 |
| 2003-12-08 18:00:00 | MSFT | Stock | 26.27 | 26.27 | 26.26 | 26.26 | 4600.0 |
| 2003-12-08 08:00:00 | NVDA | Stock | 0.1704 | 0.1704 | 0.1692 | 0.1692 | 24000.0 |
| 2003-12-08 09:00:00 | NVDA | Stock | 0.1699 | 0.1731 | 0.1698 | 0.1724 | 42561000.0 |
| 2003-12-08 10:00:00 | NVDA | Stock | 0.1724 | 0.1732 | 0.1705 | 0.1706 | 45371880.0 |
| 2003-12-08 11:00:00 | NVDA | Stock | 0.1706 | 0.1716 | 0.1701 | 0.1709 | 39712800.0 |
| 2003-12-08 12:00:00 | NVDA | Stock | 0.1709 | 0.171 | 0.1699 | 0.1702 | 21225360.0 |
| 2003-12-08 13:00:00 | NVDA | Stock | 0.1703 | 0.1722 | 0.1702 | 0.1716 | 31964040.0 |
| 2003-12-08 14:00:00 | NVDA | Stock | 0.1717 | 0.1717 | 0.1687 | 0.1703 | 41931120.0 |
| 2003-12-08 15:00:00 | NVDA | Stock | 0.1703 | 0.1732 | 0.1702 | 0.1717 | 94563240.0 |
| 2003-12-08 16:00:00 | NVDA | Stock | 0.1717 | 0.1733 | 0.1715 | 0.1717 | 6149640.0 |
| 2003-12-08 17:00:00 | NVDA | Stock | 0.1722 | 0.1725 | 0.1717 | 0.1725 | 1176000.0 |
| 2003-12-08 08:00:00 | AMZN | Stock | 2.5775 | 2.58 | 2.5775 | 2.5775 | 116000.0 |
| 2003-12-08 09:00:00 | AMZN | Stock | 2.5775 | 2.61 | 2.5525 | 2.5642 | 25764460.0 |
| 2003-12-08 10:00:00 | AMZN | Stock | 2.5625 | 2.5645 | 2.506 | 2.5198 | 47857460.0 |
| 2003-12-08 11:00:00 | AMZN | Stock | 2.5205 | 2.5275 | 2.507 | 2.521 | 18348620.0 |
| 2003-12-08 12:00:00 | AMZN | Stock | 2.519 | 2.531 | 2.5075 | 2.5305 | 17018480.0 |
| 2003-12-08 13:00:00 | AMZN | Stock | 2.5305 | 2.5421 | 2.5255 | 2.5325 | 12878600.0 |
| 2003-12-08 14:00:00 | AMZN | Stock | 2.5315 | 2.534 | 2.5125 | 2.5315 | 13914620.0 |
| 2003-12-08 15:00:00 | AMZN | Stock | 2.5311 | 2.557 | 2.526 | 2.554 | 28361200.0 |
| 2003-12-08 16:00:00 | AMZN | Stock | 2.5545 | 2.555 | 2.5475 | 2.5546 | 1065520.0 |
| 2003-12-08 17:00:00 | AMZN | Stock | 2.553 | 2.555 | 2.552 | 2.552 | 293040.0 |
| 2003-12-08 18:00:00 | AMZN | Stock | 2.5545 | 2.5545 | 2.551 | 2.551 | 13000.0 |
| 2003-12-08 09:00:00 | CL | Stock | 26.9 | 26.925 | 26.83 | 26.89 | 224400.0 |
| 2003-12-08 10:00:00 | CL | Stock | 26.89 | 26.925 | 26.84 | 26.845 | 503400.0 |
| 2003-12-08 11:00:00 | CL | Stock | 26.84 | 26.86 | 26.76 | 26.79 | 422600.0 |
| 2003-12-08 12:00:00 | CL | Stock | 26.8 | 26.8 | 26.725 | 26.75 | 492000.0 |
| 2003-12-08 13:00:00 | CL | Stock | 26.755 | 26.775 | 26.595 | 26.665 | 697000.0 |
| 2003-12-08 14:00:00 | CL | Stock | 26.665 | 26.665 | 26.575 | 26.605 | 866800.0 |
| 2003-12-08 15:00:00 | CL | Stock | 26.595 | 26.815 | 26.595 | 26.765 | 1286200.0 |
| 2003-12-08 16:00:00 | CL | Stock | 26.77 | 26.795 | 26.77 | 26.795 | 114000.0 |
| 2003-12-08 17:00:00 | CL | Stock | 26.7564 | 26.7564 | 26.7564 | 26.7564 | 3400.0 |
> showing 50 of 23,292 rows — these rows as CSV