PREVIEW / stock_1hour / 2003-08-06
file: by_date/stock_1hour/2003/2003-08-06.parquet size: 458 KB rows: 22,108 symbols: 1,597
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-08-06 08:00:00 | AAPL | Stock | 0.3632 | 0.3639 | 0.3632 | 0.3639 | 112000.0 |
| 2003-08-06 09:00:00 | AAPL | Stock | 0.3627 | 0.3639 | 0.3563 | 0.3571 | 27805232.0 |
| 2003-08-06 10:00:00 | AAPL | Stock | 0.3573 | 0.3593 | 0.3482 | 0.3496 | 52597104.0 |
| 2003-08-06 11:00:00 | AAPL | Stock | 0.3496 | 0.3513 | 0.3484 | 0.35 | 27484968.0 |
| 2003-08-06 12:00:00 | AAPL | Stock | 0.35 | 0.353 | 0.35 | 0.352 | 19282648.0 |
| 2003-08-06 13:00:00 | AAPL | Stock | 0.3521 | 0.3596 | 0.3518 | 0.3543 | 25555096.0 |
| 2003-08-06 14:00:00 | AAPL | Stock | 0.3546 | 0.3573 | 0.3539 | 0.3548 | 17712016.0 |
| 2003-08-06 15:00:00 | AAPL | Stock | 0.3548 | 0.3548 | 0.3495 | 0.3511 | 46984728.0 |
| 2003-08-06 16:00:00 | AAPL | Stock | 0.3505 | 0.3516 | 0.3498 | 0.3502 | 3528000.0 |
| 2003-08-06 17:00:00 | AAPL | Stock | 0.3491 | 0.3491 | 0.3491 | 0.3491 | 61600.0 |
| 2003-08-06 08:00:00 | MSFT | Stock | 25.28 | 25.66 | 25.22 | 25.5 | 150990.0 |
| 2003-08-06 09:00:00 | MSFT | Stock | 25.5 | 25.74 | 25.39 | 25.7 | 6581885.0 |
| 2003-08-06 10:00:00 | MSFT | Stock | 25.7 | 25.82 | 25.43 | 25.77 | 11220506.0 |
| 2003-08-06 11:00:00 | MSFT | Stock | 25.78 | 25.87 | 25.59 | 25.84 | 4832798.0 |
| 2003-08-06 12:00:00 | MSFT | Stock | 25.83 | 25.99 | 25.79 | 25.89 | 4838381.0 |
| 2003-08-06 13:00:00 | MSFT | Stock | 25.89 | 26.17 | 25.88 | 26.08 | 5186646.0 |
| 2003-08-06 14:00:00 | MSFT | Stock | 26.09 | 26.19 | 26.0 | 26.05 | 5473694.0 |
| 2003-08-06 15:00:00 | MSFT | Stock | 26.04 | 26.06 | 25.64 | 25.65 | 9149324.0 |
| 2003-08-06 16:00:00 | MSFT | Stock | 25.65 | 25.76 | 25.64 | 25.71 | 2834937.0 |
| 2003-08-06 17:00:00 | MSFT | Stock | 25.71 | 25.87 | 25.65 | 25.71 | 20762.0 |
| 2003-08-06 18:00:00 | MSFT | Stock | 25.73 | 25.73 | 25.71 | 25.71 | 2500.0 |
| 2003-08-06 08:00:00 | NVDA | Stock | 0.1662 | 0.1688 | 0.1633 | 0.1687 | 825000.0 |
| 2003-08-06 09:00:00 | NVDA | Stock | 0.1662 | 0.1687 | 0.163 | 0.1644 | 139856640.0 |
| 2003-08-06 10:00:00 | NVDA | Stock | 0.1644 | 0.1646 | 0.159 | 0.1612 | 244022160.0 |
| 2003-08-06 11:00:00 | NVDA | Stock | 0.1613 | 0.1669 | 0.1613 | 0.1667 | 65066400.0 |
| 2003-08-06 12:00:00 | NVDA | Stock | 0.1665 | 0.17 | 0.1657 | 0.1662 | 136610280.0 |
| 2003-08-06 13:00:00 | NVDA | Stock | 0.1663 | 0.1686 | 0.1662 | 0.1675 | 45883200.0 |
| 2003-08-06 14:00:00 | NVDA | Stock | 0.1674 | 0.168 | 0.1658 | 0.1661 | 62556600.0 |
| 2003-08-06 15:00:00 | NVDA | Stock | 0.1661 | 0.1661 | 0.1625 | 0.1627 | 169593360.0 |
| 2003-08-06 16:00:00 | NVDA | Stock | 0.1626 | 0.1637 | 0.1624 | 0.1633 | 22817160.0 |
| 2003-08-06 17:00:00 | NVDA | Stock | 0.1633 | 0.1639 | 0.1627 | 0.1634 | 2058000.0 |
| 2003-08-06 08:00:00 | AMZN | Stock | 1.9374 | 1.939 | 1.9325 | 1.935 | 192000.0 |
| 2003-08-06 09:00:00 | AMZN | Stock | 1.937 | 1.9565 | 1.9305 | 1.948 | 18144340.0 |
| 2003-08-06 10:00:00 | AMZN | Stock | 1.948 | 1.9535 | 1.9175 | 1.9185 | 47226320.0 |
| 2003-08-06 11:00:00 | AMZN | Stock | 1.918 | 1.9405 | 1.914 | 1.9405 | 19967480.0 |
| 2003-08-06 12:00:00 | AMZN | Stock | 1.94 | 1.955 | 1.937 | 1.938 | 15813560.0 |
| 2003-08-06 13:00:00 | AMZN | Stock | 1.938 | 1.9725 | 1.9375 | 1.9665 | 15683300.0 |
| 2003-08-06 14:00:00 | AMZN | Stock | 1.9675 | 1.9735 | 1.9519 | 1.952 | 15858320.0 |
| 2003-08-06 15:00:00 | AMZN | Stock | 1.9505 | 1.959 | 1.938 | 1.9455 | 31566440.0 |
| 2003-08-06 16:00:00 | AMZN | Stock | 1.9455 | 1.9625 | 1.9455 | 1.9525 | 2578000.0 |
| 2003-08-06 17:00:00 | AMZN | Stock | 1.9525 | 1.9555 | 1.9455 | 1.9455 | 521560.0 |
| 2003-08-06 18:00:00 | AMZN | Stock | 1.948 | 1.948 | 1.948 | 1.948 | 2000.0 |
| 2003-08-06 09:00:00 | CL | Stock | 27.15 | 27.245 | 27.075 | 27.245 | 145200.0 |
| 2003-08-06 10:00:00 | CL | Stock | 27.275 | 27.425 | 27.17 | 27.34 | 287000.0 |
| 2003-08-06 11:00:00 | CL | Stock | 27.335 | 27.47 | 27.31 | 27.435 | 396000.0 |
| 2003-08-06 12:00:00 | CL | Stock | 27.4345 | 27.515 | 27.365 | 27.385 | 319800.0 |
| 2003-08-06 13:00:00 | CL | Stock | 27.39 | 27.525 | 27.385 | 27.45 | 329200.0 |
| 2003-08-06 14:00:00 | CL | Stock | 27.455 | 27.62 | 27.445 | 27.45 | 323600.0 |
| 2003-08-06 15:00:00 | CL | Stock | 27.45 | 27.49 | 27.345 | 27.415 | 557800.0 |
| 2003-08-06 16:00:00 | CL | Stock | 27.415 | 27.425 | 27.415 | 27.425 | 76600.0 |
> showing 50 of 22,108 rows — these rows as CSV