PREVIEW / stock_1hour / 2003-12-22
file: by_date/stock_1hour/2003/2003-12-22.parquet size: 496 KB rows: 23,324 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-22 08:00:00 | AAPL | Stock | 0.3509 | 0.3518 | 0.3509 | 0.3514 | 145600.0 |
| 2003-12-22 09:00:00 | AAPL | Stock | 0.3514 | 0.3516 | 0.3438 | 0.35 | 50545040.0 |
| 2003-12-22 10:00:00 | AAPL | Stock | 0.35 | 0.3539 | 0.3496 | 0.3534 | 56677432.0 |
| 2003-12-22 11:00:00 | AAPL | Stock | 0.3534 | 0.3534 | 0.3509 | 0.3521 | 65639672.0 |
| 2003-12-22 12:00:00 | AAPL | Stock | 0.3521 | 0.3525 | 0.3486 | 0.3507 | 25783128.0 |
| 2003-12-22 13:00:00 | AAPL | Stock | 0.3509 | 0.3525 | 0.35 | 0.3521 | 18621008.0 |
| 2003-12-22 14:00:00 | AAPL | Stock | 0.3523 | 0.3536 | 0.3505 | 0.3536 | 20562360.0 |
| 2003-12-22 15:00:00 | AAPL | Stock | 0.3538 | 0.3552 | 0.353 | 0.3543 | 85282008.0 |
| 2003-12-22 16:00:00 | AAPL | Stock | 0.3543 | 0.3545 | 0.3503 | 0.353 | 2891224.0 |
| 2003-12-22 17:00:00 | AAPL | Stock | 0.3543 | 0.3543 | 0.352 | 0.352 | 166768.0 |
| 2003-12-22 08:00:00 | MSFT | Stock | 27.2 | 27.28 | 27.1 | 27.2 | 28922.0 |
| 2003-12-22 09:00:00 | MSFT | Stock | 27.2 | 27.43 | 27.11 | 27.34 | 5840965.0 |
| 2003-12-22 10:00:00 | MSFT | Stock | 27.349 | 27.39 | 27.12 | 27.18 | 5676496.0 |
| 2003-12-22 11:00:00 | MSFT | Stock | 27.18 | 27.19 | 27.01 | 27.07 | 7086269.0 |
| 2003-12-22 12:00:00 | MSFT | Stock | 27.07 | 27.09 | 27.0 | 27.05 | 3844792.0 |
| 2003-12-22 13:00:00 | MSFT | Stock | 27.041 | 27.12 | 27.02 | 27.09 | 3494622.0 |
| 2003-12-22 14:00:00 | MSFT | Stock | 27.09 | 27.1 | 26.97 | 27.06 | 7297856.0 |
| 2003-12-22 15:00:00 | MSFT | Stock | 27.06 | 27.19 | 27.03 | 27.19 | 8180132.0 |
| 2003-12-22 16:00:00 | MSFT | Stock | 27.18 | 27.25 | 27.08 | 27.17 | 863717.0 |
| 2003-12-22 17:00:00 | MSFT | Stock | 27.18 | 27.2 | 27.15 | 27.19 | 60799.0 |
| 2003-12-22 18:00:00 | MSFT | Stock | 27.19 | 27.3514 | 27.18 | 27.18 | 3250.0 |
| 2003-12-22 08:00:00 | NVDA | Stock | 0.1738 | 0.174 | 0.1729 | 0.1732 | 600000.0 |
| 2003-12-22 09:00:00 | NVDA | Stock | 0.1732 | 0.1762 | 0.1712 | 0.1752 | 78850920.0 |
| 2003-12-22 10:00:00 | NVDA | Stock | 0.1752 | 0.1752 | 0.1724 | 0.1732 | 66782640.0 |
| 2003-12-22 11:00:00 | NVDA | Stock | 0.1733 | 0.1742 | 0.1726 | 0.174 | 26140560.0 |
| 2003-12-22 12:00:00 | NVDA | Stock | 0.174 | 0.174 | 0.1729 | 0.1733 | 19385640.0 |
| 2003-12-22 13:00:00 | NVDA | Stock | 0.1733 | 0.1741 | 0.1732 | 0.1734 | 30086160.0 |
| 2003-12-22 14:00:00 | NVDA | Stock | 0.1735 | 0.1737 | 0.1726 | 0.1733 | 28248120.0 |
| 2003-12-22 15:00:00 | NVDA | Stock | 0.1733 | 0.1758 | 0.1732 | 0.1757 | 90905160.0 |
| 2003-12-22 16:00:00 | NVDA | Stock | 0.1757 | 0.1758 | 0.1742 | 0.1755 | 14264520.0 |
| 2003-12-22 17:00:00 | NVDA | Stock | 0.1758 | 0.1758 | 0.1741 | 0.1758 | 115680.0 |
| 2003-12-22 08:00:00 | AMZN | Stock | 2.4574 | 2.4575 | 2.4574 | 2.4575 | 42000.0 |
| 2003-12-22 09:00:00 | AMZN | Stock | 2.4525 | 2.5 | 2.435 | 2.494 | 31152500.0 |
| 2003-12-22 10:00:00 | AMZN | Stock | 2.494 | 2.5025 | 2.4585 | 2.4793 | 29822880.0 |
| 2003-12-22 11:00:00 | AMZN | Stock | 2.4795 | 2.4935 | 2.4765 | 2.4925 | 21514100.0 |
| 2003-12-22 12:00:00 | AMZN | Stock | 2.4925 | 2.4935 | 2.461 | 2.462 | 16206500.0 |
| 2003-12-22 13:00:00 | AMZN | Stock | 2.463 | 2.4795 | 2.459 | 2.478 | 11244560.0 |
| 2003-12-22 14:00:00 | AMZN | Stock | 2.478 | 2.4915 | 2.47 | 2.48 | 15303200.0 |
| 2003-12-22 15:00:00 | AMZN | Stock | 2.48 | 2.505 | 2.475 | 2.4955 | 25563400.0 |
| 2003-12-22 16:00:00 | AMZN | Stock | 2.4955 | 2.4965 | 2.49 | 2.494 | 742620.0 |
| 2003-12-22 17:00:00 | AMZN | Stock | 2.4925 | 2.4945 | 2.492 | 2.4945 | 203520.0 |
| 2003-12-22 09:00:00 | CL | Stock | 24.6 | 24.92 | 24.59 | 24.9 | 1117200.0 |
| 2003-12-22 10:00:00 | CL | Stock | 24.9 | 24.945 | 24.75 | 24.755 | 1639200.0 |
| 2003-12-22 11:00:00 | CL | Stock | 24.765 | 24.765 | 24.55 | 24.69 | 1209400.0 |
| 2003-12-22 12:00:00 | CL | Stock | 24.695 | 24.695 | 24.5 | 24.52 | 996400.0 |
| 2003-12-22 13:00:00 | CL | Stock | 24.51 | 24.55 | 24.46 | 24.53 | 1209800.0 |
| 2003-12-22 14:00:00 | CL | Stock | 24.535 | 24.58 | 24.48 | 24.5 | 1043600.0 |
| 2003-12-22 15:00:00 | CL | Stock | 24.5 | 24.625 | 24.46 | 24.56 | 1651800.0 |
| 2003-12-22 16:00:00 | CL | Stock | 24.56 | 24.85 | 24.56 | 24.565 | 566800.0 |
| 2003-12-22 17:00:00 | CL | Stock | 24.565 | 24.565 | 24.565 | 24.565 | 4200.0 |
> showing 50 of 23,324 rows — these rows as CSV