Quick Start

• Head over to: https://app.allium.so/explorer once you receive your login.
• Create a new query by clicking the "New" button
• Copy the sample query below into the query editor panel.

-- Fetch the daily volume and number of senders for Uniswap v3 compatible blockchains 
-- on Ethereum, Fantom, Base, and Optimism in the last 6 months.
select 
  date(block_timestamp) as date,
  chain,
  sum(usd_amount) as usd_volume,
  count(distinct transaction_from_address) as senders
from crosschain.dex.trades
where block_timestamp >= current_timestamp - interval '6 months'
  and chain in ('ethereum', 'fantom', 'base', 'optimism')
  and protocol = 'uniswap_v3'
group by all 
order by 1 desc

• Click on the "Run" button to see the results.

Data Guide

Key points to note when querying the data:

• SQL Flavor: Our batch data uses Snowflake SQL.
• Timestamps: All timestamps are in Coordinated Universal Time (UTC).
• Prices: All price-related data are in USD denomination, unless otherwise stated.
• Native Token: Native gas tokens (e.g., Ether) are represented by burn address (0x0000000000000000000000000000000000000000).
• Address Casing: All EVM addresses are in lowercase. Solana, Bitcoin, and Tron addresses are case-sensitive.

Address Casing Examples

Incorrect ❌

select *
from ethereum.dex.trades
where token_bought_address = '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2' -- weth contract address
  and block_timestamp >= current_timestamp - interval '12 hours'
order by block_number desc
limit 100

Correct ✅

select *
from ethereum.dex.trades
where token_bought_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' -- weth contract address
  and block_timestamp >= current_timestamp - interval '12 hours'
order by block_number desc
limit 100