KingTigerMafia-7mwRZbUntitled Query
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- part 1
with deposit as (
select block_timestamp::date as date, count(tx_hash) as num_tx, count(distinct origin_from_address) as num_users, sum(lp_token_amount_usd) as lp_amount
from optimism.velodrome.ez_lp_actions
where lp_action = 'deposit'
group by 1
order by 1 asc
), withdraw as (
select block_timestamp::date as date, count(tx_hash) as num_tx, count(distinct origin_to_address) as num_users, sum(lp_token_amount_usd) as lp_amount
from optimism.velodrome.ez_lp_actions
where lp_action = 'withdraw'
group by 1
order by 1 asc
)
SELECT d.date as date, sum(d.num_tx) as num_deposit, sum(d.num_users) as deposit_user, sum(w.num_tx) as num_withdraw, sum(w.num_users) as withdraw_user, sum(d.lp_amount) as deposit_amount, sum(w.lp_amount) as withdraw_amount
from deposit d join withdraw w on d.date = w.date
group by 1
order by 1 asc
-- part 2
select pool_name, count(tx_hash) as num_tx
from optimism.velodrome.ez_lp_actions
group by 1
order by 2 DESC
limit 10
-- part 3
select pool_type, count(tx_hash) as num_tx
from optimism.velodrome.ez_lp_actions
group by 1
order by 2 DESC
limit 10
-- part 4
select block_timestamp::date as date, sum(claimed_amount_usd)
Run a query to Download Data