PREVIEW / stock_daily / 2004-11-17
file: by_date/stock_daily/2004/2004-11-17.parquet size: 132 KB rows: 3,929 symbols: 2,465
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-17 | AAPL | Stock | 0.9855 | 0.9902 | 0.9682 | 0.9804 | 397751200.0 |
| 2004-11-17 | MSFT | Stock | 27.25 | 27.35 | 27.06 | 27.17 | 58830700.0 |
| 2004-11-17 | NVDA | Stock | 0.155 | 0.1592 | 0.1535 | 0.1552 | 602772000.0 |
| 2004-11-17 | AMZN | Stock | 2.02 | 2.0295 | 1.977 | 1.995 | 136872000.0 |
| 2004-11-17 | CL | Stock | 24.2 | 24.45 | 24.16 | 24.37 | 6152600.0 |
| 2004-11-17 | A | Stock | 16.4735 | 16.731 | 16.4735 | 16.7167 | 4839736.0 |
| 2004-11-17 | AABA-DELISTED | Stock | 36.9500007629395 | 37.3699989318848 | 36.4799995422363 | 36.9500007629395 | 15189100.0 |
| 2004-11-17 | AACC-DELISTED | Stock | 18.31 | 18.5 | 18.11 | 18.3 | 25999.0 |
| 2004-11-17 | AAI-DELISTED | Stock | 12.74 | 13.14 | 12.74 | 13.03 | 1319700.0 |
| 2004-11-17 | AAIC-DELISTED | Stock | 353.0 | 365.0 | 352.6 | 358.6 | 1829000.0 |
| 2004-11-17 | AAME | Stock | 3.05 | 3.05 | 3.05 | 3.05 | 1200.0 |
| 2004-11-17 | AAON | Stock | 2.1728 | 2.1728 | 2.1399 | 2.1426 | 58472.0 |
| 2004-11-17 | AAP | Stock | 28.1333 | 28.3333 | 27.8467 | 27.9133 | 2159400.0 |
| 2004-11-17 | AAV-DELISTED | Stock | 17.78 | 17.87 | 17.59 | 17.78 | 28700.0 |
| 2004-11-17 | AAXN-DELISTED | Stock | 30.1749992370605 | 30.3649997711182 | 27.9050006866455 | 28.5049991607666 | 21154800.0 |
| 2004-11-17 | ABAX-DELISTED | Stock | 12.85 | 12.99 | 12.59 | 12.75 | 85157.0 |
| 2004-11-17 | ABB-DELISTED | Stock | 6.13 | 6.17 | 6.07 | 6.1 | 650400.0 |
| 2004-11-17 | ABC-DELISTED | Stock | 14.65 | 14.69 | 14.48 | 14.49 | 2896000.0 |
| 2004-11-17 | ABCB | Stock | 17.4508 | 17.6453 | 17.0537 | 17.0942 | 8019.0 |
| 2004-11-17 | ABCO-DELISTED | Stock | 17.089 | 17.716 | 17.089 | 17.541 | 514280.0 |
| 2004-11-17 | ABCW-DELISTED | Stock | 29.09 | 29.33 | 28.88 | 29.07 | 67280.0 |
| 2004-11-17 | ABE-DELISTED | Stock | 9.04 | 9.16 | 9.0 | 9.11 | 7900.0 |
| 2004-11-17 | ABFS-DELISTED | Stock | 40.33 | 41.83 | 40.32 | 41.71 | 204665.0 |
| 2004-11-17 | ABG | Stock | 13.48 | 13.92 | 13.48 | 13.65 | 23700.0 |
| 2004-11-17 | ABK-DELISTED | Stock | 79.9 | 81.24 | 79.81 | 80.0 | 405400.0 |
| 2004-11-17 | ABM | Stock | 21.67 | 21.99 | 21.62 | 21.74 | 166200.0 |
| 2004-11-17 | ABMD-DELISTED | Stock | 15.77 | 17.5 | 15.55 | 17.42 | 452728.0 |
| 2004-11-17 | ABP-DELISTED | Stock | 2.59 | 2.59 | 2.36 | 2.38 | 404900.0 |
| 2004-11-17 | ABR | Stock | 21.95 | 21.95 | 21.6 | 21.7 | 35000.0 |
| 2004-11-17 | ABT | Stock | 21.2312 | 21.3895 | 20.8377 | 20.9433 | 8071488.0 |
| 2004-11-17 | ABTL-DELISTED | Stock | 33.0 | 34.9 | 33.0 | 34.6 | 120600.0 |
| 2004-11-17 | ABV-DELISTED | Stock | 24.7 | 24.97 | 24.39 | 24.79 | 209700.0 |
| 2004-11-17 | ABVA-DELISTED | Stock | 14.7 | 14.73 | 14.7 | 14.73 | 549.0 |
| 2004-11-17 | ABVT-DELISTED | Stock | 24.0 | 28.75 | 24.0 | 28.44 | 7400.0 |
| 2004-11-17 | ABX-DELISTED | Stock | 23.77 | 24.12 | 23.67 | 24.11 | 3956383.0 |
| 2004-11-17 | ACAD | Stock | 7.25 | 7.3 | 7.06 | 7.13 | 9500.0 |
| 2004-11-17 | ACAP-DELISTED | Stock | 33.3 | 33.82 | 33.25 | 33.82 | 74619.0 |
| 2004-11-17 | ACAS-DELISTED | Stock | 31.4 | 31.56 | 31.2 | 31.49 | 527083.0 |
| 2004-11-17 | ACAT-DELISTED | Stock | 25.57 | 26.02 | 25.57 | 25.95 | 28977.0 |
| 2004-11-17 | ACC-DELISTED | Stock | 19.96 | 20.47 | 19.96 | 20.39 | 118825.0 |
| 2004-11-17 | ACCL-DELISTED | Stock | 6.6 | 6.69 | 6.51 | 6.6 | 58229.0 |
| 2004-11-17 | ACE-DELISTED | Stock | 38.97 | 39.11 | 38.49 | 38.66 | 1329100.0 |
| 2004-11-17 | ACF-DELISTED | Stock | 21.05 | 21.19 | 20.7 | 20.95 | 759800.0 |
| 2004-11-17 | ACFC-DELISTED | Stock | 68.62 | 70.05 | 68.11 | 69.13 | 11387.0 |
| 2004-11-17 | ACG-DELISTED | Stock | 8.15 | 8.16 | 8.13 | 8.16 | 362300.0 |
| 2004-11-17 | ACGL | Stock | 4.2211 | 4.2844 | 4.2211 | 4.2722 | 746100.0 |
| 2004-11-17 | ACGN-DELISTED | Stock | 521.3288 | 532.6712 | 498.6712 | 521.3288 | 79100.0 |
| 2004-11-17 | ACH | Stock | 18.4467 | 18.7333 | 18.2867 | 18.48 | 204750.0 |
| 2004-11-17 | ACH-DELISTED | Stock | 15.375 | 15.712 | 15.36 | 15.435 | 505200.0 |
| 2004-11-17 | ACLS | Stock | 28.0 | 29.16 | 28.0 | 29.04 | 691675.0 |
> showing 50 of 3,929 rows — these rows as CSV