ValiMohammadiweekly_good_users_swaps
Updated 2023-03-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with
users as (
select distinct
from_address as user
from
optimism.core.fact_transactions
limit
500
)
select
date_trunc('week', a.block_timestamp::DATE) as date,
count(a.tx_hash) as transactions,
sum(a.amount_in_usd) as amount_in_usd,
sum(a.amount_out_usd) as amount_out_usd,
user
from
optimism.core.ez_dex_swaps a
join users on users.user = a.sender
group by
user,
date
order by
transactions desc
Run a query to Download Data