flipside

    1
    datavortex1
    Updated 2025-02-06
    /*

    WITH bridge_contracts AS (
    SELECT DISTINCT
    contract_address,
    contract_name,
    event_name,
    origin_to_address as bridge_router,
    origin_function_signature
    FROM swell.core.ez_decoded_event_logs
    WHERE event_name IN ('Deposit', 'Transfer')
    AND block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())
    ),
    bridge_stats AS (
    SELECT
    DATE_TRUNC('day', e.block_timestamp) as date,
    e.contract_address,
    e.contract_name,
    e.event_name,
    e.origin_to_address as bridge_router,
    e.origin_function_signature,
    COUNT(DISTINCT e.origin_from_address) as unique_bridgers,
    COUNT(DISTINCT e.tx_hash) as total_transactions,
    SUM(CASE
    WHEN e.decoded_log:amount is not null THEN e.decoded_log:amount::float/1e18
    WHEN e.decoded_log:value is not null THEN e.decoded_log:value::float/1e18
    ELSE 0
    END) as total_amount_bridged
    FROM swell.core.ez_decoded_event_logs e
    INNER JOIN bridge_contracts b
    ON e.contract_address = b.contract_address
    AND e.event_name IN ('Deposit', 'Transfer')
    WHERE e.block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP())
    GROUP BY 1,2,3,4,5,6
    )

    Last run: 3 months ago
    DATE
    CONTRACT_ADDRESS
    CONTRACT_NAME
    EVENT_NAME
    BRIDGE_ROUTER
    ORIGIN_FUNCTION_SIGNATURE
    UNIQUE_BRIDGERS
    TOTAL_TRANSACTIONS
    TOTAL_AMOUNT_BRIDGED
    CUMULATIVE_BRIDGERS
    CUMULATIVE_AMOUNT_BRIDGED
    1
    		2025-02-06 00:00:00.0000x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34USDeTransfer0xaaaaaaaa82812f0a1f274016514ba2ca933bf24d0xa15112f94157697263.1319361772574218.29
    2
    		2025-02-06 00:00:00.0000x58538e6a46e07434d7e7375bc268d3cb839c0133ENATransfer0xaaaaaaaa82812f0a1f274016514ba2ca933bf24d0xa15112f92128309098.0419361772574218.29
    3
    		2025-02-06 00:00:00.0000xda1f8ea667dc5600f5f654df44b47f1639a83dd1wSWELLTransfer0x3ef3d8ba38ebe18db133cec108f4d14ce00dd9ae0x71ee95c040413127159.364407288089741.31
    4
    		2025-02-06 00:00:00.0000x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34USDeTransfer0xaaaaaaaa82812f0a1f274016514ba2ca933bf24d0x3d719cd91035964882.1219361772574218.29
    5
    		2025-02-06 00:00:00.0000x4200000000000000000000000000000000000006Wrapped EtherTransfer0x0cab4d7d7001d375ab0d3a8709c564db5f012c990x81aa8259120083115865200.64
    6
    		2025-02-06 00:00:00.0000x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34USDeTransfer0x0cab4d7d7001d375ab0d3a8709c564db5f012c990x81aa8259120960877.4783115865200.64
    7
    		2025-02-06 00:00:00.0000xda1f8ea667dc5600f5f654df44b47f1639a83dd1wSWELLTransfer0xec4181ee959e47f72e9cc60274fbe53d68949e470x2bf4762b218472456.39101076209.06
    8
    		2025-02-06 00:00:00.0000x4200000000000000000000000000000000000006Wrapped EtherDeposit0x0cab4d7d7001d375ab0d3a8709c564db5f012c990x81aa8259116083115865200.64
    9
    		2025-02-06 00:00:00.0000x4200000000000000000000000000000000000006Wrapped EtherTransfer0x08739cbede6e28e387685ba20e6409bd16969cde0xc16ae7a49140102662929.69
    10
    		2025-02-06 00:00:00.0000x2826d136f5630ada89c1678b64a61620aab77aeaSwell Governance TokenTransfer0xeb8180d6e86844613d8a361461162e59b2fcb0b70x45c37e141414575996.0268272811634577.85
    11
    		2025-02-06 00:00:00.0000x4200000000000000000000000000000000000006Wrapped EtherTransfer0xe5c689d34e03611ac55a603831b00606a88005140xf970cf641012030341272427415.05
    12
    		2025-02-06 00:00:00.0000x4200000000000000000000000000000000000006Wrapped EtherDeposit0xa10d20d1210e80ba01e42fdc2a53a9379c0412930x3cdd6eeb11005894347194.46
    13
    		2025-02-06 00:00:00.0000x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34USDeTransfer0xa10d20d1210e80ba01e42fdc2a53a9379c0412930x3cdd6eeb110208385.535894347194.46
    14
    		2025-02-06 00:00:00.0000x4200000000000000000000000000000000000006Wrapped EtherTransfer0xa10d20d1210e80ba01e42fdc2a53a9379c0412930x3cdd6eeb11005894347194.46
    15
    		2025-02-06 00:00:00.0000x49c077b74292aa8f589d39034bf9c1ed1825a608EVK Vault eWETH-1Transfer0x08739cbede6e28e387685ba20e6409bd16969cde0xc16ae7a479185.79102662929.69
    16
    		2025-02-06 00:00:00.0000x2826d136f5630ada89c1678b64a61620aab77aeaSwell Governance TokenTransfer0xaaaaaaaa82812f0a1f274016514ba2ca933bf24d0x3d719cd93611430827.4519361772574218.29
    17
    		2025-02-06 00:00:00.0000x4200000000000000000000000000000000000006Wrapped EtherTransfer0x075ef0be7f0e83c3b55bce7603cbbf1acc3171f80xac9650d856020801093335116.31
    18
    		2025-02-06 00:00:00.0000xda1f8ea667dc5600f5f654df44b47f1639a83dd1wSWELLTransfer0xb92929d03768a4f8d69552e15a8071eaf8e684ed0x2bf4762b2663493.07362976194.5
    19
    		2025-02-06 00:00:00.0000x0444a8fb38264dc7e594b2acad1acbc7276a773cDebt token of EVK Vault eWETH-1Transfer0x08739cbede6e28e387685ba20e6409bd16969cde0xc16ae7a44515.62102662929.69
    20
    		2025-02-06 00:00:00.0000xea34479f7d95341e5fd49b89936366d6da710824NeptuneTransfer0xe5c689d34e03611ac55a603831b00606a88005140xf970cf645532314.1930341272427415.05
    ...
    3026
    537KB
    4s