MLDZMNDDU9
Updated 2023-08-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
date_trunc('month', block_timestamp) as month,
PLATFORM,
sum(CASE WHEN TOKEN_IN = lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0') THEN amount_in ELSE 0 END) + sum(CASE WHEN TOKEN_OUT =lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0') THEN amount_out ELSE 0 END) as volume,
count(DISTINCT origin_from_address) as no_swapers
FROM ethereum.core.ez_dex_swaps
WHERE block_timestamp >= '2022-01-01'
AND (TOKEN_IN = lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0') OR TOKEN_OUT = lower('0x3845badAde8e6dFF049820680d1F14bD3903a5d0'))
GROUP BY 1,2
Run a query to Download Data