PREVIEW / stock_daily / 2005-01-07
file: by_date/stock_daily/2005/2005-01-07.parquet size: 133 KB rows: 3,956 symbols: 2,475
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2005-01-07 | AAPL | Stock | 1.1607 | 1.2434 | 1.1563 | 1.2366 | 2227450400.0 |
| 2005-01-07 | MSFT | Stock | 26.82 | 26.89 | 26.62 | 26.67 | 68723300.0 |
| 2005-01-07 | NVDA | Stock | 0.1876 | 0.189 | 0.1808 | 0.1836 | 763092000.0 |
| 2005-01-07 | AMZN | Stock | 2.069 | 2.1345 | 2.058 | 2.116 | 196732000.0 |
| 2005-01-07 | CL | Stock | 24.865 | 25.175 | 24.675 | 25.04 | 3691600.0 |
| 2005-01-07 | A | Stock | 16.2232 | 16.4163 | 16.1874 | 16.2446 | 2624326.0 |
| 2005-01-07 | AABA-DELISTED | Stock | 35.9900016784668 | 36.4599990844727 | 35.4099998474121 | 35.9599990844727 | 18596300.0 |
| 2005-01-07 | AACC-DELISTED | Stock | 21.62 | 23.6 | 21.48 | 22.31 | 165704.0 |
| 2005-01-07 | AAI-DELISTED | Stock | 9.61 | 9.64 | 9.35 | 9.36 | 853400.0 |
| 2005-01-07 | AAIC-DELISTED | Stock | 378.0 | 382.0 | 372.0 | 376.2 | 1190100.0 |
| 2005-01-07 | AAME | Stock | 3.02 | 3.21 | 3.0 | 3.21 | 10100.0 |
| 2005-01-07 | AAON | Stock | 1.9292 | 1.9292 | 1.8765 | 1.9016 | 87328.0 |
| 2005-01-07 | AAP | Stock | 29.0667 | 29.1667 | 28.6667 | 28.7 | 1221750.0 |
| 2005-01-07 | AAV-DELISTED | Stock | 17.38 | 17.75 | 17.37 | 17.38 | 12700.0 |
| 2005-01-07 | AAXN-DELISTED | Stock | 23.7800006866455 | 25.0 | 21.2900009155273 | 22.7199993133545 | 35732800.0 |
| 2005-01-07 | ABAX-DELISTED | Stock | 13.33 | 13.33 | 12.83 | 12.86 | 74726.0 |
| 2005-01-07 | ABB-DELISTED | Stock | 5.75 | 5.75 | 5.5 | 5.62 | 330800.0 |
| 2005-01-07 | ABBC-DELISTED | Stock | 13.01 | 13.17 | 13.01 | 13.15 | 154514.0 |
| 2005-01-07 | ABC-DELISTED | Stock | 14.52 | 14.54 | 14.33 | 14.48 | 3024400.0 |
| 2005-01-07 | ABCB | Stock | 16.1945 | 16.5673 | 15.7487 | 15.927 | 15915.0 |
| 2005-01-07 | ABCO-DELISTED | Stock | 18.47 | 18.48 | 18.205 | 18.3 | 172984.0 |
| 2005-01-07 | ABCW-DELISTED | Stock | 28.36 | 28.36 | 27.73 | 27.92 | 90310.0 |
| 2005-01-07 | ABE-DELISTED | Stock | 9.53 | 9.53 | 9.3 | 9.49 | 56600.0 |
| 2005-01-07 | ABFS-DELISTED | Stock | 42.77 | 42.89 | 40.85 | 41.04 | 504731.0 |
| 2005-01-07 | ABG | Stock | 14.25 | 14.6 | 14.22 | 14.32 | 68600.0 |
| 2005-01-07 | ABK-DELISTED | Stock | 81.9 | 82.0 | 81.04 | 81.04 | 299100.0 |
| 2005-01-07 | ABM | Stock | 18.77 | 19.19 | 18.51 | 18.67 | 230100.0 |
| 2005-01-07 | ABMD-DELISTED | Stock | 14.56 | 14.56 | 13.74 | 14.25 | 97702.0 |
| 2005-01-07 | ABP-DELISTED | Stock | 2.31 | 2.33 | 2.3 | 2.3 | 60200.0 |
| 2005-01-07 | ABR | Stock | 24.04 | 24.11 | 23.79 | 23.97 | 41800.0 |
| 2005-01-07 | ABT | Stock | 22.4546 | 22.8145 | 22.3107 | 22.7905 | 13965402.0 |
| 2005-01-07 | ABTL-DELISTED | Stock | 28.5 | 29.5 | 28.0 | 28.0 | 80100.0 |
| 2005-01-07 | ABV-DELISTED | Stock | 27.75 | 27.75 | 27.35 | 27.45 | 168000.0 |
| 2005-01-07 | ABVA-DELISTED | Stock | 15.5 | 15.6 | 15.4 | 15.45 | 2700.0 |
| 2005-01-07 | ABVT-DELISTED | Stock | 33.0 | 36.0 | 33.0 | 36.0 | 400.0 |
| 2005-01-07 | ABX-DELISTED | Stock | 22.15 | 22.4 | 21.75 | 22.0 | 2341000.0 |
| 2005-01-07 | ACAD | Stock | 6.43 | 6.7 | 6.43 | 6.5 | 18700.0 |
| 2005-01-07 | ACAP-DELISTED | Stock | 34.85 | 35.27 | 34.8 | 34.95 | 52576.0 |
| 2005-01-07 | ACAS-DELISTED | Stock | 33.48 | 33.53 | 32.72 | 32.77 | 482103.0 |
| 2005-01-07 | ACAT-DELISTED | Stock | 24.88 | 25.2 | 24.37 | 24.96 | 72981.0 |
| 2005-01-07 | ACC-DELISTED | Stock | 21.03 | 21.22 | 20.9 | 21.14 | 43078.0 |
| 2005-01-07 | ACCL-DELISTED | Stock | 6.45 | 6.45 | 6.0 | 6.02 | 213581.0 |
| 2005-01-07 | ACE-DELISTED | Stock | 42.75 | 42.83 | 42.28 | 42.52 | 1366600.0 |
| 2005-01-07 | ACF-DELISTED | Stock | 23.8 | 23.85 | 23.55 | 23.59 | 652000.0 |
| 2005-01-07 | ACFC-DELISTED | Stock | 66.48 | 67.86 | 66.48 | 66.94 | 2933.0 |
| 2005-01-07 | ACG-DELISTED | Stock | 8.19 | 8.19 | 8.18 | 8.19 | 259800.0 |
| 2005-01-07 | ACGL | Stock | 4.1578 | 4.2011 | 4.1389 | 4.1911 | 771300.0 |
| 2005-01-07 | ACGN-DELISTED | Stock | 521.3288 | 532.6712 | 510.0 | 532.6712 | 176400.0 |
| 2005-01-07 | ACH | Stock | 18.4 | 18.4333 | 17.98 | 17.9867 | 209100.0 |
| 2005-01-07 | ACH-DELISTED | Stock | 13.217 | 13.312 | 13.127 | 13.247 | 234383.0 |
> showing 50 of 3,956 rows — these rows as CSV