PREVIEW / stock_1hour / 2003-12-12
file: by_date/stock_1hour/2003/2003-12-12.parquet size: 489 KB rows: 22,746 symbols: 1,688
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-12 08:00:00 | AAPL | Stock | 0.3787 | 0.3788 | 0.3782 | 0.3788 | 4099760.0 |
| 2003-12-12 09:00:00 | AAPL | Stock | 0.3782 | 0.3807 | 0.3725 | 0.3725 | 24600072.0 |
| 2003-12-12 10:00:00 | AAPL | Stock | 0.3723 | 0.3725 | 0.3696 | 0.3716 | 54255376.0 |
| 2003-12-12 11:00:00 | AAPL | Stock | 0.3714 | 0.3723 | 0.3713 | 0.372 | 13905024.0 |
| 2003-12-12 12:00:00 | AAPL | Stock | 0.372 | 0.3725 | 0.3714 | 0.3718 | 9947728.0 |
| 2003-12-12 13:00:00 | AAPL | Stock | 0.3716 | 0.3721 | 0.3705 | 0.3716 | 11337312.0 |
| 2003-12-12 14:00:00 | AAPL | Stock | 0.3714 | 0.3729 | 0.3707 | 0.3721 | 24343088.0 |
| 2003-12-12 15:00:00 | AAPL | Stock | 0.3723 | 0.3742 | 0.3718 | 0.3739 | 42596456.0 |
| 2003-12-12 16:00:00 | AAPL | Stock | 0.3739 | 0.3741 | 0.3727 | 0.3732 | 4351312.0 |
| 2003-12-12 17:00:00 | AAPL | Stock | 0.3732 | 0.3732 | 0.3732 | 0.3732 | 407680.0 |
| 2003-12-12 08:00:00 | MSFT | Stock | 26.68 | 26.72 | 26.61 | 26.68 | 86114.0 |
| 2003-12-12 09:00:00 | MSFT | Stock | 26.68 | 26.72 | 26.519 | 26.56 | 8453471.0 |
| 2003-12-12 10:00:00 | MSFT | Stock | 26.54 | 26.62 | 26.5 | 26.57 | 10978151.0 |
| 2003-12-12 11:00:00 | MSFT | Stock | 26.56 | 26.62 | 26.55 | 26.6 | 9504263.0 |
| 2003-12-12 12:00:00 | MSFT | Stock | 26.6 | 26.67 | 26.58 | 26.59 | 7082386.0 |
| 2003-12-12 13:00:00 | MSFT | Stock | 26.6 | 26.74 | 26.59 | 26.691 | 10429297.0 |
| 2003-12-12 14:00:00 | MSFT | Stock | 26.699 | 26.76 | 26.66 | 26.71 | 7695957.0 |
| 2003-12-12 15:00:00 | MSFT | Stock | 26.71 | 26.81 | 26.65 | 26.67 | 12106352.0 |
| 2003-12-12 16:00:00 | MSFT | Stock | 26.66 | 26.71 | 26.64 | 26.7 | 827703.0 |
| 2003-12-12 17:00:00 | MSFT | Stock | 26.7 | 26.7 | 26.66 | 26.67 | 66574.0 |
| 2003-12-12 18:00:00 | MSFT | Stock | 26.67 | 26.68 | 26.66 | 26.66 | 3534.0 |
| 2003-12-12 08:00:00 | NVDA | Stock | 0.1762 | 0.1768 | 0.175 | 0.1767 | 414000.0 |
| 2003-12-12 09:00:00 | NVDA | Stock | 0.1754 | 0.1781 | 0.1725 | 0.1725 | 94983240.0 |
| 2003-12-12 10:00:00 | NVDA | Stock | 0.1725 | 0.1755 | 0.1723 | 0.1742 | 132749040.0 |
| 2003-12-12 11:00:00 | NVDA | Stock | 0.1742 | 0.1752 | 0.1737 | 0.1742 | 56731920.0 |
| 2003-12-12 12:00:00 | NVDA | Stock | 0.1742 | 0.1752 | 0.172 | 0.1733 | 76086000.0 |
| 2003-12-12 13:00:00 | NVDA | Stock | 0.1733 | 0.1737 | 0.1713 | 0.1721 | 65819400.0 |
| 2003-12-12 14:00:00 | NVDA | Stock | 0.1721 | 0.1736 | 0.1708 | 0.1732 | 111055680.0 |
| 2003-12-12 15:00:00 | NVDA | Stock | 0.1733 | 0.1752 | 0.1728 | 0.1737 | 140385600.0 |
| 2003-12-12 16:00:00 | NVDA | Stock | 0.1737 | 0.1738 | 0.1729 | 0.1729 | 15349200.0 |
| 2003-12-12 17:00:00 | NVDA | Stock | 0.173 | 0.1737 | 0.173 | 0.1737 | 395520.0 |
| 2003-12-12 08:00:00 | AMZN | Stock | 2.54 | 2.5625 | 2.54 | 2.56 | 46000.0 |
| 2003-12-12 09:00:00 | AMZN | Stock | 2.5575 | 2.5625 | 2.502 | 2.505 | 18488900.0 |
| 2003-12-12 10:00:00 | AMZN | Stock | 2.5035 | 2.5225 | 2.496 | 2.5045 | 25124440.0 |
| 2003-12-12 11:00:00 | AMZN | Stock | 2.5045 | 2.55 | 2.499 | 2.5445 | 16586400.0 |
| 2003-12-12 12:00:00 | AMZN | Stock | 2.5437 | 2.5655 | 2.537 | 2.5376 | 17735560.0 |
| 2003-12-12 13:00:00 | AMZN | Stock | 2.538 | 2.5415 | 2.5115 | 2.514 | 10085300.0 |
| 2003-12-12 14:00:00 | AMZN | Stock | 2.5145 | 2.5365 | 2.509 | 2.531 | 10131420.0 |
| 2003-12-12 15:00:00 | AMZN | Stock | 2.5318 | 2.55 | 2.528 | 2.541 | 20800040.0 |
| 2003-12-12 16:00:00 | AMZN | Stock | 2.5455 | 2.5495 | 2.538 | 2.5425 | 2944820.0 |
| 2003-12-12 17:00:00 | AMZN | Stock | 2.548 | 2.548 | 2.5455 | 2.548 | 125480.0 |
| 2003-12-12 18:00:00 | AMZN | Stock | 2.543 | 2.543 | 2.543 | 2.543 | 2000.0 |
| 2003-12-12 09:00:00 | CL | Stock | 26.475 | 26.475 | 26.335 | 26.355 | 370600.0 |
| 2003-12-12 10:00:00 | CL | Stock | 26.355 | 26.465 | 26.345 | 26.435 | 536800.0 |
| 2003-12-12 11:00:00 | CL | Stock | 26.445 | 26.635 | 26.435 | 26.595 | 434400.0 |
| 2003-12-12 12:00:00 | CL | Stock | 26.595 | 26.81 | 26.59 | 26.72 | 356600.0 |
| 2003-12-12 13:00:00 | CL | Stock | 26.715 | 26.825 | 26.695 | 26.795 | 270400.0 |
| 2003-12-12 14:00:00 | CL | Stock | 26.795 | 26.84 | 26.74 | 26.81 | 383600.0 |
| 2003-12-12 15:00:00 | CL | Stock | 26.81 | 26.925 | 26.75 | 26.805 | 868000.0 |
| 2003-12-12 16:00:00 | CL | Stock | 26.805 | 26.855 | 26.805 | 26.855 | 121400.0 |
> showing 50 of 22,746 rows — these rows as CSV