PREVIEW / stock_daily / 2003-10-27
file: by_date/stock_daily/2003/2003-10-27.parquet size: 120 KB rows: 3,527 symbols: 2,189
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-27 | AAPL | Stock | 0.4063 | 0.4088 | 0.4016 | 0.4036 | 162013600.0 |
| 2003-10-27 | MSFT | Stock | 26.91 | 27.1 | 26.82 | 26.91 | 65619100.0 |
| 2003-10-27 | NVDA | Stock | 0.1433 | 0.145 | 0.1423 | 0.1433 | 254460000.0 |
| 2003-10-27 | AMZN | Stock | 2.745 | 2.7625 | 2.725 | 2.741 | 127838000.0 |
| 2003-10-27 | CL | Stock | 25.85 | 26.1 | 25.375 | 25.545 | 13343400.0 |
| 2003-10-27 | A | Stock | 16.5379 | 16.5594 | 16.2518 | 16.3591 | 1520884.0 |
| 2003-10-27 | AABA-DELISTED | Stock | 20.3999996185303 | 20.7299995422363 | 20.3050003051758 | 20.5849990844727 | 17490000.0 |
| 2003-10-27 | AAI-DELISTED | Stock | 15.3 | 16.96 | 15.25 | 16.64 | 3543200.0 |
| 2003-10-27 | AAIC-DELISTED | Stock | 362.0 | 369.4 | 362.0 | 365.8 | 670000.0 |
| 2003-10-27 | AAME | Stock | 2.41 | 2.44 | 2.4 | 2.43 | 4500.0 |
| 2003-10-27 | AAON | Stock | 2.3638 | 2.377 | 2.3467 | 2.3572 | 171619.0 |
| 2003-10-27 | AAP | Stock | 25.0533 | 25.75 | 25.0533 | 25.67 | 997200.0 |
| 2003-10-27 | AAXN-DELISTED | Stock | 4.61666679382324 | 4.62083339691162 | 4.28000020980835 | 4.503333568573 | 7340400.0 |
| 2003-10-27 | ABAX-DELISTED | Stock | 15.25 | 16.18 | 15.25 | 15.85 | 192700.0 |
| 2003-10-27 | ABB-DELISTED | Stock | 5.26 | 5.29 | 4.88 | 4.98 | 432600.0 |
| 2003-10-27 | ABC-DELISTED | Stock | 14.19 | 14.4 | 14.1 | 14.34 | 2877600.0 |
| 2003-10-27 | ABCB | Stock | 13.0415 | 13.1874 | 13.0334 | 13.1874 | 10980.0 |
| 2003-10-27 | ABCO-DELISTED | Stock | 17.503 | 17.778 | 16.13 | 16.13 | 1766437.0 |
| 2003-10-27 | ABCW-DELISTED | Stock | 24.51 | 25.3 | 24.45 | 24.97 | 58700.0 |
| 2003-10-27 | ABE-DELISTED | Stock | 6.74 | 6.83 | 6.74 | 6.81 | 6500.0 |
| 2003-10-27 | ABFS-DELISTED | Stock | 32.5 | 33.13 | 32.3 | 32.592 | 175868.0 |
| 2003-10-27 | ABG | Stock | 15.4 | 16.99 | 15.3 | 16.37 | 102500.0 |
| 2003-10-27 | ABK-DELISTED | Stock | 69.4 | 70.02 | 69.4 | 69.87 | 413700.0 |
| 2003-10-27 | ABM | Stock | 14.73 | 15.21 | 14.7 | 14.89 | 164300.0 |
| 2003-10-27 | ABMD-DELISTED | Stock | 9.1 | 9.5 | 8.896 | 8.96 | 101306.0 |
| 2003-10-27 | ABP-DELISTED | Stock | 0.97 | 0.98 | 0.91 | 0.95 | 18400.0 |
| 2003-10-27 | ABT | Stock | 18.7461 | 18.8404 | 18.5441 | 18.598 | 4812421.0 |
| 2003-10-27 | ABTL-DELISTED | Stock | 50.35 | 55.0 | 50.0 | 52.1 | 220200.0 |
| 2003-10-27 | ABV-DELISTED | Stock | 22.11 | 22.41 | 22.05 | 22.29 | 143600.0 |
| 2003-10-27 | ABVA-DELISTED | Stock | 16.17 | 16.39 | 16.0 | 16.25 | 2500.0 |
| 2003-10-27 | ABX-DELISTED | Stock | 19.515 | 19.605 | 19.295 | 19.545 | 2206213.0 |
| 2003-10-27 | ACAP-DELISTED | Stock | 27.22 | 27.5 | 26.62 | 26.81 | 41913.0 |
| 2003-10-27 | ACAS-DELISTED | Stock | 26.11 | 26.5 | 26.01 | 26.14 | 316331.0 |
| 2003-10-27 | ACAT-DELISTED | Stock | 22.19 | 22.19 | 21.65 | 22.15 | 58734.0 |
| 2003-10-27 | ACCL-DELISTED | Stock | 8.68935966491699 | 9.19622993469238 | 8.68935966491699 | 9.19622993469238 | 114600.0 |
| 2003-10-27 | ACE-DELISTED | Stock | 34.17 | 34.35 | 33.78 | 34.22 | 906141.0 |
| 2003-10-27 | ACF-DELISTED | Stock | 12.0 | 12.05 | 11.53 | 12.01 | 1880000.0 |
| 2003-10-27 | ACG-DELISTED | Stock | 8.25 | 8.29 | 8.25 | 8.28 | 444600.0 |
| 2003-10-27 | ACGL | Stock | 3.93 | 3.9622 | 3.9222 | 3.9344 | 372600.0 |
| 2003-10-27 | ACGN-DELISTED | Stock | 1167.3288 | 1348.6712 | 1144.6712 | 1212.6712 | 178400.0 |
| 2003-10-27 | ACH | Stock | 13.8933 | 13.8933 | 11.6667 | 13.28 | 1510350.0 |
| 2003-10-27 | ACH-DELISTED | Stock | 12.313 | 13.025 | 12.188 | 13.025 | 786400.0 |
| 2003-10-27 | ACLS | Stock | 35.24 | 35.96 | 34.84 | 35.2 | 159725.0 |
| 2003-10-27 | ACO-DELISTED | Stock | 16.25 | 16.64 | 16.02 | 16.64 | 528200.0 |
| 2003-10-27 | ACPW-DELISTED | Stock | 15.6 | 16.2 | 15.05 | 15.4 | 26310.0 |
| 2003-10-27 | ACS-DELISTED | Stock | 48.1 | 48.7 | 47.9 | 48.68 | 1770000.0 |
| 2003-10-27 | ACTA-DELISTED | Stock | 8.4 | 8.6 | 8.2 | 8.4 | 142400.0 |
| 2003-10-27 | ACTG | Stock | 6.19 | 6.21 | 5.9 | 5.9 | 290400.0 |
| 2003-10-27 | ACTI-DELISTED | Stock | 8.61 | 8.95 | 8.54 | 8.95 | 57062.0 |
| 2003-10-27 | ACTT-DELISTED | Stock | 1.4 | 1.401 | 1.39 | 1.391 | 58600.0 |
> showing 50 of 3,527 rows — these rows as CSV