Features

  • Multi-Chain Support: Write SQL queries that span across all blockchains offered by Allium in a single platform.
  • Unified Data Schema: Leverage abstracted data models across different blockchains (e.g crosschain.dex.trades and crosschain.stablecoin.transfers) to simplify query writing.
  • Parameterized Queries: Create dynamic, reusable SQL statements with user-defined parameters.
  • SQL Formatter: Formats your code to clean, readable SQL code, enhancing collaboration and maintenance.
Using the Explorer Query Runner: In this example we will show you how to fetch DEX USD Volume for Ethereum, Base, and Solana with parameterized queries. Example: Fetch DEX USD Volume for Ethereum, Base, and Solana Head to https://app.allium.so/explorer and click on New to create a new query. Creating the query:
  1. Copy and paste the query below into the query editor.
select 
    date(block_timestamp) as date, 
    chain, 
    sum(usd_amount) as usd_volume
from crosschain.dex.trades
where block_timestamp >= current_timestamp - interval '{{last_n_days}} days' and chain in ('ethereum', 'base', 'solana')
group by all
order by 1 desc
  1. The {{last_n_days}} is a parameter that you can use to filter the data. There will be a window to input the parameter value once a parameter is defined.
  2. Click on Format to format the query.
  3. Click on Save to save the query.
  4. Click on Run (or Crtl+Enter / Mac: Cmd+Enter) to execute the query.