CUBE3Get address historical from to tx
Updated 2024-09-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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