arbitrum AS (

SELECT

block_timestamp,

tx_hash AS tx,

from_address AS wallet,

(raw_amount / POW(10, 6)) AS amount

FROM

arbitrum.core.fact_token_transfers

WHERE

block_timestamp BETWEEN (CURRENT_DATE - {{range}} - 1) AND (CURRENT_DATE - 1)

AND contract_address = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8'

AND from_address <> '0x0000000000000000000000000000000000000000'

AND raw_amount > 0

),

avalanche AS (

SELECT

block_timestamp,

tx_hash AS tx,

from_address AS wallet,

(raw_amount / POW(10, 6)) AS amount

FROM

avalanche.core.fact_token_transfers

WHERE

block_timestamp BETWEEN (CURRENT_DATE - {{range}} - 1) AND (CURRENT_DATE - 1)

AND contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

AND from_address <> '0x0000000000000000000000000000000000000000'

AND raw_amount > 0

),

axelar AS (

SELECT

block_timestamp,

tx_id AS tx,

sender AS wallet,

amount / POW(10, decimal) AS amount

FROM