PREVIEW / stock_1hour / 2003-12-17
file: by_date/stock_1hour/2003/2003-12-17.parquet size: 493 KB rows: 23,024 symbols: 1,701
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-17 08:00:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.3588 | 0.3589 | 3108000.0 |
| 2003-12-17 09:00:00 | AAPL | Stock | 0.3589 | 0.3591 | 0.3536 | 0.3551 | 32940320.0 |
| 2003-12-17 10:00:00 | AAPL | Stock | 0.3552 | 0.3571 | 0.3534 | 0.3559 | 35752472.0 |
| 2003-12-17 11:00:00 | AAPL | Stock | 0.3559 | 0.3595 | 0.355 | 0.3566 | 40783736.0 |
| 2003-12-17 12:00:00 | AAPL | Stock | 0.3564 | 0.3568 | 0.3545 | 0.3546 | 16954672.0 |
| 2003-12-17 13:00:00 | AAPL | Stock | 0.3546 | 0.3563 | 0.3545 | 0.355 | 22908256.0 |
| 2003-12-17 14:00:00 | AAPL | Stock | 0.3552 | 0.3577 | 0.3548 | 0.3552 | 32055632.0 |
| 2003-12-17 15:00:00 | AAPL | Stock | 0.3552 | 0.3564 | 0.3543 | 0.355 | 50940848.0 |
| 2003-12-17 16:00:00 | AAPL | Stock | 0.3559 | 0.3584 | 0.3545 | 0.3552 | 18417000.0 |
| 2003-12-17 17:00:00 | AAPL | Stock | 0.3552 | 0.3552 | 0.3552 | 0.3552 | 5600.0 |
| 2003-12-17 08:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.0 | 27.04 | 51210.0 |
| 2003-12-17 09:00:00 | MSFT | Stock | 27.06 | 27.14 | 26.92 | 27.01 | 6297810.0 |
| 2003-12-17 10:00:00 | MSFT | Stock | 27.01 | 27.04 | 26.92 | 26.98 | 7920524.0 |
| 2003-12-17 11:00:00 | MSFT | Stock | 26.97 | 27.03 | 26.95 | 26.96 | 5725229.0 |
| 2003-12-17 12:00:00 | MSFT | Stock | 26.96 | 27.0 | 26.94 | 26.96 | 5779343.0 |
| 2003-12-17 13:00:00 | MSFT | Stock | 26.95 | 26.97 | 26.85 | 26.89 | 5137272.0 |
| 2003-12-17 14:00:00 | MSFT | Stock | 26.88 | 26.98 | 26.88 | 26.95 | 5786527.0 |
| 2003-12-17 15:00:00 | MSFT | Stock | 26.95 | 27.07 | 26.91 | 27.05 | 11880847.0 |
| 2003-12-17 16:00:00 | MSFT | Stock | 27.04 | 27.16 | 27.0189 | 27.02 | 1168805.0 |
| 2003-12-17 17:00:00 | MSFT | Stock | 27.13 | 27.15 | 27.04 | 27.14 | 28256.0 |
| 2003-12-17 18:00:00 | MSFT | Stock | 27.13 | 27.13 | 27.05 | 27.11 | 17200.0 |
| 2003-12-17 09:00:00 | NVDA | Stock | 0.1725 | 0.1725 | 0.1663 | 0.1684 | 120905400.0 |
| 2003-12-17 10:00:00 | NVDA | Stock | 0.1684 | 0.1706 | 0.1676 | 0.1695 | 95936640.0 |
| 2003-12-17 11:00:00 | NVDA | Stock | 0.1692 | 0.1711 | 0.1685 | 0.17 | 47429400.0 |
| 2003-12-17 12:00:00 | NVDA | Stock | 0.1699 | 0.17 | 0.1675 | 0.1679 | 31330200.0 |
| 2003-12-17 13:00:00 | NVDA | Stock | 0.1679 | 0.1683 | 0.1667 | 0.167 | 44646480.0 |
| 2003-12-17 14:00:00 | NVDA | Stock | 0.167 | 0.1698 | 0.1669 | 0.1685 | 66316440.0 |
| 2003-12-17 15:00:00 | NVDA | Stock | 0.1685 | 0.1697 | 0.1681 | 0.1695 | 67211400.0 |
| 2003-12-17 16:00:00 | NVDA | Stock | 0.1693 | 0.1702 | 0.1687 | 0.1691 | 7759200.0 |
| 2003-12-17 08:00:00 | AMZN | Stock | 2.4745 | 2.4745 | 2.455 | 2.4625 | 83000.0 |
| 2003-12-17 09:00:00 | AMZN | Stock | 2.472 | 2.4805 | 2.425 | 2.4302 | 28865040.0 |
| 2003-12-17 10:00:00 | AMZN | Stock | 2.433 | 2.4405 | 2.391 | 2.4198 | 58256240.0 |
| 2003-12-17 11:00:00 | AMZN | Stock | 2.42 | 2.4255 | 2.395 | 2.4046 | 33261260.0 |
| 2003-12-17 12:00:00 | AMZN | Stock | 2.4045 | 2.41 | 2.378 | 2.3825 | 28349240.0 |
| 2003-12-17 13:00:00 | AMZN | Stock | 2.3825 | 2.3895 | 2.35 | 2.351 | 34832340.0 |
| 2003-12-17 14:00:00 | AMZN | Stock | 2.35 | 2.392 | 2.35 | 2.3795 | 38145300.0 |
| 2003-12-17 15:00:00 | AMZN | Stock | 2.38 | 2.3858 | 2.3575 | 2.3755 | 45682140.0 |
| 2003-12-17 16:00:00 | AMZN | Stock | 2.3795 | 2.381 | 2.3665 | 2.37 | 1953240.0 |
| 2003-12-17 17:00:00 | AMZN | Stock | 2.366 | 2.376 | 2.365 | 2.375 | 602340.0 |
| 2003-12-17 18:00:00 | AMZN | Stock | 2.375 | 2.375 | 2.3655 | 2.3655 | 7548000.0 |
| 2003-12-17 09:00:00 | CL | Stock | 26.65 | 26.8 | 26.6 | 26.75 | 867200.0 |
| 2003-12-17 10:00:00 | CL | Stock | 26.765 | 26.85 | 26.75 | 26.8 | 1247200.0 |
| 2003-12-17 11:00:00 | CL | Stock | 26.8 | 26.86 | 26.645 | 26.65 | 1087200.0 |
| 2003-12-17 12:00:00 | CL | Stock | 26.65 | 26.8 | 26.65 | 26.75 | 677000.0 |
| 2003-12-17 13:00:00 | CL | Stock | 26.755 | 26.765 | 26.7 | 26.71 | 279400.0 |
| 2003-12-17 14:00:00 | CL | Stock | 26.715 | 26.87 | 26.71 | 26.82 | 665600.0 |
| 2003-12-17 15:00:00 | CL | Stock | 26.82 | 26.96 | 26.78 | 26.935 | 786400.0 |
| 2003-12-17 16:00:00 | CL | Stock | 26.935 | 26.94 | 26.935 | 26.94 | 161400.0 |
| 2003-12-17 17:00:00 | CL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 2400.0 |
| 2003-12-17 18:00:00 | CL | Stock | 26.94 | 26.94 | 26.94 | 26.94 | 71400.0 |
> showing 50 of 23,024 rows — these rows as CSV