PREVIEW / stock_1hour / 2003-12-24
file: by_date/stock_1hour/2003/2003-12-24.parquet size: 298 KB rows: 12,571 symbols: 1,675
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-24 08:00:00 | AAPL | Stock | 0.3542 | 0.3542 | 0.3538 | 0.3538 | 2086448.0 |
| 2003-12-24 09:00:00 | AAPL | Stock | 0.3538 | 0.3568 | 0.3509 | 0.3564 | 13829592.0 |
| 2003-12-24 10:00:00 | AAPL | Stock | 0.3559 | 0.3604 | 0.3541 | 0.36 | 40939976.0 |
| 2003-12-24 11:00:00 | AAPL | Stock | 0.36 | 0.3655 | 0.36 | 0.3654 | 57477728.0 |
| 2003-12-24 12:00:00 | AAPL | Stock | 0.3654 | 0.3677 | 0.3638 | 0.3643 | 61412624.0 |
| 2003-12-24 13:00:00 | AAPL | Stock | 0.3646 | 0.3655 | 0.3643 | 0.3645 | 278152.0 |
| 2003-12-24 08:00:00 | MSFT | Stock | 27.1 | 27.17 | 27.1 | 27.1 | 535068.0 |
| 2003-12-24 09:00:00 | MSFT | Stock | 27.06 | 27.15 | 27.0 | 27.04 | 3585491.0 |
| 2003-12-24 10:00:00 | MSFT | Stock | 27.04 | 27.14 | 27.03 | 27.09 | 4080912.0 |
| 2003-12-24 11:00:00 | MSFT | Stock | 27.09 | 27.14 | 27.08 | 27.12 | 3289469.0 |
| 2003-12-24 12:00:00 | MSFT | Stock | 27.13 | 27.15 | 27.03 | 27.05 | 4677467.0 |
| 2003-12-24 13:00:00 | MSFT | Stock | 27.03 | 27.06 | 27.03 | 27.04 | 53097.0 |
| 2003-12-24 08:00:00 | NVDA | Stock | 0.1829 | 0.1832 | 0.1829 | 0.1832 | 994680.0 |
| 2003-12-24 09:00:00 | NVDA | Stock | 0.1821 | 0.1835 | 0.1812 | 0.1827 | 59692800.0 |
| 2003-12-24 10:00:00 | NVDA | Stock | 0.1825 | 0.1833 | 0.182 | 0.183 | 47855040.0 |
| 2003-12-24 11:00:00 | NVDA | Stock | 0.1831 | 0.1833 | 0.1826 | 0.1831 | 25848240.0 |
| 2003-12-24 12:00:00 | NVDA | Stock | 0.1831 | 0.1834 | 0.1817 | 0.1817 | 63529320.0 |
| 2003-12-24 13:00:00 | NVDA | Stock | 0.1817 | 0.1817 | 0.1815 | 0.1817 | 1338000.0 |
| 2003-12-24 08:00:00 | AMZN | Stock | 2.622 | 2.622 | 2.61 | 2.6215 | 92000.0 |
| 2003-12-24 09:00:00 | AMZN | Stock | 2.621 | 2.6655 | 2.6075 | 2.648 | 26202460.0 |
| 2003-12-24 10:00:00 | AMZN | Stock | 2.6475 | 2.6675 | 2.631 | 2.6605 | 23914320.0 |
| 2003-12-24 11:00:00 | AMZN | Stock | 2.66 | 2.694 | 2.655 | 2.6825 | 33395660.0 |
| 2003-12-24 12:00:00 | AMZN | Stock | 2.6825 | 2.6935 | 2.656 | 2.6655 | 24026360.0 |
| 2003-12-24 13:00:00 | AMZN | Stock | 2.666 | 2.666 | 2.666 | 2.666 | 34000.0 |
| 2003-12-24 09:00:00 | CL | Stock | 24.625 | 24.68 | 24.52 | 24.55 | 438200.0 |
| 2003-12-24 10:00:00 | CL | Stock | 24.55 | 24.635 | 24.54 | 24.57 | 609600.0 |
| 2003-12-24 11:00:00 | CL | Stock | 24.565 | 24.61 | 24.5 | 24.515 | 1011600.0 |
| 2003-12-24 12:00:00 | CL | Stock | 24.515 | 24.57 | 24.505 | 24.565 | 835200.0 |
| 2003-12-24 13:00:00 | CL | Stock | 24.575 | 24.585 | 24.575 | 24.585 | 22800.0 |
> showing 29 of 12,571 rows — these rows as CSV