headitmanagerTotal fee paid for Bridge transactions per day
    Updated 2022-07-11
    with total_count_Bridge as (select count(*) from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
    and block_timestamp::date > current_date - interval '90 days'
    )
    , total_count_Bridge_daily as (select count(*),block_timestamp::date from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
    and block_timestamp::date > current_date - interval '90 days'
    group by block_timestamp::date
    )
    ,total_gas_Bridge as (select sum(GAS_USED)/1e18 from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
    and block_timestamp::date > current_date - interval '90 days'
    )
    , total_gas_daily as (select sum(GAS_USED)/1e18,block_timestamp::date from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
    and block_timestamp::date > current_date - interval '90 days'
    group by block_timestamp::date
    )
    ,total_fee_Bridge as (select sum(TRANSACTION_FEE)/1e18 from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
    and block_timestamp::date > current_date - interval '90 days'
    )
    , total_fee_daily as (select sum(TRANSACTION_FEE)/1e18,block_timestamp::date from flipside_prod_db.mdao_near.transactions where TX_RECEIPT like '%"executor_id":"aurora"%'
    and block_timestamp::date > current_date - interval '90 days'
    group by block_timestamp::date
    )
    select * from total_fee_daily
    Run a query to Download Data