Run a basic query

Query any Allium table with SQL, from raw chain data to cross-chain models such as crosschain.dex.trades and stablecoins.core.supply_daily.

Create a query

Open Library > Queries, choose New, and name the query.

Write your SQL

The schema browser lists every schema and table, with each table’s docs. This query reads the daily circulating supply of five stablecoins:

-- Daily circulating supply of the largest stablecoins over the last 90 days
select
  date,
  token_symbol,
  sum(circulating_supply_usd) as circulating_supply_usd
from stablecoins.core.supply_daily
where
  date >= current_date - 90
  and token_symbol in ('USDT', 'USDC', 'USDe', 'USDS', 'PYUSD')
group by all
order by date

Run it

Choose Run, or press Cmd + Enter. Run saves the query first, then returns the results as a table.

Query editor with the stablecoin supply SQL and a results table of date, token symbol and circulating supply

Edits are saved only by Save or a run, so save before leaving a query you haven’t run.
A query runs on the compute profile you pick for it. See Compute profiles.
File > Export CSV downloads the results, where your plan includes exports.

Next steps

Visualize results

Chart the results and share them.

Parameterized queries

Rerun the same SQL with different values.

Query a previous result

Build on a finished run without recomputing it.

Explorer API

Run saved queries through the API.

Queries

Dashboards

Your Data

Beam

Issuer Intelligence

Settings

Next steps

Visualize results

Parameterized queries

Query a previous result

Explorer API

Queries

Dashboards

Your Data

Beam

Issuer Intelligence

Settings

​Next steps

Visualize results

Parameterized queries

Query a previous result

Explorer API

Next steps