0xnirmalTXNS Percentage of High Users
    Updated 2023-01-24
    with a as (
    select
    date_trunc(day, block_timestamp) as date,
    from_address,
    count(*) as num_transactions
    from bsc.core.fact_transactions
    where block_timestamp > '2022-10-02'
    group by date, from_address
    order by date desc
    )
    select
    a.date,
    count (distinct a.from_address) as num_high_add,
    sum(a.num_transactions) as total_high_transactions
    from a
    where a.num_transactions > 100
    group by date
    order by date desc
    Run a query to Download Data