Updated 2022-09-29
    select date_trunc('day', a.block_timestamp) as date_day,date_trunc('week', a.block_timestamp) as date_week
    ,date_trunc('month', a.block_timestamp) as date_month
    ,sum(ETH_VALUE) as volume_eth,COUNT(origin_from_address) 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 a.block_timestamp>'2022-01-01'
    and lower(contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    group by 1,2,3
    Run a query to Download Data