adriaparcerisasAvalanche swaps vs transfers
Updated 2022-06-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
trunc(block_timestamp,'hour') as hours,
event_name,
count(distinct origin_from_address) as users,
sum(case when event_name='Transfer' then event_inputs:value/pow(10,6)
else event_inputs:amount0In+event_inputs:amount0Out
end) as volume,
avg(case when event_name='Transfer' then event_inputs:value/pow(10,6)
ELSE event_inputs:amount0In+event_inputs:amount0Out
end) as avg_volume
from avalanche.core.fact_event_logs
where
block_timestamp>='2022-06-20'
and contract_address=lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E')
and event_name in ('Transfer','Swap')
--limit 10
group by 1,2
order by 1 asc
Run a query to Download Data