0xaimanusd vol
    Updated 2023-04-18
    (
    select
    date_trunc('month', block_timestamp) as month,
    case
    when block_timestamp is not null then 'squid'
    end as platform,
    sum(amount) as vol
    from
    (
    (
    select
    x.*,
    project_name
    from
    (
    SELECT
    es.block_timestamp,
    destination_chain,
    es.tx_hash,
    es.token_symbol,
    es.amount,
    arb.to_address,
    origin_from_address
    from
    axelar.core.ez_squid es
    join arbitrum.core.fact_token_transfers arb on arb.tx_hash = es.tx_hash
    where
    source_chain = 'arbitrum'
    ) x
    join arbitrum.core.dim_labels arb2 on arb2.address = x.to_address
    where
    label_type = 'dex'
    )
    Union
    (
    select
    Run a query to Download Data