PREVIEW / stock_daily / 2001-09-19
file: by_date/stock_daily/2001/2001-09-19.parquet size: 102 KB rows: 3,048 symbols: 1,909
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 |
|---|---|---|---|---|---|---|---|
| 2001-09-19 | AAPL | Stock | 0.2946 | 0.3054 | 0.2786 | 0.3039 | 373318400.0 |
| 2001-09-19 | MSFT | Stock | 27.23 | 27.35 | 25.3 | 26.935 | 126950200.0 |
| 2001-09-19 | NVDA | Stock | 0.2677 | 0.2707 | 0.2255 | 0.2629 | 1561908000.0 |
| 2001-09-19 | AMZN | Stock | 0.3675 | 0.3725 | 0.332 | 0.3655 | 188730000.0 |
| 2001-09-19 | CL | Stock | 29.0 | 29.005 | 28.195 | 28.475 | 6391400.0 |
| 2001-09-19 | A | Stock | 15.4006 | 16.4521 | 14.3848 | 16.2732 | 4091666.0 |
| 2001-09-19 | AABA-DELISTED | Stock | 5.09499979019165 | 5.19999980926514 | 4.90000009536743 | 5.03499984741211 | 24542000.0 |
| 2001-09-19 | AAI-DELISTED | Stock | 3.59 | 3.61 | 3.2 | 3.43 | 1365900.0 |
| 2001-09-19 | AAIC-DELISTED | Stock | 115.0 | 115.0 | 110.0 | 110.2 | 23900.0 |
| 2001-09-19 | AAME | Stock | 1.16 | 1.22 | 1.13 | 1.22 | 28400.0 |
| 2001-09-19 | AAON | Stock | 1.6557 | 1.6827 | 1.6095 | 1.6645 | 1031991.0 |
| 2001-09-19 | AAXN-DELISTED | Stock | 0.716666638851166 | 0.716666638851166 | 0.625 | 0.663333356380463 | 494400.0 |
| 2001-09-19 | ABAX-DELISTED | Stock | 4.01 | 4.1 | 3.61 | 4.0 | 28200.0 |
| 2001-09-19 | ABB-DELISTED | Stock | 7.48 | 7.6 | 7.0 | 7.0 | 68400.0 |
| 2001-09-19 | ABC-DELISTED | Stock | 16.24 | 16.29 | 15.8 | 16.08 | 5694400.0 |
| 2001-09-19 | ABCB | Stock | 10.5775 | 10.6585 | 10.537 | 10.5937 | 9993.0 |
| 2001-09-19 | ABCW-DELISTED | Stock | 16.25 | 17.65 | 16.25 | 17.45 | 50900.0 |
| 2001-09-19 | ABE-DELISTED | Stock | 6.22 | 6.22 | 6.15 | 6.2 | 10500.0 |
| 2001-09-19 | ABFS-DELISTED | Stock | 21.72 | 21.85 | 20.31 | 21.27 | 233600.0 |
| 2001-09-19 | ABK-DELISTED | Stock | 52.5 | 52.51 | 46.0 | 47.98 | 2038200.0 |
| 2001-09-19 | ABM | Stock | 15.0 | 15.0 | 14.22 | 14.62 | 170200.0 |
| 2001-09-19 | ABMD-DELISTED | Stock | 14.56 | 14.75 | 13.53 | 14.5 | 424600.0 |
| 2001-09-19 | ABP-DELISTED | Stock | 1.75 | 2.1 | 1.42 | 1.9 | 369000.0 |
| 2001-09-19 | ABT | Stock | 22.6695 | 22.8042 | 21.6729 | 22.2655 | 10791469.0 |
| 2001-09-19 | ABTL-DELISTED | Stock | 5.8 | 5.8 | 4.5 | 4.5 | 16400.0 |
| 2001-09-19 | ABV-DELISTED | Stock | 17.0 | 17.5 | 16.94 | 17.02 | 304700.0 |
| 2001-09-19 | ABX-DELISTED | Stock | 16.69 | 17.199 | 16.65 | 16.85 | 4421544.0 |
| 2001-09-19 | ACAP-DELISTED | Stock | 20.8 | 21.0 | 19.0 | 19.04 | 212400.0 |
| 2001-09-19 | ACAS-DELISTED | Stock | 27.32 | 27.5 | 24.45 | 26.26 | 327600.0 |
| 2001-09-19 | ACAT-DELISTED | Stock | 15.0 | 15.0 | 14.9 | 14.9 | 158500.0 |
| 2001-09-19 | ACCL-DELISTED | Stock | 9.47999954223633 | 9.5939998626709 | 8.98600006103516 | 9.22500038146973 | 608600.0 |
| 2001-09-19 | ACE-DELISTED | Stock | 25.02 | 25.06 | 22.9 | 23.89 | 13409700.0 |
| 2001-09-19 | ACF-DELISTED | Stock | 34.6 | 34.6 | 29.5 | 31.25 | 3022300.0 |
| 2001-09-19 | ACG-DELISTED | Stock | 8.58 | 8.58 | 7.5 | 8.02 | 840500.0 |
| 2001-09-19 | ACGL | Stock | 2.0 | 2.0 | 1.9556 | 1.9556 | 37800.0 |
| 2001-09-19 | ACGN-DELISTED | Stock | 940.6712 | 1133.3288 | 918.0 | 1020.0 | 22400.0 |
| 2001-09-19 | ACH | Stock | 12.6 | 12.6533 | 12.1 | 12.3333 | 118500.0 |
| 2001-09-19 | ACLS | Stock | 47.84 | 48.4 | 41.64 | 43.2 | 303475.0 |
| 2001-09-19 | ACO-DELISTED | Stock | 5.72 | 5.72 | 5.58 | 5.61 | 47800.0 |
| 2001-09-19 | ACPW-DELISTED | Stock | 23.4 | 24.25 | 18.75 | 20.7 | 197980.0 |
| 2001-09-19 | ACS-DELISTED | Stock | 42.0 | 43.5 | 41.9625 | 43.45 | 1153800.0 |
| 2001-09-19 | ACTA-DELISTED | Stock | 11.0 | 11.0 | 9.0 | 9.8 | 67800.0 |
| 2001-09-19 | ACTT-DELISTED | Stock | 7.43 | 7.9 | 6.98 | 7.2 | 175100.0 |
| 2001-09-19 | ACTU-DELISTED | Stock | 4.25 | 4.27 | 2.8 | 3.7 | 3709900.0 |
| 2001-09-19 | ACXM-DELISTED | Stock | 10.01 | 10.24 | 8.43 | 9.36 | 2423000.0 |
| 2001-09-19 | ACY-DELISTED | Stock | 5.5 | 5.68 | 5.5 | 5.68 | 3400.0 |
| 2001-09-19 | AD | Stock | 32.68 | 33.2 | 32.5333 | 33.0667 | 122550.0 |
| 2001-09-19 | ADAT-DELISTED | Stock | 66.6 | 69.48 | 55.8 | 66.6 | 1662.0 |
| 2001-09-19 | ADBE | Stock | 13.765 | 14.525 | 12.3 | 13.05 | 22127400.0 |
| 2001-09-19 | ADC | Stock | 18.56 | 19.3 | 18.56 | 18.66 | 11600.0 |
> showing 50 of 3,048 rows — these rows as CSV