Query on a previous result

Every finished run keeps its results as a table you can query. Reference it to aggregate, filter or join an expensive result without recomputing it.

Copy a run ID

Open the query whose results you want and copy the ID of a successful run from its run history.

Run history listing successful runs with their age, duration and run ID

Query it as a table

Read the run as query_history.<run_id>. This query takes the stablecoin supply results from Run a basic query and works out each stablecoin’s share on the latest day:

-- Each stablecoin's share of supply on the latest day of a previous run
select
  token_symbol,
  circulating_supply_usd,
  circulating_supply_usd / sum(circulating_supply_usd) over () as share_of_supply
from query_history.F4Gw4rjRkH7de06rFBPu_20261020T005305_lives
where date = (select max(date) from query_history.F4Gw4rjRkH7de06rFBPu_20261020T005305_lives)
order by circulating_supply_usd desc

Query editor reading query_history with a five-row result of each stablecoin's share of supply

A query that joins a query_history result with Allium tables can only use results less than 24 hours old. A query that reads only query_history results has no age limit.

Queries

Dashboards

Your Data

Beam

Issuer Intelligence

Settings

Next steps

Parameterized queries

Compute profiles

Queries

Dashboards

Your Data

Beam

Issuer Intelligence

Settings

​Next steps

Parameterized queries

Compute profiles

Next steps