flipside

    fee amount paid out each day
    elsinafee amount paid out each day
    Updated 2022-05-23
    select
    block_timestamp::date as day
    ,sum( REPLACE(fee, NVL(REGEXP_SUBSTR(fee,'i.*'), REGEXP_SUBSTR(fee,'u.*')), '')::decimal/pow(10,6)) as fee_amount
    from osmosis.core.fact_transactions
    where BLOCK_TIMESTAMP::date>=CURRENT_DATE-30
    group by 1
    Run a query to Download Data