eslamis-darkatswap 9
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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