Query on a previous result

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

Run Your Initial Query

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

Access Run History

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

Copy the Run ID

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

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

Create a parameterized query Visualize results

⌘I

Use Cases

Allium App

Allium Datashares

Allium Datastreams

Allium Beam

How It Works

Time Limits

Use Cases

Example: Multi-Stage Analysis

Next Steps

Basic Queries

Parameterized Queries

Explorer API

Compute Profiles

​How It Works

​Time Limits

​Use Cases

​Example: Multi-Stage Analysis

​Next Steps

Basic Queries

Parameterized Queries

Explorer API

Compute Profiles

How It Works

Time Limits

Use Cases

Example: Multi-Stage Analysis

Next Steps