flipside

    number of transactions based on position
    defi__joshnumber of transactions based on position
    Updated 2025-03-26
    select
    case when position >= 5 then 'big'
    else 'small' end as type,
    count(*) as no_of_transactions
    from aurora.core.fact_transactions
    where date(block_timestamp) between '{{start_date}}' and '{{end_date}}'
    and type like '{{tx_type}}'
    group by 1
    ;
    Last run: about 1 month ago
    TYPE
    NO_OF_TRANSACTIONS
    1
    		small1279126
    1
    19B
    1s