April 27, 2023

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.

April 20, 2023

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.

April 14, 2023

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

April 6, 2023

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