phu50. active user
    Updated 2022-10-19
    with
    optimism_cte as (
    select
    block_timestamp
    , tx_hash
    , from_address
    , status
    from optimism.core.fact_transactions
    )
    , arbitrum_cte as (
    select
    block_timestamp
    , tx_hash
    , from_address
    , status
    from arbitrum.core.fact_transactions
    )
    , avalanche_cte as (
    select
    block_timestamp
    , tx_hash
    , from_address
    , status
    from avalanche.core.fact_transactions
    )
    , bnb_cte as (
    select
    block_timestamp
    , tx_hash
    , from_address
    , status
    from bsc.core.fact_transactions
    )
    , polygon_cte as (
    select
    block_timestamp
    Run a query to Download Data