'SEI' as network,

count(distinct TX_ID) as transfers,

count(distinct SENDER) as SENDERs,

count(distinct RECEIVER) as RECEIVERs,

sum(AMOUNT /pow(10, 6)) AS Volume,

avg(AMOUNT /pow(10, 6)) AS avg_Volume,

Volume / SENDERs as vol_per_sender

from SEI.core.fact_transfers

where BLOCK_TIMESTAMP::date >= '2023-08-15'

and AMOUNT < 1e14

and CURRENCY in ( 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H'

, 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp'

, 'factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ'

, 'ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349'

union all

select

'Optimism' as network,

count(distinct TX_hash) as transfers,

count(distinct FROM_ADDRESS) as SENDERs,

count(distinct TO_ADDRESS) as RECEIVERs,