flipside

    Top Projects By TXs[Past Week]
    0xHaM-dTop Projects By TXs[Past Week]
    Updated 9 days ago
    with priceTb as (
    SELECT
    hour as p_date,
    symbol,
    PRICE as usd_price
    FROM aptos.price.ez_prices_hourly
    WHERE symbol = 'APT'
    )
    ,
    functionTb as (
    select
    block_timestamp,
    gas_used,
    (case
    when PAYLOAD_FUNCTION ilike '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x3c1d4a86594d681ff7e5d5a233965daeabdc6a15fe5672ceeda5260038857183%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01%'then 'defi'
    when PAYLOAD_FUNCTION ilike '0x6b3720cd988adeaf721ed9d4730da4324d52364871a68eac62b46d21e4d2fa99%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x3c4a58b4a8dffe6d14448072efcdd5a0e0089a22c6837b94f1d7e8bb1552137f%'then 'defi'
    when PAYLOAD_FUNCTION ilike '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x7893a5d6cd60610f2bad22bb29668e596d14245b682d508a0794ce69613bcaab%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x16fe2df00ea7dde4a63409201f7f4e536bde7bb7335526a35d05111e68aa322c%' then 'dex'
    when PAYLOAD_FUNCTION ilike '0xd1fd99c1944b84d1670a2536417e997864ad12303d19eac725891691b04d614e%' then 'nft'
    when PAYLOAD_FUNCTION ilike '0xfe2ffdb3a74307f7314a1c8ab3762b6b5869a3c1278cdd5d230249453e15a1db%' then 'dapp'
    when PAYLOAD_FUNCTION ilike '0x43d8cad89263e6936921a0adb8d5d49f0e236c229460f01b14dca073114df2b9%' then 'bridge'
    when PAYLOAD_FUNCTION ilike '0x17f1e926a81639e9557f4e4934df93452945ec30bc962e11351db59eb0d78c33%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c%' then 'dex'
    when PAYLOAD_FUNCTION ilike '0xc0188ad3f42e66b5bd3596e642b8f72749b67d84e6349ce325b27117a9406bdf%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0x31a6675cbe84365bf2b0cbce617ece6c47023ef70826533bde5203d32171dc3c%' then 'dex'
    when PAYLOAD_FUNCTION ilike '0x54ad3d30af77b60d939ae356e6606de9a4da67583f02b962d2d3f2e481484e90%' then 'bridge'
    when PAYLOAD_FUNCTION ilike '0x4bf51972879e3b95c4781a5cdcb9e1ee24ef483e7d22f2d903626f126df62bd1%' then 'defi'
    when PAYLOAD_FUNCTION ilike '0xe7c7bb0e53fc6fb86aa7464645fbac96b96716463b4e2269c62945c135aa26fd%' then 'dapp'
    when PAYLOAD_FUNCTION ilike '0x867ed1f6bf916171b1de3ee92849b8978b7d1b9e0a8cc982a3d19d535dfd9c0c%' then 'dapp'
    when PAYLOAD_FUNCTION ilike '0x890812a6bbe27dd59188ade3bbdbe40a544e6e104319b7ebc6617d3eb947ac07%' then 'defi'
    Last run: 9 days ago
    Project
    Transactions
    TXs Change %
    AUs
    AUs Change %
    Fees
    Fees Change %
    1
    		Kgen2407347🟥 -16.48%1592661🟥 -12.36%854.499631🟩 71.89%
    2
    		Tevi1963472🟥 -26.42%272960🟥 -30.20%372.976693🟩 40.65%
    3
    		Stan1770737🟥 -9.25%545015🟥 -19.12%19.478107🟥 -9.25%
    4
    		Thala1231316🟩 1.01%609🟩 1.33%93.494706🟩 2.18%
    5
    		Eragon680041🟩 5.38%161873🟥 -2.63%21.828581🟩 2.30%
    6
    		Cellana606321🟥 -43.93%4280🟩 15.12%32.334053🟥 -40.37%
    7
    		Econia312113🟥 -7.78%30🟥 -23.08%11.499809🟥 -8.12%
    8
    		Switchboard229287🟩 0.04%30.00%9.446535🟩 0.06%
    9
    		Slime Revolution213161🟥 -12.58%130187🟥 -16.92%0.883416🟥 -10.84%
    10
    		Lync153839🟥 -8.71%134934🟥 -13.07%57.555467🟥 -7.83%
    10
    768B
    915s