campin and out 5
    Updated 2022-11-01
    -- -- Inflows and Outflows

    -- Pay by Quality Your score determines your final payout.
    -- Grand Prize 75 USDC (A score of 11 or 12 earns you a Grand Prize title)
    -- Payout 50 USDC
    -- Score Multiplier 0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
    -- Payout Network Ethereum
    -- Level Beginner
    -- Difficulty Medium
    -- What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism
    -- network and the Ethereum network across the bridge?
    -- How has that changed over time? Note any interesting trends or outliers that you see.
    -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!

    with txns as (
    select
    iff(origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1', 'OP-->ETH', 'ETH-->OP') as flow,
    symbol,
    concat(flow,' (',symbol, ')') as type,
    block_timestamp,
    tx_hash,
    amount_usd,
    origin_from_address
    from ethereum.core.ez_token_transfers
    where origin_to_address in (
    '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' -- Optimism --> ETH
    ,'0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- ETH --> Optimism
    )
    and block_timestamp < CURRENT_DATE
    and symbol in ('USDC','DAI','USDT')
    )

    select
    date_trunc('week',block_timestamp) as date,
    flow,
    type,
    Run a query to Download Data