PREVIEW / stock_1hour / 2004-03-22
file: by_date/stock_1hour/2004/2004-03-22.parquet size: 526 KB rows: 24,600 symbols: 1,745
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-22 08:00:00 | AAPL | Stock | 0.4555 | 0.462 | 0.4482 | 0.4516 | 2816800.0 |
| 2004-03-22 09:00:00 | AAPL | Stock | 0.4516 | 0.4602 | 0.4509 | 0.4593 | 57114792.0 |
| 2004-03-22 10:00:00 | AAPL | Stock | 0.4591 | 0.4673 | 0.4566 | 0.4655 | 78747592.0 |
| 2004-03-22 11:00:00 | AAPL | Stock | 0.4657 | 0.4657 | 0.4582 | 0.4584 | 60038440.0 |
| 2004-03-22 12:00:00 | AAPL | Stock | 0.4582 | 0.4598 | 0.4527 | 0.4566 | 39388104.0 |
| 2004-03-22 13:00:00 | AAPL | Stock | 0.4564 | 0.4616 | 0.4532 | 0.4575 | 57162896.0 |
| 2004-03-22 14:00:00 | AAPL | Stock | 0.4575 | 0.4607 | 0.4561 | 0.4584 | 20265112.0 |
| 2004-03-22 15:00:00 | AAPL | Stock | 0.4584 | 0.4618 | 0.4582 | 0.4607 | 54227096.0 |
| 2004-03-22 16:00:00 | AAPL | Stock | 0.4607 | 0.4623 | 0.46 | 0.4611 | 953344.0 |
| 2004-03-22 17:00:00 | AAPL | Stock | 0.4609 | 0.4618 | 0.4609 | 0.4618 | 498960.0 |
| 2004-03-22 08:00:00 | MSFT | Stock | 24.5 | 24.58 | 24.39 | 24.5 | 75125.0 |
| 2004-03-22 09:00:00 | MSFT | Stock | 24.51 | 24.57 | 24.23 | 24.27 | 13037875.0 |
| 2004-03-22 10:00:00 | MSFT | Stock | 24.26 | 24.33 | 24.11 | 24.3 | 17338728.0 |
| 2004-03-22 11:00:00 | MSFT | Stock | 24.3 | 24.41 | 24.23 | 24.26 | 11550287.0 |
| 2004-03-22 12:00:00 | MSFT | Stock | 24.26 | 24.3 | 24.14 | 24.19 | 8760034.0 |
| 2004-03-22 13:00:00 | MSFT | Stock | 24.19 | 24.19 | 24.02 | 24.13 | 13620011.0 |
| 2004-03-22 14:00:00 | MSFT | Stock | 24.13 | 24.53 | 24.01 | 24.52 | 25198588.0 |
| 2004-03-22 15:00:00 | MSFT | Stock | 24.53 | 24.81 | 24.37 | 24.53 | 25250427.0 |
| 2004-03-22 16:00:00 | MSFT | Stock | 24.51 | 24.6 | 24.35 | 24.54 | 723857.0 |
| 2004-03-22 17:00:00 | MSFT | Stock | 24.54 | 24.57 | 24.5 | 24.57 | 350707.0 |
| 2004-03-22 18:00:00 | MSFT | Stock | 24.58 | 24.58 | 24.55 | 24.55 | 1600.0 |
| 2004-03-22 08:00:00 | NVDA | Stock | 0.1833 | 0.1842 | 0.1821 | 0.1821 | 576000.0 |
| 2004-03-22 09:00:00 | NVDA | Stock | 0.1821 | 0.1847 | 0.1818 | 0.1822 | 71503200.0 |
| 2004-03-22 10:00:00 | NVDA | Stock | 0.1821 | 0.1833 | 0.1811 | 0.1832 | 68074200.0 |
| 2004-03-22 11:00:00 | NVDA | Stock | 0.1832 | 0.184 | 0.1808 | 0.1812 | 82684920.0 |
| 2004-03-22 12:00:00 | NVDA | Stock | 0.1812 | 0.1819 | 0.1792 | 0.1819 | 66694560.0 |
| 2004-03-22 13:00:00 | NVDA | Stock | 0.1819 | 0.1819 | 0.1803 | 0.1809 | 56098080.0 |
| 2004-03-22 14:00:00 | NVDA | Stock | 0.1809 | 0.1821 | 0.1801 | 0.1817 | 59492400.0 |
| 2004-03-22 15:00:00 | NVDA | Stock | 0.1818 | 0.1838 | 0.1818 | 0.1838 | 106647600.0 |
| 2004-03-22 16:00:00 | NVDA | Stock | 0.1835 | 0.1841 | 0.1832 | 0.1835 | 11047800.0 |
| 2004-03-22 17:00:00 | NVDA | Stock | 0.1832 | 0.1837 | 0.1832 | 0.1837 | 1578240.0 |
| 2004-03-22 08:00:00 | AMZN | Stock | 2.105 | 2.1075 | 2.0875 | 2.095 | 107000.0 |
| 2004-03-22 09:00:00 | AMZN | Stock | 2.095 | 2.095 | 2.053 | 2.053 | 26105660.0 |
| 2004-03-22 10:00:00 | AMZN | Stock | 2.0535 | 2.077 | 2.04 | 2.0735 | 29556520.0 |
| 2004-03-22 11:00:00 | AMZN | Stock | 2.073 | 2.074 | 2.055 | 2.056 | 21775060.0 |
| 2004-03-22 12:00:00 | AMZN | Stock | 2.056 | 2.064 | 2.052 | 2.0595 | 11011460.0 |
| 2004-03-22 13:00:00 | AMZN | Stock | 2.0595 | 2.0645 | 2.054 | 2.058 | 11205780.0 |
| 2004-03-22 14:00:00 | AMZN | Stock | 2.058 | 2.061 | 2.0455 | 2.05 | 15273100.0 |
| 2004-03-22 15:00:00 | AMZN | Stock | 2.05 | 2.056 | 2.0255 | 2.0425 | 46974340.0 |
| 2004-03-22 16:00:00 | AMZN | Stock | 2.0415 | 2.045 | 2.033 | 2.0375 | 769360.0 |
| 2004-03-22 17:00:00 | AMZN | Stock | 2.0375 | 2.0425 | 2.0375 | 2.0425 | 469060.0 |
| 2004-03-22 09:00:00 | CL | Stock | 27.375 | 27.395 | 27.25 | 27.25 | 276600.0 |
| 2004-03-22 10:00:00 | CL | Stock | 27.25 | 27.26 | 27.11 | 27.235 | 568000.0 |
| 2004-03-22 11:00:00 | CL | Stock | 27.235 | 27.235 | 27.035 | 27.105 | 395000.0 |
| 2004-03-22 12:00:00 | CL | Stock | 27.11 | 27.11 | 27.0 | 27.045 | 396600.0 |
| 2004-03-22 13:00:00 | CL | Stock | 27.04 | 27.065 | 26.92 | 26.95 | 318200.0 |
| 2004-03-22 14:00:00 | CL | Stock | 26.94 | 26.94 | 26.75 | 26.795 | 535000.0 |
| 2004-03-22 15:00:00 | CL | Stock | 26.795 | 26.925 | 26.75 | 26.845 | 1183600.0 |
| 2004-03-22 16:00:00 | CL | Stock | 26.845 | 26.845 | 26.825 | 26.825 | 4400.0 |
> showing 49 of 24,600 rows — these rows as CSV