KARTODMetaswaps
Updated 2022-06-22Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",
platform AS "Distr.",
SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS "Volume",
COUNT(DISTINCT TX_HASH) AS "Transactions",
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users"
FROM ethereum.core.ez_dex_swaps
WHERE BLOCK_TIMESTAMP > CURRENT_DATE() - INTERVAL'720 day' AND ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c'
GROUP BY "Date", "Distr."
Run a query to Download Data