rezarwzsource chain metrics Transfers
    Updated 8 days ago
    WITH total_Data AS (
    SELECT
    CREATED_AT,
    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
    )
    OR (
    TYPEOF(SEND_AMOUNT) = 'ARRAY'
    AND ARRAY_SIZE(SEND_AMOUNT) = 0
    )
    )
    OR send:value IS NULL
    ),
    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
    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
    sei183642123162252.1689213407101102964.388996874.47619661.142857279034
    2
    binance247721838300232.75192750055706067.659149750.666667285.6666674351058294.9767581649
    3
    ethereum33757809024924.4879181601120744228.8330235865.564103521.43589739489168.73378574127
    4
    osmosis136129661237380.6878713310218367705.01910753781.3611111748.416667291788699.27855061215
    5
    axelarnet17750434118873.516576610852971.8379443.75197.025583755922.5665320236
    6
    terra-284952249791214.011385337267805975.437855792654.751236.5937500
    7
    kujira25588202010194.74610445866121521.05291224775.393939298.1818181854208.09428552710
    8
    avalanche64830173885849.297306292174347146.232432661620.75805.95133330522.71499288719
    9
    polygon81790172395796.23717466274420405.03172232097.1794871377.4102565762315.66757877117
    10
    arbitrum967266706934.897929449172300239.13441136333.517241200.1724143148748.11637331111
    11
    secret-snip865455654683.63972530841686505.56484015262.242424131.5757583151226822.13393145235
    12
    kava196051560672.53471117631841452.59052547039.071429101131.4313508058
    13
    umee781041614357.39624089721387145.24654136260.33333379.46666729100739.33340715910
    14
    fantom2614941326847.1697358161771059662.74794194670.487179444.97435912797.3046051131
    15
    moonbeam1936433529528.537221310484859731.500954392496.512821298.205128101606.2771924224
    16
    neutron368433523063.775041715251523775.62613826167.454545101.5454553400021.917632
    17
    crescent536619056330.49013231377657114.844487321185.03448380.89655200
    18
    archway11318007594.3917577481385199.568596758.6923084.23076910.155936071
    19
    cosmoshub456711329983.15743112588306215.761011652123.43243280.2162163745.2047573353
    20
    juno767411321485.91330013175332984.879802943225.705882135.941176316.1183174583
    59
    5KB
    88s