Sbhn_NPopti 4
Updated 2022-11-03
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
›
⌄
with t1 as
(with t2 as (
select date_trunc('month',block_timestamp) as months,
contract_address,
sum(raw_amount) as amount,
count(distinct from_address) as lps,
case
when to_address='0x85149247691df622eaf1a8bd0cafd40bc45154a9' then 'WETH-USDC: 0.05%'
when to_address='0x73b14a78a0d396c521f954532d43fd5ffe385216' then 'WETH-WBTC: 0.3%'
when to_address='0x68f5c0a2de713a54991e01858fd27a3832401849' then 'WETH-OP: 0.3%'
when to_address='0x03af20bdaaffb4cc0a521796a223f7d85e2aac31' then 'WETH-DAI: 0.3%'
when to_address='0x98d9ae198f2018503791d1caf23c6807c135bb6b' then 'USDC-FRAX: 0.05%'
when to_address='0xf334f6104a179207ddacfb41fa3567feea8595c2' then 'WETH-LYRA: 1%'
when to_address='0x100bdc1431a9b09c61c0efc5776814285f8fb248' then 'USDC-DAI: 0.05%'
when to_address='0xac6705bc7f6a35eb194bdb89066049d6f1b0b1b5' then 'THALES-WETH: 0.3%'
when to_address='0x535541f1aa08416e69dc4d610131099fa2ae7222' then 'WETH-PERP: 0.3%'
when to_address='0x0392b358ce4547601befa962680bede836606ae2' then 'WETH-SNX: 0.3%'
when to_address='0x730691cdac3cbd4d41fc5eb9d8abbb0cea795b94' then 'WETH-OP: 1%'
when to_address='0x1c3140ab59d6caf9fa7459c6f83d4b52ba881d36' then 'OP-USDC: 0.3%'
when to_address='0x6fcb3b6eccba19693fade13366b5aa0da37ee43f' then 'WETH-FIRN: 1%'
when to_address='0xadb35413ec50e0afe41039eac8b930d313e94fa4' then 'sUSD-DAI: 0.05%'
when to_address='0xb589969d38ce76d3d7aa319de7133bc9755fd840' then 'WETH-USDC: 0.3%'
when to_address='0xbf16ef186e715668aa29cef57e2fd7f9d48adfe6' then 'USDC-DAI: 0.01%'
when to_address='0x819ff7911fcc218665ecd6faad61730af544b3e1' then 'EST-DAI: 0.3%'
when to_address='0xf1f199342687a7d78bcc16fce79fa2665ef870e1' then 'USDC-USDT: 0.01%'
when to_address='0x8eda97883a1bc02cf68c6b9fb996e06ed8fdb3e5' then 'USDC-sUSD: 0.05$'
when to_address='0x827f0a2a4376bc26729f398b865f424dc8456841' then 'USDT-DAI: 0.05%'
when to_address='0xbd93951d2e9ec615f9940887559b4317032d98d0' then 'STG-USDC: 0.3%'
when to_address='0xad4c666fc170b468b19988959eb931a3676f0e9f' then 'WETH-UNI: 0.3%'
when to_address='0x381af0787add5bbbfa6ff88bd1284449a486372b' then 'DAI-XCHF: 0.05%'
when to_address='0xc858a329bf053be78d6239c4a4343b8fbd21472b' then 'WETH-USDT: 0.05%'
when to_address='0xf3f3433c3a97f70349c138ada81da4d3554982db' then 'USDC-USDT: 0.05%'
when to_address='0x85c31ffa3706d1cce9d525a00f1c7d4a2911754c' then 'WETH-WBTC: 0.05%'
when to_address='0xe62bd99a9501ca33d98913105fc2bec5bae6e5dd' then 'WETH-KROM: 0.3%'
when to_address='0x6f32061f59a21086c334d0d45f804089ce374aaf' then 'OP-USDC: 1%'
when to_address='0x790fde1fd6d2568050061a88c375d5c2e06b140b' then 'WETH-AAVE: 0.3%'
Run a query to Download Data