MLDZMNsquid1
    Updated 2023-04-12
    select
    count(distinct tx_hash) as no_txn,
    count(distinct SENDER) as no_users,
    sum(amount) as volume,
    avg(AMOUNT) as avg_volume,
    median(AMOUNT) as median_volume,
    no_users/count(distinct date_trunc(day, block_timestamp)) as average_user_day,
    volume/count(distinct date_trunc(day, block_timestamp)) as average_volume_day

    from axelar.core.ez_squid

    Run a query to Download Data