KARTODCelsius wallet
Updated 2022-06-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
Address AS "Address",
COUNT(F.TX_HASH) AS "Send transactions",
COUNT(T.TX_HASH) AS "Received transactions",
"Send transactions" + "Received transactions" AS "Total transactions"
FROM flipside_prod_db.crosschain.address_labels L
LEFT JOIN ethereum.core.fact_transactions F ON Address = F.FROM_ADDRESS
LEFT JOIN ethereum.core.fact_transactions T ON Address = T.TO_ADDRESS
WHERE L.ADDRESS_NAME = 'celsius wallet'
GROUP BY 1
ORDER BY "Total transactions" DESC
Run a query to Download Data