Updated 2022-08-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with lp as (
select block_timestamp::date as date, count(distinct tx_hash) as num_tx, count(distinct origin_from_address) as num_users
from optimism.velodrome.ez_lp_actions
group by 1
order by 1 asc)
,
sw as (
select block_timestamp::date as date, count(distinct tx_hash) as num_tx, count(distinct origin_from_address) as num_users
from optimism.velodrome.ez_swaps
group by 1
order by 1 asc)
select lp.date,
sw.num_tx as swp_num_tx,
lp.num_tx as lp_num_tx,
sw.num_users as swp_num_users,
lp.num_users as lp_num_users
from lp join sw on lp.date=sw.date
--group by 1
order by 1 asc
Run a query to Download Data