Query editor
with eth_transfer_raw as (select block_time, tx_hash, cast(value as decimal(38, 0)) as amountfrom ethereum.traceswhere call_type = 'call'and success = trueand value > uint256 '0'and block_time >= now() - interval '30' day),eth_transfer_amount as (select tx_hash,sum(amount) as amountfrom eth_transfer_rawgroup by 1order by 2 desclimit 100)select row_number() over (order by amount desc) as rank_id,amount / 1e18 as transfer_amount,block_time,"from" as from_address,"to" as to_address,'<a href=https://etherscan.io/tx/' || cast(tx_hash as varchar) || ' target=_blank>EtherScan</a>' as etherscan_link,tx_hashfrom eth_transfer_amount einner join ethereum.transactions t on e.tx_hash = t.hashorder by amount desclimit 100