flipside

    source chain metrics GMP
    rezarwzsource chain metrics GMP
    Updated 8 days ago
    WITH total_Data AS (
    SELECT
    CREATED_AT,
    CAST(CALL:returnValues:destinationChain AS STRING) AS DESTINATION_CHAIN,
    CAST(CALL:chain AS STRING) AS SOURCE_CHAIN,
    CONCAT(
    CAST(CALL:chain AS STRING),
    ' -> ',
    CAST(CALL:returnValues:destinationChain AS STRING)
    ) AS path,
    COALESCE(CAST(data:value AS FLOAT), 0) AS volume,
    CAST(id AS STRING) AS id,
    lower(COALESCE(CAST(CALL:receipt:from AS STRING),CAST(call:transaction:from as STRING))) as user_address,
    CAST(TIME_SPENT:total AS FLOAT) AS TIME_SPENT
    FROM axelar.axelscan.fact_gmp
    ),
    total_metrics AS (
    SELECT
    SOURCE_CHAIN,
    COUNT(id) AS "Total Transactions",
    SUM(VOLUME) AS "Total Volume",
    COUNT(DISTINCT user_Address) AS "Total Users"
    FROM total_Data
    WHERE SOURCE_CHAIN IS NOT NULL
    GROUP BY SOURCE_CHAIN
    ),
    monthly_data AS (
    SELECT
    SOURCE_CHAIN,
    DATE_TRUNC('month', CREATED_AT) AS month,
    SUM(VOLUME) AS total_volume,
    COUNT(id) AS total_transactions,
    COUNT(DISTINCT user_address) AS total_users
    FROM total_Data
    WHERE SOURCE_CHAIN IS NOT NULL
    GROUP BY SOURCE_CHAIN, DATE_TRUNC('month', CREATED_AT)
    Last run: 8 days ago
    SOURCE_CHAIN
    Total Transactions
    Total Volume
    Total Users
    Average monthly Volume
    Average monthly Transaction Count
    Average monthly Active User
    # of Transactions (last30days)
    Volume (last30days)
    Active Users (last30days)
    1
    		ethereum172576985194155.6047769199329854368.35165995229.5757583352.2727271451464159741.10354629259
    2
    		binance334804499516416.01804716327916113432.774775710800.1290326490.6129031495117127236.83079898740
    3
    		arbitrum371064432601723.60610915639114917300.814003812795.3103457958.275862960419751699.91448375349
    4
    		osmosis173587415505466.2340583038218065455.05365477547.260872059.913043934720672868.15208572415
    5
    		base273980248893789.81361911048511852085.2292213046.6666677837.047619113918229649.921350136199
    6
    		polygon350350216170952.4884061511016357969.1908354610304.4117655945.70588277105230671.930994663735
    7
    		fantom127020203317178.233869492645979917.006878493735.8823531904.88235360199509927.432489753438
    8
    		celo40252141864725.057025129945254249.076186111490.814815587.777778122722142210.6589763669
    9
    		optimism142692128477212.46466660935839873.2938481864864220.04545550161992316.835438392774
    10
    		avalanche10339489333359.6547177460762627451.7545505230411680.61764727183230057.764547081505
    11
    		kava2127675660283.270957837762910010.89503684818.307692218.7692313051815311.91692122149
    12
    		blast4419565687862.9525486206455052912.534811433399.6153852003.15384614261908988.76372511800
    13
    		moonbeam6913950348422.4249346189951480835.953674552033.5735.76470613773216460.68559485466
    14
    		terra-2205242717424.46358554993883402.22396232186.54545567.09090900
    15
    		linea7309038217529.6326158434151819882.363457893480.476192684.71428631851308162.336156482488
    16
    		kujira979432961998.768832418061734842.04046487515.473684158.947368101224233.65789371243
    17
    		neutron374630880177.492414516711625272.49960077197.157895102.4736841921342668.1531942134
    18
    		lava1937227018608.1610198156383002067.573446642152.4444441806.444444234206927.585601258170
    19
    		mantle2416721092344.2492231154531110123.381538061271.947368961.315789314305775.982994926199
    20
    		scroll5088120339414.6859335307361129967.482551862826.7222222086.944444722324271.47399309613
    57
    5KB
    90s