sinahosseinzadehUntitled Query
Updated 2022-08-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
With a as (
select date_trunc('day', block_timestamp) as day, count(*) as Total_Swap_Count
from optimism.velodrome.ez_swaps
group by 1
),
b as (
select date_trunc('day', block_timestamp) as daya, count(distinct SENDER_ADDRESS) as Number_of_unqiue_users
from optimism.velodrome.ez_swaps
group by 1
)
select day, total_swap_Count, Number_of_unqiue_users
from a
full outer join b on day=daya
Run a query to Download Data