datavortexbridgers categories
    Updated 2025-04-15
    WITH token_prices AS (
    SELECT
    token_address,
    CASE
    WHEN token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' THEN 'WBTC'
    WHEN token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' THEN 'WETH'
    WHEN token_address = '0x3073f7aaa4db83f95e9fff17424f71d4751a3073' THEN 'MOVE'
    WHEN token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'USDC'
    WHEN token_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'USDT'
    ELSE 'unknown'
    END AS symbol,
    AVG(price) AS avg_price,
    CAST(DATE(hour) AS DATE) AS date
    FROM
    ethereum.price.ez_prices_hourly
    WHERE
    token_address IN (
    '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599', -- WBTC
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2', -- WETH
    '0x3073f7aaa4db83f95e9fff17424f71d4751a3073', -- MOVE
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- USDC
    '0xdac17f958d2ee523a2206206994597c13d831ec7' -- USDT
    )
    GROUP BY
    token_address,
    CAST(DATE(hour) AS DATE)
    ),
    -- Movement to Ethereum
    movement_to_ethereum AS (
    SELECT
    tx_hash AS "Transaction_hash",
    event_data:from_address AS "bridger",
    event_data:amount_sent_ld AS "amount_bridged",
    CASE
    WHEN event_address = '0x7e4fd97ef92302eea9b10f74be1d96fb1f1511cf7ed28867b0144ca89c6ebc3c' THEN 'MOVE'
    WHEN event_address = '0x4d2969d384e440db9f1a51391cfc261d1ec08ee1bdf7b9711a6c05d485a4110a' THEN 'USDC.e'
    Last run: 3 months ago
    VOLUME_CATEGORY
    TOTAL_BRIDGERS
    1
    1-100 USD3906
    2
    100-500 USD1097
    3
    500-1000 USD279
    4
    1000-5000 USD257
    5
    5000-1M USD232
    6
    1M+ USD2
    6
    118B
    6s