with

avax as (

select trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as txs

from avalanche.core.ez_decoded_event_logs

where event_name = 'Transfer' and contract_address = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e')

and tx_hash not in (select distinct tx_hash from avalanche.core.fact_event_logs where event_name = 'Swap')

and decoded_log:value/1e6 < 1e9 and tx_status = 'SUCCESS' and block_timestamp >= '2022-01-01'

group by 1

),

opt as (

select trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as txs

from optimism.core.ez_decoded_event_logs

where event_name = 'Transfer' and contract_address = lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607')

and tx_hash not in (select distinct tx_hash from optimism.core.ez_decoded_event_logs where event_name = 'Swap')

and decoded_log:value/1e6 < 1e9 and tx_status = 'SUCCESS' and block_timestamp >= '2022-01-01'

group by 1

),

arb as (

select trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as txs

from arbitrum.core.ez_token_transfers

where contract_address in (lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831'),lower('0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'))

and amount < 1e9 and block_timestamp >= '2022-01-01'

group by 1

),

poly as (

select trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as txs

from polygon.core.ez_decoded_event_logs

where event_name = 'Transfer' and contract_address = lower('0x2791Bca1f2de4661ED88A30C99A7a9449Aa84174')

and tx_hash not in (select distinct tx_hash from polygon.core.ez_decoded_event_logs where event_name = 'Swap')

and decoded_log:value/1e6 < 1e9 and tx_status = 'SUCCESS' and block_timestamp >= '2022-01-01'

group by 1