headitmanagerBlocto Total Fee over time
    Updated 2022-07-10
    with Blocto_total_fee as (select sum(TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0]) as fee
    from flow.core.fact_transactions
    where payer='0x55ad22f01ef568a1')
    , Blocto_fee_overtime as (select sum(TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0]) as fee,block_timestamp::date
    from flow.core.fact_transactions
    where payer='0x55ad22f01ef568a1'
    group by block_timestamp::date)
    , other_wallet_providers_transactions_count as (select count(*),payer from flow.core.fact_transactions
    group by payer
    order by count(*) DESC
    limit 20)
    , other_wallet_providers_fee_amount as (select sum(TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0]) as fee,payer from flow.core.fact_transactions
    where TRANSACTION_RESULT:events[ARRAY_SIZE(TRANSACTION_RESULT:events)-1]:value:fields[0] is not null
    group by payer
    order by fee DESC
    limit 20)
    select * from Blocto_fee_overtime

    Run a query to Download Data