PREVIEW / stock_daily / 2003-10-20
file: by_date/stock_daily/2003/2003-10-20.parquet size: 119 KB rows: 3,504 symbols: 2,168
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-20 | AAPL | Stock | 0.4036 | 0.4168 | 0.3996 | 0.4146 | 279132000.0 |
| 2003-10-20 | MSFT | Stock | 28.95 | 29.37 | 28.8 | 29.35 | 38794500.0 |
| 2003-10-20 | NVDA | Stock | 0.1389 | 0.1421 | 0.1381 | 0.1419 | 467388000.0 |
| 2003-10-20 | AMZN | Stock | 2.978 | 3.012 | 2.946 | 2.9795 | 221722000.0 |
| 2003-10-20 | CL | Stock | 28.65 | 28.775 | 28.44 | 28.685 | 3800200.0 |
| 2003-10-20 | A | Stock | 17.0959 | 17.1602 | 16.917 | 17.0458 | 1295107.0 |
| 2003-10-20 | AABA-DELISTED | Stock | 21.25 | 21.3700008392334 | 20.9050006866455 | 21.1849994659424 | 17092600.0 |
| 2003-10-20 | AAI-DELISTED | Stock | 17.7 | 18.45 | 17.66 | 18.45 | 1467800.0 |
| 2003-10-20 | AAIC-DELISTED | Stock | 358.0 | 360.2 | 356.2 | 360.0 | 500000.0 |
| 2003-10-20 | AAME | Stock | 2.42 | 2.45 | 2.42 | 2.45 | 4900.0 |
| 2003-10-20 | AAON | Stock | 2.4165 | 2.4612 | 2.3835 | 2.4138 | 151875.0 |
| 2003-10-20 | AAP | Stock | 24.6433 | 24.78 | 24.5433 | 24.6667 | 488400.0 |
| 2003-10-20 | AAXN-DELISTED | Stock | 3.43416666984558 | 3.64416670799255 | 3.43416666984558 | 3.63333344459534 | 2328000.0 |
| 2003-10-20 | ABAX-DELISTED | Stock | 18.35 | 18.52 | 15.55 | 16.416 | 586424.0 |
| 2003-10-20 | ABB-DELISTED | Stock | 5.63 | 5.65 | 5.55 | 5.64 | 177100.0 |
| 2003-10-20 | ABC-DELISTED | Stock | 14.31 | 14.31 | 14.14 | 14.3 | 3009600.0 |
| 2003-10-20 | ABCB | Stock | 13.6008 | 13.6008 | 13.2522 | 13.3658 | 4442.0 |
| 2003-10-20 | ABCO-DELISTED | Stock | 22.27 | 23.05 | 22.27 | 22.87 | 100000.0 |
| 2003-10-20 | ABCW-DELISTED | Stock | 24.99 | 25.17 | 24.7 | 24.9 | 51800.0 |
| 2003-10-20 | ABE-DELISTED | Stock | 6.76 | 6.84 | 6.76 | 6.81 | 24400.0 |
| 2003-10-20 | ABFS-DELISTED | Stock | 31.42 | 32.75 | 31.35 | 32.75 | 430958.0 |
| 2003-10-20 | ABG | Stock | 17.51 | 17.93 | 17.42 | 17.75 | 40600.0 |
| 2003-10-20 | ABK-DELISTED | Stock | 69.43 | 70.0 | 69.07 | 69.31 | 441000.0 |
| 2003-10-20 | ABM | Stock | 14.6 | 14.98 | 14.55 | 14.98 | 107200.0 |
| 2003-10-20 | ABMD-DELISTED | Stock | 9.02 | 9.03 | 8.52 | 8.96 | 29024.0 |
| 2003-10-20 | ABP-DELISTED | Stock | 0.95 | 0.97 | 0.86 | 0.88 | 477300.0 |
| 2003-10-20 | ABT | Stock | 18.7596 | 19.011 | 18.6249 | 18.9661 | 9553334.0 |
| 2003-10-20 | ABTL-DELISTED | Stock | 56.6 | 57.75 | 54.3 | 54.55 | 88600.0 |
| 2003-10-20 | ABV-DELISTED | Stock | 21.5 | 21.8 | 21.41 | 21.8 | 265800.0 |
| 2003-10-20 | ABVA-DELISTED | Stock | 16.329 | 16.4 | 16.05 | 16.05 | 3000.0 |
| 2003-10-20 | ABX-DELISTED | Stock | 18.75 | 18.87 | 18.65 | 18.67 | 1294300.0 |
| 2003-10-20 | ACAP-DELISTED | Stock | 27.56 | 27.75 | 27.41 | 27.63 | 9368.0 |
| 2003-10-20 | ACAS-DELISTED | Stock | 25.5 | 25.74 | 25.3 | 25.55 | 309507.0 |
| 2003-10-20 | ACAT-DELISTED | Stock | 22.8 | 22.9 | 21.95 | 22.55 | 45650.0 |
| 2003-10-20 | ACCL-DELISTED | Stock | 9.65999984741211 | 10.0509996414185 | 9.63099956512451 | 9.83300018310547 | 101300.0 |
| 2003-10-20 | ACE-DELISTED | Stock | 34.01 | 34.22 | 33.68 | 34.13 | 1595131.0 |
| 2003-10-20 | ACF-DELISTED | Stock | 10.85 | 11.34 | 10.85 | 11.17 | 1059800.0 |
| 2003-10-20 | ACG-DELISTED | Stock | 8.15 | 8.22 | 8.14 | 8.21 | 729100.0 |
| 2003-10-20 | ACGL | Stock | 3.8756 | 3.9444 | 3.8756 | 3.9167 | 644400.0 |
| 2003-10-20 | ACGN-DELISTED | Stock | 1269.3288 | 1280.6712 | 1258.0 | 1269.3288 | 66000.0 |
| 2003-10-20 | ACH | Stock | 15.2467 | 15.3 | 14.9 | 14.9867 | 301200.0 |
| 2003-10-20 | ACH-DELISTED | Stock | 11.5 | 11.65 | 11.393 | 11.65 | 133200.0 |
| 2003-10-20 | ACLS | Stock | 39.0 | 39.88 | 38.56 | 38.8 | 166575.0 |
| 2003-10-20 | ACO-DELISTED | Stock | 14.95 | 15.2 | 14.85 | 15.04 | 189800.0 |
| 2003-10-20 | ACPW-DELISTED | Stock | 15.55 | 15.7 | 14.5 | 14.8 | 25316.0 |
| 2003-10-20 | ACS-DELISTED | Stock | 49.72 | 50.93 | 49.6 | 50.69 | 1624600.0 |
| 2003-10-20 | ACTA-DELISTED | Stock | 9.0 | 9.2 | 8.8 | 8.8 | 215800.0 |
| 2003-10-20 | ACTG | Stock | 7.6 | 7.94 | 7.45 | 7.7 | 354700.0 |
| 2003-10-20 | ACTI-DELISTED | Stock | 9.4 | 9.42 | 8.77 | 9.06 | 332680.0 |
| 2003-10-20 | ACTT-DELISTED | Stock | 1.51 | 1.51 | 1.39 | 1.42 | 94900.0 |
> showing 50 of 3,504 rows — these rows as CSV