PREVIEW / stock_daily / 2000-01-20
file: by_date/stock_daily/2000/2000-01-20.parquet size: 87 KB rows: 2,705 symbols: 1,689
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-20 | AAPL | Stock | 1.0313 | 1.0848 | 1.0134 | 1.0134 | 1831132800.0 |
| 2000-01-20 | MSFT | Stock | 53.5312 | 54.8438 | 52.9375 | 53.0 | 56349800.0 |
| 2000-01-20 | NVDA | Stock | 0.0953 | 0.1005 | 0.0935 | 0.0943 | 179568000.0 |
| 2000-01-20 | AMZN | Stock | 3.3469 | 3.35 | 3.1969 | 3.2375 | 119560000.0 |
| 2000-01-20 | CL | Stock | 30.6875 | 31.875 | 30.25 | 30.9688 | 3082000.0 |
| 2000-01-20 | A | Stock | 50.608 | 50.6974 | 48.2833 | 48.7303 | 2007947.0 |
| 2000-01-20 | AABA-DELISTED | Stock | 92.265625 | 92.984375 | 87.25 | 87.984375 | 31349600.0 |
| 2000-01-20 | AAI-DELISTED | Stock | 4.5 | 4.63 | 4.44 | 4.63 | 400100.0 |
| 2000-01-20 | AAIC-DELISTED | Stock | 165.0 | 173.75 | 165.0 | 167.5 | 112300.0 |
| 2000-01-20 | AAME | Stock | 2.5 | 2.5 | 2.25 | 2.5 | 14600.0 |
| 2000-01-20 | AAON | Stock | 0.845 | 0.8523 | 0.8413 | 0.8413 | 64927.0 |
| 2000-01-20 | ABAX-DELISTED | Stock | 9.0 | 9.0 | 8.25 | 8.6875 | 127900.0 |
| 2000-01-20 | ABC-DELISTED | Stock | 5.234375 | 5.25 | 5.0 | 5.046875 | 1674000.0 |
| 2000-01-20 | ABCB | Stock | 8.004 | 8.1053 | 7.8014 | 8.1053 | 21962.0 |
| 2000-01-20 | ABCW-DELISTED | Stock | 14.72 | 14.75 | 13.94 | 14.28 | 39600.0 |
| 2000-01-20 | ABE-DELISTED | Stock | 16.375 | 16.4375 | 16.125 | 16.125 | 55700.0 |
| 2000-01-20 | ABFS-DELISTED | Stock | 13.9375 | 13.9375 | 12.6875 | 13.5 | 159600.0 |
| 2000-01-20 | ABK-DELISTED | Stock | 48.81 | 49.0 | 47.19 | 48.0 | 224900.0 |
| 2000-01-20 | ABM | Stock | 10.125 | 10.1562 | 9.9062 | 10.1562 | 151200.0 |
| 2000-01-20 | ABMD-DELISTED | Stock | 23.53125 | 24.438 | 23.46875 | 23.5 | 43200.0 |
| 2000-01-20 | ABT | Stock | 14.6734 | 14.7576 | 14.2245 | 14.3929 | 15429241.0 |
| 2000-01-20 | ABTL-DELISTED | Stock | 61.25 | 61.56 | 57.5 | 57.5 | 125200.0 |
| 2000-01-20 | ABV-DELISTED | Stock | 14.31 | 14.62 | 14.0 | 14.13 | 201800.0 |
| 2000-01-20 | ABX-DELISTED | Stock | 17.188 | 17.188 | 17.0 | 17.063 | 1490975.0 |
| 2000-01-20 | ACAS-DELISTED | Stock | 23.5625 | 24.0625 | 23.4375 | 23.625 | 60600.0 |
| 2000-01-20 | ACAT-DELISTED | Stock | 10.188 | 10.188 | 9.938 | 9.938 | 144293.0 |
| 2000-01-20 | ACCL-DELISTED | Stock | 26.2000007629395 | 26.4300003051758 | 23.7150001525879 | 25.7970008850098 | 342200.0 |
| 2000-01-20 | ACE-DELISTED | Stock | 19.625 | 19.9375 | 19.5625 | 19.75 | 656400.0 |
| 2000-01-20 | ACF-DELISTED | Stock | 17.69 | 17.69 | 17.06 | 17.31 | 295500.0 |
| 2000-01-20 | ACG-DELISTED | Stock | 7.4375 | 7.5625 | 7.3125 | 7.5 | 184700.0 |
| 2000-01-20 | ACGN-DELISTED | Stock | 2266.6712 | 3931.3112 | 1983.3288 | 2585.4824 | 304000.0 |
| 2000-01-20 | ACH | Stock | 6.25 | 6.3333 | 6.0833 | 6.125 | 59550.0 |
| 2000-01-20 | ACO-DELISTED | Stock | 15.3125 | 15.5 | 15.1875 | 15.1875 | 45300.0 |
| 2000-01-20 | ACS-DELISTED | Stock | 23.4688 | 24.4688 | 23.4688 | 24.0 | 131000.0 |
| 2000-01-20 | ACTA-DELISTED | Stock | 3100.0 | 3185.0 | 3010.0 | 3045.0 | 149100.0 |
| 2000-01-20 | ACTT-DELISTED | Stock | 9.875 | 11.125 | 9.4375 | 10.9375 | 92400.0 |
| 2000-01-20 | ACTU-DELISTED | Stock | 50.0 | 50.13 | 46.88 | 46.88 | 309400.0 |
| 2000-01-20 | ACXM-DELISTED | Stock | 26.9999 | 27.5011 | 26.87464 | 27.063 | 872691.0 |
| 2000-01-20 | ACY-DELISTED | Stock | 6.06 | 6.06 | 6.06 | 6.06 | 1800.0 |
| 2000-01-20 | AD | Stock | 66.0833 | 67.6667 | 66.0833 | 66.6667 | 420900.0 |
| 2000-01-20 | ADAT-DELISTED | Stock | 283.5 | 286.87 | 261.0 | 280.12 | 18400.0 |
| 2000-01-20 | ADBE | Stock | 15.9062 | 16.1562 | 15.375 | 15.9531 | 4248800.0 |
| 2000-01-20 | ADC | Stock | 13.4375 | 13.8125 | 13.4375 | 13.6875 | 9000.0 |
| 2000-01-20 | ADEP-DELISTED | Stock | 34.06 | 34.38 | 31.88 | 33.75 | 8200.0 |
| 2000-01-20 | ADGF-DELISTED | Stock | 1.97 | 2.0 | 1.75 | 1.94 | 106300.0 |
| 2000-01-20 | ADI | Stock | 51.625 | 52.0 | 49.5 | 49.7188 | 1991000.0 |
| 2000-01-20 | ADM | Stock | 12.1315 | 12.1882 | 11.5646 | 11.8481 | 1527073.0 |
| 2000-01-20 | ADMP-DELISTED | Stock | 637.5 | 701.25 | 616.25 | 658.75 | 600.0 |
| 2000-01-20 | ADPI-DELISTED | Stock | 6.84 | 6.88 | 6.81 | 6.81 | 6100.0 |
| 2000-01-20 | ADSK | Stock | 7.5625 | 7.7734 | 7.4688 | 7.5625 | 1371600.0 |
> showing 50 of 2,705 rows — these rows as CSV