PREVIEW / stock_1hour / 2004-02-25
file: by_date/stock_1hour/2004/2004-02-25.parquet size: 506 KB rows: 23,436 symbols: 1,727
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-02-25 08:00:00 | AAPL | Stock | 0.4033 | 0.4033 | 0.4033 | 0.4033 | 33600.0 |
| 2004-02-25 09:00:00 | AAPL | Stock | 0.4018 | 0.403 | 0.3964 | 0.4023 | 25650352.0 |
| 2004-02-25 10:00:00 | AAPL | Stock | 0.4022 | 0.4063 | 0.4013 | 0.4063 | 35463736.0 |
| 2004-02-25 11:00:00 | AAPL | Stock | 0.4063 | 0.4089 | 0.4059 | 0.407 | 39792704.0 |
| 2004-02-25 12:00:00 | AAPL | Stock | 0.4066 | 0.4086 | 0.4054 | 0.4084 | 21639968.0 |
| 2004-02-25 13:00:00 | AAPL | Stock | 0.4084 | 0.4089 | 0.4063 | 0.4066 | 27022016.0 |
| 2004-02-25 14:00:00 | AAPL | Stock | 0.4066 | 0.4075 | 0.406 | 0.4071 | 27768272.0 |
| 2004-02-25 15:00:00 | AAPL | Stock | 0.407 | 0.4086 | 0.4061 | 0.4075 | 68240592.0 |
| 2004-02-25 16:00:00 | AAPL | Stock | 0.4075 | 0.4091 | 0.4071 | 0.4073 | 7085288.0 |
| 2004-02-25 17:00:00 | AAPL | Stock | 0.4073 | 0.4073 | 0.4073 | 0.4073 | 173040.0 |
| 2004-02-25 08:00:00 | MSFT | Stock | 26.8 | 26.89 | 26.8 | 26.88 | 26400.0 |
| 2004-02-25 09:00:00 | MSFT | Stock | 26.88 | 26.99 | 26.84 | 26.97 | 8503517.0 |
| 2004-02-25 10:00:00 | MSFT | Stock | 26.97 | 26.98 | 26.68 | 26.81 | 13707436.0 |
| 2004-02-25 11:00:00 | MSFT | Stock | 26.81 | 26.87 | 26.62 | 26.7 | 10552840.0 |
| 2004-02-25 12:00:00 | MSFT | Stock | 26.69 | 26.77 | 26.67 | 26.74 | 5996637.0 |
| 2004-02-25 13:00:00 | MSFT | Stock | 26.74 | 26.77 | 26.66 | 26.71 | 4714450.0 |
| 2004-02-25 14:00:00 | MSFT | Stock | 26.71 | 26.77 | 26.66 | 26.69 | 5267592.0 |
| 2004-02-25 15:00:00 | MSFT | Stock | 26.69 | 26.74 | 26.63 | 26.64 | 12312562.0 |
| 2004-02-25 16:00:00 | MSFT | Stock | 26.64 | 26.71 | 26.55 | 26.63 | 708925.0 |
| 2004-02-25 17:00:00 | MSFT | Stock | 26.63 | 26.98 | 26.62 | 26.64 | 407015.0 |
| 2004-02-25 18:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.63 | 26.65 | 2925.0 |
| 2004-02-25 08:00:00 | NVDA | Stock | 0.1873 | 0.1875 | 0.1873 | 0.1874 | 372000.0 |
| 2004-02-25 09:00:00 | NVDA | Stock | 0.1868 | 0.1904 | 0.1862 | 0.1894 | 127743360.0 |
| 2004-02-25 10:00:00 | NVDA | Stock | 0.1898 | 0.1911 | 0.1882 | 0.1886 | 118110360.0 |
| 2004-02-25 11:00:00 | NVDA | Stock | 0.1886 | 0.1896 | 0.1855 | 0.1866 | 97872000.0 |
| 2004-02-25 12:00:00 | NVDA | Stock | 0.1866 | 0.1887 | 0.1865 | 0.1887 | 49141200.0 |
| 2004-02-25 13:00:00 | NVDA | Stock | 0.1887 | 0.1887 | 0.1867 | 0.1874 | 58441320.0 |
| 2004-02-25 14:00:00 | NVDA | Stock | 0.1874 | 0.1886 | 0.1872 | 0.1876 | 60101280.0 |
| 2004-02-25 15:00:00 | NVDA | Stock | 0.1877 | 0.1883 | 0.1872 | 0.1874 | 104459760.0 |
| 2004-02-25 16:00:00 | NVDA | Stock | 0.1879 | 0.1882 | 0.1874 | 0.1878 | 4692360.0 |
| 2004-02-25 17:00:00 | NVDA | Stock | 0.1878 | 0.1879 | 0.1875 | 0.1875 | 469200.0 |
| 2004-02-25 08:00:00 | AMZN | Stock | 2.125 | 2.1295 | 2.116 | 2.1274 | 184000.0 |
| 2004-02-25 09:00:00 | AMZN | Stock | 2.1255 | 2.164 | 2.122 | 2.157 | 40518260.0 |
| 2004-02-25 10:00:00 | AMZN | Stock | 2.1555 | 2.1645 | 2.1315 | 2.1465 | 36007960.0 |
| 2004-02-25 11:00:00 | AMZN | Stock | 2.146 | 2.1526 | 2.1345 | 2.1445 | 16540280.0 |
| 2004-02-25 12:00:00 | AMZN | Stock | 2.1455 | 2.15 | 2.1385 | 2.1475 | 6564760.0 |
| 2004-02-25 13:00:00 | AMZN | Stock | 2.1475 | 2.1525 | 2.1415 | 2.1495 | 9550140.0 |
| 2004-02-25 14:00:00 | AMZN | Stock | 2.1485 | 2.1525 | 2.139 | 2.14 | 9118160.0 |
| 2004-02-25 15:00:00 | AMZN | Stock | 2.14 | 2.154 | 2.1375 | 2.1455 | 19783780.0 |
| 2004-02-25 16:00:00 | AMZN | Stock | 2.1455 | 2.1485 | 2.1425 | 2.1484 | 511800.0 |
| 2004-02-25 17:00:00 | AMZN | Stock | 2.147 | 2.16 | 2.145 | 2.157 | 461280.0 |
| 2004-02-25 18:00:00 | AMZN | Stock | 2.158 | 2.158 | 2.158 | 2.158 | 10000.0 |
| 2004-02-25 09:00:00 | CL | Stock | 27.725 | 27.925 | 27.675 | 27.9 | 284600.0 |
| 2004-02-25 10:00:00 | CL | Stock | 27.905 | 27.905 | 27.7 | 27.715 | 335400.0 |
| 2004-02-25 11:00:00 | CL | Stock | 27.71 | 27.85 | 27.65 | 27.68 | 378000.0 |
| 2004-02-25 12:00:00 | CL | Stock | 27.68 | 27.76 | 27.65 | 27.685 | 327200.0 |
| 2004-02-25 13:00:00 | CL | Stock | 27.685 | 27.685 | 27.575 | 27.625 | 412400.0 |
| 2004-02-25 14:00:00 | CL | Stock | 27.625 | 27.645 | 27.56 | 27.62 | 476800.0 |
| 2004-02-25 15:00:00 | CL | Stock | 27.625 | 27.68 | 27.505 | 27.525 | 721800.0 |
| 2004-02-25 16:00:00 | CL | Stock | 27.5 | 27.5995 | 27.5 | 27.5 | 112000.0 |
> showing 50 of 23,436 rows — these rows as CSV