PS0G1vol across
    Updated 2022-11-30
    --credit misaghlb
    with bridge_data as (
    SELECT
    a.BLOCK_TIMESTAMP,
    a.tx_hash,
    SYMBOL,
    amount, amount_usd,
    b.origin_from_address,
    regexp_substr_all(SUBSTR(a.DATA, 3, len(a.DATA)), '.{64}')[2] AS seg_ch2,
    ethereum.public.udf_hex_to_int(seg_ch2) as chainid,
    case when chainid = '137' THEN 'Polygon'
    WHEN chainid = '288' THEN 'Boba'
    WHEN chainid = '10' THEN 'Optimism'
    WHEN chainid = '42161' THEN 'Arbitrum'
    when chainid = '1' then 'Ethereum'
    when chainid = '56' then 'BNB'
    when chainid = '43114' then 'Avalanche'
    when chainid = '288' then 'Boba'
    else 'Others'
    END as chain
    FROM ethereum.core.fact_event_logs a
    join ethereum.core.ez_token_transfers b on a.tx_hash = b.tx_hash
    where date(a.BLOCK_TIMESTAMP) >= '2022-06-01'
    and lower(a.CONTRACT_ADDRESS) = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
    and a.origin_to_address = lower('0x4D9079Bb4165aeb4084c526a32695dCfd2F77381')
    and a.origin_from_address != '0x428ab2ba90eba0a4be7af34c9ac451ab061ac010' -- relayer
    and a.origin_from_address != '0xf7bac63fc7ceacf0589f25454ecf5c2ce904997c'
    and a.tx_status = 'SUCCESS'

    UNION all

    SELECT
    a.BLOCK_TIMESTAMP,
    a.tx_hash,
    Run a query to Download Data