flipside

    source chain metrics Total
    rezarwzsource chain metrics Total
    Updated 2025-03-07
    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
    UNION ALL
    SELECT
    CREATED_AT AS Date,
    CAST(DESTINATION_CHAIN AS STRING) AS DESTINATION_CHAIN,
    CAST(SOURCE_CHAIN AS STRING) AS SOURCE_CHAIN,
    CONCAT(
    CAST(SOURCE_CHAIN AS STRING),
    ' -> ',
    CAST(DESTINATION_CHAIN AS STRING)
    ) AS path,
    COALESCE(CAST(send:value AS FLOAT), 0) AS volume,
    CAST(id AS STRING) AS id,
    lower(CAST(SENDER_ADDRESS AS STRING)) AS user_address,
    CAST(DATA:time_spent.total AS FLOAT) AS TIME_SPENT
    FROM axelar.axelscan.fact_transfers
    WHERE
    NOT (
    (
    TYPEOF(link:price) = 'ARRAY'
    AND ARRAY_SIZE(link:price) = 0
    )
    Last run: 3 months 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
    		binance3595762337816648.7699616964270842928.75060510896.2424246368.6666671538618185531.8075578781
    2
    		sei185212123332065.8920113473101111050.756762881.952381664.952381279034
    3
    		ethereum2063331794219080.0926910659946005617.43827425290.5897443348.8205131455364648909.83733199282
    4
    		osmosis3097161076742846.921935714329909523.52560918603.2222223004.305556963821461567.43063632613
    5
    		arbitrum380736499308658.50403915988017217539.948415113128.8275868141.034483963519800448.0308575360
    6
    		axelarnet17826434118873.516577310852971.8379445.65197.225583755922.5665320236
    7
    		polygon432140388566748.7255761931729963249.9673224511080.5128216546.92307777675292987.598573433751
    8
    		terra-287004292508638.474971340129140894.952342842718.8751257.2187500
    9
    		avalanche168224263219208.952024744406580480.22380064205.62230.02528513560580.479539971519
    10
    		base276276259551305.01373911074812359585.9530352131567860.714286113968230142.898171336203
    11
    		fantom153169244644025.403605649256272923.728297553927.4102562100.89743660209512724.737094863439
    12
    		kujira35382234972193.51493656497120369.500452611072.181818378.727273119278441.75217923953
    13
    		celo40588146715620.565729130865059159.329852731399.586207552.068966122822142215.701864670
    14
    		optimism144827135193482.666299663276145158.303013576583.0454554242.09090950181993840.814319142776
    15
    		kava23236127220955.80566942944543605.56448818829.857143237.5357143151816443.34827202157
    16
    		moonbeam8850383877950.962156289762150716.691337332269.307692937.84615413873218066.96278728469
    17
    		blast4421165858542.1827452206565066041.706365023400.8461542004.07692314261908988.76372511800
    18
    		neutron743064403241.267456330572800140.92467201323.043478178.3913041951742690.0708242135
    19
    		secret-snip865455654683.63972530841686505.56484015262.242424131.5757583151226822.13393145235
    20
    		umee831647290815.644615210641576360.52148717277.286.36666753136033.55591773220
    68
    6KB
    91s