eslamis-darkattrain swap mask
Updated 2022-09-29
9
1
2
3
4
5
6
7
8
9
›
⌄
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