alirsopbv-09
Updated 2022-09-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with base as (select block_timestamp::date as Date,tx_hash,
-- IFF(TOKEN0_AMOUNT_USD IS NULL, TOKEN1_AMOUNT_USD,TOKEN0_AMOUNT_USD) as TOKEN0_AMOUNT_USD_n,
-- IFF(TOKEN1_AMOUNT_USD IS NULL, TOKEN0_AMOUNT_USD, TOKEN1_AMOUNT_USD) as TOKEN1_AMOUNT_USD_n
IFF(SYMBOL_IN IS NULL, TOKEN_ADDRESS_IN, SYMBOL_IN) as SYMBOL_IN_n,
IFF(SYMBOL_OUT IS NULL, TOKEN_ADDRESS_OUT, SYMBOL_OUT) as SYMBOL_OUT_n,
CONCAT(SYMBOL_IN_n, '-->', SYMBOL_OUT_n) as Swap_Pairs
from optimism.velodrome.ez_swaps
where date >= '2022-08-05' and date <= '2022-09-02'
)
select
--block_timestamp::date as Date,
SYMBOL_OUT_n,
count (distinct tx_hash) as Num_Swap
--count (distinct ORIGIN_FROM_ADDRESS) as daily_Swapper
from base
where date >= '2022-08-05' and date <= '2022-09-02'
GROUP by 1
ORDER by 2 DESC
limit 10
Run a query to Download Data