Short but Power Query for Finding Any Transaction on Ethereum
1 2 3 select sum(value)/10^18 as royalties, 0.7*sum(value)/10^18 as dao_royalties, 0.3*sum(value)/10^18 as artist_royalties from ethereum."transactions" tx where tx.from = '\x0b7a434782792b539623fd72a428838ea4173b22' and tx.to = '\x557068A9b7d66F97A61b97C80541eb17672E1e6f'