PREVIEW / stock_daily / 2004-11-12
file: by_date/stock_daily/2004/2004-11-12.parquet size: 131 KB rows: 3,897 symbols: 2,439
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-12 | AAPL | Stock | 0.9823 | 0.9945 | 0.9793 | 0.9911 | 395701600.0 |
| 2004-11-12 | MSFT | Stock | 30.16 | 30.2 | 29.8 | 29.97 | 162269000.0 |
| 2004-11-12 | NVDA | Stock | 0.1529 | 0.1533 | 0.1493 | 0.1508 | 647076000.0 |
| 2004-11-12 | AMZN | Stock | 1.9525 | 2.047 | 1.95 | 2.023 | 231920000.0 |
| 2004-11-12 | CL | Stock | 23.825 | 23.825 | 23.63 | 23.81 | 4836200.0 |
| 2004-11-12 | A | Stock | 16.6381 | 16.6381 | 15.6652 | 16.1516 | 27064721.0 |
| 2004-11-12 | AABA-DELISTED | Stock | 37.8699989318848 | 38.2999992370605 | 37.5299987792969 | 37.7999992370605 | 16545200.0 |
| 2004-11-12 | AACC-DELISTED | Stock | 17.67 | 18.15 | 17.56 | 17.91 | 119837.0 |
| 2004-11-12 | AAI-DELISTED | Stock | 12.8 | 12.84 | 12.66 | 12.82 | 732500.0 |
| 2004-11-12 | AAIC-DELISTED | Stock | 342.6 | 352.4 | 340.6 | 352.0 | 1923500.0 |
| 2004-11-12 | AAME | Stock | 3.09 | 3.09 | 3.01 | 3.06 | 1800.0 |
| 2004-11-12 | AAON | Stock | 2.1505 | 2.1728 | 2.1294 | 2.1728 | 224775.0 |
| 2004-11-12 | AAP | Stock | 27.9667 | 28.1333 | 27.7333 | 28.1333 | 594450.0 |
| 2004-11-12 | AAV-DELISTED | Stock | 17.8 | 17.8 | 17.44 | 17.8 | 116700.0 |
| 2004-11-12 | AAXN-DELISTED | Stock | 28.3500003814697 | 29.8999996185303 | 27.8050003051758 | 28.75 | 27720200.0 |
| 2004-11-12 | ABAX-DELISTED | Stock | 12.8 | 12.96 | 12.56 | 12.9 | 158371.0 |
| 2004-11-12 | ABB-DELISTED | Stock | 6.06 | 6.18 | 6.02 | 6.15 | 165400.0 |
| 2004-11-12 | ABC-DELISTED | Stock | 14.77 | 14.81 | 14.59 | 14.75 | 2836000.0 |
| 2004-11-12 | ABCB | Stock | 17.4103 | 17.7021 | 17.0618 | 17.7021 | 39110.0 |
| 2004-11-12 | ABCO-DELISTED | Stock | 17.157 | 17.778 | 17.127 | 17.308 | 1749098.0 |
| 2004-11-12 | ABCW-DELISTED | Stock | 27.93 | 28.45 | 27.87 | 28.1 | 78170.0 |
| 2004-11-12 | ABE-DELISTED | Stock | 8.77 | 8.96 | 8.77 | 8.85 | 18900.0 |
| 2004-11-12 | ABFS-DELISTED | Stock | 41.49 | 41.78 | 40.96 | 41.65 | 193148.0 |
| 2004-11-12 | ABG | Stock | 13.9 | 14.0 | 13.86 | 13.96 | 32200.0 |
| 2004-11-12 | ABK-DELISTED | Stock | 81.0 | 81.0 | 80.02 | 80.77 | 358100.0 |
| 2004-11-12 | ABM | Stock | 21.69 | 21.9 | 21.55 | 21.85 | 108900.0 |
| 2004-11-12 | ABMD-DELISTED | Stock | 15.34 | 15.89 | 15.33 | 15.89 | 169568.0 |
| 2004-11-12 | ABP-DELISTED | Stock | 2.7 | 2.8 | 2.6 | 2.75 | 181000.0 |
| 2004-11-12 | ABR | Stock | 21.45 | 21.47 | 21.3 | 21.44 | 34500.0 |
| 2004-11-12 | ABT | Stock | 21.3751 | 21.5094 | 20.9529 | 21.1976 | 13839725.0 |
| 2004-11-12 | ABTL-DELISTED | Stock | 33.9 | 35.1 | 32.8 | 35.1 | 116900.0 |
| 2004-11-12 | ABV-DELISTED | Stock | 24.09 | 24.28 | 24.0 | 24.18 | 284600.0 |
| 2004-11-12 | ABVA-DELISTED | Stock | 14.8 | 14.8 | 14.8 | 14.8 | 110.0 |
| 2004-11-12 | ABVT-DELISTED | Stock | 26.0 | 26.0 | 26.0 | 26.0 | 10000.0 |
| 2004-11-12 | ABX-DELISTED | Stock | 22.79 | 23.25 | 22.68 | 23.2 | 1727152.0 |
| 2004-11-12 | ACAD | Stock | 7.15 | 7.2 | 7.09 | 7.09 | 3000.0 |
| 2004-11-12 | ACAP-DELISTED | Stock | 33.6 | 33.6 | 33.09 | 33.22 | 44437.0 |
| 2004-11-12 | ACAS-DELISTED | Stock | 31.26 | 31.57 | 30.95 | 31.46 | 565249.0 |
| 2004-11-12 | ACAT-DELISTED | Stock | 25.99 | 26.016 | 25.751 | 26.0 | 32548.0 |
| 2004-11-12 | ACC-DELISTED | Stock | 19.0 | 19.2 | 18.85 | 19.2 | 69600.0 |
| 2004-11-12 | ACCL-DELISTED | Stock | 6.6 | 6.66 | 6.28 | 6.539 | 66982.0 |
| 2004-11-12 | ACE-DELISTED | Stock | 39.37 | 39.5 | 38.41 | 39.2 | 1598700.0 |
| 2004-11-12 | ACF-DELISTED | Stock | 21.2 | 21.29 | 20.44 | 21.14 | 1559900.0 |
| 2004-11-12 | ACFC-DELISTED | Stock | 67.7 | 67.7 | 66.58 | 66.84 | 6657.0 |
| 2004-11-12 | ACG-DELISTED | Stock | 8.08 | 8.13 | 8.08 | 8.13 | 342300.0 |
| 2004-11-12 | ACGL | Stock | 4.2678 | 4.2833 | 4.2244 | 4.2644 | 1011600.0 |
| 2004-11-12 | ACGN-DELISTED | Stock | 566.6712 | 566.6712 | 521.3288 | 544.0 | 79300.0 |
| 2004-11-12 | ACH | Stock | 18.5 | 18.62 | 18.3467 | 18.5867 | 267600.0 |
| 2004-11-12 | ACH-DELISTED | Stock | 15.378 | 15.966 | 15.228 | 15.861 | 838657.0 |
| 2004-11-12 | ACLS | Stock | 27.72 | 28.0 | 26.6 | 27.36 | 350625.0 |
> showing 50 of 3,897 rows — these rows as CSV