Run a basic query

Next Steps

Write SQL queries spanning all blockchains offered by Allium. Query raw blockchain data for full flexibility, or leverage abstracted data models to quickly access the data you need (e.g., crosschain.dex.trades and crosschain.stablecoin.transfers).

Create a New Query

Navigate to app.allium.so/analyze/queries and click New.

Write Your SQL Query

Enter your SQL query in the editor. Here’s an example that fetches DEX USD volume for Ethereum, Base, and Solana over the last 10 days:

-- DEX USD volume for Ethereum, Base, and Solana for the last 10 days
select
  date(block_timestamp) as date,
  chain,
  sum(usd_amount) as usd_volume
from crosschain.dex.trades
where
  block_timestamp >= current_timestamp - interval '10 days'
  and chain in ('ethereum', 'base', 'solana')
group by all
order by date asc;