saadiqTransactions OUT Amounts
    Updated 2023-10-05
    WITH
    txns AS (
    SELECT
    tx_hash,
    block_timestamp,
    eth_from_address AS from_address,
    eth_to_address AS to_address,
    amount,
    amount_usd,
    'ETH' AS symbol
    FROM
    ethereum.core.ez_eth_transfers
    WHERE
    eth_from_address = lower('0x4863799d31d4c4A0F08857E7167BC3FCeFCe747f')
    OR eth_to_address = lower('0x4863799d31d4c4A0F08857E7167BC3FCeFCe747f')
    UNION ALL
    SELECT
    tx_hash,
    block_timestamp,
    from_address,
    to_address,
    amount,
    amount_usd,
    symbol
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    from_address = lower('0x4863799d31d4c4A0F08857E7167BC3FCeFCe747f')
    OR to_address = lower('0x4863799d31d4c4A0F08857E7167BC3FCeFCe747f')
    ORDER BY
    block_timestamp DESC
    ),
    symbol_amounts AS (
    SELECT
    symbol,
    SUM(amount) as total_amount
    Run a query to Download Data