alirsAPA-07
    Updated 2022-11-30
    WITH Across
    AS (
    SELECT block_timestamp
    ,tx_hash
    ,regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS Segmented_Data
    ,ethereum.PUBLIC.udf_hex_to_int(Segmented_Data [0]) / pow(10, 18) AS amount
    ,origin_from_address
    FROM ethereum.core.fact_event_logs
    WHERE origin_to_address = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
    AND contract_address = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
    AND origin_from_address NOT IN (
    '0x428ab2ba90eba0a4be7af34c9ac451ab061ac010'
    ,'0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c'
    )
    AND tx_status = 'SUCCESS'
    )


    SELECT block_timestamp::DATE AS DATE
    ,count(DISTINCT tx_hash) AS Number_of_Bridges
    ,count(DISTINCT origin_from_address) AS Number_of_Users
    ,sum(amount_usd) AS Bridge_Volume
    FROM ethereum.core.ez_token_transfers
    WHERE tx_hash IN (
    SELECT DISTINCT (tx_hash)
    FROM Across) AND
    DATE >= CURRENT_DATE - 30
    GROUP BY 1

    Run a query to Download Data