msafadoosttransactions using the native bridge
    Updated 2022-06-17
    SELECT
    CASE
    when EVENT_NAME IS NULL THEN 'TransferSentToL2'
    WHEN EVENT_NAME = 'ERC20DepositInitiated' THEN 'ERC20DepositInitiated'
    WHEN EVENT_NAME = 'ERC20WithdrawalFinalized' THEN 'ERC20WithdrawalFinalized'
    END AS EVENT_NAME,
    COUNT(CONTRACT_ADDRESS)
    FROM ethereum.core.fact_event_logs
    WHERE CONTRACT_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1')
    -- AND EVENT_NAME = 'ERC20WithdrawalFinalized'
    GROUP by 1
    ORDER by 2 DESC
    --LIMIT 10
    Run a query to Download Data