MoeGMX Protocol Overview 6
    Updated 2022-09-18
    with tab1 as (
    SELECT
    *,
    CASE WHEN ADDRESS_NAME LIKE 'hop protocol: wbtc l2canonicaltoken' THEN 'WBTC'
    WHEN ADDRESS_NAME LIKE 'chainlink' THEN 'LINK'
    WHEN ADDRESS_NAME LIKE 'hop protocol: dai l2canonicaltoken' THEN 'DAI'
    WHEN ADDRESS_NAME LIKE 'uniswap' THEN 'UNI'
    WHEN ADDRESS_NAME LIKE 'frax finance: frax token' THEN 'FARX'
    WHEN ADDRESS_NAME LIKE 'hop protocol: eth l2canonicaltoken' THEN 'WETH'
    WHEN ADDRESS_NAME LIKE 'hop protocol: usdt l2canonicaltoken' THEN 'USDT'
    WHEN ADDRESS_NAME LIKE 'hop protocol: usdc l2canonicaltoken' THEN 'USDC' END as symbol_1,
    CASE WHEN ADDRESS_NAME LIKE 'hop protocol: wbtc l2canonicaltoken' THEN 8
    WHEN ADDRESS_NAME LIKE 'chainlink' THEN 18
    WHEN ADDRESS_NAME LIKE 'hop protocol: dai l2canonicaltoken' THEN 18
    WHEN ADDRESS_NAME LIKE 'uniswap' THEN 18
    WHEN ADDRESS_NAME LIKE 'frax finance: frax token' THEN 18
    WHEN ADDRESS_NAME LIKE 'hop protocol: eth l2canonicaltoken' THEN 18
    WHEN ADDRESS_NAME LIKE 'hop protocol: usdt l2canonicaltoken' THEN 6
    WHEN ADDRESS_NAME LIKE 'hop protocol: usdc l2canonicaltoken' THEN 6 END as decimal_1
    FROM arbitrum.core.fact_token_transfers
    LEFT outer JOIN arbitrum.core.dim_labels
    ON contract_address LIKE address
    WHERE to_address LIKE lower('0x09f77E8A13De9a35a7231028187e9fD5DB8a2ACB')
    )

    SELECT
    symbol_1,
    COUNT(DISTINCT tx_hash) as events,
    COUNT(DISTINCT origin_from_address) as users,
    sum((raw_amount / power(10, decimal_1)) * price) as volume
    FROM tab1
    LEFT outer join ethereum.core.fact_hourly_token_prices
    ON symbol = symbol_1
    AND date_trunc('day', block_timestamp) = hour
    Run a query to Download Data