james________MATIC: Wallet Received From
Updated 2022-10-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
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