flipside

    Top Projects By TXs[Past Week]
    0xHaM-dTop Projects By TXs[Past Week]
    Updated 8 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: 8 days ago
    Project
    Transactions
    TXs Change %
    AUs
    AUs Change %
    Fees
    Fees Change %
    1
    		Kgen3634473🟥 -22.82%1999107🟥 -17.95%203.268586🟥 -25.72%
    2
    		Stan2122744🟩 19.72%665751🟩 20.75%23.350184🟩 19.72%
    3
    		Thala1090441🟥 -27.20%586🟩 23.37%82.747027🟥 -27.26%
    4
    		Eragon1064912🟩 74.70%145000🟩 5.29%31.960984🟩 64.14%
    5
    		Tevi761714🟥 -61.30%128789🟥 -57.23%21.512018🟥 -93.97%
    6
    		Cellana494121🟥 -39.26%3168🟥 -21.31%27.080103🟥 -35.83%
    7
    		Lync248694🟩 76.44%96006🟥 -2.73%108.664796🟩 86.05%
    8
    		Econia231104🟥 -25.74%13🟩 18.18%8.588971🟥 -25.77%
    9
    		Switchboard224964🟩 2.13%6🟩 50.00%9.295018🟩 2.57%
    10
    		Palette176228🟩 4.68%5000.00%149.477204🟩 4.49%
    10
    759B
    715s