PREVIEW / stock_1hour / 2003-12-16
file: by_date/stock_1hour/2003/2003-12-16.parquet size: 505 KB rows: 23,533 symbols: 1,696
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-16 09:00:00 | AAPL | Stock | 0.3598 | 0.3641 | 0.358 | 0.3623 | 26033728.0 |
| 2003-12-16 10:00:00 | AAPL | Stock | 0.3623 | 0.3659 | 0.3611 | 0.363 | 35581224.0 |
| 2003-12-16 11:00:00 | AAPL | Stock | 0.3632 | 0.3636 | 0.36 | 0.3629 | 22686328.0 |
| 2003-12-16 12:00:00 | AAPL | Stock | 0.3627 | 0.3629 | 0.3602 | 0.3607 | 44338392.0 |
| 2003-12-16 13:00:00 | AAPL | Stock | 0.3605 | 0.3613 | 0.3588 | 0.3593 | 31586968.0 |
| 2003-12-16 14:00:00 | AAPL | Stock | 0.3595 | 0.3607 | 0.3573 | 0.3605 | 82828088.0 |
| 2003-12-16 15:00:00 | AAPL | Stock | 0.3604 | 0.3605 | 0.3582 | 0.3588 | 58643648.0 |
| 2003-12-16 16:00:00 | AAPL | Stock | 0.3589 | 0.3596 | 0.3429 | 0.3579 | 29557864.0 |
| 2003-12-16 17:00:00 | AAPL | Stock | 0.3593 | 0.3593 | 0.3589 | 0.3589 | 140000.0 |
| 2003-12-16 08:00:00 | MSFT | Stock | 26.76 | 26.94 | 26.7 | 26.79 | 108700.0 |
| 2003-12-16 09:00:00 | MSFT | Stock | 26.78 | 27.02 | 26.75 | 27.0 | 9404471.0 |
| 2003-12-16 10:00:00 | MSFT | Stock | 27.0 | 27.1 | 26.91 | 26.98 | 12886798.0 |
| 2003-12-16 11:00:00 | MSFT | Stock | 26.98 | 27.081 | 26.92 | 27.04 | 8787178.0 |
| 2003-12-16 12:00:00 | MSFT | Stock | 27.04 | 27.05 | 26.91 | 26.96 | 8295023.0 |
| 2003-12-16 13:00:00 | MSFT | Stock | 26.96 | 27.07 | 26.94 | 26.99 | 9945495.0 |
| 2003-12-16 14:00:00 | MSFT | Stock | 26.99 | 27.1 | 26.97 | 27.09 | 8685798.0 |
| 2003-12-16 15:00:00 | MSFT | Stock | 27.1 | 27.16 | 26.98 | 27.08 | 11851379.0 |
| 2003-12-16 16:00:00 | MSFT | Stock | 27.07 | 27.1 | 27.04 | 27.07 | 997014.0 |
| 2003-12-16 17:00:00 | MSFT | Stock | 27.06 | 27.07 | 27.0084 | 27.0085 | 160433.0 |
| 2003-12-16 18:00:00 | MSFT | Stock | 27.06 | 27.07 | 27.05 | 27.07 | 4000.0 |
| 2003-12-16 08:00:00 | NVDA | Stock | 0.1707 | 0.1707 | 0.1697 | 0.17 | 287400.0 |
| 2003-12-16 09:00:00 | NVDA | Stock | 0.17 | 0.1715 | 0.1681 | 0.1684 | 73300080.0 |
| 2003-12-16 10:00:00 | NVDA | Stock | 0.1684 | 0.1699 | 0.1674 | 0.169 | 91909920.0 |
| 2003-12-16 11:00:00 | NVDA | Stock | 0.1688 | 0.169 | 0.1662 | 0.1683 | 125388000.0 |
| 2003-12-16 12:00:00 | NVDA | Stock | 0.1683 | 0.1687 | 0.1671 | 0.1682 | 32391360.0 |
| 2003-12-16 13:00:00 | NVDA | Stock | 0.1682 | 0.171 | 0.1675 | 0.1697 | 78702240.0 |
| 2003-12-16 14:00:00 | NVDA | Stock | 0.1697 | 0.1735 | 0.1692 | 0.1732 | 94289400.0 |
| 2003-12-16 15:00:00 | NVDA | Stock | 0.1731 | 0.1736 | 0.1716 | 0.1725 | 69697560.0 |
| 2003-12-16 16:00:00 | NVDA | Stock | 0.1725 | 0.1729 | 0.1717 | 0.1725 | 6895440.0 |
| 2003-12-16 17:00:00 | NVDA | Stock | 0.1722 | 0.1725 | 0.1722 | 0.1722 | 468720.0 |
| 2003-12-16 08:00:00 | AMZN | Stock | 2.4815 | 2.5025 | 2.474 | 2.4975 | 428000.0 |
| 2003-12-16 09:00:00 | AMZN | Stock | 2.485 | 2.4975 | 2.4315 | 2.4385 | 41732780.0 |
| 2003-12-16 10:00:00 | AMZN | Stock | 2.44 | 2.485 | 2.434 | 2.4486 | 51541420.0 |
| 2003-12-16 11:00:00 | AMZN | Stock | 2.45 | 2.472 | 2.435 | 2.4601 | 23644200.0 |
| 2003-12-16 12:00:00 | AMZN | Stock | 2.4615 | 2.4615 | 2.4405 | 2.4495 | 16801460.0 |
| 2003-12-16 13:00:00 | AMZN | Stock | 2.4495 | 2.464 | 2.44 | 2.4455 | 18347480.0 |
| 2003-12-16 14:00:00 | AMZN | Stock | 2.445 | 2.4705 | 2.44 | 2.4705 | 23583000.0 |
| 2003-12-16 15:00:00 | AMZN | Stock | 2.469 | 2.4802 | 2.451 | 2.4735 | 27481480.0 |
| 2003-12-16 16:00:00 | AMZN | Stock | 2.4765 | 2.482 | 2.474 | 2.4775 | 1774780.0 |
| 2003-12-16 17:00:00 | AMZN | Stock | 2.4765 | 2.478 | 2.475 | 2.478 | 305160.0 |
| 2003-12-16 18:00:00 | AMZN | Stock | 2.477 | 2.477 | 2.477 | 2.477 | 12000.0 |
| 2003-12-16 09:00:00 | CL | Stock | 26.785 | 26.855 | 26.715 | 26.81 | 355200.0 |
| 2003-12-16 10:00:00 | CL | Stock | 26.815 | 26.82 | 26.595 | 26.61 | 493800.0 |
| 2003-12-16 11:00:00 | CL | Stock | 26.61 | 26.615 | 26.525 | 26.555 | 764000.0 |
| 2003-12-16 12:00:00 | CL | Stock | 26.55 | 26.58 | 26.465 | 26.485 | 597600.0 |
| 2003-12-16 13:00:00 | CL | Stock | 26.485 | 26.64 | 26.455 | 26.6 | 684800.0 |
| 2003-12-16 14:00:00 | CL | Stock | 26.605 | 26.73 | 26.585 | 26.71 | 764200.0 |
| 2003-12-16 15:00:00 | CL | Stock | 26.715 | 26.715 | 26.54 | 26.6 | 1361200.0 |
| 2003-12-16 16:00:00 | CL | Stock | 26.6 | 26.6 | 26.58 | 26.58 | 286400.0 |
| 2003-12-16 17:00:00 | CL | Stock | 26.58 | 26.58 | 26.58 | 26.58 | 400.0 |
> showing 50 of 23,533 rows — these rows as CSV