james________MATIC: Wallet Received From
    Updated 2022-10-03
    WITH matic_sent AS
    (select FROM_ADDRESS SENDER, 'MATIC' AS SYMBOL, COUNT(*) tx_sent, sum(MATIC_VALUE) sum_token_amount, MIN(BLOCK_TIMESTAMP::DATE) first_tx_sent,
    'https://polygonscan.com/address/' || max(FROM_ADDRESS) AS address_link
    from polygon.core.fact_transactions
    where TO_ADDRESS = LOWER('{{poly_address}}')
    GROUP BY 1, 2),

    tokens_sent AS
    (select FROM_ADDRESS SENDER, 'https://polygonscan.com/token/' || CONTRACT_ADDRESS AS SYMBOL,
    COUNT(*) tx_sent, sum(RAW_AMOUNT) sum_token_amount, MIN(BLOCK_TIMESTAMP::DATE) first_tx_sent,
    'https://polygonscan.com/address/' || max(FROM_ADDRESS) AS address_link
    from polygon.core.fact_token_transfers
    where TO_ADDRESS = LOWER('{{poly_address}}')
    GROUP BY 1, 2)

    SELECT *
    FROM matic_sent
    UNION ALL
    SELECT *
    FROM tokens_sent





    Run a query to Download Data