hbd1994Swaps in Base - Overview
    Updated 2023-08-29
    select
    '' as "Network",
    count(distinct ORIGIN_FROM_ADDRESS) as "Swapper",
    count(distinct tx_hash) as "Swap Transactions",
    count(*) as "Swaps",
    sum(coalesce(AMOUNT_OUT_USD , AMOUNT_IN_USD)) as "USD Volume",
    count(distinct TOKEN_IN) as "From Tokens",
    count(distinct TOKEN_OUT) as "To Tokens",
    count(distinct CONTRACT_ADDRESS) as "Pools"
    from base.defi.ez_dex_swaps
    where block_timestamp >= '{{Start_Date}}'
    and block_timestamp <= '{{End_Date}}'
    Run a query to Download Data