Salvors | i_dan | Flipside

i_danSalvors

Updated 2025-03-08

-- 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

Last run: about 1 month ago

	COUNT(TX_HASH)	CONTRACT_NAME	CONTRACT_ADDRESS
1	76	Neon World on SALVOR	0xe1852d4e212549cf8ccb2844f4bf80d27d2d10b5
2	102	Daily pixels on salvor	0x21e61c7cb335a062deec65b7fb042d502f4ccbab
3	20	Not a Salvor	0x27f0b7a2e42246099116ba38aa4fe216ede1f486
4	517583	SalvorArtToken	0xf99516bc189af00ff8effd5a1f2295b67d70a90e
5	183	Eyes of Luv / Salvor	0x58282878ac09ae8947ee84ab1a1e41b0fbd2ba1a
6	128	EvilBeards 1/1 Collection On Salvor	0x3216dcc45f3edb979227c09a451a638602c0491c
7	108	MINI pengu on salvor	0x0466611e357a0dff48a9cf0a29acfd6dfe8b6be8
8	491886	The Salvors	0xce4fee23ab35d0d9a4b6b644881ddd8adebeb300
9	124	The Salvor Boys	0x8de52c60911f63f0e3f2dcbe43cbb5f973690941
10	106	Soliiiart Salvor	0x11155e77a0e678e5cbcacb5340141daabeeecc6b
11	144412	Mini Salvors	0x8d57da692ff6112d71a0b3c10247897f21ccb4aa
12	225	𝕭𝖑𝖆𝖉 𝕮𝖑𝖚𝖇 / Salvor	0x558ca5404c5ac95cc887617dc297135378514e87
13	241196	SalvorVeArt	0x72b73fa1569df9ff1ae9b29cd5b164af6c02ebaa
14	54	AVUNK salvor	0x295d853b16d47b1fe4381c812de9cae8c9bab617

1KB

12s

flipside