FatemeTheLady00 Overall stats - partcuar sddress
    Updated 2023-05-05
    select
    count(distinct tx_hash) as "Swaps",
    sum(amount_in_usd) as "volume(USD)",
    max(amount_in_usd) as "max volume(USD)",
    avg(amount_in_usd) as "avg volume(USD)",
    median(amount_in_usd) as "median volume(USD)",
    min(amount_in_usd) as "min Volume(USD)"
    from
    avalanche.core.ez_dex_swaps
    where origin_from_address='{{Address}}'
    and block_timestamp::date between '{{StartDate}}' and '{{EndDate}}'

    Run a query to Download Data