u.contract_address

--,count(distinct u.tx_id) as num_of_wallets

,sum(gas_used) as Used_Gass

FROM ethereum.udm_events u

left join ethereum.transactions t

on t.block_id=u.block_id

where

u.contract_address in

(

'0x09b8d86c6275e707155cdb5963cf611a432ccb21',

'0x23c85dca3d19b31f14aeea19beac32c2cb2ffc72',

'0x33412fef1af035d6dba8b2f9b33b022e4c31dbb4',

'0x4564a37c88e3b13d3a0c08832dcf88278997e6fe',

'0x467414f0312ecedba1e505c12bd97daa3609da87',

'0x53a4512bbe5083695d8e890789fe1cf6f5686d52',

'0x55eed13ab07f8b5538eff301551492a1d776da7b',

'0x65bc5c6a2630a87c2b494f36148e338dd76c054f',

'0x6c8116abe5c5f2c39553c6f4217840e71462539c',

'0x704ececabe7855996cede5cefa660eccd3c01dbe',

'0x716bd8a7f8a44b010969a1825ae5658e7a18630d',

'0x7f92463e24b2ea1f7267aceed3ad68f7a956d2d8',

'0x8cd73cb1e1fa35628e36b8c543c5f825cd4e77f1',

'0x97491b65c9c8e8754b5c55ed208ff490b2ee6190',

'0x9a98bffabc0abf291d6811c034e239e916bbcec0',

'0xbb9b86a75ca3115caab045e2af17b0bba483acbc',

'0xbff4a47a0f77637f735e3a0ce10ff2bf9be12e89',

'0xc14e7ec60699a39cfd59bae06168afc2c76f32ac',

'0xc86b1e7fa86834cac1468937cdd53ba3ccbc1153',

'0xc92ff322c8a18e38b46393dbcc8a7c5691586497',

'0xd8dbdb77305898365d7ba6dd438f2663f7d4e409',

'0xe065ff6a26f286ddb0e823920caaecd1fcd57ba1',

'0xf0a9f5c64f80fa390a46b298791dab9e2bb29bca',