Eman-RazNumber of Daily Liquidity Providers/ Removers
Updated 2023-05-26
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 data1 as (with tab1 as (select block_timestamp::date as date, contract_address, sum(raw_amount) as amount, count(distinct from_address) as liquidity_providers, 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%'
when to_address='0x665d8d87ac09bdbc1222b8b9e72ddcb82f76b54a' then 'WETH-AELIN: 1%'
when to_address='0x6168ec836d0b1f0c37381ec7ed1891a412872121' then 'WBTC-USDC: 0.3%'
when to_address='0x2e80d5a7b3c613d854ee43243ff09808108561eb' then 'WETH-sUSD: 0.3%'
when to_address='0xaefc1edaede6adadcdf3bb344577d45a80b19582' then 'WETH-rETH: 0.05%'
when to_address='0xdd0c6bae8ad5998c358b823df15a2a4181da1b80' then 'WETH-USDT: 0.3%'
when to_address='0xc50958e82c36b8d6d0baf555f90b76b0a28ceeeb' then 'THALES-USDC: 0.3%'
Run a query to Download Data