Run a basic query - Allium Documentation Hub

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;

Execute and View Results

Click Run to execute the query. Results appear in table format:

Switch to chart view and group by chain to visualize the data:

Learn more about charting options in the Visualize Results guide.

Next Steps

Parameterized Queries

Create reusable queries with configurable parameters

Query Previous Results

Build on top of completed query runs

Explorer API

Execute queries programmatically via REST endpoints

Visualize Results

Create charts and visualizations from query results

Overview Create a parameterized query

⌘I

​Next Steps

Parameterized Queries

Query Previous Results

Explorer API

Visualize Results

Next Steps