PREVIEW / stock_1hour / 2003-12-18
file: by_date/stock_1hour/2003/2003-12-18.parquet size: 507 KB rows: 24,060 symbols: 1,693
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-18 08:00:00 | AAPL | Stock | 0.3552 | 0.3554 | 0.3552 | 0.3554 | 61600.0 |
| 2003-12-18 09:00:00 | AAPL | Stock | 0.3555 | 0.3589 | 0.3554 | 0.3584 | 49532280.0 |
| 2003-12-18 10:00:00 | AAPL | Stock | 0.3582 | 0.3584 | 0.3564 | 0.3571 | 58262120.0 |
| 2003-12-18 11:00:00 | AAPL | Stock | 0.3571 | 0.3575 | 0.3564 | 0.3575 | 40213320.0 |
| 2003-12-18 12:00:00 | AAPL | Stock | 0.3575 | 0.3582 | 0.3573 | 0.3579 | 33866112.0 |
| 2003-12-18 13:00:00 | AAPL | Stock | 0.3579 | 0.3591 | 0.3575 | 0.3585 | 26757752.0 |
| 2003-12-18 14:00:00 | AAPL | Stock | 0.3584 | 0.3596 | 0.3579 | 0.3589 | 36155392.0 |
| 2003-12-18 15:00:00 | AAPL | Stock | 0.3591 | 0.36 | 0.3571 | 0.3579 | 61709592.0 |
| 2003-12-18 16:00:00 | AAPL | Stock | 0.358 | 0.3588 | 0.3579 | 0.3579 | 8008504.0 |
| 2003-12-18 17:00:00 | AAPL | Stock | 0.3579 | 0.3579 | 0.3579 | 0.3579 | 95200.0 |
| 2003-12-18 08:00:00 | MSFT | Stock | 27.045 | 27.14 | 27.045 | 27.14 | 33248.0 |
| 2003-12-18 09:00:00 | MSFT | Stock | 27.11 | 27.35 | 27.06 | 27.29 | 8023186.0 |
| 2003-12-18 10:00:00 | MSFT | Stock | 27.3 | 27.4 | 27.269 | 27.39 | 12838796.0 |
| 2003-12-18 11:00:00 | MSFT | Stock | 27.39 | 27.4 | 27.25 | 27.32 | 6373606.0 |
| 2003-12-18 12:00:00 | MSFT | Stock | 27.32 | 27.32 | 27.23 | 27.26 | 4397357.0 |
| 2003-12-18 13:00:00 | MSFT | Stock | 27.26 | 27.33 | 27.2 | 27.23 | 5226781.0 |
| 2003-12-18 14:00:00 | MSFT | Stock | 27.23 | 27.37 | 27.22 | 27.35 | 7358271.0 |
| 2003-12-18 15:00:00 | MSFT | Stock | 27.35 | 27.42 | 27.22 | 27.42 | 12061028.0 |
| 2003-12-18 16:00:00 | MSFT | Stock | 27.42 | 27.45 | 27.33 | 27.43 | 2545960.0 |
| 2003-12-18 17:00:00 | MSFT | Stock | 27.33 | 27.43 | 27.1467 | 27.34 | 22140.0 |
| 2003-12-18 18:00:00 | MSFT | Stock | 27.35 | 27.35 | 27.3 | 27.34 | 5300.0 |
| 2003-12-18 08:00:00 | NVDA | Stock | 0.1692 | 0.1692 | 0.1692 | 0.1692 | 48000.0 |
| 2003-12-18 09:00:00 | NVDA | Stock | 0.1716 | 0.1716 | 0.1693 | 0.1708 | 62038560.0 |
| 2003-12-18 10:00:00 | NVDA | Stock | 0.1709 | 0.1731 | 0.1702 | 0.1729 | 81771600.0 |
| 2003-12-18 11:00:00 | NVDA | Stock | 0.173 | 0.173 | 0.1721 | 0.1724 | 32066760.0 |
| 2003-12-18 12:00:00 | NVDA | Stock | 0.1724 | 0.173 | 0.1721 | 0.1727 | 39311520.0 |
| 2003-12-18 13:00:00 | NVDA | Stock | 0.1727 | 0.1745 | 0.1727 | 0.173 | 50304960.0 |
| 2003-12-18 14:00:00 | NVDA | Stock | 0.1731 | 0.1747 | 0.173 | 0.1745 | 35179320.0 |
| 2003-12-18 15:00:00 | NVDA | Stock | 0.1745 | 0.1747 | 0.1726 | 0.1727 | 120329160.0 |
| 2003-12-18 16:00:00 | NVDA | Stock | 0.1733 | 0.1735 | 0.1725 | 0.1732 | 5348880.0 |
| 2003-12-18 17:00:00 | NVDA | Stock | 0.1732 | 0.1737 | 0.1732 | 0.1737 | 1800000.0 |
| 2003-12-18 08:00:00 | AMZN | Stock | 2.381 | 2.395 | 2.381 | 2.395 | 168000.0 |
| 2003-12-18 09:00:00 | AMZN | Stock | 2.39 | 2.417 | 2.3805 | 2.3975 | 33184860.0 |
| 2003-12-18 10:00:00 | AMZN | Stock | 2.3975 | 2.4 | 2.3725 | 2.3895 | 49591380.0 |
| 2003-12-18 11:00:00 | AMZN | Stock | 2.3895 | 2.398 | 2.3845 | 2.3926 | 25360980.0 |
| 2003-12-18 12:00:00 | AMZN | Stock | 2.3925 | 2.404 | 2.3835 | 2.4005 | 23623560.0 |
| 2003-12-18 13:00:00 | AMZN | Stock | 2.402 | 2.4135 | 2.4 | 2.4115 | 20820220.0 |
| 2003-12-18 14:00:00 | AMZN | Stock | 2.412 | 2.4415 | 2.4085 | 2.4415 | 24993600.0 |
| 2003-12-18 15:00:00 | AMZN | Stock | 2.4405 | 2.4445 | 2.4205 | 2.4355 | 31271680.0 |
| 2003-12-18 16:00:00 | AMZN | Stock | 2.4345 | 2.4375 | 2.4315 | 2.435 | 1194860.0 |
| 2003-12-18 17:00:00 | AMZN | Stock | 2.436 | 2.4365 | 2.4355 | 2.436 | 29500.0 |
| 2003-12-18 18:00:00 | AMZN | Stock | 2.4365 | 2.44 | 2.4365 | 2.44 | 522960.0 |
| 2003-12-18 09:00:00 | CL | Stock | 26.25 | 26.325 | 25.995 | 26.025 | 2472400.0 |
| 2003-12-18 10:00:00 | CL | Stock | 26.025 | 26.0255 | 25.335 | 25.42 | 6305400.0 |
| 2003-12-18 11:00:00 | CL | Stock | 25.425 | 25.425 | 24.925 | 25.015 | 6460800.0 |
| 2003-12-18 12:00:00 | CL | Stock | 25.02 | 25.35 | 25.0 | 25.195 | 4771200.0 |
| 2003-12-18 13:00:00 | CL | Stock | 25.195 | 25.245 | 25.05 | 25.055 | 1763600.0 |
| 2003-12-18 14:00:00 | CL | Stock | 25.055 | 25.08 | 24.95 | 25.065 | 3361200.0 |
| 2003-12-18 15:00:00 | CL | Stock | 25.05 | 25.345 | 25.04 | 25.235 | 5532200.0 |
| 2003-12-18 16:00:00 | CL | Stock | 25.225 | 25.235 | 25.1478 | 25.155 | 467200.0 |
> showing 50 of 24,060 rows — these rows as CSV