mohammadh5)Open Analytics Bounty: Aribtrum (September 3)
    Updated 2022-09-08
    select
    date_trunc('day', block_timestamp) as block_day,
    count(distinct TX_HASH) as tx_count,
    sum(tx_count) over (partition by PROJECT_NAME order by block_day asc) as cum_tx,
    ADDRESS_NAME,
    PROJECT_NAME,
    LABEL_TYPE,
    avg(TX_FEE) as avg_fee,
    sum(TX_FEE) as sum_fee
    from arbitrum.core.fact_transactions a
    join arbitrum.core.dim_labels b
    on a.TO_ADDRESS=b.ADDRESS
    where block_timestamp >= '2022-07-01' and block_timestamp < current_date -1
    group by block_day,ADDRESS_NAME,PROJECT_NAME,LABEL_TYPE
    having tx_count > 100
    Run a query to Download Data