select to_date(block_timestamp) as date , 'OPTIMISM' as chain, count(distinct origin_from_address) as num_lpers from optimism.core.fact_event_logs

WHERE contract_address in ('0xdecc0c09c3b5f6e92ef4184125d5648a66e35298','0x165137624f1f692e69659f944bf69de02874ee27','0x368605d9c6243a80903b9e326f1cddde088b8924','0x2f8bc9081c7fcfec25b9f41a50d97eaa592058ae',

'0x3533f5e279bdbf550272a199a223da798d9eff78','0x5421fa1a48f9ff81e4580557e86c7c0d24c18036')

AND topics[0] = '0xb4c03061fb5b7fed76389d5af8f2e0ddb09f8c70d1333abbb62582835e10accb'

group by date, chain),

ALL_LPERS_bsc AS (

select to_date(block_timestamp) as date , 'BSC' as chain, count(distinct origin_from_address) as num_lpers from BSC.core.fact_event_logs

WHERE contract_address in ('0x9aa83081aa06af7208dcc7a4cb72c94d057d2cda','0x98a5737749490856b401db5dc27f522fc314a4e1','0x4e145a589e4c03cbe3d28520e4bf3089834289df','0x7bfd7f2498c4796f10b6c611d9db393d3052510c')

AND topics[0] = '0xb4c03061fb5b7fed76389d5af8f2e0ddb09f8c70d1333abbb62582835e10accb'

group by date, chain),

ALL_LPERS_ETH AS (

select to_date(block_timestamp) as date , 'ETHEREUM' as chain, count(distinct origin_from_address) as num_lpers from ethereum.core.fact_event_logs

WHERE contract_address in ('0xdf0770df86a8034b3efef0a1bb3c889b8332ff56','0x38ea452219524bb87e18de1c24d3bb59510bd783','0x0faf1d2d3ced330824de3b8200fc8dc6e397850d','0xfa0f307783ac21c39e939acff795e27b650f6e68','0x692953e758c3669290cb1677180c64183cee374e','0xe8f55368c82d38bbbbdb5533e7f56afc2e978cc2','0x590d4f8a68583639f215f675f3a259ed84790580')

AND topics[0] = '0xb4c03061fb5b7fed76389d5af8f2e0ddb09f8c70d1333abbb62582835e10accb'

group by date, chain),

ALL_LPERS_avax AS (

select to_date(block_timestamp) as date , 'AVALANCHE' as chain, count(distinct origin_from_address) as num_lpers from avalanche.core.fact_event_logs

WHERE contract_address in ('0x1205f31718499dbf1fca446663b532ef87481fe1','0x29e38769f23701a2e4a8ef0492e19da4604be62c','0x1c272232df0bb6225da87f4decd9d37c32f63eea','0x8736f92646b2542b3e5f3c63590ca7fe313e283b')

AND topics[0] = '0xb4c03061fb5b7fed76389d5af8f2e0ddb09f8c70d1333abbb62582835e10accb'

group by date, chain),

ALL_LPERS_POLY AS (

select to_date(block_timestamp) as date , 'OPTIMISM' as chain, count(distinct origin_from_address) as num_lpers from optimism.core.fact_event_logs

WHERE contract_address in ('0x1205f31718499dbf1fca446663b532ef87481fe1','0x29e38769f23701a2e4a8ef0492e19da4604be62c','0x1c272232df0bb6225da87f4decd9d37c32f63eea','0x8736f92646b2542b3e5f3c63590ca7fe313e283b')

AND topics[0] = '0xb4c03061fb5b7fed76389d5af8f2e0ddb09f8c70d1333abbb62582835e10accb'

group by date, chain)

select * from ALL_LPERS_OPT

UNION ALL

SELECT * FROM ALL_LPERS_eth