Algorand AS (

SELECT

block_timestamp,

tx_id AS tx,

tx_sender AS wallet,

amount

FROM

algorand.core.ez_transfer

WHERE

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

AND asset_id = 31566704

AND amount > 0

),

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