kumbayaa2024-04-10 02:45 AM
Updated 2024-04-10
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE,PLATFORM,
CONTRACT_ADDRESS, CREATOR, ORIGIN_FROM_ADDRESS, SENDER,
SUM (AMOUNT_OUT_USD) AS Amount_received
FROM ethereum.defi.ez_dex_swaps AS a
INNER JOIN ethereum.core.dim_labels AS b
ON a.CONTRACT_ADDRESS=b.address
WHERE PLATFORM='uniswap-v2' AND AMOUNT_OUT_USD >0
GROUP BY ('day', BLOCK_TIMESTAMP),PLATFORM,CONTRACT_ADDRESS,
CREATOR, ORIGIN_FROM_ADDRESS, SENDER,TX_TO
ORDER BY Amount_received DESC
LIMIT 10;
QueryRunArchived: QueryRun has been archived