0xHaM-dTop Projects By TXs[Past Week]
    Updated 2 days ago
    -- forked from MoDeFi / Top Projects By TXs @ https://flipsidecrypto.xyz/MoDeFi/q/9PeeqNBqso9f/top-projects-by-txs
    with functionTb as (
    select
    BLOCK_TIMESTAMP,
    case
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x6d138096fb880d1c16b48f10686b98a96000c0ac18501425378f784c6b81c34d' then 'eragon'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x8e80b817291d0f2875dec36677d32d6a58205877e02e382429ce1d342a23c086' then 'eragon'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xb2346c5482beea3d2e9dcd197d19d7fdbe1e43fefc58bed20e71ad0b896a0cf2' then 'eragon'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x0183e47c7bca37445c7c8e1442cd480329ce247a6a91d9a27043ab1100a8cdd4' then 'eragon'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x3022a85102011994552104c12171702f3c37c9ecce5a92293101c5de638b3a36' then 'eragon'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xf9552a68230e0f4c0aa4ff3521b622ccabd8a8f07d17e453fe6fa3c091c8d495' then 'eragon'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'amnis finance'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06' then 'merkle'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33' then 'VibrantX'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3' then 'Aries'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba' then 'Echelon'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01'then 'thala'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x92e95ed77b5ac815d3fbc2227e76db238339e9ca43ace45031ec2589bea5b8c' then 'thala'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x163df34fccbf003ce219d3f1d9e70d140b60622cb9dd47599c25fb2f797ba6e' then 'liquidswap'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xb247ddeee87e848315caf9a33b8e4c71ac53db888cb88143d62d2370cca0ead2' then 'liquidswap'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x54cb0bb2c18564b86e34539b9f89cfe1186e39d89fce54e1cd007b8e61673a85' then 'liquidswap'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x6b3720cd988adeaf721ed9d4730da4324d52364871a68eac62b46d21e4d2fa99' then 'thala'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x3c4a58b4a8dffe6d14448072efcdd5a0e0089a22c6837b94f1d7e8bb1552137f'then 'thala'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x8d2d7bcde13b2513617df3f98cdd5d0e4b9f714c6308b9204fe18ad900d92609'then 'Chingari'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xe7c7bb0e53fc6fb86aa7464645fbac96b96716463b4e2269c62945c135aa26fd' then 'Galxe'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x31a6675cbe84365bf2b0cbce617ece6c47023ef70826533bde5203d32171dc3c' then 'sushiswap'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x54ad3d30af77b60d939ae356e6606de9a4da67583f02b962d2d3f2e481484e90' then 'layerzero'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1' then 'Cellana'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c' then 'Panora'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x3c1d4a86594d681ff7e5d5a233965daeabdc6a15fe5672ceeda5260038857183' then 'Aptin'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x5a96fab415f43721a44c5a761ecfcccc3dae9c21f34313f0e594b49d8d4564f4' then 'KGeN'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xb7f5dd022310be46f769af231fb761b9ca18bc2f63237cb6d004aed8ce01336c' then 'KGeN'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x06b43eae979756527d8475fd3645d149177cdef13ecec1d1d65d04d420411c55' then 'KGeN'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xcd7b88c2181881bf8e7ef741cae867aee038e75df94224496a4a81627edf7f65' then 'unknown NFT'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0x43d8cad89263e6936921a0adb8d5d49f0e236c229460f01b14dca073114df2b9' then 'layerzero'
    when split(PAYLOAD_FUNCTION, '::')[0] ilike '0xfe2ffdb3a74307f7314a1c8ab3762b6b5869a3c1278cdd5d230249453e15a1db' then 'petra name'
    Last run: 2 days ago
    Project
    Transactions
    TXs Change %
    AUs
    AUs Change %
    Fees
    Fees Change %
    1
    Eragon2625762🟩 34.25%187045🟥 -0.47%127.40131🟩 41.68%
    2
    Kgen1792291🟩 25.09%1400136🟩 33.90%1223.074196🟩 14.09%
    3
    Chingari1769233🟥 -29.13%848913🟥 -17.49%449.568962🟥 -33.75%
    4
    Thala966645🟩 0.20%747🟩 1.08%71.1085150.00%
    5
    Cellana744327🟩 1.59%4904🟥 -10.98%38.646998🟩 1.93%
    6
    Slime Revolution631276🟩 33.38%199858🟩 54.12%2.550331🟩 33.21%
    7
    Econia344687🟩 5.76%74🟩 32.14%12.52806🟩 4.07%
    8
    Checkin293981🟥 -1.41%53612🟩 1.07%2.034933🟥 -30.31%
    9
    Switchboard214663🟥 -2.24%3🟥 -40.00%8.952864🟥 -2.43%
    10
    Lync154636🟥 -22.49%111345🟥 -19.09%68.118083🟥 -18.89%
    10
    769B
    674s