LI.FIAAVE: Pay with collateral 30 D
Updated 2024-10-17
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
›
⌄
-- forked from AAVE: Pay with collateral over time @ https://flipsidecrypto.xyz/studio/queries/ba358248-80a0-4e96-9c06-2098a3963aff
with txns as (
SELECT 'polygon' as chain , a.*
FROM polygon.core.ez_decoded_event_logs a, polygon.core.ez_decoded_event_logs b
WHERE a.event_name = 'FlashLoan' and a.contract_address IN ('0x794a61358d6845594f94dc1db02a252b5b4814ad','0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf')
AND b.event_name = 'Repay'
AND a.tx_hash = b.tx_hash
AND a.block_timestamp > current_date-30
UNION
SELECT 'avalanche' as chain , a.*
FROM avalanche.core.ez_decoded_event_logs a, avalanche.core.ez_decoded_event_logs b
WHERE a.event_name = 'FlashLoan' and a.contract_address IN ('0x794a61358d6845594f94dc1db02a252b5b4814ad','0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf')
AND b.event_name = 'Repay'
AND a.tx_hash = b.tx_hash
AND a.block_timestamp > current_date-30
UNION
SELECT 'arbitrum' as chain , a.*
FROM arbitrum.core.ez_decoded_event_logs a, arbitrum.core.ez_decoded_event_logs b
WHERE a.event_name = 'FlashLoan' and a.contract_address IN ('0x794a61358d6845594f94dc1db02a252b5b4814ad','0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf')
AND b.event_name = 'Repay'
AND a.tx_hash = b.tx_hash
AND a.block_timestamp > current_date-30
UNION
SELECT 'ethereum' as chain , a.*
FROM ethereum.core.ez_decoded_event_logs a, ethereum.core.ez_decoded_event_logs b
WHERE a.event_name = 'FlashLoan' and a.contract_address = '0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2'
AND b.event_name = 'Repay'
AND a.tx_hash = b.tx_hash
AND a.block_timestamp > current_date-30
UNION
SELECT 'base' as chain , a.*
FROM base.core.ez_decoded_event_logs a, base.core.ez_decoded_event_logs b
WHERE a.event_name = 'FlashLoan' and a.contract_address = '0xa238dd80c259a72e81d7e4664a9801593f98d1c5'
AND b.event_name = 'Repay'
AND a.tx_hash = b.tx_hash
QueryRunArchived: QueryRun has been archived