eslamis-darkattrain swap mask
    Updated 2022-09-29
    select date_trunc('day', a.block_timestamp) as date,sum(ETH_VALUE) as volume_eth,COUNT(a.TX_HASH) as number_of_swaps
    from ethereum.core.fact_transactions a
    join ethereum.core.fact_event_logs b on a.TX_HASH= b.TX_HASH
    join ethereum.core.dim_function_signatures c on a.origin_function_signature = bytes_signature
    WHERE lower(text_signature) like ('%swap%') and date>'2022-01-01'
    and lower(contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    group by date

    Run a query to Download Data