alitaslimiBlockchain Wallet Types
    Updated 2022-11-22
    WITH
    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
    Run a query to Download Data