flipside

    Optimism Bridge Analysis
    jackguyOptimism Bridge Analysis
    Updated 2022-10-31
    WITH tab1 as (
    SELECT DISTINCT tx_hash
    FROM optimism.core.fact_event_logs
    WHERE contract_address LIKE '0x4200000000000000000000000000000000000010'
    -- LIMIT 100
    )

    SELECT
    date_trunc('week', block_timestamp) as week,
    symbol,
    count(DISTINCT tx_hash) as transfer,
    count(DISTINCT TO_ADDRESS) as users
    FROM optimism.core.fact_token_transfers
    LEFT OUTER JOIN optimism.core.dim_contracts
    ON address = contract_address
    WHERE tx_hash in (SELECT * FROM tab1)
    AND from_address LIKE '0x0000000000000000000000000000000000000000'
    --AND symbol IN ('USDC', 'USDT', 'ETH')
    GROUP BY 1,2
    Run a query to Download Data