mamad-5XN3k3BOB Paid Fee by Events
    Updated 3 days ago
    with pricet as (
    select
    'Core' as sym,
    Hour::date as pdate,
    avg(price) as price
    from core.price.ez_prices_Hourly
    where symbol = 'CORE'
    group by 1,2

    union

    select
    'ETH' as sym,
    Hour::date as pdate,
    avg(price) as price
    from ethereum.price.ez_prices_Hourly
    where symbol = 'ETH'
    and token_address is null
    group by 1,2
    )

    select
    distinct day,
    case when chain = 'BOB' then fee end as BOB_Fee,
    case when chain = 'BOB' then swap_fee end as BOB_swap_fee,
    case when chain = 'BOB' then transfer_fee end as BOB_transfer_fee,
    case when chain = 'Arbitrum' then fee end as Arbitrum_Fee,
    case when chain = 'Arbitrum' then swap_fee end as Arbitrum_swap_fee,
    case when chain = 'Arbitrum' then transfer_fee end as Arbitrum_transfer_fee,
    case when chain = 'Base' then fee end as Base_Fee,
    case when chain = 'Base' then swap_fee end as Base_swap_fee,
    case when chain = 'Base' then transfer_fee end as Base_transfer_fee,
    case when chain = 'Core' then fee end as Core_Fee,
    case when chain = 'Core' then swap_fee end as Core_swap_fee,
    case when chain = 'Core' then transfer_fee end as Core_transfer_fee
    from(
    Last run: 3 days ago
    DAY
    BOB_FEE
    BOB_SWAP_FEE
    BOB_TRANSFER_FEE
    ARBITRUM_FEE
    ARBITRUM_SWAP_FEE
    ARBITRUM_TRANSFER_FEE
    BASE_FEE
    BASE_SWAP_FEE
    BASE_TRANSFER_FEE
    CORE_FEE
    CORE_SWAP_FEE
    CORE_TRANSFER_FEE
    1
    2025-03-13 00:00:00.000389.0122.32159.04
    2
    2025-03-29 00:00:00.000201.6118.678.59
    3
    2025-03-06 00:00:00.000168.9914.9767.95
    4
    2025-03-18 00:00:00.00063.154.425.38
    5
    2025-04-01 00:00:00.000250.36.6182.28
    6
    2025-03-30 00:00:00.00082578285734.96215767.3
    7
    2025-03-27 00:00:00.0001047.7857.04255.75
    8
    2025-03-14 00:00:00.0001053790.26160589.2483409.01
    9
    2025-04-03 00:00:00.000238300.0612481.1638136.2
    10
    2025-03-21 00:00:00.0002083.2297.93341.73
    11
    2025-03-06 00:00:00.0004178.89199.21617.13
    12
    2025-03-23 00:00:00.0001047.3970.64234.58
    13
    2025-03-29 00:00:00.000995.5373.24268.84
    14
    2025-03-15 00:00:00.00078.084.1132.64
    15
    2025-04-03 00:00:00.000460.7826.2786.42
    16
    2025-03-23 00:00:00.00053.13.3220.61
    17
    2025-03-23 00:00:00.000786590.8670066.53213470.75
    18
    2025-03-11 00:00:00.0005104.48382.851423.47
    19
    2025-03-15 00:00:00.0002878.1218.27100.61
    20
    2025-03-16 00:00:00.000103.753.8139.94
    ...
    124
    12KB
    523s