danhanSushi Swap Activity
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc('day',BLOCK_TIMESTAMP) as "DATE", --to group number of unique address had Swap activity on Sushi
count (distinct ORIGIN_FROM_ADDRESS) as "Distinct Wallets", --count total number of individual wallets
count (distinct tx_hash) as "Transactions"
from ethereum.sushi.ez_swaps
WHERE "DATE"::DATE >= CURRENT_DATE - 90 --last three month
GROUP by "DATE"
order by "DATE" desc
Run a query to Download Data