Query editor
with claims as (selectcoalesce(to_owner, tx_signer) as address,--tx_id as hash,--block_time,sum(amount/1e6) as amount--count(*)from tokens_solana.transferswhere token_mint_address = 'MEFNBXixkEbait3xn9bkm8WsJzXtVsaJEn4c8Sam21u'and outer_executing_account = 'disGCfSiJKFigEphfou4PGHn1rukMfbs9cg9GpTM6oe'and block_time > cast('2024-12-10' as timestamp)group by 1 order by 2)selectcount(distinct(address)) as unique_addresses,sum(amount) as tokens_claimed,max(amount) as max_amount_claimed,min(amount) as min_amount_claimedfrom claims