icampsAerodrome LP Breakdown Detailed
Updated 2024-12-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
›
⌄
-- Aerodrome launch date: 2023-08-28 00:00:00.000
--
-- POOLS: [pool_name : pool_address ; gauge_address]
-- DOLA/USDbC: 0x0B25c51637c43decd6CC1C1e3da4518D54ddb528; 0xeAE066C25106006fB386A3a8b1698A0cB6931c1a
-- DAI+/USD+: 0x1b05e4e814b3431a48b8164c41eaC834d9cE2Da6; 0x87803Cb321624921cedaAD4555F07Daa0D1Ed325
-- MAI/USDbC: 0xf6Aec4F97623E691a9426a69BaF5501509fCa05D; 0xC01E2ff20501839db7B28F5Cb3eD2876fEa3d6b1
-- eUSD/USDbC: 0x5BfB340FA9305abB164Fb0248D0D82FC3D82C3bb; 0x1457Da0dcBe22249408BB2D1e24Bd2f1484d7620
-- DOLA/MAI: 0x8b432C54d6e8E1B8D1802753514AB53044Af1861; 0xDe23611176b16720346f4Df071D1aA01752c68C1
-- USDC/USDbC: 0x27a8Afa3Bd49406e48a074350fB7b2020c43B2bD; 0x1Cfc45C5221A07DA0DE958098A319a29FbBD66fE
-- USD+/USDbC: 0x4a3636608d7Bc5776CB19Eb72cAa36EbB9Ea683B; 0xa5972f0C07a2D1cc5A8457c28d88ec4f3C009864
-- LUSD/USDC: 0xf53B7Af40BE75043eeBa493C622F4f56b3C27A31; 0xA8C37a644bDf3297C6E19A48150aF3b7069294FC
-- hyUSD/eUSD: 0xb5E331615FdbA7DF49e05CdEACEb14Acdd5091c3; 0x025137c819298654162de2609f407514De4bb027
-- eUSD/USDC: 0x7A034374C89C463DD65D8C9BCfe63BcBCED41f4F; 0x793F22aB88dC91793E5Ce6ADbd7E733B0BD4733e
-- USDC/USD+: 0x418457Ca08fA5EC77f811B105F2c585cd051Ac10; 0x9701A079C6e80D91CE4c464C4a996237A27FE537
-- USDC/MAI: 0x2a1463CeBE85315224c536AfD389b381B43F3206; 0x9280df579CeA690cAf5c31601cb71564Bb6FA6B7
-- DOLA/USDC: 0xf213F2D02837012dC0236cC105061e121bB03e37; 0xCCff5627cd544b4cBb7d048139C1A6b6Bde67885
-- DAI/USDC: 0x67b00B46FA4f4F24c03855c5C8013C0B938B3eEc; 0x640e9ef68e1353112fF18826c4eDa844E1dC5eD0
-- MAI/eUSD: 0x413d78628d688edcdE29518199A3A3DB955068EC; 0x2cC76EF706B2fC694F86c633b880a6dde81687F1
WITH dates AS (
SELECT
DATE(date_day) AS date_day
FROM crosschain.core.dim_dates
WHERE date_day between '{{start_date}}' and current_date()
),
received AS (
SELECT
*,
txs.to_address as target_address,
amount as amount_adj
FROM base.core.ez_token_transfers as txs
WHERE txs.to_address IN (
lower('0x0B25c51637c43decd6CC1C1e3da4518D54ddb528'), -- DOLA/USDbC
lower('0x1b05e4e814b3431a48b8164c41eaC834d9cE2Da6'), -- DAI+/USD+
QueryRunArchived: QueryRun has been archived