Share of Transactions by Event copy copy

SniperShare of Transactions by Event copy copy

Updated 2025-03-23

select

-- '0x77ce5148b7ad284e431175ad7258b54a64816da6',

-- '0x87a699a08d57142d46c909b7f2df49d44d87211f',

-- '0x9c76fc5bd894e7f51c422f072675c876d5998a9e',

-- '0xc69f7434d4b336e68acbbde4101b7990e7d6b3b3',

-- -- '0xdda950223ead838c21838109a2f550c964a23c5b',

-- -- '0xd42364171036dd7dabe2ba5efc368c896d03ce89',

-- '0x4079da822e8972982b8569e38cdf719a21069934',

-- '0xca3f4ee13c4def532b16b90ec5246138ef6d92bf'

-- trunc(BLOCK_TIMESTAMP,'day') as daily,

-- case

-- when contract_address = '0x77ce5148b7ad284e431175ad7258b54a64816da6' then 'Rods'

-- when contract_address = '0x9c76fc5bd894e7f51c422f072675c876d5998a9e' then 'Chests'

-- when contract_address = '0x4079da822e8972982b8569e38cdf719a21069934' then 'Fish'

-- when contract_address = '0x3fa1e076bd4e7f4b7469ad1646332c09b275082d' then 'Founders Pass'

-- else 'other'

-- end as "NFT Name",

EVENT_NAME,

--*

-- DISTINCT ORIGIN_TO_ADDRESS as wallet

count(DISTINCT tx_hash ) as Transactions,

count(DISTINCT origin_from_address ) as wallets ,

-- count(DISTINCT TOPIC_1 ) as wallets ,

-- count (DISTINCT token_id) as nfts

from ronin.core.ez_decoded_event_logs where

CONTRACT_ADDRESS in (

-- '0x4079da822e8972982b8569e38cdf719a21069934',--fish

-- '0x9c76fc5bd894e7f51c422f072675c876d5998a9e',--chests

-- '0x77ce5148b7ad284e431175ad7258b54a64816da6',--rods

-- '0x3fa1e076bd4e7f4b7469ad1646332c09b275082d',-- Fishing Frenzy Founders Pass

'0xdda950223ead838c21838109a2f550c964a23c5b'

)

and TX_SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP::date>= '2025-03-18'

--and EVENT_NAME not in ('TokensMintedWithSignature','Transfer','OwnershipTransferred','RoleGranted','ChestTierUpdated','DefaultRoyaltySet','RoleRevoked')

-- and EVENT_NAME in ('ChestMintedBatch','RodMintedBatch','FishMintedBatch','ApprovalForAll')

QueryRunArchived: QueryRun has been archived

flipside

flipside