flipside

    ransactions are done in a block on Polygon, Solana, Flow, Arbitrum, and Optimism Comparison of the minimum time between two blocks two blocks on polygon, Solana, Flow, Arbitrum, and Optimism Comparison of the maximum time between two blocks two blocks on polygon, Solana, Flow, Arbitrum, and Optimism Comparison of the average time between blocks two blocks on polygon, Solana, Flow, Arbitrum, and Optimism
    superflyransactions are done in a block on Polygon, Solana, Flow, Arbitrum, and Optimism Comparison of the minimum time between two blocks two blocks on polygon, Solana, Flow, Arbitrum, and Optimism Comparison of the maximum time between two blocks two blocks on polygon, Solana, Flow, Arbitrum, and Optimism Comparison of the average time between blocks two blocks on polygon, Solana, Flow, Arbitrum, and Optimism
    Updated 2023-01-14
    with bridge as (select tx_hash
    from ethereum.core.fact_event_logs
    where EVENT_INPUTS:chainId = '42161'
    and event_name = 'TransferSentToL2'
    )

    select
    date_trunc(week,BLOCK_TIMESTAMP) as date ,
    'ETH' as token,
    count (distinct ETH_FROM_ADDRESS) as users,
    sum(AMOUNT_USD) as bridged_value
    from ethereum.core.ez_eth_transfers
    where ORIGIN_FROM_ADDRESS <> lower('0x710bda329b2a6224e4b44833de30f38e7f81d564') and ETH_to_ADDRESS = lower('0xb8901acb165ed027e32754e0ffe830802919727f')
    and tx_hash in (select tx_hash from bridge)
    and block_timestamp::date >= '2023-01-01' and block_timestamp::date < CURRENT_DATE
    group by 1,2

    union all
    select
    date_trunc(week,BLOCK_TIMESTAMP) as date,
    case
    when to_address = lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') then 'DAI'
    when to_address = lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6') then 'USDT'
    when to_address = lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') then 'USDC
    '
    end as token,
    count (distinct ORIGIN_FROM_ADDRESS) as users,
    sum(AMOUNT_USD) as bridged_value
    from
    ethereum.core.ez_token_transfers
    where TO_ADDRESS in (lower('0x3d4Cc8A61c7528Fd86C55cfe061a78dCBA48EDd1') --dai
    ,lower('0x3E4a3a4796d16c0Cd582C382691998f7c06420B6') --usdt
    ,lower('0x3666f603Cc164936C1b87e207F36BEBa4AC5f18a') --usdc
    )
    and tx_hash in (select tx_hash from bridge)
    Run a query to Download Data