CUBE3Get address historical from to tx
    Updated 2024-09-30
    SELECT FROM_ADDRESS, TO_ADDRESS, SUM(VALUE) as total_value
    FROM ethereum.core.fact_transactions
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '90 days'
    AND BLOCK_TIMESTAMP < CURRENT_DATE
    AND (
    ethereum.core.fact_transactions.from_address = '0xa4f532e6832e3888819258f752372f611bf2360c'
    OR ethereum.core.fact_transactions.to_address = '0xa4f532e6832e3888819258f752372f611bf2360c'
    )
    AND ethereum.core.fact_transactions.value > 0
    GROUP BY FROM_ADDRESS, TO_ADDRESS
    ORDER BY total_value DESC
    LIMIT 1000;
    QueryRunArchived: QueryRun has been archived