Skip to main content
You can reference the results of any completed query run in a new query. This enables you to build multi-stage analyses, perform additional aggregations, or join datasets without re-executing expensive queries.

​
How It Works

1

Run Your Initial Query

Execute any query in the Allium App. Once complete, the results are stored and can be referenced by other queries.
2

Access Run History

On the query editor page, click View Run History to see all completed runs:
Query run history
3

Copy the Run ID

Find the query run you want to reference and click the copy button to copy its Run ID.
4

Reference in a New Query

Use the Run ID in a new query with the format query_history.<query_run_id>:
select sum(usd_volume)
from query_history.hoHTRjrs2MO3X64I5Rc2_20251001T080527_horde;
You can perform any SQL operations on the query history results, including joins, aggregations, and filtering.

​
Time Limits

Query History Time Constraints
  • Mixed queries: When combining query_history results with Allium data tables, query results must be less than 24 hours old
  • Query history only: When querying exclusively from query_history tables, there is no time limit

​
Use Cases

Querying previous results is useful for:
  • Breaking down complex analyses into manageable steps
  • Joining pre-computed datasets without re-running expensive queries
  • Performing multiple aggregations on the same base dataset
  • Creating derived tables for further analysis
  • Iterating on analysis without recomputing source data

​
Example: Multi-Stage Analysis

-- Step 1: Run a query to get daily DEX volumes (save as query_id_1)
select
  date(block_timestamp) as date,
  chain,
  sum(usd_amount) as daily_volume
from crosschain.dex.trades
where block_timestamp >= current_timestamp - interval '30 days'
group by all;

-- Step 2: Calculate 7-day moving average from the first query
select
  date,
  chain,
  daily_volume,
  avg(daily_volume) over (
    partition by chain 
    order by date 
    rows between 6 preceding and current row
  ) as ma_7d
from query_history.query_id_1_20251015T120000_horde
order by chain, date;

​
Next Steps

Basic Queries

Learn the fundamentals of running queries

Parameterized Queries

Create reusable queries with configurable parameters

Explorer API

Access query results programmatically

Compute Profiles

Optimize performance for complex queries
⌘I