PREVIEW / stock_daily / 2000-01-03
file: by_date/stock_daily/2000/2000-01-03.parquet size: 55 KB rows: 1,650 symbols: 1,646
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-03 | AABA-DELISTED | Stock | 110.73046875 | 119.25 | 107.375 | 118.75 | 38469600.0 |
| 2000-01-03 | AAI-DELISTED | Stock | 4.47 | 4.66 | 4.31 | 4.5 | 443700.0 |
| 2000-01-03 | AAIC-DELISTED | Stock | 155.0 | 155.0 | 140.0 | 142.5 | 55400.0 |
| 2000-01-03 | ABAX-DELISTED | Stock | 7.75 | 7.875 | 7.4375 | 7.5 | 50400.0 |
| 2000-01-03 | ABC-DELISTED | Stock | 3.875 | 3.9375 | 3.8125 | 3.890625 | 2784800.0 |
| 2000-01-03 | ABCW-DELISTED | Stock | 15.06 | 15.06 | 14.31 | 15.0 | 69500.0 |
| 2000-01-03 | ABE-DELISTED | Stock | 16.375 | 16.9375 | 16.25 | 16.9375 | 80500.0 |
| 2000-01-03 | ABFS-DELISTED | Stock | 12.25 | 12.6875 | 12.125 | 12.375 | 74300.0 |
| 2000-01-03 | ABK-DELISTED | Stock | 52.06 | 52.13 | 50.25 | 50.69 | 420800.0 |
| 2000-01-03 | ABMD-DELISTED | Stock | 18.51567 | 18.6563 | 18.3 | 18.3 | 181200.0 |
| 2000-01-03 | ABTL-DELISTED | Stock | 78.75 | 80.0 | 76.25 | 76.88 | 56200.0 |
| 2000-01-03 | ABV-DELISTED | Stock | 13.88 | 15.0 | 13.88 | 14.56 | 126900.0 |
| 2000-01-03 | ABX-DELISTED | Stock | 17.563 | 18.188 | 17.438 | 17.625 | 1501381.0 |
| 2000-01-03 | ACAS-DELISTED | Stock | 23.0 | 23.5 | 22.5625 | 23.0 | 103900.0 |
| 2000-01-03 | ACAT-DELISTED | Stock | 9.938 | 10.126 | 9.938 | 10.063 | 44599.0 |
| 2000-01-03 | ACCL-DELISTED | Stock | 16.3799991607666 | 16.5639991760254 | 15.8400001525879 | 16.0209999084473 | 630700.0 |
| 2000-01-03 | ACE-DELISTED | Stock | 17.063 | 17.126 | 16.125 | 16.313 | 1368700.0 |
| 2000-01-03 | ACF-DELISTED | Stock | 18.5 | 18.63 | 17.06 | 17.13 | 315200.0 |
| 2000-01-03 | ACG-DELISTED | Stock | 6.5625 | 6.6875 | 6.5 | 6.625 | 206300.0 |
| 2000-01-03 | ACGN-DELISTED | Stock | 1151.0088 | 1151.0088 | 991.6712 | 1133.3288 | 12000.0 |
| 2000-01-03 | ACO-DELISTED | Stock | 16.0 | 16.0 | 15.0625 | 15.375 | 205600.0 |
| 2000-01-03 | ACS-DELISTED | Stock | 22.875 | 23.0 | 22.375 | 22.8125 | 576300.0 |
| 2000-01-03 | ACTA-DELISTED | Stock | 3718.75 | 4018.75 | 3482.5 | 4000.0 | 300100.0 |
| 2000-01-03 | ACTT-DELISTED | Stock | 8.0625 | 8.875 | 8.0625 | 8.75 | 14900.0 |
| 2000-01-03 | ACTU-DELISTED | Stock | 45.25 | 48.75 | 40.75 | 43.25 | 326600.0 |
| 2000-01-03 | ACXM-DELISTED | Stock | 23.875 | 25.125 | 23.8125 | 25.0 | 1836100.0 |
| 2000-01-03 | ACY-DELISTED | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 300.0 |
| 2000-01-03 | ADAT-DELISTED | Stock | 308.25 | 312.75 | 277.88 | 286.88 | 28300.0 |
| 2000-01-03 | ADEP-DELISTED | Stock | 30.62 | 34.38 | 30.31 | 33.75 | 12300.0 |
| 2000-01-03 | ADGF-DELISTED | Stock | 1.72 | 1.88 | 1.69 | 1.88 | 86600.0 |
| 2000-01-03 | ADMP-DELISTED | Stock | 584.375 | 595.0 | 552.5 | 563.125 | 100.0 |
| 2000-01-03 | ADPI-DELISTED | Stock | 7.12 | 7.19 | 7.0 | 7.0 | 7000.0 |
| 2000-01-03 | ADVNB-DELISTED | Stock | 13.38 | 13.5 | 12.75 | 13.25 | 23600.0 |
| 2000-01-03 | ADVS-DELISTED | Stock | 65.75 | 66.75 | 61.0 | 65.25 | 51600.0 |
| 2000-01-03 | AEC-DELISTED | Stock | 7.8125 | 8.125 | 7.75 | 8.125 | 55200.0 |
| 2000-01-03 | AEGN-DELISTED | Stock | 28.19 | 28.19 | 26.5 | 27.12 | 89700.0 |
| 2000-01-03 | AEPI-DELISTED | Stock | 25.0 | 25.0 | 23.9375 | 24.75 | 6800.0 |
| 2000-01-03 | AES.C-DELISTED | Stock | 61.5 | 61.5 | 59.5 | 60.5 | 19900.0 |
| 2000-01-03 | AET-DELISTED | Stock | 6.9255 | 6.9802 | 6.8864 | 6.9411 | 5742638.0 |
| 2000-01-03 | AEY-DELISTED | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 1000.0 |
| 2000-01-03 | AF-DELISTED | Stock | 10.27 | 10.27 | 9.666 | 9.708 | 654900.0 |
| 2000-01-03 | AFAM-DELISTED | Stock | 1.0317 | 1.063 | 1.0005 | 1.063 | 44200.0 |
| 2000-01-03 | AFFX-DELISTED | Stock | 89.51 | 89.76 | 71.6 | 81.37 | 1691124.0 |
| 2000-01-03 | AFP-DELISTED | Stock | 18.375 | 18.375 | 18.125 | 18.125 | 1100.0 |
| 2000-01-03 | AGII-DELISTED | Stock | 19.987 | 19.987 | 19.006 | 19.19 | 14377.0 |
| 2000-01-03 | AGN-DELISTED | Stock | 35.5625 | 35.9375 | 34.125 | 35.0 | 602000.0 |
| 2000-01-03 | AGU-DELISTED | Stock | 8.22 | 8.905 | 8.22 | 8.905 | 420023.0 |
| 2000-01-03 | AHCI-DELISTED | Stock | 1.75 | 1.75 | 1.75 | 1.75 | 2500.0 |
| 2000-01-03 | AHPI-DELISTED | Stock | 5.5 | 5.5 | 5.0 | 5.0 | 1000.0 |
| 2000-01-03 | AIPC-DELISTED | Stock | 31.19 | 31.63 | 29.75 | 29.81 | 389000.0 |
> showing 50 of 1,650 rows — these rows as CSV