PREVIEW / stock_daily / 2001-01-23
file: by_date/stock_daily/2001/2001-01-23.parquet size: 92 KB rows: 2,901 symbols: 1,811
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-01-23 | AAPL | Stock | 0.3449 | 0.3739 | 0.3404 | 0.3661 | 879530400.0 |
| 2001-01-23 | MSFT | Stock | 29.875 | 30.4688 | 29.4688 | 30.2812 | 70295200.0 |
| 2001-01-23 | NVDA | Stock | 0.2057 | 0.2333 | 0.2047 | 0.2291 | 433632000.0 |
| 2001-01-23 | AMZN | Stock | 0.9188 | 0.9656 | 0.9125 | 0.9477 | 94886000.0 |
| 2001-01-23 | CL | Stock | 28.515 | 29.135 | 28.41 | 28.865 | 2749200.0 |
| 2001-01-23 | A | Stock | 44.8408 | 45.7797 | 43.9914 | 44.8856 | 3067911.0 |
| 2001-01-23 | AABA-DELISTED | Stock | 17.21875 | 19.5 | 17.09375 | 19.4765625 | 34783200.0 |
| 2001-01-23 | AAI-DELISTED | Stock | 7.5 | 8.19 | 7.44 | 7.88 | 1207600.0 |
| 2001-01-23 | AAIC-DELISTED | Stock | 145.0 | 148.75 | 142.5 | 146.25 | 52100.0 |
| 2001-01-23 | AAME | Stock | 2.0156 | 2.0156 | 1.875 | 2.0 | 15800.0 |
| 2001-01-23 | AAON | Stock | 1.2876 | 1.3681 | 1.2803 | 1.3681 | 208448.0 |
| 2001-01-23 | ABAX-DELISTED | Stock | 5.8125 | 5.8125 | 5.625 | 5.625 | 130400.0 |
| 2001-01-23 | ABC-DELISTED | Stock | 10.90625 | 11.671875 | 10.90625 | 11.671875 | 1855600.0 |
| 2001-01-23 | ABCB | Stock | 8.1053 | 8.2573 | 8.1053 | 8.1053 | 3084.0 |
| 2001-01-23 | ABCW-DELISTED | Stock | 14.69 | 15.25 | 14.63 | 15.25 | 11300.0 |
| 2001-01-23 | ABE-DELISTED | Stock | 9.4375 | 9.5625 | 9.4375 | 9.5 | 99500.0 |
| 2001-01-23 | ABFS-DELISTED | Stock | 22.125 | 22.375 | 20.5 | 21.0 | 657300.0 |
| 2001-01-23 | ABK-DELISTED | Stock | 49.0 | 51.0 | 48.81 | 50.69 | 1342300.0 |
| 2001-01-23 | ABM | Stock | 15.8125 | 15.9375 | 15.8125 | 15.9375 | 55000.0 |
| 2001-01-23 | ABMD-DELISTED | Stock | 19.4375 | 20.375 | 18.625 | 19.125 | 173700.0 |
| 2001-01-23 | ABP-DELISTED | Stock | 4.38 | 4.69 | 4.31 | 4.5 | 964000.0 |
| 2001-01-23 | ABT | Stock | 19.948 | 20.0041 | 19.4991 | 19.7516 | 8053448.0 |
| 2001-01-23 | ABTL-DELISTED | Stock | 11.406 | 12.031 | 10.625 | 11.25 | 18700.0 |
| 2001-01-23 | ABV-DELISTED | Stock | 26.75 | 26.75 | 25.75 | 25.8125 | 634800.0 |
| 2001-01-23 | ABX-DELISTED | Stock | 16.2 | 16.2 | 15.75 | 15.86 | 1193600.0 |
| 2001-01-23 | ACAS-DELISTED | Stock | 24.875 | 25.625 | 24.5625 | 25.1875 | 170600.0 |
| 2001-01-23 | ACAT-DELISTED | Stock | 12.4375 | 12.875 | 12.375 | 12.75 | 6300.0 |
| 2001-01-23 | ACCL-DELISTED | Stock | 20.0900001525879 | 20.4559993743896 | 19.7320003509521 | 20.3659992218018 | 445100.0 |
| 2001-01-23 | ACE-DELISTED | Stock | 36.3125 | 38.9375 | 35.6875 | 38.5 | 1612300.0 |
| 2001-01-23 | ACF-DELISTED | Stock | 33.44 | 34.94 | 33.25 | 34.94 | 754700.0 |
| 2001-01-23 | ACG-DELISTED | Stock | 7.875 | 7.9375 | 7.8125 | 7.8125 | 290800.0 |
| 2001-01-23 | ACGL | Stock | 1.625 | 1.7222 | 1.625 | 1.6667 | 58500.0 |
| 2001-01-23 | ACGN-DELISTED | Stock | 672.9688 | 736.6712 | 578.0 | 634.6712 | 110500.0 |
| 2001-01-23 | ACH | Stock | 10.625 | 11.0833 | 10.5 | 10.875 | 620850.0 |
| 2001-01-23 | ACLS | Stock | 42.25 | 45.75 | 40.5 | 44.0 | 276500.0 |
| 2001-01-23 | ACO-DELISTED | Stock | 4.5 | 4.625 | 4.1875 | 4.375 | 20400.0 |
| 2001-01-23 | ACPW-DELISTED | Stock | 145.0 | 145.31 | 118.12 | 127.5 | 80360.0 |
| 2001-01-23 | ACS-DELISTED | Stock | 29.375 | 30.0625 | 29.3125 | 29.9688 | 223700.0 |
| 2001-01-23 | ACTA-DELISTED | Stock | 101.25 | 119.38 | 98.12 | 118.12 | 184600.0 |
| 2001-01-23 | ACTT-DELISTED | Stock | 7.9375 | 9.25 | 7.9375 | 8.8125 | 25500.0 |
| 2001-01-23 | ACTU-DELISTED | Stock | 19.84 | 23.0 | 19.63 | 23.0 | 589200.0 |
| 2001-01-23 | ACXM-DELISTED | Stock | 28.13 | 35.0 | 27.88 | 33.03 | 4941959.0 |
| 2001-01-23 | ACY-DELISTED | Stock | 4.88 | 4.88 | 4.5 | 4.81 | 6200.0 |
| 2001-01-23 | AD | Stock | 38.7333 | 39.84 | 38.0667 | 38.6 | 445800.0 |
| 2001-01-23 | ADAT-DELISTED | Stock | 87.19 | 93.37 | 84.38 | 88.88 | 13800.0 |
| 2001-01-23 | ADBE | Stock | 29.8438 | 30.0 | 28.9375 | 29.7188 | 6972000.0 |
| 2001-01-23 | ADC | Stock | 15.125 | 15.75 | 15.0 | 15.5625 | 16900.0 |
| 2001-01-23 | ADEP-DELISTED | Stock | 135.31 | 144.06 | 135.0 | 138.75 | 58100.0 |
| 2001-01-23 | ADGF-DELISTED | Stock | 1.19 | 1.47 | 1.19 | 1.44 | 72300.0 |
| 2001-01-23 | ADI | Stock | 56.0 | 57.5 | 54.75 | 56.3125 | 3020200.0 |
> showing 50 of 2,901 rows — these rows as CSV