MadiDEX swaps amount by protocol
    Updated 2022-12-21
    with

    df as (
    select date_trunc('day',BLOCK_TIMESTAMP) as date, PLATFORM, TX_HASH, SENDER, SYMBOL_IN, AMOUNT_IN_USD
    from ethereum.core.ez_dex_swaps
    WHERE date >= '2022-01-01' and EVENT_NAME = 'Swap'
    ),

    dd as (select df.date as date,
    platform,
    count(distinct df.TX_HASH) as TX_count,
    count(distinct SENDER) as SENDERs,
    sum(AMOUNT_IN_USD) as sum_usd,
    TX_count/SENDERs as "Transactions per user",
    min(AMOUNT_IN_USD) as min_usd,
    max(AMOUNT_IN_USD) as max_usd,
    avg(AMOUNT_IN_USD) as avg_usd,
    median(AMOUNT_IN_USD) as median_usd,
    min(TX_FEE) as min_fee,
    median(TX_FEE) as median_fee,
    avg(TX_FEE) as avg_fee,
    max(TX_FEE) as max_fee,
    sum(tx_fee) as fee,
    sum(GAS_USED) as gas,
    min(GAS_USED) as min_gas,
    median(GAS_USED) as median_gas,
    avg(GAS_USED) as avg_gas,
    max(GAS_USED) as max_gas
    from df join ethereum.core.fact_transactions on df.tx_hash = ethereum.core.fact_transactions.tx_hash
    where df.date >= '2022-01-01' and AMOUNT_IN_USD >0
    group by 1,2)

    select platform as Protocol, sum(sum_usd) as "DEX swaps amount, USD",
    min(min_usd) as "Min swap amount",
    median(median_usd) as "Median swap amount",
    avg(avg_usd) as "Avg swap amount",
    Run a query to Download Data