Drsimon2023-04-22 02:36 AM
    Updated 2023-04-25
    SELECT
    -- ez.BLOCK_NUMBER,
    -- ez.BLOCK_TIMESTAMP,
    count(DISTINCT ez.TX_HASH) as num_tx,
    count(DISTINCT ez.SENDER),
    ez.TOKEN_ADDRESS,
    dt.LABEL_TYPE,
    dt.LABEL_SUBTYPE,
    dt.LABEL,
    dt.PROJECT_NAME,
    dt.ALIAS,
    dt.DECIMAL,
    ez.TOKEN_SYMBOL,
    ez.AMOUNT,
    ez.SOURCE_CHAIN,
    ez.DESTINATION_CHAIN,
    count(DISTINCT ez.RECEIVER)
    FROM
    axelar.core.ez_squid ez
    LEFT JOIN axelar.core.dim_tokens dt ON ez.TOKEN_ADDRESS = dt.ADDRESS
    GROUP BY ez.TOKEN_ADDRESS,
    dt.LABEL_TYPE,
    dt.LABEL_SUBTYPE,
    dt.LABEL,
    dt.PROJECT_NAME,
    dt.ALIAS,
    dt.DECIMAL,
    ez.TOKEN_SYMBOL,
    ez.AMOUNT,
    ez.SOURCE_CHAIN,
    ez.DESTINATION_CHAIN
    ORDER BY num_tx
    Run a query to Download Data