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 Flavour: 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 for their contract address .E.g.for Ethereum: 0x0000000000000000000000000000000000000000
• Address Casing: All EVM addresses are in lowercase. Solana, Bitcoin and Tron address are case-sensitive.

Address Casing:

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

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