PREVIEW / stock_daily / 2001-04-20
file: by_date/stock_daily/2001/2001-04-20.parquet size: 99 KB rows: 2,916 symbols: 1,808
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-04-20 | AAPL | Stock | 0.4452 | 0.4577 | 0.4393 | 0.4471 | 693403200.0 |
| 2001-04-20 | MSFT | Stock | 35.15 | 35.55 | 34.25 | 34.5 | 192919600.0 |
| 2001-04-20 | NVDA | Stock | 0.3454 | 0.375 | 0.3363 | 0.3623 | 1773840000.0 |
| 2001-04-20 | AMZN | Stock | 0.781 | 0.81 | 0.7485 | 0.789 | 170442000.0 |
| 2001-04-20 | CL | Stock | 26.325 | 26.825 | 25.95 | 26.65 | 5099400.0 |
| 2001-04-20 | A | Stock | 27.8827 | 29.3276 | 27.5465 | 28.8984 | 3567277.0 |
| 2001-04-20 | AABA-DELISTED | Stock | 10.1000003814697 | 10.4899997711182 | 9.60999965667725 | 9.92500019073486 | 25914000.0 |
| 2001-04-20 | AAI-DELISTED | Stock | 9.9 | 9.99 | 9.8 | 9.88 | 501900.0 |
| 2001-04-20 | AAIC-DELISTED | Stock | 116.0 | 117.0 | 108.0 | 108.0 | 28700.0 |
| 2001-04-20 | AAON | Stock | 1.112 | 1.115 | 1.112 | 1.112 | 35880.0 |
| 2001-04-20 | ABAX-DELISTED | Stock | 4.9 | 5.2 | 4.51 | 5.05 | 33300.0 |
| 2001-04-20 | ABB-DELISTED | Stock | 17.83 | 18.0 | 17.6 | 17.87 | 62900.0 |
| 2001-04-20 | ABC-DELISTED | Stock | 12.9899997711182 | 12.9899997711182 | 12.5749998092651 | 12.8575000762939 | 2707600.0 |
| 2001-04-20 | ABCB | Stock | 9.0537 | 9.3212 | 8.997 | 9.1428 | 5675.0 |
| 2001-04-20 | ABCW-DELISTED | Stock | 13.43 | 13.86 | 13.25 | 13.3 | 9600.0 |
| 2001-04-20 | ABE-DELISTED | Stock | 8.44 | 8.44 | 8.3 | 8.35 | 48000.0 |
| 2001-04-20 | ABFS-DELISTED | Stock | 17.05 | 17.1 | 16.65 | 16.98 | 100500.0 |
| 2001-04-20 | ABK-DELISTED | Stock | 55.25 | 55.6 | 53.4 | 53.96 | 2040600.0 |
| 2001-04-20 | ABM | Stock | 15.025 | 15.395 | 14.985 | 15.25 | 74200.0 |
| 2001-04-20 | ABMD-DELISTED | Stock | 19.1 | 21.57 | 18.9 | 20.0 | 135100.0 |
| 2001-04-20 | ABP-DELISTED | Stock | 4.35 | 4.45 | 4.26 | 4.3 | 61700.0 |
| 2001-04-20 | ABT | Stock | 19.9985 | 20.2499 | 19.9043 | 20.2409 | 10627068.0 |
| 2001-04-20 | ABTL-DELISTED | Stock | 6.1 | 6.35 | 6.05 | 6.3 | 24800.0 |
| 2001-04-20 | ABV-DELISTED | Stock | 22.75 | 22.75 | 21.0 | 21.3 | 519200.0 |
| 2001-04-20 | ABX-DELISTED | Stock | 15.94 | 16.0 | 15.7 | 15.77 | 2033500.0 |
| 2001-04-20 | ACAP-DELISTED | Stock | 17.95 | 17.95 | 17.73 | 17.8 | 31500.0 |
| 2001-04-20 | ACAS-DELISTED | Stock | 26.25 | 26.25 | 26.0 | 26.1 | 103800.0 |
| 2001-04-20 | ACAT-DELISTED | Stock | 13.12 | 13.2 | 13.01 | 13.01 | 45600.0 |
| 2001-04-20 | ACCL-DELISTED | Stock | 14.7002000808716 | 15.0978002548218 | 14.3591995239258 | 15.0978002548218 | 337100.0 |
| 2001-04-20 | ACE-DELISTED | Stock | 36.49 | 36.85 | 33.79 | 34.9 | 1537500.0 |
| 2001-04-20 | ACF-DELISTED | Stock | 44.91 | 44.94 | 43.3 | 43.79 | 920200.0 |
| 2001-04-20 | ACG-DELISTED | Stock | 7.93 | 7.96 | 7.9 | 7.92 | 243200.0 |
| 2001-04-20 | ACGL | Stock | 1.7167 | 1.7333 | 1.7056 | 1.7233 | 1157400.0 |
| 2001-04-20 | ACGN-DELISTED | Stock | 544.0 | 578.0 | 544.0 | 578.0 | 12800.0 |
| 2001-04-20 | ACH | Stock | 11.2333 | 11.3 | 10.8667 | 11.0333 | 104550.0 |
| 2001-04-20 | ACLS | Stock | 56.84 | 59.48 | 55.96 | 59.08 | 1050350.0 |
| 2001-04-20 | ACO-DELISTED | Stock | 4.56 | 4.66 | 4.45 | 4.45 | 41400.0 |
| 2001-04-20 | ACPW-DELISTED | Stock | 103.05 | 110.95 | 102.55 | 107.5 | 227500.0 |
| 2001-04-20 | ACS-DELISTED | Stock | 33.825 | 33.825 | 31.7 | 32.425 | 1040000.0 |
| 2001-04-20 | ACTA-DELISTED | Stock | 44.8 | 57.0 | 43.0 | 45.2 | 251800.0 |
| 2001-04-20 | ACTT-DELISTED | Stock | 5.9 | 5.95 | 5.9 | 5.92 | 7700.0 |
| 2001-04-20 | ACTU-DELISTED | Stock | 11.65 | 11.7 | 10.8 | 10.95 | 337100.0 |
| 2001-04-20 | ACXM-DELISTED | Stock | 15.68 | 15.8 | 15.29 | 15.7 | 868400.0 |
| 2001-04-20 | ACY-DELISTED | Stock | 4.6 | 4.6 | 4.5 | 4.6 | 3000.0 |
| 2001-04-20 | AD | Stock | 44.6333 | 44.6333 | 42.72 | 43.3333 | 142800.0 |
| 2001-04-20 | ADAT-DELISTED | Stock | 110.16 | 113.58 | 108.0 | 113.58 | 10716.0 |
| 2001-04-20 | ADBE | Stock | 23.505 | 24.07 | 22.36 | 22.98 | 9952400.0 |
| 2001-04-20 | ADC | Stock | 16.4 | 16.45 | 16.27 | 16.3 | 2800.0 |
| 2001-04-20 | ADEP-DELISTED | Stock | 55.75 | 61.45 | 54.0 | 61.15 | 26400.0 |
| 2001-04-20 | ADGF-DELISTED | Stock | 1.11 | 1.15 | 1.08 | 1.08 | 20000.0 |
> showing 50 of 2,916 rows — these rows as CSV