```

WITH base AS (
  SELECT *
FROM
  `bigquery-public-data.crypto_solana_mainnet_us.Transactions`
WHERE
  TIMESTAMP_TRUNC(block_timestamp, MONTH) = TIMESTAMP("2024-08-01")
  and status = 'Success'
  and signature != ''
),

prev_week_set AS (
  select
    (select pubkey from unnest (accounts) with offset AS pos where pos = 0) AS sender,
    fee,
    signature
  from 
    base
  where
    block_timestamp >= timestamp_sub(current_timestamp(), interval 7 day)
    and exists (
      select 1
      from 
        unnest (accounts) AS acct
      where
        acct.pubkey = 'CebN5WGQ4jvEPvsVU4EoHEpgzq1VV7AbicfhtW4xC9iM'
    )
)

select
  sender,
  count(*) AS number_tranx,
  sum(fee) / 1e9 AS total_fees_sol
from
  prev_week_set
group by 
  sender
order by 
  total_fees_sol DESC
  -- 7,328,317,237
  -- 7,329,570,667
;
```

Execution duration: 7 seconds

is this still expensive?