freeman_7ARBITRUM
    Updated 2024-09-30
    -- For Arbitrum
    with transactions as (
    select
    date(date_trunc('{{Period}}',block_timestamp)) as date_time,
    count(distinct origin_from_address) as address,
    count( distinct tx_hash) as transaction
    from Arbitrum.core.ez_decoded_event_logs
    where origin_to_address = lower('0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE')
    or decoded_log:bridgeData:integrator = 'jumper.exchange'
    or decoded_log:integrator = 'jumper.exchange'
    And event_name in ('LiFiGenericSwapCompleted','LiFiTransferStarted','LiFiSwappedGeneric')
    group by date_time
    )
    select
    date_time,
    address,
    transaction,
    sum(transaction) over() as total_transction
    from transactions
    order by date_time




    QueryRunArchived: QueryRun has been archived