superflyUntitled Query
Updated 2022-10-28
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT to_char(date_trunc(MONTH, BLOCK_TIMESTAMP::DATE), 'YYYY-MM') AS MONTH, COUNT(DISTINCT TX_HASH) AS "Number of Transactions",
SUM(AMOUNT_IN_USD) AS "Amount In USD",
SUM(AMOUNT_IN) AS "Amount In ETH",
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Number of Unique Wallets"
FROM ethereum.core.ez_dex_swaps
WHERE ORIGIN_TO_ADDRESS = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
AND SYMBOL_IN = 'WETH'
GROUP BY 1
ORDER BY 1
Run a query to Download Data