CryptoIcicleaxlUSDC: Soon to be forgotten? - LPs
Updated 2022-11-04
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Grand Prize 208.334 OSMO (A score of 11 or 12 earns you a Grand Prize title)
-- Payout 138.889 OSMO
-- Score Multiplier 0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
-- Payout Network Osmosis
-- Level Advanced
-- Difficulty Elite
-- Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates.
-- Let's look at how pervasive axlUSDC is within IBC.
-- Track Satellite bridge activity strictly related to axlUSDC transfer.
-- Which app-chains have the most/least flows of axlUSDC?
-- Looking at Osmosis specifically, analyze how dominant axlUSDC has become compared to both ATOM and other USDC assets in trading and pools.
-- Hint: You will need to analyze both Axelar tables and Osmosis tables for the second half of this question.
-- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
with prices as (
select
date_trunc('day', recorded_at) as date,
avg(price) as price_usd
from osmosis.core.dim_prices
where symbol = 'OSMO'
group by 1
),
lp_txns as (
select
CASE pool_id
WHEN '1' THEN 'ATOM / OSMO'
WHEN '678' THEN 'axlUSDC / OSMO'
WHEN '674' THEN 'DAI / OSMO'
WHEN '560' THEN 'USTC / OSMO'
WHEN '633' THEN 'USTC.grv / OSMO'
WHEN '818' THEN 'USDT.grv / OSMO'
ELSE 'OTHER'
END as pool_name,
p.price_usd,
(2 * l.amount * p.price_usd/1e6) as amount_usd,
l.*
Run a query to Download Data