kakamoraBridge Transactions by Amount of Money Transferred
    Updated 2022-06-21
    with hop_bridges as (
    select
    address,
    address_name
    from ethereum.core.DIM_LABELS
    where LABEL = 'hop protocol'
    and address_name like '%bridge%'
    UNION
    select
    lower('0x3666f603cc164936c1b87e207f36beba4ac5f18a'),
    'hop protocol: usdc bridge'
    ),
    hop_transfers as (
    SELECT
    tfr.tx_hash,
    tfr.block_timestamp,
    to_date(tfr.block_timestamp) as date,
    tfr.origin_from_address as wallet,
    tfr.symbol as token,
    tfr.amount as token_amount,
    tfr.amount_usd as token_amount_usd,
    case logs.event_inputs:chainId::string
    when 10 then 'Optimism'
    when 137 then 'Polygon'
    when 42161 then 'Arbitrum'
    end as destination,
    case
    when token_amount_usd > 1 * 1e6 then '$1 Million+'
    when token_amount_usd > 0.5 * 1e6 then '$500K - $1 Million'
    when token_amount_usd > 0.25 * 1e6 then '$250K - $500K'
    when token_amount_usd > 0.1 * 1e6 then '$100K - $250K'
    when token_amount_usd > 50000 then '$50K - $100K'
    when token_amount_usd > 10000 then '$10K - $50K'
    when token_amount_usd > 5000 then '$5K - $10K'
    when token_amount_usd > 1000 then '$1K - $5K'
    else 'Less than $1K'
    Run a query to Download Data