i_danSalvors
Updated 2025-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- with
-- main as (
-- select
-- tx_hash,
-- block_timestamp,
-- nvl(decoded_log:user, origin_from_address)::string as user,
-- decoded_log:amount / 1e18 as amount,
-- replace(event_name, 'ART', '') as event_name
-- from
-- avalanche.core.ez_decoded_event_logs
-- where
-- tx_status = 'SUCCESS'
-- and event_name in ('DepositART', 'WithdrawART')
-- and contract_address = '0x72b73fa1569df9ff1ae9b29cd5b164af6c02ebaa'
-- )
-- select
-- event_name,
-- count(distinct tx_hash) as transactions,
-- count(distinct user) as users,
-- sum(amount) as volume_art,
-- avg(amount) as average_amount_art
-- from
-- main
-- group by 1
SELECT
COUNT(tx_hash)
, contract_name
, contract_address
From avalanche.core.ez_decoded_event_logs
WHERE --contract_address = '0x72b73fa1569df9ff1ae9b29cd5b164af6c02ebaa'
contract_name ILIKE '%Salvor%'
GROUP BY 2, 3
LIMIT 1000
QueryRunArchived: QueryRun has been archived