alitaslimiProtocols Daily (30D)
    Updated 2025-03-04
    with
    -------------------- Arbitrum --------------------
    arbitrum as (
    select
    block_timestamp,
    origin_from_address,
    origin_to_address,
    tx_hash
    from
    arbitrum.core.ez_decoded_event_logs logs
    join arbitrum.core.dim_labels labels on logs.origin_to_address = labels.address
    where
    tx_status = 'SUCCESS'
    and block_timestamp::date between (current_date - 31) and (current_date - 1)
    and contract_address = '0x2297aebd383787a160dd0d9f71508148769342e3'
    ),
    -------------------- Avalanche --------------------
    avalanche as (
    select
    block_timestamp,
    origin_from_address,
    origin_to_address,
    tx_hash
    from
    avalanche.core.ez_decoded_event_logs logs
    join avalanche.core.dim_labels labels on logs.origin_to_address = labels.address
    where
    tx_status = 'SUCCESS'
    and block_timestamp::date between (current_date - 31) and (current_date - 1)
    and contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'
    ),
    -------------------- BSC --------------------
    bsc as (
    select
    block_timestamp,
    origin_from_address,