Query editor
with tx as (select count(distinct "from") users, count(1) as payments, sum(value/1e18) as value,sum(value/1e18)/count(1) as avg_value_per_tx,count(1)*1.0/count(distinct "from") as avg_tx_per_user,sum(value/1e18)/count(distinct "from") as avg_value_per_userfrom monerium_eure_gnosis.EURe_evt_Transferwhere to = 0x4822521E6135CD2599199c83Ea35179229A172EE -- Gnosis Pay aggregator),card_sales as (select count(1) as sales, sum(value/1e18) as sales_amountfrom monerium_eure_gnosis.EURe_evt_Transferwhere to = 0x3d4fd6a1a7a1382ae1d62c3dd7247254a0236847 -- Gnosis Pay sales addressand evt_block_time < date_trunc('week', current_timestamp)and value/1e18 > 1 -- just sanity check, could maybe check = 30.23€)select *from txcross join card_sales