Afonso_DiazOvertime (stable pools)
Updated 2024-07-30
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 t as (
select
tx_hash,
block_timestamp,
b.amount_usd as amount0_usd,
b.amount as amount0,
b.symbol as symbol0,
c.amount_usd as amount1_usd,
c.amount as amount1,
c.symbol as symbol1,
event_name as action,
a.origin_from_address as user,
iff(symbol0 > symbol1, symbol0 || ' - ' || symbol1, symbol1 || ' - ' || symbol0) as swap_pair,
case
when swap_pair in ('DAI+ - DAI', 'USDR - USDC', 'pETH - WETH', 'USDt - USDC', 'mWETH - WETH', 'gmdUSDC - DAI', 'WETH - ETH', 'weETH - WETH',
'USDS - USDC', 'USDC - EUROs', 'rWETH - WETH', 'jEUR - EURS', 'fxUSD - USDs', 'senUSD - USDC', 'wstETH - swETH', 'TUSD - DAI', 'USDT - USDC',
'frxETH - WETH', 'dUSDC - USDC', 'USDT - EURT', 'USDT - USDN', 'arUSD - USDs', 'USDD - USDC', 'USDT - FRAX', 'tBTC - WBTC', 'WETH.e - WETH',
'gUSDC - gDAI', 'ezETH - WETH', 'fUSDC - USDC', 'WBTC - SolvBTC', 'iUSD - USDT', 'USDx - USDC', 'USDO - USDC', 'USDLR - USDC',
'fxEUR - USDC', 'fUSDC - LUSD', 'rtETH - WETH', 'cbETH - WETH', 'wstETH - ankrETH', 'zGND - GND', 'USDC - EUROe', 'USDT - DAI', 'USDT - LUSD',
'agEUR - EUROe', 'pxGMX - GMX', 'wUSD+ - USDC', 'gmUSD - gDAI', 'uBTC - BTC.b', 'gmUSDC - USDC', 'USDC - EUROC', 'hUSDT - USDT', 'gUSDC - USDC',
'fDAI - DAI', 'USDE - DAI', 'gBRC - BRC', 'hETH - WETH', 'wstETH - gETH', 'rARB - ARB', 'vWETH - WETH', 'DUSD - DAI', 'ribUSDC - USDC', 'WETH - RWETH',
'tUSDC - USDC', 'USDT - USDE', 'USDV - USDT', 'WETH - SLETH', 'wstETH - rETH', 'wstETH - WETH', 'WETH - ETH', 'roeUSDC - USDC',
'sfrxETH - WETH', 'USDV - USD+', 'USDbC - USDC', 'aArbARB - ARB', 'cbETH - GETH', 'WBTC - BTC.b', 'USDN - USDC', 'USDE - USDC', 'gmUSD - USDC',
'wstETH - rsETH', 'esVELA - VELA', 'geUSDC - USDC', 'USDT - TUSD', 'sSPELL - SPELL', 'nETH - WETH', 'gDAI - USDC', 'ankrETH - WETH', 'geWBTC - WBTC',
'nUSD - USDC', 'geWETH - WETH', 'xARC - ARC', 'gmdETH - WETH', 'renBTC - WBTC', 'dEth - WETH', 'WBTC - BTCBR', 'hyETH - WETH', 'USDC - LUSD',
'USDs - USDC', 'USDC - DUSD', 'USSD - USDT', 'gmUSD - USDT', 'LUSD - DAI', 'USDC - MIM', 'goARB - ARB', 'fUSDT - fUSDC', 'aArbWETH - WETH',
'USDT - USD+', 'USDC - DAI', 'axlUSDC - USDC', 'fUSDT - USDT', 'rsETH - WETH', 'rETH - WETH', 'glpUSDC - USDC', 'apBoop - Boop', 'USDC - USD+',
'gmdUSDC - gmUSD', 'crvUSD - LUSD', 'wUSDR - USDC', 'USDe - USDC', 'USDs - DAI', 'USDC - GUSD', 'WMATIC - MATIC', 'crvUSD - USDT', 'hUSDC - USDC',
'wstETH - sfrxETH', 'USDC - TUSD', 'fUSDC - USDT', 'wstETH - ezETH', 'FRAX - DAI', 'miweETH - WETH', 'USDV - USDC', 'USDe - USDT', 'aArbUSDC - USDC',
'peUSD - USDC', 'weETH - rETH', 'gDAI - DAI', 'apPEAS - PEAS', 'gDAI - USDs', 'eUSD - USDC', 'fxUSD - USDC', 'gETH - WETH') then 'Stable Pools' else 'Volatile Pools'
end as pair_type,
iff(block_timestamp::date < '2024-03-14', 'Before fee changes', 'After fee changes') as timespan
from arbitrum.core.ez_decoded_event_logs a
join arbitrum.core.ez_token_transfers b
using (tx_hash, block_timestamp)
join arbitrum.core.ez_token_transfers c
QueryRunArchived: QueryRun has been archived