flipside

    total stats: axl swap on eth
    Eman-Raztotal stats: axl swap on eth
    Updated 2024-11-23
    with swap_data as (select block_timestamp, tx_hash as swap, amount_in as swap_amount_axl, amount_in_usd as swap_amount_usd,
    origin_from_address as swapper
    from ethereum.defi.ez_dex_swaps
    where token_in='0x467719ad09025fcc6cf6f8311755809d45a5e5f3'

    union all

    select block_timestamp, tx_hash as swap, amount_out as swap_amount_axl, amount_out_usd as swap_amount_usd,
    origin_from_address as swapper
    from ethereum.defi.ez_dex_swaps
    where token_out='0x467719ad09025fcc6cf6f8311755809d45a5e5f3')

    select count(distinct swap) as "Swap Count",
    sum(swap_amount_axl) as "Swap Volume ($AXL)", sum(swap_amount_USD) as "Swap Volume ($USD)",
    count(distinct swapper) as "Swapper Count"
    from swap_data
    where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

    QueryRunArchived: QueryRun has been archived