New Subscription Plans

• We have overhauled our plans by making the API accessible to all users, offering more to Free users and moving to a more flexible credit-based model with unlimited collaboration baked in.
• Learn more through this announcement, and check them out here.

DuneSQL Migration

• We have published a new timeline for migrating to DuneSQL and sunsetting our other query engines, Postgres and SparkSQL.

Improvements & Fixes

• Shipped an API button in the Query Editor for easily fetching a query’s results programmatically.
• Added 1inch into dex_aggregator.trades.
• Released the first issue of the Weekly Prophet, which consists of a weekly overview of all changes occurring in Spellbook.
• Added support for translating explodes and more into Harmonizer, our open-source query translation tool for migrating to DuneSQL.
  

Improvements & Fixes

• Solana native decoding, which means we now also support decoding of native Solana programs in addition to Anchor programs. You can submit Solana contracts to us via this form.
• Open sourced harmonizer, a tool to migrate Postgres and SparkSQL queries to DuneSQL.

Improvements & Fixes

• Launched our first several Solana decoded contracts, including protocols like Candy Machine, Drift, Jupiter, Mango, Sharky, Whirlpool and Zeta. Here is an example which uses the views.
• Released Version History, which allows you to view a trail of updates to your query, restore previous versions, compare them with a diff viewer.
• Materialized nft.trades and perpetuals.trades for faster selects.
• Released `ethereum.withdrawals` - Data on Ethereum Beacon Chain withdrawals

Improvements & Fixes

• Rolled out more powerful performance tiers for DuneSQL
• Improved DuneSQL to handle larger data loads by spilling data to disk
• Released an API endpoint to fetch a query’s latest results by query ID
• Revamped DuneSQL docs