COPE SALADA Secondary Sales & Price Scatter Chart

Summary

Upgrade the COPE SALADA section on the XCOPY dashboard to mirror ICXN with a dedicated secondary sales scatter chart (Price vs. Date in ETH) and an OpenSea secondary sales activity table, replacing the temporary full-width transfer event table.

What’s Ready:

• Validated Query: Built and tested via Seaport on Shape (seaport_shape.seaport_evt_orderfulfilled) joined with ERC-721 transfers (0xab3a867a6b14cc2f3286b9f03698656f8a892e9e).

• Accurate Data: Successfully parsed 100+ historical sales (top sale: 4.29 ETH) with dynamic ETH to USD pricing, ENS resolution, and OpenSea/Shapescan deep links.

• Layout Ready: 2x2 layout matching ICXN:

  • Scatter Chart (col 0, width 3): Date vs. Price in ETH

  • Secondary Sales Table (col 3, width 3): Time, Token #, Price, USD Amount, Seller, Buyer, Tx Link.

• Staged Locally: SQL saved at queries/cope_salada_secondary_sales.sql.

Dependency / Blocker:

• Waiting for Dune compute credits on @grifterdmac to publish and execute.